| |

AVHzY Forum

 找回密码
 注册
查看: 280|回复: 2

Problem with CSV-Export

[复制链接]

1

主题

1

帖子

7

积分

Newbie

Rank: 1

积分
7

 Germany

发表于: 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


回复

使用道具 举报

0

主题

15

帖子

76

积分

Moderator

Rank: 7Rank: 7Rank: 7

积分
76

 China

发表于: 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

Rank: 1

积分
4

 United States

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

回复

使用道具 举报

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

本版积分规则

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

GMT-8, 19-02-2019 01:49 , Processed in 0.061710 sec., 24 queries .

Powered by Discuz! X3.4

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

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