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.
08/21/2015 at 7:47 pm #343891
I followed the steps in this FAQ: http://connections-pro.com/faqs/how-do-i-import-categories/ and separated the new categories I want to create via CVS import and they are not being created. For instance, I have “Categories” as the column Heading then Trust, CT (where Trust and CT are two different categories separated with the comma as stated in the FAQ) and what happens is Trust is created as a category, but with left quote marks and CT is added as my First Address line with right quote marks.
I attached a screenshot.
Attachments:You must be logged in to view attached files.08/22/2015 at 10:58 am #343930
The instructions are correct for a CSV file, that said, it sounds like you entering your data into a spreadsheet app. A spreadsheet is not a CSV … a spreadsheet app can save the file as a CSV file and when it does, it will add the necessary quotes. Put another way, in your spreadsheet, do not add the quotes, only separate the categories with commas.
Hope that helps, let me know.08/24/2015 at 11:00 am #344142
I am using Excel and saving as an CSV file (not a spreadsheet), so that won’t work? I am not adding any quotes myself…I’m adding a comma between multiple categories. I am doing everything as stated in your FAQ…and it’s not working as it said it would.08/24/2015 at 11:18 am #344143
Excel is a spreadsheet app. Saving it from Excel as a CSV file will work fine. The issue you are experiencing, from my experience, can only happen when the info is being manually quoted in the spreadsheet. For me to further diagnose the issue, I’ll need to see the CSV file you are importing. Please change the
.txtand attach it as a reply and I’ll take a look at it immediately after receiving it.09/09/2015 at 2:41 pm #346180This reply has been marked as private.09/09/2015 at 2:43 pm #346182
Hmmm I do see quotes in the txt file, but I never added any to the Excel created cvs file. How can I stop that from happening? I am not manually adding those quotes.
09/09/2015 at 2:47 pm #346184This reply has been marked as private.09/09/2015 at 3:53 pm #346206
- This reply was modified 8 years, 5 months ago by Vikram Rajan.
re: Hmmm I do see quotes in the txt file, but I never added any to the Excel created cvs file. How can I stop that from happening?
This is correct. Excel should be adding the quotes otherwise that would create an invalid CSV file. Like I said, it’ll add the necessary quotes.
When imported, two categories should be created. One for “Trust and Probate” and another for “CT”. The entry should be linked to both.
I test imported the file and it imported correctly with the settings for Fields delimited by: set to Tab and the setting for Fields enclosed by: set to Double Quotes
Excel exported CSV files do work fine, however, Excel also has a history not doing a so great of a job at it. It could be that it worked for me fine because merely saving the file could have corrected text encoding errors cause by Excel. Try using LibreOffice instead saving the CSV out as comma separated and fields double quoted (it’ll as).
Hope that helps!09/09/2015 at 4:44 pm #346213
Crazy! I used OpenOffice and that worked! Thank you very much!09/09/2015 at 8:22 pm #346226
Great to hear!
You cannot reply to this support topic. Please open your own support topic.