-->
Welcome, Guest
Username: Password: Remember me

TOPIC: UK Regions & Counties SQL

UK Regions & Counties SQL 6 years 5 months ago #20173

  • whythehellnot
  • whythehellnot's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 9
  • Thank you received: 1
  • Karma: 0
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.

File Attachment:

File Name: dolibarr_countries_counties.txt
File Size: 6663
The administrator has disabled public write access.
The following user(s) said Thank You: aljawaid

Re:UK Regions & Counties SQL 6 years 2 months ago #20615

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
The administrator has disabled public write access.

Re: UK Regions & Counties SQL 6 years 2 months ago #20623

  • eldy
  • eldy's Avatar
  • OFFLINE
  • Administrateur
  • Open Source ERP CRM expert.
  • Posts: 1666
  • Thank you received: 102
  • Karma: 175
Thanks. data will be added for 3.3
The administrator has disabled public write access.

Re: UK Regions & Counties SQL 6 years 1 week ago #21280

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
The administrator has disabled public write access.

Re: UK Regions & Counties SQL 6 years 1 week ago #21292

  • whythehellnot
  • whythehellnot's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 9
  • Thank you received: 1
  • Karma: 0
Yes I noticed that too - it's not used as far as I can tell
The administrator has disabled public write access.

UK Regions & Counties SQL 6 months 4 days ago #33275

  • cdan_hi
  • cdan_hi's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 4
  • Karma: 0
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?
The administrator has disabled public write access.

UK Regions & Counties SQL 6 months 4 days ago #33278

  • eldy
  • eldy's Avatar
  • OFFLINE
  • Administrateur
  • Open Source ERP CRM expert.
  • Posts: 1666
  • Thank you received: 102
  • Karma: 175
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)
Last Edit: 6 months 4 days ago by eldy.
The administrator has disabled public write access.
The following user(s) said Thank You: cdan_hi
Time to create page: 0.082 seconds