[configure CSV format] Import feature

More
11 years 9 months ago #39628 by suge1w
Guys I have a CSV file that i'm trying to import. All my columns seem to be sound. I have a "title" column but I always get an error message whenever I import "CSV file lacks column 'title'"

I have uploaded the file to see if I'm doing it right.
Attachments:

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39629 by ggppdk
Hello

you post this CSV files without mention the CSV format parameters that you used

before clicking to import, did you set the CSV format parameters?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39632 by suge1w
I used \t because I have columns seperated by tabs, \n indicating new line per item and I don't think it's mandatory but I set first column to "title"

I tried messing with debugging to see if that helps but it doesn't.

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39634 by ggppdk
Hello

why did you use TAB ??:
\t

your separator of fields seem to be:
;


Also you have field(column) enclosing character:
"
Did you not set this ?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39635 by suge1w
Semicolon is what I initially used to separate the fields into tabs. The saved CSV file is separated by tabs so I used \t... is that not what is meant by the 'field separator' field?

I've just tried to add in ';' instead but am getting the same error.

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #39636 by suge1w
Ahh okay, I have solved this with following settings:

;
"
\n
0

I was doing it wrong after all :oops:

Thank you Sir George :D

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.438 seconds
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save