Bulk Import Question

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

Open Support Ticket

Tagged: bulk import, CSV

Author

Posts
May 18, 2016 at 10:43 pm #193899

Caryl Hale
Free User

Post count: 39

Hi, I am currently setting up the database for a bulk import using csv.

I have a few places that do not have an address listed. These are in home businesses that do not wish to have their addresses listed. How do I include these? They are already in the database, is this something I am going to have to exclude because of lack of address and latitude/longitude coordinates? Thanks.

Caryl

May 19, 2016 at 12:35 pm #194181

Guust
Moderator

Post count: 29970

You can create a CPT for those businesses without an address, and then select that CPT at
GD > general > general tab > Select CPT to disable physical location
That will allow you to use listings without an address.

May 19, 2016 at 5:56 pm #194387

Caryl Hale
Free User

Post count: 39

Also, do you have a sample csv file of just the mandatory data needed to import. I don’t have a lot of the fields that are shown in the sample data file. I want to make sure I get it right. Thanks.

May 19, 2016 at 6:14 pm #194397

Paolo
Site Admin

Post count: 31206

Hi,

please see: https://wpgeodirectory.com/docs/core-export

Thanks

May 19, 2016 at 7:37 pm #194450

Caryl Hale
Free User

Post count: 39

This reply has been marked as private.

May 19, 2016 at 8:15 pm #194461

Paolo
Site Admin

Post count: 31206

Hi,

that will not import.

Because of double quotes (which are used as delimiters) part of the content of each column is being moved to the next column, messign up the whole file.

See image attached.

Try to avoid ” and if you can’t use a backslash before them. Like this: ” (that will tell the file that it’s not a delimiter)

Let us know,

Thanks

May 20, 2016 at 1:26 pm #195016

Caryl Hale
Free User

Post count: 39

Paolo-

I apologize for the many questions but appreciate the help. I am looking at fixing this csv file, so if I open in notepad and us the find and replace option, what would you suggest I replace the ” with? The ” ? Or should I use the Find option and delete the ” ?

On the ” is it both of those keys? Or do I leave out the “?

One last question…in the notepad, I see some columns have many commas, will this interfere with the import? I have attached screenshots.

May 20, 2016 at 1:32 pm #195020

Guust
Moderator

Post count: 29970

You really need to use OpenOffice, please review https://wpgeodirectory.com/docs/core-export

May 20, 2016 at 1:51 pm #195022

Caryl Hale
Free User

Post count: 39

I had used libreoffice, which was listed. So, I am downloading openoffice now. Do I open my csv in open office and then fix the formatting? Do I use a find and replace function?

May 20, 2016 at 2:12 pm #195036

Caryl Hale
Free User

Post count: 39

I have opened this file in openoffice and I don’t see any ” but I do see <?> in some of the post_content fields

May 20, 2016 at 8:58 pm #195394

Paolo
Site Admin

Post count: 31206

Hi,

make sure to clean it up and avoid empty rows.

There are other weird charcters like: Insurance Centralÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ (row 230)

Make sure all headers are there as in the sample file. Between post_category
and post_type you ahve 5 empty headers (that’s not going to work).

Several listings have empty address, that will not work.

Post region cannot be abbreviation. Kansas should be Kansas not KS

Several listings have lat and long, that will not work.

Do not delete file header, leave them blank but don’t delete them. You deleted everything after geodir_website

Let us know how you went.

Thanks
Author

Posts