import zip codes and city names for a country

Using my Dolibarr
1

Hi

which table in the database stores country city names and zip codes so i can populate it for Bulgaria ?

2

Take a look at
htdocs/install/mysql/data/llx_00_c_country.sql
htdocs/install/mysql/data/llx_10_c_regions.sql
htdocs/install/mysql/data/llx_20_c_departements.sql
to see how the tables are populated and use the later entries as examples of how to add all the necessary queries for Bulgaria.
Then post them back here so they can be included in the next Dolibarr.

3

Hi

Bulgaria was present in llx_c_country

departments and region files contain only Bulgarian regions 28 and municipalities 265

add them to the next dolibarr version

dolibarr.rar (3.12 KB)

1 Like
4

Hi IvanBG,
Thank you for sharing, but why are you using the Latin names if you are in Bulgaria? I asked you because I am also and we running everything in Bulgarian. You can pm me if you want.

Regards,

5

hi :happy:

I think the translation is done by lang files, dolibarr team will have to give us file with translation key and i will input Bulgarian translated string.
but i’m not sure :happy: someone from dolibarr will have to say how should we proceed.
I have translated and corrected many strings in Bulgarian for dolibarr in transifex.com

1 Like