[please configure proper CSV file format] Import not working

More
10 years 9 months ago #44558 by pundip
I have been unable to get the import function to work. Clicking "Test file format" takes me to a blank page which has this message:
"please click here to return previous page please click here to return previous page" and nothing else.
"Prepare import task" just logs me out of the admin backend. Now when I try to import the same file I get a popup saying that "CSV lacks column 'title' . The file has a column called 'title'

Flexi content version is 2.1.2 r1806 beta and its running on Joomla! 3.2.1 Stable [ Ember ] 18-December-2013 14:30 GMT

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

More
10 years 9 months ago #44562 by ggppdk
Hello

you do not mention the format of your CSV file

since you get this message but you have a title it means that you have not configured the format of the CSV file properly

there are 3 parameters that define the format of the CSV file, it is close to the selection of the CSV file (please read inline instructions/description)


-- 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
10 years 9 months ago #44564 by pundip
I am using the CSV export from excel with the "," delimiter and " as item separator. All , have been removed from the content before converting to CSV. I have attached the file.

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

More
10 years 9 months ago #44582 by ggppdk
Hello

pundip wrote: I am using the CSV export from excel with the "," delimiter and " as item separator. All , have been removed from the content before converting to CSV. I have attached the file.


and what is the field separator then?
and i am not sure that i understand what is the item separator either
e.g. you say it is double quote
which sound wrong
because i suspect that you have double quote at the start and at the end of item ?
the item separator should be only at the end of the record

Please note that:
1. parsing of CSV file is tested and it works, e.g. in your case you may need to take a closer look at you CSV file format


2. debugging of your CSV file format is not possible to support individually, it is your responsibility to set a proper format of your CSV file, if you have a particular bug to report then we will help you with it and provide a fix

e.g. v2.1.2 r1806 - v2.1.3 r1824 (beta) have a bug they cannot accept reverse single quote (due to Joomla way of saving session into DB):
`

single reverse quote issue is fixed in v2.1.3 r1837 (beta), but this fix is not relevant in your case, in your case you need to configure proper format

docs.google.com/uc?export=downl ... VNJTHQ5V00


-- 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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.430 seconds
Save
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