search

ORNL-AMO / AMO-Tools-Desktop

AMO-Tools-Desktop is an energy efficiency calculation application for use with industrial equipment such as pumps, furnaces, fans, and motors, as well as for industrial systems such as steam. Currently in beta.
Other
37 stars 21 forks source link

Data Explorer: accept data from loggers without user cleaning #3856

Closed koay9f closed 3 years ago

koay9f commented 3 years ago

Currently users need to remove the header of files before submitting to MEASUR

A lot will probably look like this... image.png Where you just have to delete the first row

Some will have multiple rows that you need to delete. Maybe MEASUR can look for the first row with numbers and then say the previous row is the header? Not sure. Shubham may have managed it.

However, you also can have loggers that look like this... image.png Where, even if you go with the "row above the numbers" as the proper column headers, it data in that row doesn't actually tell the user enough to ID what the columns are It could be that we can only handle simpler ones and some need to be preped by the user no matter what.

koay9f commented 3 years ago

Would also need some kind of warning / stop if MEASUR can't get it right so users know they need to go back and edit themselves

koay9f commented 3 years ago

Help text: Instead of Choose a data file from your file system use Choose a .csv data file from your file system

loggers seem to start of with ".dat" files that we can't read, and they will still need to export to csv