c2c-oerpscenario team mailing list archive

["SKH\(OpenERP\)" <485245@xxxxxxxxxxxxxxxxxx>]

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

** Changed in: openobject-addons
     Assignee: (unassigned) => SKH(OpenERP) (skh-openerp)

-- 
importing data, crashes with european number formats
https://bugs.launchpad.net/bugs/485245
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: Confirmed

Bug description:
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...