Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
Tagged: 8.1.5, category, csv import
- This topic has 3 replies, 2 voices, and was last updated 8 years, 5 months ago by Steven Zahm.
12/02/2014 at 6:50 pm #311505Nikki ChristiansenParticipant
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.12/03/2014 at 9:16 am #311595Steven ZahmKeymaster
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!12/03/2014 at 12:04 pm #311630Nikki ChristiansenParticipant
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.12/03/2014 at 12:30 pm #311633Steven ZahmKeymaster
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!
You cannot reply to this support topic. Please open your own support topic.