obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 1, 2020 14:51:19 GMT
Hello there from Germany,
i got a Problem with the .csv file from the Sotware.
The Rows are not korrekt lined up if you import the .csv file in open office. Is there any solution that i didnt found ?
Martin
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 13:45:01 GMT
I use Open Offie CALC the same thing as excel, these things have Problems with the comma between the Data rows
I think the export file is bad Programmed.
there are commas as seperator, but the voltage nr. got also an comma in his value.
Sample:
Days Ago,Min Battery Volt.(V),Max Battery Volt.(V),Max Charge Curr.(A),Max Discharge Curr.(A),Max Charge Power(W),Max Discharge Power(W),Charge Ah,Discharge Ah,Charge KWh,Discharge KWh
12,0,0,0,0,0,00,0,00,0,0,0,0,0,0
,,,,,,,,,,
10,0,0,0,0,0,00,0,00,0,0,0,0,0,0
9,13,0,13,1,0,00,0,12,0,0,0,0,0,0
8,12,9,14,7,3,80,0,13,52,0,7,0,0,092,0
7,12,6,13,4,1,80,6,25,21,79,3,1,0,039,0,012
6,12,9,13,7,1,85,0,00,20,0,4,0,0,052,0
,,,,,,,,,,
4,11,4,14,6,5,82,20,76,80,186,6,0,0,079,0
3,12,9,13,5,1,80,0,00,22,0,3,0,0,039,0
2,12,9,14,3,2,55,0,00,34,0,6,0,0,078,0
,,,,,,,,,,
0,11,8,14,8,6,75,6,13,60,78,9,6,0,117,0,073
|
|
|
Post by Admin on Jan 3, 2020 17:08:25 GMT
Hello there from Germany, i got a Problem with the .csv file from the Sotware. The Rows are not korrekt lined up if you import the .csv file in open office. Is there any solution that i didnt found ? Martin Unfortunately, there is nothing we can do about this. We no longer offer support for this type of software, it is currently unsupported -Renogy Team
|
|
|
Post by mediadogg on Jan 3, 2020 17:21:34 GMT
If I remember correctly, the European standard for CSV uses ";" as a separator in order to avoid the problem that you are seeing ("," in the data).
The only solution is to smartly pre-process the data file to either (1) substitute "." for "," in the numeric data, or (2) substitute ";" for "," as the delimiter, or (3) enclose all data values with quotes, such as "12,4".
If you are not able to do this, or select options within open office to do it, let me know, and I might be able to write a small program to do it for you.
The other possibility is that you can force the export to be in "US" format, which will export the numbers with "." instead of ",". This will allow Open Office to correctly use the "," as delimiter.
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 19:29:10 GMT
Hello there from Germany, i got a Problem with the .csv file from the Sotware. The Rows are not korrekt lined up if you import the .csv file in open office. Is there any solution that i didnt found ? Martin Unfortunately, there is nothing we can do about this. We no longer offer support for this type of software, it is currently unsupported -Renogy Team Sad Sad, I thought something like that already.
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 19:33:32 GMT
If I remember correctly, the European standard for CSV uses ";" as a separator in order to avoid the problem that you are seeing ("," in the data). The only solution is to smartly pre-process the data file to either (1) substitute "." for "," in the numeric data, or (2) substitute ";" for "," as the delimiter, or (3) enclose all data values with quotes, such as "12,4". If you are not able to do this, or select options within open office to do it, let me know, and I might be able to write a small program to do it for you. The other possibility is that you can force the export to be in "US" format, which will export the numbers with "." instead of ",". This will allow Open Office to correctly use the "," as delimiter. Hi there, i tried to manually pic the right numbers together, that worked but was very time consuming, I think a little "programm" in office where the right numbers get automatically sortet would work, but i dont know if i want to do so. ( hope my English is readable ) :-)
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 19:34:41 GMT
Insert a column, do the column math in the new column column B + column c/10 , copy down the column I think i know what you want to tell me, but i didnt understand it :-)
|
|
|
Post by mediadogg on Jan 3, 2020 19:37:33 GMT
Insert a column, do the column math in the new column column B + column c/10 , copy down the column If the problem is what he says it is, commas inside the data, then this solution will not work in general if a particular data value ever does NOT have a comma. Hopefully, the export process has an option to either use decimal points in the numbers or enclose all data in quotes.
|
|
|
Post by mediadogg on Jan 3, 2020 19:40:10 GMT
Insert a column, do the column math in the new column column B + column c/10 , copy down the column I think i know what you want to tell me, but i didnt understand it :-) I think he was telling you to do exactly what you did, but you found it time consuming. I think if you explore the options in CALC and the export process, there might be an option already available. You are likely not the first European user of these programs.
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 19:44:26 GMT
Thanks mediadogg, yes this is the Problem, only commas , , , , , , , :-) and in the Programm i got no options for export. i will try it the time consuming version, :-)
|
|
|
Post by mediadogg on Jan 3, 2020 19:50:13 GMT
Thanks mediadogg, yes this is the Problem, only commas , , , , , , , :-) and in the Programm i got no options for export. i will try it the time consuming version, :-) If you are certain that the data ALWAYS contains a comma in the same column(s) in EVERY row, then you can use the solution that bupkis gave very easily, using a CALC macro.
|
|
|
Post by mediadogg on Jan 3, 2020 20:02:39 GMT
Another idea. If you are the administrator for your PC, perhaps you can create a new User ID, just for the purpose of using this software. That user ID should have the "localization" set to "US", so that programs use the "." instead of "," for decimal numbers. This will automatically cause the export program to create the correct format for the CALC program to work correctly.
|
|
obi81
Solar Newcomer
Posts: 9
|
Post by obi81 on Jan 3, 2020 20:57:41 GMT
Another idea. If you are the administrator for your PC, perhaps you can create a new User ID, just for the purpose of using this software. That user ID should have the "localization" set to "US", so that programs use the "." instead of "," for decimal numbers. This will automatically cause the export program to create the correct format for the CALC program to work correctly. wow, this sound like a crazy idea, what could work you have some good ideas but i createt an import calc what sorts the numbers together. And its working But the Open office is a shit Programm, cant handle commas in a diagramm and crashes more often. think i must search my old excel programm
|
|