Updating Data via CSV

This topic contains 7 replies, has 3 voices, and was last updated by  thebirdiemachine 10 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • September 17, 2014 at 1:02 pm #15690

    thebirdiemachine
    Expired Member
    Post count: 246

    I am wondering after I upload my initial files (spreadsheets) to GD and need to update them because say I have added fields or refined fields etc – how does GD handle this? Does it overwrite my old stuff or does it duplicate entries? Will it mess up user review/comments?

    Thanks
    Stacey

    September 17, 2014 at 1:11 pm #15692

    Simone
    Expired Member
    Post count: 3515

    Hello Stacey, it will duplicate the entries.

    September 17, 2014 at 1:18 pm #15696

    thebirdiemachine
    Expired Member
    Post count: 246

    Yikes! Is there anyway to keep this from happening? I do have all the paid add-ons (duplicated listing alert). If not what is the best way to go about this do you think?

    September 17, 2014 at 1:21 pm #15697

    Simone
    Expired Member
    Post count: 3515

    I’m afraid but you should manually edit this via wordpress backend or via phpmyadmin, editing the geodir_place_details (or any post type you have created, e.g. geodir_restaurants_details if restaurants) and then editing the column for each field (these are self explanatory such as post_title, post_address etc..)

    September 17, 2014 at 1:28 pm #15698

    thebirdiemachine
    Expired Member
    Post count: 246

    OK. Can I ask what is the purpose/function of the Duplicate Alert Addon?? I originally thought it would have something to do with this issue, but obviously I am wrong about that.

    September 17, 2014 at 1:46 pm #15701

    Simone
    Expired Member
    Post count: 3515

    For some unknown reasons, I had the duplicate alert plugin disabled when testing, now I have enabled it but it’s the same: when uploading a CSV with same entries, it will duplicate the entries. To be honest, I ran different tests, even adding the entry manually (with the duplicated alert set to notify me if the title is duplicated) but i didn’t receive any notification about the duplicated listing. I will notify Paolo, he might address what’s wrong.

    September 17, 2014 at 3:06 pm #15711

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    Ajax duplicate alert is only working on the add listing form to prevent visitors to add duplicates.

    It doesn’t perform any check on the CSV file uploaded and the CSV upload is meant to add new listings only, not to edit them.

    Thanks

    September 17, 2014 at 3:09 pm #15712

    thebirdiemachine
    Expired Member
    Post count: 246

    Got it! Makes sense, thank you @paolo

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount