Difference between revisions of "Importing Tariffs from CSV with wrong Regional Settings"

From Kolmisoft Wiki
Jump to navigationJump to search
(New page: In many computers Regional Settings affects how CSV is saved from XLS file. MOR accepts CSV file where values are separated by comma "," and decimal places by point "." Very often values...)
 
Line 6: Line 6:


In order to import such files, we need to fix them a little.
In order to import such files, we need to fix them a little.
[[Image:crs1.png]]
[[Image:crs2.png]]
[[Image:crs3.png]]
[[Image:crs4.png]]
[[Image:crs5.png]]
[[Image:crs6.png]]
[[Image:crs7.png]]
[[Image:crs8.png]]
[[Image:crs9.png]]
[[Image:crs10.png]]
[[Image:crs11.png]]
[[Image:crs12.png]]

Revision as of 10:09, 3 April 2008

In many computers Regional Settings affects how CSV is saved from XLS file.

MOR accepts CSV file where values are separated by comma "," and decimal places by point "."

Very often values are separated by ";" and decimal places by comma ","

In order to import such files, we need to fix them a little.

Crs1.png Crs2.png Crs3.png Crs4.png Crs5.png Crs6.png Crs7.png Crs8.png Crs9.png Crs10.png Crs11.png Crs12.png