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

    How to use CSV export feature?

    General Discussion
    2
    4
    146
    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
      BraydenM last edited by

      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?

      jkandasa 1 Reply Last reply Reply Quote 0
      • jkandasa
        jkandasa @BraydenM last edited by

        @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
          BraydenM last edited by

          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

          jkandasa 1 Reply Last reply Reply Quote 0
          • jkandasa
            jkandasa @BraydenM last edited by jkandasa

            @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
            • First post
              Last post

            0
            Online

            647
            Users

            506
            Topics

            3.3k
            Posts

            Copyright © 2015-2022 MyController.org | Contributors | Localization