Importing markers and categories/maps

  • effusing
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 5 months ago #5131 by effusing
Importing markers and categories/maps was created by effusing
Dima, I'm migrating from GooglePro maps to Zh GoogleMaps. Looking for a way to import the data, I have over 900 markers from 90 countries/categories. Are you interested in contracting to do this for us? thanks.

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

  • effusing
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 5 months ago #5132 by effusing
Replied by effusing on topic Importing markers and categories/maps
Hello, I see I can load placemarks via phpAdmin
wiki.zhuk.cc/index.php?title=Zh_GoogleMap_LoadPlacemarks

I also wish to load maps, which fields in the maps table are required to load a list of maps?

thanks.

Also still interested in contracting you to do this for us. Please reply.

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

More
10 years 5 months ago #5133 by Dima
Replied by Dima on topic Importing markers and categories/maps
Hi

Sorry for delay, I'm busy at work.

You can import your data (by that tutorial).

I don't know how the data stored in the other extension (simple table fields, or JSON).
if simple database columns - you can simple execute SQL clause

insert into <my_table_for_placemarks> ( <column_list>) select <column_list> from <your_table_with_old_data>

<> - you can replace it by yours names

It is easy, just look at MySQL docs

Insert .. select ... it is very easy way to do.

I don't think it is too hard to you to do it by yourself.

As for required fields - there are defaults on columns, then you don't need to fill it all.

Only one thing - categories. I suggest you to load your data without categories, and after load data just update to your. Or create categories which you need, and use it when load.

Feel free, you can mail me
ZhukDL@gmail.com

Don't forget support my developments: post review in JED , donate , help with translation ;)

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

Time to create page: 0.215 seconds
Powered by Kunena Forum