Importing Places deletes my homepage and makes one of the listings my home page

This topic contains 22 replies, has 4 voices, and was last updated by  BJ Bowen 6 years, 10 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #387060

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    It depends on what you are testing, i just clone the DB, its only files i need to change on the dev site, is this not the case with you too?

    #387317

    BJ Bowen
    Full Member
    Post count: 73

    Okay. After reading your response, I don’t think you understand the extent of work that was done on the Development site.

    So here’s the scenario: I was asked to redesign the site (foundation96.com). So, I cloned the entire site over to the development area (dev.foundation96.com). We spent 2.5 months on redesigning the site, adding new pages and content in the development area.

    Once the redesign was finished and approved, the next task was to add the Users and Places (User Generated Content) that had been created on the live site (foundation96.com) WHILE the development of the new design was in progress in the development area (dev.foundation96.com). So, in other words, while I was working in the development area, the live site was still up and running and new User Generated Content was being created.

    So, I have two sites that need to be merged. 1) The development site has new CSS, new pages, new images, new sliders, and changes made to existing pages. 2) The live site only has two new types of content: Users and Places that were created since the redesign began.

    Importing/Exporting the new Users was not a problem.

    The problem was when I used GeoDirectory’s Import/Export tool for Places.

    So, how would you get the new Places that were added to the live site since the redesign began over to the development site without overwriting the content that had been created on the development site? How?

    Thank you.

    #387321

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    I would export by date only the new listings and import them after removing IDs data from the post_id column.

    That seems like such a simple solution that I’m sure you thought about it already.

    What’s the problem doing that? That’s what I think we are missing…

    Let us know,

    Thanks

    #387330

    BJ Bowen
    Full Member
    Post count: 73

    Actually, I didn’t know the import would work if I deleted the IDs from the post_id column. Yes, if that will work, it’s the easiest solution.

    #387339

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Yes if there is no ID then it will create a new listing, hence why we say to export only after X date so you dont end up with duplicates.

    Stiofan

    #388022

    BJ Bowen
    Full Member
    Post count: 73

    Hey… one more questions… and thanks so much for helping me through this… If I import without the ID, will that detach the User from that listing? Are users attached to the listing by the ID?

    #388047

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    no, post_author has its own column, just make sure you have the ID of the correct user for each listing in that column.

    Thanks

    #388055

    BJ Bowen
    Full Member
    Post count: 73

    sweet!! thank you!

Viewing 8 posts - 16 through 23 (of 23 total)

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

Open Support Ticket