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...
_______________________________________________
Mailing list: https://launchpad.net/~c2c-oerpscenario
Post to : [email protected]
Unsubscribe : https://launchpad.net/~c2c-oerpscenario
More help : https://help.launchpad.net/ListHelp
