UK Regions & Counties SQL

Using my Dolibarr
1

Attached is a file containing the SQL code to add the UK regions and counties. Take a look and feel free to use it. Any questions, PM me.

dolibarr_countries_counties.txt (6.51 KB)

1 Like
2

Thanks for the file. However I get error with version 3.2.0. I have changed prefis from llx_ to doli_ But get error on line 2. However GB is already active in doli_c_pays so delete first 2 lines and works ok.
Regards

3

Thanks. data will be added for 3.3

4

I am using this file however for GB we do not have a code_department for our counties. Therefore values assigned ie 8xxx are meaningless. Is this field used for any other purpose than display or can we leave as null?
Thanks
Paul

5

Yes I noticed that too - it’s not used as far as I can tell

6

I am trying to add a new prospect/customer, however I don’t see UK listed under country. I believe this document will allow me to add UK? How do I input it into the system?

7

The country should be available by default install under name “United Kingdom” with code “GB”
Make a search on “GB”
(according to standard https://en.wikipedia.org/wiki/ISO_3166-1)

1 Like