OS Property support center

Country: France. Missing some cities and states

  • Hoffmann
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 5 months ago #90951 by Hoffmann
Hey, i tried to add a few cities and states that are missing from the France location, modifying the fr-FR location files but i'm returned with multiples SQL errors messages when uploading. Obviously i'm doing something wrong. Here's my modified files.
Those "States" are: Martinique, Côtes d'Armor, Côtes-d'Or, Mayotte, Guyane et Guadeloupe, Val-d'Oise, La Réunion.

Could you help me format this correctly ?
Attachments:

Please Log in or Create an account to join the conversation.

More
8 years 5 months ago #91007 by Mr. Dam
Hi Hoffmann,
You should change:
Côtes d'Armor, Côtes-d'Or and Val-d'Oise to Côtes d\'Armor, Côtes-d\'Or and Val-d\'Oise
to solve the SQL error
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Hoffmann
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
8 years 5 months ago #91015 by Hoffmann
Thank you very much!
Solved.

While we're here, do you think the sql database could import something with more information such as this file i'm adding as attachments?

The main problem could be the singularity and differences between each country.
But it could allow:
-Search by postal code,
-Search by clicking somewhere on a map.
-Precise listing.

Ay... too much work.

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamNguyen Phu Quan