Dynamic Data not via XML?

New home Forums Basic Version General queries Dynamic Data not via XML?

Tagged: 

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #32179
    dotpitch
    Member

    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

    #32180
    Perry
    Moderator

    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

    #32181
    dotpitch
    Member

    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

    #32182
    Perry
    Moderator

    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

    #32183
    dotpitch
    Member

    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

    #32185
    Perry
    Moderator

    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

    #32186
    dotpitch
    Member

    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

    #32193
    Perry
    Moderator

    Hi Christian

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

    Kind regards
    – Perry

    #32227
    dotpitch
    Member

    Hy Perry, did you get my response?

    Kind Regards, Christian

    #32228
    Perry
    Moderator

    Hi Chrsitan,

    Sorry about the delay in responding, please check your inbox

    Kind regards
    – Perry

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.