[Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays

2014-06-28 Par sujet Oli Sennhauser
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'

[Dolibarr-dev] Translation of `llx_c_departements`

2014-06-28 Par sujet Oli Sennhauser
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

[Dolibarr-dev] Translation of table llx_c_forme_juridique

2014-06-28 Par sujet Oli Sennhauser
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

Re: [Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays

2014-06-28 Par sujet Destailleur Laurent
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

Re: [Dolibarr-dev] Translation of table llx_c_forme_juridique

2014-06-28 Par sujet Destailleur Laurent
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