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

    How to use CSV export feature?

    Scheduled Pinned Locked Moved General Discussion
    4 Posts 2 Posters 375 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

      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?

      jkandasaJ 1 Reply Last reply Reply Quote 0
      • jkandasaJ Offline
        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 Offline
          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

          jkandasaJ 1 Reply Last reply Reply Quote 0
          • jkandasaJ Offline
            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

            587

            Users

            529

            Topics

            3.4k

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