I would like to import historical consumption data (electricity, energy…) created by my Homeseer software into InfluxDB. The data is in csv format but I need to convert it to annotated csv format for InfluxDB. I can import a test file only with first couple of lines into InfluxDB database using the InfluxDB graphical interface.
My test file has electricity and energy meter data and below is the file which I can import to InfluxDB:
#datatype,string,long,string,dateTime:RFC3339,string,double,string,double #group,true,true,true,false,true,false,true,false #default,,,,,,,, ,result,table,_field,_time,_measurement,_value,_measurement2,_value2 ,consumption,1,field,2022-12-31T15:00:00+02:00,electricity,10652.2,energy,16.925 ,consumption,1,field,2022-12-31T16:00:00+02:00,electricity,10652.9,energy,16.926
My problem is that I can see only the electricity meter data (e.g. 10652.2) in Data explorer but not the energy meter data (e.g. 16.925). I can also plot the graph for the electricity meter data but not for the energy meter. Below is a screen copy:
Even though I can write to the database it seems that the format of my csv file is not quite correct. So, my question is what is the correct syntax for multiple measurements in an annotated csv file?