Dynamic Data not via XML?

[dotpitch]

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

[Perry]

Hi 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
– Perry

[dotpitch]

Would 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

[Perry]

Hi 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” option

Please 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
– Perry

[dotpitch]

Thank 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

[Perry]

Hi 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
– Perry

[dotpitch]

The 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

[Perry]

Hi Christian

I’ve sent you an e-mail, please check your inbox

Kind regards
– Perry

[dotpitch]

Hy Perry, did you get my response?

Kind Regards, Christian

[Perry]

Hi Chrsitan,

Sorry about the delay in responding, please check your inbox

Kind regards
– Perry

[Author]

Posts