How to use CSV export feature?
-
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?
-
@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 -
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?
-
@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.fromtimestampI 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