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

From Kolmisoft Wiki
Jump to navigationJump to search
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.
FIle in Excel looks like this:


[[Image:crs1.png]]
[[Image:crs1.png]]
Let's save it to CSV format:
[[Image:crs2.png]]
[[Image:crs2.png]]
CSV looks like this and we see incorrect file format for MOR import (';' and ',' instead of ',' and '.'):
[[Image:crs3.png]]
[[Image:crs3.png]]
Let's open this file in some editor (MS Word in this example - any other will be good also):
[[Image:crs4.png]]
[[Image:crs4.png]]
We see same picture in MS Word also:
[[Image:crs5.png]]
[[Image:crs5.png]]
In '''Find and Replace''' window enter '''Find what''': ',' and '''Replace with''' '.', e.g. we are fixing decimal values from ',' to '.':
[[Image:crs6.png]]
[[Image:crs6.png]]
We replaced a lot of values:
[[Image:crs7.png]]
[[Image:crs7.png]]
We see some improvement:
[[Image:crs8.png]]
[[Image:crs8.png]]
Again in '''Find and Replace''' window enter '''Find what''': ';' and '''Replace with''' ',', e.g. we are fixing value separation from ';' to ',':
[[Image:crs9.png]]
[[Image:crs9.png]]
Even more fixes done:
[[Image:crs10.png]]
[[Image:crs10.png]]
We see correct file format:
[[Image:crs11.png]]
[[Image:crs11.png]]
Let's save it to another correct file:
[[Image:crs12.png]]
[[Image:crs12.png]]
Now you are ready to import this CSV file into MOR tariffs.

Revision as of 10:16, 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.

FIle in Excel looks like this:

Crs1.png


Let's save it to CSV format:

Crs2.png


CSV looks like this and we see incorrect file format for MOR import (';' and ',' instead of ',' and '.'):

Crs3.png


Let's open this file in some editor (MS Word in this example - any other will be good also):

Crs4.png


We see same picture in MS Word also:

Crs5.png


In Find and Replace window enter Find what: ',' and Replace with '.', e.g. we are fixing decimal values from ',' to '.':

Crs6.png


We replaced a lot of values:

Crs7.png


We see some improvement:

Crs8.png


Again in Find and Replace window enter Find what: ';' and Replace with ',', e.g. we are fixing value separation from ';' to ',':

Crs9.png


Even more fixes done:

Crs10.png


We see correct file format:

Crs11.png


Let's save it to another correct file:

Crs12.png


Now you are ready to import this CSV file into MOR tariffs.