How do we want to fix the 3-letter ISO codes in the table llx_c_pays?
For me the following job worked but I do not believe it is the right
place...
Source: http://en.wikipedia.org/wiki/ISO_3166-1
UPDATE llx_c_pays SET code_iso = 'AFG' WHERE code = 'AF';
UPDATE llx_c_pays SET code_iso = 'ALA'
Hello all,
how is the translation of the departments table done? Is this in transifex?
Quick and dirty this worked for me:
UPDATE llx_c_departements SET nom = 'Aargau' where rowid = 378;
UPDATE llx_c_departements SET nom = 'Appenzell Innerrhoden' where rowid
= 379;
UPDATE llx_c_departements SE
Hello all,
how is the translation of the forme_juridicque table done? Is this in
transifex?
Quick and dirty this worked for me:
UPDATE llx_c_forme_juridique SET libelle = 'Einzelfirma' WHERE rowid = 124;
UPDATE llx_c_forme_juridique SET libelle = 'Einfache Gesellschaft' WHERE
rowid = 125;
UP
I update file llx_c_00_pays.sql to include the update.
A better fix would be to modified directly the insert instead of doing
insert then update into this file.
2014-06-28 15:51 GMT+02:00 Oli Sennhauser :
> How do we want to fix the 3-letter ISO codes in the table llx_c_pays?
>
> For me the fol
Thanks Oli.
Another contributor send us this for juridical type of companies for
germany:
insert into llx_c_forme_juridique (fk_pays, code, libelle) values (5,
'500', 'GmbH - Gesellschaft mit beschränkter Haftung');
insert into llx_c_forme_juridique (fk_pays, code, libelle) values (5,
'501', 'AG