importing data, crashes with european number formats

[Ana Juaristi Olalde]

Trying to import data on products, when formating csv archive prices decimal point have to be always point

On Spain, our basic format number is like this 1.234,00

Trying to import 12,34 is not possible. System gives an error float()
Substituing 12,34 by 12.34 on csv file it works, so Its a minor bug not critical at all.

And this is a little improvement on importing data. By default data separator should be different of ',' . This character is often used to separate addresses on standard way, and produces error on importing. I use ; and it works much better.

This is an spanish standard address:

C/ mayor, nº23 - 1ª

Thank you...

[Somesh Khare (somesh.khare)]

Hello Ana,

Yes, you are right when you substitute the fields in the CSV it changes the fields column type as text, This is the reason it works fine in the CSV.

But when you import the CSV in the OpenERP it matches the fields type, if the fields type found incorrect OpenERP buit functions raises such kind of Value Error. because it founds incorrect Value.

Hope this will clear the scenario.

Thanks