Easy to Create, Easy to Change - Easy to use!


Import csv


Started by Rainer
Search
You will need to Sign In to be able to add or comment on the forum!

Import csv

I have problems to import csv data with the decimal. The coma in csv is a point and in dataease a coma.

The function Import "insert decimals for fixed point field" does only work when you have 0,12 or 0,50 but not when you have 0,5

Written by Rainer 16/02/16 at 09:31:28 Dataease [{8}]FIVE

Re:Import csv

Hmmm...
Commas and national characters is a returning problem in Dataease, and I think it has been "solved" a 1000 times and every time in a slightly different way...

DataEase use . in coding (it can be overridden with setting in RDRRxAAA.INI for an application) but it displays decimals and dates/time etc as configured in the operating system on the computer it is run.

So far so good, but what about importing data?

Here DataEase could choose the path of the programmer...always . for decimal or the path of the user i.e. what the user use.

So if you use , in your windows, DataEase will expect , as decimal in import files.

As you see from above:

1. this is the data as they were saved and exported. In the export file we removed trailing 0s.
2. This is re-imported with the same decimal separator. You see that it import fixed decimals correctly even with trailing 0s removed.
3. We change the Windows decimal settings to German (,)...And we get a mess as expected.

It is tricky to balance national settings especially when you move between programming and human interface etc.

Written by DataEase 17/02/16 at 16:15:08 Dataease [{8}]FIVE