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.
Noticed my topic was closed, so creating a new one. Sorry for the delay. Busy times.
I looked into the issue further and now I see that the multiple categories are actually exporting, however, they are also separated by commas within the cell, so when we open the file in Excel, all of the categories get separated into their own cell. The only way to resolve this is the open the export file in a text editor and replace ALL of the “, ” (quote comma space quote) with a tab character and then delete the remaining quotes. This resolves the issue. It would be nice to have the option of comma separated or tab separated. Is this something that is being considered for future releases? Thanks Steve!
re: when we open the file in Excel, all of the categories get separated into their own cell.
When you import it, change the delimiter from tab to comma.
*For this to work in Excel 2013, you must uncheck Use system separators in Options>Advanced**
Or add this to the top of the CSV file: http://superuser.com/a/730509
re: It would be nice to have the option of comma separated or tab separated. Is this something that is being considered for future releases?
Technically, that would be a TSV file, not a CSV file. I’m not planning on adding any options to the CSV Export to keep them simple to use.
Thanks for your thoughts and assistance Steve!
You cannot reply to this support topic. Please open your own support topic.