*

RogSM

  • **
  • 16 posts
Location Italy database.
« on: November 30, 2022, 07:54:36 PM »
I've loaded the database for Italy and although there are regions, there are no cities so unfortunately Google Maps doesn't work. If the Italy database isn't going to be updated is there any way that I can do a limited update myself that will load into osclass and create working Google Maps? Even if I could add say 20 cities per region it would be a great help for my application.

*

MB Themes

Re: Location Italy database.
« Reply #1 on: December 01, 2022, 10:48:29 PM »
Not sure how it relates to google maps?
Not all regions has cities, really depend on source if it had them or no, anyway you can update location structure in oc-admin
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

RogSM

  • **
  • 16 posts
Re: Location Italy database.
« Reply #2 on: December 02, 2022, 06:26:10 PM »
None of the regions in the osclass Italy database contain cities which of course is not correct.

If you add cities yourself in the osclass locations dashboard then they are not picked up by Google Maps and the item's Google Maps position doesn't display on the item page. In fact there's no Google Map at all.

I've checked other country databases in the SQL tables and they have GPS coordinates and a couple of other codes that I don't understand and cities are numbered, so without having more information on the database structure I can't update the Italy database myself in a way that works with the Google Maps API.

Is there a site or source from which osclass obtains its country databases?
« Last Edit: December 02, 2022, 06:30:46 PM by RogSM »

*

MB Themes

Re: Location Italy database.
« Reply #3 on: December 02, 2022, 06:43:40 PM »
Go there.
http://download.geonames.org/export/zip/

Check italy data.
At bottom of page, you will find explanation what each column means.
If you can clearly identify what is region and what is city (by providing administrative codes), we can review Italy database.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

RogSM

  • **
  • 16 posts
Re: Location Italy database.
« Reply #4 on: December 03, 2022, 05:55:47 PM »
OK, I've done it myself. The official osclass Italy database was structured incorrectly and contained several typing and syntax errors all of which I've corrected. I've now created a new version which works perfectly for me in Osclass 8 with Sigma theme and is uploadable via data import.

If you let me know how I can get it to you (it's only 4.7 mb so I could even email it as an attachment) you can check it out and put it into your library as a general download. I'm amazed to find that it contains around 40000 locations!

Now if someone could tell me how to transfer the relevant sections out of the gui item.php into the standard sigma item.php to get the fancy image viewing function I reckon we'd be about evens :-)
« Last Edit: December 03, 2022, 08:00:22 PM by RogSM »

*

MB Themes

Re: Location Italy database.
« Reply #5 on: December 06, 2022, 02:51:55 PM »
Nice to hear ;)
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots