[Nikki Christiansen]

I found a post where you described how to import only categories:

Do you mean just importing categories? You can do that too, though, not exactly straight forward.

Create a CSV with three columns; first name, last name, category. You only need to add a single row. Add a bogus first and last name. In the category column, add all you categories separated by commas. Import the CSV and then delete the bogus entry. You’ll be left with just the imported categories.

When you say “add all the categories separated by commas”, how do you do that in one column.
I have an excel spreadsheet with just a column for categories (304 of them), and have saved it as a .csv file.
Are you saying I just add a 2 columns for first and Last name, fake ones, then upload.
Also, I currently have categories, with entries assigned to them. Will the current categories be deleted?
I just don’t want to delete any of the current data I have uploaded.

[Steven Zahm]

@ Nikki

No you would have three columns with all 304 of your categories in the Categories column. So you CSV file would look something like this:

First Name, Last Name, Categories
Jane, Doe, “cat 1, cat 2, cat 3, so on, and so on”

I believe there is a command in Excel that you can use to convert the column to a row and then you should be able to merge the row contents.

Hope that helps!

[Nikki Christiansen]

Like this? I have attached the csv file.

Also, will this delete the current categories I have in there.

This is the website: http://www.denverleadsgroups.com/leads-group-7/
It is for a Chamber Leads Group Program. I already have the Leads Groups as categories, but now want to add industries.

If I do have to re-add the Leads Groups as categories, will I have to reassign each member again?

Attachments:

You must be logged in to view attached files.

[Steven Zahm]

@ Nikki

No, like this:

First Name,Last Name,Chamber Member Industries
Jane,Doe,"Accounting Services, Advertising ,Aerospace"

You will only have two rows, three columns. All the categories will be in one “cell” separated by commas with the entire “cell” wrapped in double-quotes.

No categories will be deleted, the import will only add new ones new categories.

Hope that helps!

[Author]

Posts