Listings: Import CSV – not all column data being added to places

This topic contains 9 replies, has 4 voices, and was last updated by  Kiran 5 years, 9 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • January 24, 2019 at 3:26 pm #465233

    Nolan
    Expired Member
    Post count: 13

    I’m having some issues uploading CSV files. When I import some of the places update properly, but the majority have fields that are missing data that was in the import file. Please see the screenshots I have attached. All GD plugins are up-to-date as of posting this.

    Here is the CSV file: https://drive.google.com/file/d/14C3aljBDM3r7EyuCgDCh-e6c4UQLFTpf/view?usp=sharing

    January 24, 2019 at 7:36 pm #465274

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    There are errors in the CSV file.

    1) Categories: there is a comma in front of the ID and there shouldn’t be one. Also I believe the importer uses category names and slugs, not ID. (I’ll have a developer confirm this)

    2) Custom fields: Did you create them on your website in advance? Custom Field should have the geodir_ prefix and yours don’t have it.

    The best way to get this right is to add data to all custom fields in one listing manually and export the CSV to have all headings correct.

    3) Images: you should only add the file name and let GD tell you were to upload the file AFTER importing.

    Fixing this 3 points should do it.

    Let us know how it goes.

    Thanks

    January 24, 2019 at 7:43 pm #465278

    Paolo
    Site Admin
    Post count: 31206

    About point 1 the developers told me ID is the way to go with GDv2, but you need to remove the comma before the IDs. Comma are just needed to separate categories.

    Example:

    1,2,3

    not

    ,1,2,3,

    If instead you are still using V1, cat names must be used.

    Thanks

    January 25, 2019 at 5:53 pm #465471

    Nolan
    Expired Member
    Post count: 13

    Hi Paolo,

    Thank you for the fast reply.

    To clarify, I am using V2. This is my first attempt at setting up Geodirectory so nothing from V1 should be in there. Also to give you some context I added the custom fields within GD while setting it up. In order to keep the upload file equivalent I originally did what you suggested— I added a new listing to the website through wordpress then exported the listing as a CSV file. Here is how that file exports for your reference: https://drive.google.com/file/d/1tlVzb2xn5UBmzn_UcLJDSo9WlrN4infZ/view?usp=sharing

    As you will see I kept the column headers the same as the import file (no geodir_ prefix). Additionally you’ll see the comma before the category ID is present in this file.

    Anyway I updated the import with your recommendations. Seen here: https://drive.google.com/file/d/1swj-nBSmwD3UkczePQHJMjLhB_PT4GZx/view?usp=sharing On the first upload only 290 out of 401 were added even though the upload screen said that all 401 entries had been successfully added (see screenshot).
    Additionally 12 of those listings only had their post_title, post_content, post_tags, post_category, and post_image data imported. Also when I export the locations that were newly uploaded only 270 show up in the export file.

    I’m going to be playing around with it to see if I can try importing only the ones that didn’t import, but I wanted to give you an update in the meantime.

    Anyway thanks for the help here!

    Nolan

    January 25, 2019 at 6:10 pm #465475

    Alex Rollin
    Moderator
    Post count: 27815

    See also: https://wpgeodirectory.com/docs-v2/geodirectory/settings/import-export/#recommended

    January 25, 2019 at 6:11 pm #465476

    Nolan
    Expired Member
    Post count: 13

    I realize that I missed your #3 recommendation regarding image file paths. I just changed them for the file name instead and re-uploaded. I’m still seeing the same issue. The import screen says 401 items successfully added, but this time 289 places imported. I’m seeing a lot of overlap with the locations that are missing data from the import file.

    As I mentioned I’m going to try and isolate those entries that didn’t import to see if there is anything abnormal there. Unfortunately nothing is sticking out right now.

    January 25, 2019 at 6:21 pm #465478

    Paolo
    Site Admin
    Post count: 31206

    A developer has been alerted and will look into it if you share a url FTP and admin credentials in a private reply, it’ll be a lot easier for him.

    Let us know.

    Thanks

    January 25, 2019 at 7:00 pm #465482

    Nolan
    Expired Member
    Post count: 13

    Not sure if this helps, but here is a list of the locations that did not import: https://drive.google.com/file/d/1pIE01GyEBaF4tifvDv3xu-Ro-gOZuXMz/view?usp=sharing

    January 26, 2019 at 1:40 am #465502

    Nolan
    Expired Member
    Post count: 13

    Update here. I finally got the majority to import. It was foreign characters in the csv file that were keeping them from being imported properly. Turns out there are a lot of accented text when dealing with wines.

    February 1, 2019 at 1:11 pm #466604

    Kiran
    Moderator
    Post count: 7069

    Hello Nola,

    Can we mark this topic resolved or you still have any issue?

    Let us know.

    Kiran

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