New home › Forums › Basic Version › General queries › Dynamic Data not via XML?
Tagged: xml
- This topic has 9 replies, 2 voices, and was last updated 5 years, 10 months ago by dotpitch.
-
AuthorPosts
-
November 16, 2017 at 12:24 pm #32179dotpitchMember
Hy Guys,
I tried to serve Marker via XML but the Plugin overwrites the XML File.
I need a way to serve Client Data to the Plugin, I thought that is xml is supposed to?
Clients Data is saved in a DB so I could generate a XML file with the right data by my self but why you overwrite the XML File?Is there a way to fix that?
Thanks Christian
November 16, 2017 at 12:37 pm #32180PerryModeratorHi Christian
Thank you for getting in touch!
The XML file merely serves as a cache, it’s not recommended that you write to that file because any changes made there will be overwritten, it’s also a deprecated feature.
I recommend that you select the data from the DB and then write it to the relevant wpgmza_tables
I can help you convert your data if you need?
Kind regards
– PerryNovember 16, 2017 at 12:59 pm #32181dotpitchMemberWould be really Cool if you could help me.
I think I need a script select the Clients Data (from localhost DB) and drop it to wpgmza_tables ones a day. The Clients data don’t offer a LAT or LONG just the City and Street+ Number. Or do you have a better Solution? If I get it to work I will purchase the pro version cause I need 2-3 Maps.
Thank You Perry!
Kind regards Christian
November 16, 2017 at 1:03 pm #32182PerryModeratorHi Christian
In that case the best option would be to
1) Export the table to a CSV
2) Download the example from here http://www.wpgmaps.com/documentation/exporting-and-importing-your-markers/
3) Re-arrange the columns in your clients CSV to match the ones in the example, and finally
4) Import the resulting CSV using the “geocode addresses” optionPlease note the CSV import / export is a feature of our Pro add-on
If you need any help doing this, please let me know?
Kind regards
– PerryNovember 16, 2017 at 1:11 pm #32183dotpitchMemberThank you, thats not possible.
Just to clarify the long way of the Data:
Clients local Software stores Data in another local Database. From there we drop the Data to our Online Database. If the Client change something in they’re local Software we sync it to the online DB. So nobody can upload a csv file. :/
I think there is no Solution with wpgmaps to do this right?
Hmmm
regards Christian
November 16, 2017 at 1:42 pm #32185PerryModeratorHi Christian
If you wanted to do it directly from DB to DB programatically, you would need to use PHP to read the data, geocode it and then write to the other when you sync. If you can tell me more about your sync method I can be more specific.
I have a server side geocoding class I’d be happy to give you if you’d like to implement this yourself,
If you’re interested we could potentially submit this as a custom job subject to quote
Please let me know?
Kind regards
– PerryNovember 16, 2017 at 2:06 pm #32186dotpitchMemberThe sync is done by another Guy and its not relevant for me.
But yes, read the Data by PHP, geocode it and write to wpgmza_tables is what could be possible. It all in the same DB.
Read and write is possible for me but geocode it maybe not, cause I´m not a coder 🙂How much would you charge for it? If you like we can talk about that by Mail!?
Kind regards Christian
November 16, 2017 at 4:12 pm #32193PerryModeratorHi Christian
I’ve sent you an e-mail, please check your inbox
Kind regards
– PerryNovember 17, 2017 at 4:29 pm #32227dotpitchMemberHy Perry, did you get my response?
Kind Regards, Christian
November 17, 2017 at 5:25 pm #32228PerryModeratorHi Chrsitan,
Sorry about the delay in responding, please check your inbox
Kind regards
– Perry -
AuthorPosts
- You must be logged in to reply to this topic.