update via import

This topic contains 11 replies, has 2 voices, and was last updated by  Guust 5 years, 8 months ago.

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

Open Support Ticket
  • Author
    Posts
  • August 31, 2018 at 6:36 pm #444876

    Charles Renwick
    Lifetime Member
    Post count: 15

    Hi, I’m have trouble getting my listings to update.
    I have the option “Update listing if post with post_id already exists” selected and I am certain I am using the correct post ID, but a new record is created nonetheless.
    I’ve reviewed the core export & import docs and I don’t seem to be able to identify the problem.
    Any help would be much appreciated.

    August 31, 2018 at 11:22 pm #444900

    Guust
    Moderator
    Post count: 29970

    Can you please post your URL, WP admin detail, and also details of a listing you try to update, in a private reply.
    Then we can have a check for you.

    Thanks

    August 31, 2018 at 11:28 pm #444902

    Charles Renwick
    Lifetime Member
    Post count: 15
    This reply has been marked as private.
    September 1, 2018 at 12:18 am #444912

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    September 1, 2018 at 12:22 am #444915

    Charles Renwick
    Lifetime Member
    Post count: 15
    This reply has been marked as private.
    September 1, 2018 at 1:03 am #444917

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    September 1, 2018 at 1:04 am #444918

    Guust
    Moderator
    Post count: 29970

    I have updated a listing without any issue after turning off endurance cache.
    https://wpgeodirectory.com/docs/known-issues/#cacheplugins

    Thanks

    September 1, 2018 at 4:22 pm #444954

    Charles Renwick
    Lifetime Member
    Post count: 15

    Thanks,
    Still not able to update via the import on my end.

    September 1, 2018 at 11:28 pm #444970

    Guust
    Moderator
    Post count: 29970

    Are you creating a new CSV file or exporting, then updating, and re-importing?
    What is the post ID number of the new listing created? It must be a different number, which suggests you are doing it wrong.
    Try adding 1 new test listing with a CSV file without adding a post_id.
    Check the post_id [see image], and add to the same CSV.
    Upload again with “Update listing if post with post_id already exists” selected.

    Thanks

    September 1, 2018 at 11:29 pm #444972

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    September 2, 2018 at 12:09 am #444985

    Charles Renwick
    Lifetime Member
    Post count: 15

    Thanks. That works. I was trying to export into an Access database and then manipulate and filter data and then import updated info. Not sure how it is changing such that the info in Access is not able to be uploaded. I hope to have over 200k records eventually so exporting the whole database every time I want to make an update to a handful of records is going to be tedious. Any suggestions?

    September 2, 2018 at 12:20 am #444986

    Guust
    Moderator
    Post count: 29970

    Updating a handful is probably easier just doing it in the WP Admin backend.
    You do not need to export first, and you can use the same CSV file to add data and then import.
    Any of the Microsoft products add invisible extra code that can break imports: https://wpgeodirectory.com/docs/core-export/#important

    Thanks

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

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

Open Support Ticket