importing data, crashes with european number formats

Bug #485245 reported by Ana Juaristi Olalde
20
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
Revision history for this message
Somesh Khare (somesh.khare) wrote :

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: nobody → SKH(OpenERP) (skh-openerp)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.