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.
Premium Support
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
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.
So not put the quotes in. The column header for categories should be Category not ” category”.
The category value should be Almond not “Almond” or ‘ Almond’
This has nothing to do with your theme, you need to structure the data correctly.
When you enter your data in Excel or LibreOffice you do not add the quotes. When you export the CSV file from those applications they will properly added the quotes (well, LibreOffice does it correctly all the time … Excel can mangle it which is why I suggested using LibreOffice.
When you are working in a spreadsheet application you are not creating the CSV file you are creating a spreadsheet file. You only get a CSV file by exporting/saving as the spreadsheet as a CSV file. During this save process from the spreadsheet to CSV file, the application will automatically add the quotes, you do not add them when creating the spreadsheet.
When saving from LibreOffice. Save it as a CSV file. Use the settings shown in the attached screenshot.
When importing, the quotes are imported because different applications will quote the values differently. You can find out how the app quoted the values by opening the CSV file in a text editor like Notepad++.
The settings in the CSV Import page apply only to the CSV file not how the data is entered in the spreadsheet.
The only time you would add the quotes yourself is if you are manually creating a CSV file.
If you want to learn me about CSV files, read this page. I skimmed over it, it seems like a pretty thorough resource to learn from.
.
