40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Import Issues

This topic contains 36 replies, has 3 voices, and was last updated by  Anitra Larsen 4 years, 4 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • November 18, 2019 at 11:55 pm #517700

    Anitra Larsen
    Full Member
    Post count: 52

    I’m trying to create a couple new CPTs for my GeoDirectory. I’d like to export some listings from the “places” category and into these new CPTs. So for example, I need to export listings from my “Dining” category and then import them into my new CPT for “Restaurants.”

    I’ve been following the instructions in your documentation, I’ve created a sample listing in that CPT and downloaded/exported the CSV file from my new CPT for restaurants. Then I used the SAME file (adding some listing info) for 3 test listings. But after import, most of my fields are missing (address, longitude, latitude, phone, website, facebook, etc.)

    I’ve tried a dozen different things and I still get this error. Can you please help figure out what’s going wrong?

    November 19, 2019 at 12:15 am #517707

    Alex Rollin
    Moderator
    Post count: 27815

    Please zip the file into a .zip archive before posting.

    Did you use Open or Libre office to edit the file?

    November 19, 2019 at 12:17 am #517709

    Anitra Larsen
    Full Member
    Post count: 52
    This reply has been marked as private.
    November 19, 2019 at 12:31 am #517714

    Anitra Larsen
    Full Member
    Post count: 52
    This reply has been marked as private.
    November 19, 2019 at 12:44 am #517716

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    If you are wanting to import ‘new’ listings, as in, transfer listings from one CPT to another, then the ID column should be blank.

    November 19, 2019 at 12:49 am #517717

    Anitra Larsen
    Full Member
    Post count: 52

    Oh THANK YOU! I assumed what I needed to do was change the post type on the existing IDs, not create new listings. Now I understand and it works!

    November 19, 2019 at 12:56 am #517719

    Anitra Larsen
    Full Member
    Post count: 52

    So, one final issue (fingers crossed) – it didn’t import the images correctly. It put an image in the “featured image” location in the admin, but it doesn’t show on the front end of the site at all. And when I had multiple images, it seemed to only grab the one…

    I copied the “post_images” column exactly from my places table into my restaurants CPT table.

    November 19, 2019 at 1:16 am #517722

    Alex Rollin
    Moderator
    Post count: 27815

    I would try re-importing.

    Try removing the full url from the image in post_images column. Instead of the full URL just leave the filename like filename.jpeg

    Don’t remove any of the other values around the image, just the URL.

    November 19, 2019 at 2:25 am #517724

    Anitra Larsen
    Full Member
    Post count: 52

    I tried that… just removing the part of the URL and leaving the file name, but that had the same results. Featured image shows only in admin. No additional images are added.

    November 19, 2019 at 3:37 pm #517792

    Anitra Larsen
    Full Member
    Post count: 52

    Any other ideas on this? I can’t ask the client to re-upload all of their images…

    November 19, 2019 at 6:22 pm #517829

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    If you are importing listings then the images will need to be in the expected folder location, yes. If you uploaded them today the folder is 2019/11

    November 19, 2019 at 6:29 pm #517833

    Anitra Larsen
    Full Member
    Post count: 52

    Ok. Well they obviously are not all in the same folder… These are listings that have been imported gradually over a 3 year period. And for 500+ listings, it’s not good time management to re-upload all the images AND edit them all in the spreadsheet either when an export/import process exists.

    So I think I will need to figure out how to use the full URL on these imported listings. How is that accomplished? How do I get the import function to read the full address of the image? If this option doesn’t work (and in my attempts it has not), it seems there’s some work to be done on the import process. Can you bring in a developer to help with this?

    November 20, 2019 at 7:48 am #517894

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    November 20, 2019 at 2:33 pm #517937

    Anitra Larsen
    Full Member
    Post count: 52
    This reply has been marked as private.
    November 21, 2019 at 11:12 am #518093

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 37 total)

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

Open Support Ticket