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

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

Open Support Ticket

Tagged: Import CSV

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