40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Export-import problem

This topic contains 13 replies, has 4 voices, and was last updated by  Paolo 5 years ago.

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

Open Support Ticket
  • Author
    Posts
  • April 5, 2019 at 4:13 pm #478657

    milettic
    Expired Member
    Post count: 240

    Hi,
    I have successfully migrated from GDV1 to GDV2. Now I am trying to Export listings from that GDV2 and import to new clear WP with GDV2, but I have a problem…

    in which order do I need to import data? First locations, then Categories and then Listings? Do I even need to import locations?
    In the “old” web site I have some additional Custom Fields that I want to ignore and not to import. Do I need to delete them firstly?

    I’m getting only two messages:
    1. If I chose “Update listing If post ID already exists” I received the message that Listings already exists (But the database is empty)
    2. If I chose to ignore listing if post ID exists, I receive the message that they were successfully imported. But the database is still empty.

    Can you help me please?

    April 5, 2019 at 4:18 pm #478658

    milettic
    Expired Member
    Post count: 240
    This reply has been marked as private.
    April 5, 2019 at 8:45 pm #478723

    Paolo
    Site Admin
    Post count: 31206

    1st you should create the custom fields in Place > Settings.

    Don’t create those that you want to drop.

    No need to import locations, 1st categories, then listings.

    If that doesn’t work, please provide access to phpmyadmin or cpanel.

    Thanks

    April 6, 2019 at 1:27 pm #478898

    milettic
    Expired Member
    Post count: 240
    This reply has been marked as private.
    April 6, 2019 at 4:34 pm #478922

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    If importing to a new site you must remove the post ID.
    You must also make sure the category ID match up, if importing them they may change in some circumstances.

    Stiofan

    April 6, 2019 at 5:43 pm #478927

    milettic
    Expired Member
    Post count: 240

    Ah, ok for post IDs, maybe I can do that…
    And yes, category IDs are changed…how to solve this? How to update? Do I need to update all _terms tables manually?

    And, if the solution is to change Category ID in CSV, how to do that? IDs are not unique and I don’t know how to replace them only in one column… if you understand what I mean…

    April 8, 2019 at 1:59 pm #479226

    milettic
    Expired Member
    Post count: 240

    I did manually drop and import entire _term tables with phpmyadmin (4 of them)… Seems that now I can import Listings regularly…

    Currently, there is also a Bug in phpmyadmin which doesn’t allow to export in SQL single table…

    April 8, 2019 at 8:15 pm #479297

    Alex Rollin
    Moderator
    Post count: 27815

    Do you have a backup? Can you restore it?

    I think Stiofan meant that you would need to swap out new IDs for old in the CSV.

    April 8, 2019 at 8:27 pm #479300

    milettic
    Expired Member
    Post count: 240

    I managed to somehow solve the problem. Do not touch anything 🙂 If it does not work, I’ll call you for help.
    I managed to migrate 160k Listings. Now I need to test.

    April 8, 2019 at 9:19 pm #479310

    milettic
    Expired Member
    Post count: 240

    I managed to import Listings, but there is a ton of duplicates. How to clean?
    The problem importing Listings without IDs is that if something goes wrong during the import, then you have to delete all and start from the beginning, true?!

    Also, then why you have options “Update listing if post ID already exists” and “Ignore listing if post ID already exists” if I import without IDs?

    April 8, 2019 at 9:33 pm #479314

    Alex Rollin
    Moderator
    Post count: 27815

    If you are importing a CSV with new and old listings, that setting allows you to skip the old/existing listings.

    To identify duplicates you could create a category ‘dupes’ and export via CSV< identify duplicates, set that category, and then import.

    Once changes are in the listings can be delected from the “all places” screen. Use screen options to select up to 200 listings at a time, use category to sort by ‘dupes’ category and bulk trash them.

    April 8, 2019 at 9:41 pm #479316

    milettic
    Expired Member
    Post count: 240

    I am not sure what are you suggesting to me

    I have 160.000 Listings, I can’t repeat 800 times select and delete… and if I select to show more than 250 listings, wp brakes during bach delete.

    I have 9 CSV files with 20k listings… I’ve tried to export 100k but WP freeze…

    April 15, 2019 at 3:04 pm #480868

    milettic
    Expired Member
    Post count: 240

    I managed to get everything done…

    April 15, 2019 at 10:21 pm #480970

    Paolo
    Site Admin
    Post count: 31206

    Glad to hear that and thanks for letting us know.

    Thanks

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

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

Open Support Ticket