• Categories
  • Recent
  • Tags
  • Popular
  • Register
  • Login
  • Categories
  • Recent
  • Tags
  • Popular
  • Register
  • Login

How to use CSV export feature?

Scheduled Pinned Locked Moved General Discussion
4 Posts 2 Posters 489 Views 2 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • B Offline
    BraydenM
    last edited by 18 Feb 2020, 05:56

    Hello, I have recently been looking into using mycontroller for my senior project, I was wondering if you can export the data a node has collected as a CSV. I am hoping to take the data points used to make the graphs for analysis in an external python program.

    From searching I noticed this issue has come up before and saw it was added in the newest release (https://github.com/mycontroller-org/mycontroller/issues/361).

    I could not find any documentation on it so I was hoping someone could help me with this feature, is it usable from the UI and if so how is it done?

    J 1 Reply Last reply 20 Feb 2020, 09:59 Reply Quote 0
    • J Offline
      jkandasa @BraydenM
      last edited by 20 Feb 2020, 09:59

      @BraydenM We can not export as CSV, but ew can export as JSON
      in the recent version on UI near to backup tab, you can see an option to export data

      1 Reply Last reply Reply Quote 0
      • B Offline
        BraydenM
        last edited by 24 Feb 2020, 00:56

        Got it, thank you for the help, I was unframiliar with what JSON were as I've never used java.

        My only other question is how to decode the timestamp format? I can't see how it translates to date and time. What does each digit corrospond to?
        5b3625e1-d09b-4163-846b-3c9326dc4b1a-image.png

        J 1 Reply Last reply 24 Feb 2020, 02:38 Reply Quote 0
        • J Offline
          jkandasa @BraydenM
          last edited by jkandasa 24 Feb 2020, 02:38

          @BraydenM timestamp is the number of milliseconds that have elapsed since January 1, 1970 at 00:00:00 GMT.
          Note: In java it is in milliseconds. But in UNIX/Linux it is in seconds.

          In python, you can convert to date, time by using the function, datetime.datetime.fromtimestamp(1582439517).
          I believe it should be seconds. So you have to do, received timestamp / 1000 = in seconds
          https://docs.python.org/3/library/datetime.html#datetime.date.fromtimestamp

          I was unframiliar with what JSON were as I've never used java.

          JSON is not a java specific. We can use it most of the languages. Examples in Python, https://docs.python.org/3/library/json.html

          1 Reply Last reply Reply Quote 0
          4 out of 4
          • First post
            4/4
            Last post

          0

          Online

          623

          Users

          531

          Topics

          3.4k

          Posts
          Copyright © 2015-2025 MyController.org | Contributors | Localization