translation problems when import while the data is translated

[Aline (OpenERP)]

create an empty db (without demo data) in french.

- got to customer (shortcut "Client") list
- create a "Client" and don't forget to fill in "Pays" field (country_id)
- export the "Client" (with this field)
- in the csv you can see "Belgique"
- import this csv

-> error due to translation, the system doesn't know "Belgique" but "Belgium"

L'import a échoué car : Traceback (most recent call last): File "/home/aline/openerp/trunk/server/openerp/netsvc.py", line 410, in dispatch result = ExportService.getService(service_name).dispatch(method, auth, params) File "/home/aline/openerp/trunk/server/openerp/service/web_services.py", line 598, in dispatch res = fn(db, uid, *params) File "/home/aline/openerp/trunk/server/openerp/osv/osv.py", line 122, in wrapper return f(self, dbname, *args, **kwargs) File "/home/aline/openerp/trunk/server/openerp/osv/osv.py", line 176, in execute res = self.execute_cr(cr, uid, obj, method, *args, **kw) File "/home/aline/openerp/trunk/server/openerp/osv/osv.py", line 167, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/home/aline/openerp/trunk/server/openerp/osv/orm.py", line 868, in import_data process_liness(self, datas, [], current_module, self._name, fields_def, position=position) File "/home/aline/openerp/trunk/server/openerp/osv/orm.py", line 818, in process_liness res = _get_id(relation, line[i], current_module, mode) File "/home/aline/openerp/trunk/server/openerp/osv/orm.py", line 741, in _get_id raise ValueError('No record found for %s' % (id,)) ValueError: No record found for Belgique

-

[Vo Minh Thu (thu)]

Probably related to this bug report: https://bugs.launchpad.net/openobject-server/+bug/721347

[Yogesh (SerpentCS) (yogesh-serpentcs)]

Hello Aline,

I have checked your issued with latest trunk but I didn't faced any problem.

Can you check again with the latest code?

Thanks.

[Cristian Salamea (ovnicraft)]

Hello R&D team, can you set a serie for this bug ?

Regards,

[Rudolf Schnapka (rs-t3)]

Hi you all,
I believe there is a larger issue behind all this... as issues described in Bugs #1081953 and #993466 as well as this and a few others suggest:
any import/export works quite smoothly without translation. As soon as translation is needed export and import seem to be incompatible. Exports do not use translation while import expects translated terms. Setting up tables on installation of apps/modules give different results when using native english vs. translated base-database. (As described in #1081953)

hope this helps find the issue(s) and leads to resolving something that has been a pain for a long time now...

thanks