importing data, crashes with european number formats
Bug #485245 reported by
Ana Juaristi Olalde
This bug affects 4 people
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) | Status tracked in Trunk | |||||
5.0 |
Won't Fix
|
Undecided
|
Unassigned | |||
Trunk |
Invalid
|
Undecided
|
Unassigned | |||
Odoo Server (MOVED TO GITHUB) | Status tracked in Trunk | |||||
5.0 |
Won't Fix
|
Undecided
|
Unassigned | |||
Trunk |
Confirmed
|
Wishlist
|
OpenERP's Framework R&D |
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...
Changed in openobject-addons: | |
status: | New → Confirmed |
To post a comment you must log in.
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