找回密码
 注册
查看: 5154|回复: 3

Problem with CSV-Export

[复制链接]

2

主题

1

回帖

20

积分

Member

积分
20
发表于: 11-09-2018 22:25:34
| 显示全部楼层 |阅读模式
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


回复

使用道具 举报

1

主题

45

回帖

207

积分

Moderator

积分
207
发表于: 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.
回复

使用道具 举报

0

主题

1

回帖

4

积分

Newbie

积分
4
发表于: 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!

回复

使用道具 举报

2

主题

1

回帖

20

积分

Member

积分
20
 楼主| 发表于: 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...
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archive|手机版|小黑屋|AVHzY Forum

GMT-8, 28-03-2024 13:54 , Processed in 0.096546 sec., 16 queries .

Powered by Discuz! X3.5

© 2001-2023 Discuz! Team.

Release 20231001, © 2001-2024, Tencent Cloud.

MultiLingual version, Rev. 4300, © 2009-2024 codersclub.org

快速回复 返回顶部 返回列表