How to export the power measurement results

Available to be read by all.
Zheqi_Yu
Posts: 13
Joined: Wed Sep 26, 2018 3:49 pm

How to export the power measurement results

Postby Zheqi_Yu » Tue Jan 29, 2019 4:53 pm

Hi, anyone. Can I export the power measurement results to excel or any txt log files? If so, could you please tell me how to export it? Thank you very much.

Asbjørn_Djupdal
Posts: 32
Joined: Wed Feb 01, 2017 4:15 pm

Re: How to export the power measurement results

Postby Asbjørn_Djupdal » Wed Jan 30, 2019 7:29 am

Hi

The data is stored in an sqlite database file (profile.db3). You can use the sqlitebrowser to access the data. However, I should probably make an export function that exports to a csv file. If you provide me with a description (or example) of how you would like to have the data exported, I will make the export function this week.

Zheqi_Yu
Posts: 13
Joined: Wed Sep 26, 2018 3:49 pm

Re: How to export the power measurement results

Postby Zheqi_Yu » Wed Jan 30, 2019 9:26 am

Hi, thank you for your information, I have shown the screenshot of profile results for my data collection. It is a Line Chart for a sensor power measurement, and I plan to export this data to analysis.
Attachments
PMU_Sensor2_1.png
PMU_Sensor2_1.png (181.84 KiB) Viewed 35091 times

Asbjørn_Djupdal
Posts: 32
Joined: Wed Feb 01, 2017 4:15 pm

Re: How to export the power measurement results

Postby Asbjørn_Djupdal » Wed Jan 30, 2019 10:40 am

I wanted a suggestion for how you want the data file formatted. One example could be like this:

=== test.csv start here ===
Time;Power;Function name
0.0001;6.2;main()
0.0003;7.2;main()
0.0012;5.5;otherFunction()
=== test.csv end here ===

Would this be OK?

Zheqi_Yu
Posts: 13
Joined: Wed Sep 26, 2018 3:49 pm

Re: How to export the power measurement results

Postby Zheqi_Yu » Wed Jan 30, 2019 11:34 am

Good, that looks like ok, and due to I running the Linux system in the board now, so the elf and bitstream don't upload by the LynSyn board that loading by boot file in the board. The collected power data directly from the sensor, maybe, the function data can't be collected now? However, you can add function as a parameter in the CSV, it will help the future work for the project.

Zheqi_Yu
Posts: 13
Joined: Wed Sep 26, 2018 3:49 pm

Re: How to export the power measurement results

Postby Zheqi_Yu » Wed Jan 30, 2019 11:38 am

And also, I hoped the collect power measurement export data can to set the time-frequency by manual. For example, the collected data for totally 1mins and every 10ms as a row in the CSV file. Thank you very much.

Asbjørn_Djupdal
Posts: 32
Joined: Wed Feb 01, 2017 4:15 pm

Re: How to export the power measurement results

Postby Asbjørn_Djupdal » Wed Jan 30, 2019 12:09 pm

Thanks. I'll probably do this before the end of the week.

I have added this feature request to the github issue tracker:
https://github.com/tulipp-eu/sthem/issues/10

Further status about the development of this feature will be given there.

Asbjørn_Djupdal
Posts: 32
Joined: Wed Feb 01, 2017 4:15 pm

Re: How to export the power measurement results

Postby Asbjørn_Djupdal » Wed Jan 30, 2019 12:21 pm

Zheqi_Yu wrote:Good, that looks like ok, and due to I running the Linux system in the board now, so the elf and bitstream don't upload by the LynSyn board that loading by boot file in the board. The collected power data directly from the sensor, maybe, the function data can't be collected now? However, you can add function as a parameter in the CSV, it will help the future work for the project.


We are working on supporting linux now so hopefully we will get these things also for linux applications soon.

Zheqi_Yu
Posts: 13
Joined: Wed Sep 26, 2018 3:49 pm

Re: How to export the power measurement results

Postby Zheqi_Yu » Wed Jan 30, 2019 1:50 pm

Thank you very much for your information and help, I am waiting for your update project and to try it again.

Asbjørn_Djupdal
Posts: 32
Joined: Wed Feb 01, 2017 4:15 pm

Re: How to export the power measurement results

Postby Asbjørn_Djupdal » Wed Jan 30, 2019 2:20 pm

Export feature added. You find it in the "File" menu.


Return to “FAQ about Tulipp Development Platform”

Who is online

Users browsing this forum: No registered users and 1 guest