| |
| | |

AVHzY Forum

 Forgot password?
 Register
Search
View: 394|Reply: 2

Problem with CSV-Export

[Copy link]

1

Threads

1

Posts

7

Credits

Newbie

Rank: 1

Credits
7

 Germany

Post time: 11-09-2018 22:25:34
| Show all posts |Read mode
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


Reply

Use magic Report

0

Threads

19

Posts

92

Credits

Moderator

Rank: 7Rank: 7Rank: 7

Credits
92

 China

Post time: 12-09-2018 18:56:59
| Show all posts
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.
Reply

Use magic Report

0

Threads

1

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 United States

Post time: 14-09-2018 04:49:33
| Show all posts
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!

Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Archive|Mobile|Dark room|AVHzY Forum

21-04-2019 01:15 GMT-8 , Processed in 0.060950 sec., 24 queries .

Powered by Discuz! X3.4

AVHzY version, Rev. 864, © 2009-2019 forum.avhzy.com

Quick Reply To Top Return to the list