CSV Issues - Creating Duplicate Cities

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

Open Support Ticket

Author

Posts
September 2, 2014 at 9:18 pm #14083

identity
Lifetime Member

Post count: 445

First tests with uploading via CSV and it looks like it is creating new locations for all of the cities. Since the site will be a hyper-local focus, I had already added all of the locations.

Based on the Lat/Long coordinates, it looks like the duplicate cities are based on the first entry for that respective city in the CSV. Looking in the SQL location table, a new ID is created for the city, though the slug stays the same for both versions.

Not entirely sure if this is related, but I had also setup 76 categories across 10 CPTs, which all seemed to have disappeared. I hadn’t looked in there before attempting the upload, so not sure if they had disappeared prior to this for some other reason.

Going to be uploading around 4,000 or so listings, so want to avoid trying to merge locations or other issues.

cheers

September 2, 2014 at 10:26 pm #14091

identity
Lifetime Member

Post count: 445

Well, I’ve solved at least part of this…

key note for US sites…if you preset locations, make sure the state form matches…abbreviation vs. spelled out.

September 3, 2014 at 10:28 am #14123

Guust
Moderator

Post count: 29970

Unless your data for a location is exactly the same [same spelling and name for city, region and country, and same LAT and LNG), the system will create another location [it is only a machine :)]

CTPs and Categories should be created before uploading a CSV.
Did you find the existing ones back?

September 3, 2014 at 10:51 am #14130

identity
Lifetime Member

Post count: 445

Thanks Guust.

Not sure what happened. …category names, slugs, default image, map markers….most of those “disappeared.” And that included CPTs that I wasn’t even trying to CSV upload into.

Later I discovered that a lot of the form field settings for the CPTs reverted back to default settings as well.

Actually spent around 6 hours the other night setting up all of the CPTs. That included time figuring out what all the settings did and the different settings and creating a master spreadsheet to make this mostly copy-paste–highly, highly recommend this for everyone!

Not taking nearly as much time to rebuild these, but still painful and this is going to be huge issue if these continue to disappear or something else is wiping them out.

cheers
Author

Posts