TBpnav 发表于 11-09-2018 22:25:34

Problem with CSV-Export

Hi,

the Kotomi PC software gives me export like this:

This file is generated by Kotomi PC software
Time,Voltage(V),Current(A),Energy(Wh),Capacity(Ah),Energy Proportion(%),Capacity Proportion(%)
0day00:00:00,1,6410,0,4877,0,0011,0,0007,0,00,0,01
0day00:00:05,4,9420,2,0048,0,0149,0,0035,0,05,0,05

but the problem with this: the columns seperator is the same character like the decimal seperator and thats makes it difficult die work with. Can this problem be solved using another seperator for columns?

Best R.
Tobias


yanke928 发表于 12-09-2018 18:56:59

The seperator ',' is used for CSV format, so that you can process the data easily in Excel.

If you have conditions that must not use ',' as the separator, you can use any editor to replace all ',' into the one you want.

Also, could you please tell me what software you want to deal with the data? If it is a common issue, we should provide a setting to set the format.

Mike 发表于 14-09-2018 04:49:33

Zuletzt bearbeitet von Mike um 14-09-2018 04:53

If you have conditions that must not use ',' as the separator, you can use any editor to replace all ',' into the one you want.
That wouldn't solve the problem Tobias described. In Germany, where Tobias comes from, the "," is used instead of "." as the decimal separator (see the mentioned example).

"the columns seperator is the same character like the decimal seperator"
The seperator should be another character than the decimal seperator. For example, if the seperator would be ";" instead of "," Excel could import this correctly by a simple double click on a csv file.

And I also would prefer if the software wouldn't export the comment line "This file is generated by Kotomi PC software". Or let the first line mention the separator: "sep=;"

The result, which could be simply imported by Excel through a double click on the csv file, would be:

Time;Voltage(V);Current(A);Energy(Wh);Capacity(Ah);Energy Proportion(%);Capacity Proportion(%)
0day00:00:00;1,6410;0,4877;0,0011;0,0007;0,00;0,01
0day00:00:05;4,9420;2,0048;0,0149;0,0035;0,05;0,05

or:

sep=;
Time;Voltage(V);Current(A);Energy(Wh);Capacity(Ah);Energy Proportion(%);Capacity Proportion(%)
0day00:00:00;1,6410;0,4877;0,0011;0,0007;0,00;0,01
0day00:00:05;4,9420;2,0048;0,0149;0,0035;0,05;0,05

instead of the example Tobias has mentioned:

This file is generated by Kotomi PC software
Time,Voltage(V),Current(A),Energy(Wh),Capacity(Ah),Energy Proportion(%),Capacity Proportion(%)
0day00:00:00,1,6410,0,4877,0,0011,0,0007,0,00,0,01
0day00:00:05,4,9420,2,0048,0,0149,0,0035,0,05,0,05


And I have another quick request:

I would like to see in the graph at a cursor point also the Capacity(Ah) and Energy(Wh) (not only Capacity Proportion(%) and Energy Proportion(%)).

Thank you!

TBpnav 发表于 04-09-2019 10:02:46

Hi,

after a few month I updates the software and still cannot use the export because of the problem with the separator! Please do not use the , as separator! Please use ; for example.

Please!!!

Thank you...
页: [1]
查看完整版本: Problem with CSV-Export