Trouble importing listings

This topic contains 15 replies, has 2 voices, and was last updated by  Alex Rollin 5 years, 10 months ago.

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

Open Support Ticket
  • Author
    Posts
  • March 18, 2019 at 3:06 pm #475141

    Dotty Directory
    Full Member
    Post count: 254

    I’ve been attempting to run a few trial uploads of listings to make sure I’m ready for switching staging over to live, but they won’t import. Not sure why. It keep’s saying the listings were updated.

    Also, categories won’t save for me.

    Thanks,
    Mark

    March 18, 2019 at 3:07 pm #475142

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    March 18, 2019 at 6:33 pm #475183

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    please see our recommended process here:
    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    To import from V1, you will need to take your export from V1 and merge it into a CSV exported from your V2 site, and then load your images to the folder location shown at the end of the import.

    March 19, 2019 at 12:32 pm #475331

    Dotty Directory
    Full Member
    Post count: 254

    That is what I was trying initially, although another issue has been fixed in the meantime and the categories now work.

    I’ll try again when I can and let you know if it now works.

    Thanks,
    Mark

    March 19, 2019 at 3:55 pm #475374

    Dotty Directory
    Full Member
    Post count: 254

    Still not working correctly, I decided to just try an export, duplicate a record and reupload it. It actually added a listing this time but it’s missing nearly all information after address.

    Strangely enough when I try to upload the previous sheet it confirmed it updated listings but I still can’t see them.

    Let me know what you need.

    Thanks,
    Mark

    March 19, 2019 at 4:54 pm #475388

    Alex Rollin
    Moderator
    Post count: 27815

    please see our recommended process here:
    https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    To import from V1, you will need to take your export from V1 and merge it into a CSV exported from your V2 site, and then load your images to the folder location shown at the end of the import.

    March 20, 2019 at 12:59 pm #475527

    Dotty Directory
    Full Member
    Post count: 254

    Hi Alex, sorry I should of clarified it a bit better.

    I’ve followed the linked documentation and set up GeoDirectory mostly, the remaining changes are cosmetic and not structural. I’ve also added my custom post type as well as custom fields and imported my categories.

    The general overview is that it is set up.

    I’ve also tried following the suggested recommended importing procedure which failed before doing my previous post.

    Still not working correctly, I decided to just try an export, duplicate a record and reupload it. It actually added a listing this time but it’s missing nearly all information after address.

    Strangely enough when I try to upload the previous sheet it confirmed it updated listings but I still can’t see them.

    I’ve created listings, exported them, opened with OpenOffice Calc (I believe you refer to it as LibreOffice Calc), gathered data from a previous export from the old Directory, transferred it column by column.

    When uploading it seems fine and even suggests it’s updated when re-uploading the .csv but the listings don’t show up on neither the front or back end.

    Hope that clears up what I mean.

    Thanks again, Mark.

    March 20, 2019 at 8:34 pm #475593

    Alex Rollin
    Moderator
    Post count: 27815

    I tested and I don’t see any missing info in the import. Do you?

    March 21, 2019 at 10:17 am #475693

    Dotty Directory
    Full Member
    Post count: 254

    The one’s you have done is fine. Concerned why it’s not working for me then.

    What are the deliminator settings on Calc for you?

    I had it set as the image attached

    March 21, 2019 at 3:46 pm #475729

    Alex Rollin
    Moderator
    Post count: 27815

    Attached

    March 21, 2019 at 5:01 pm #475746

    Dotty Directory
    Full Member
    Post count: 254

    Tried changing the character set too, that didn’t work.

    I’ve attached the file I am trying to upload using the recommended import settings and same character set, as well as other options.

    I know it’s not really support and I appreciate your help but I genuinely can’t figure out what I’m doing wrong.

    Thanks,
    Mark

    March 21, 2019 at 5:02 pm #475747

    Dotty Directory
    Full Member
    Post count: 254
    This reply has been marked as private.
    March 21, 2019 at 8:09 pm #475785

    Alex Rollin
    Moderator
    Post count: 27815

    Are you setting the option to update if ID exists?
    I took a single row, changed title to test and it worked for me. I also exported and compared row headers (always gotta do that).

    March 22, 2019 at 9:57 am #475885

    Dotty Directory
    Full Member
    Post count: 254

    Yes I am, I did the same process but if I’m trying to add more, they just aren’t showing. Not sure what’s going on to be honest

    March 22, 2019 at 11:44 am #475891

    Dotty Directory
    Full Member
    Post count: 254

    I’ve just downloaded the CSV, opened with OpenOffice Calc, copied and pasted your listing, altered the ID and Title and tried to upload it.

    Nothing new was shown

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 16 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