[Import format was not understood according to configuration] fc 3.3.2 - CSV export file is missing the ID column

More
4 years 8 months ago #78177 by manchine

ggppdk wrote: Hello

e.g. your first row needs to field-names and NOT field labels !
aka "created_by" and not "Created By"
aka "state" and not "Published"


This is how the export tool generated the file.
I haven't found any export configuration option to export field names instead of labels.

Please see attached file.


File Attachment:

File Name: EXPORT3.txt
File Size:18 KB

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

More
4 years 8 months ago #78178 by ggppdk
Hello

the export and import features were developed independently
the exported data is not a direct match for the import task

in order for import to work
you need to do things like change the first line to be field names instead of field labels


-- 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
4 years 7 months ago #78441 by manchine

ggppdk wrote: Hello

To export the id
1. create a new field of type CORE-property field type
(and assign it to the desirable item types or to ALL item types)
2. Configure in it to display "ID"
3. Enable CSV export in it


I've followed this method and got an export file with the id column.
Nonetheless, the import tool keeps saying that the id column is missing.

Thanks.


File Attachment:

File Name: EXPORT_mod.csv.txt
File Size:135 KB
Attachments:

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

More
4 years 7 months ago - 4 years 7 months ago #78443 by ggppdk
Hello

please configure these to match your import file format
- record separator
- field separator

then the import file format ... will be parsed properly and the ID column (and all other columns) will be ... "found"

Default export format is this so configure it for import
Code:
Field Separator \t Field Encloser Character " Item Separator \n


-- 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...
Last edit: 4 years 7 months ago by ggppdk.

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

More
4 years 7 months ago #78450 by manchine

ggppdk wrote: Hello
Default export format is this so configure it for import

Code:
Field Separator \t Field Encloser Character " Item Separator \n


Is it possible to set Export format options anywhere?

Without changing anything, the CSV file I'm getting uses a comma as field delimiter and double quotes (") as item separator.
When I configure the Import tool with matching delimiters, it still complains about a missing id column.
Attachments:

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

More
2 years 1 month ago #82854 by zarzon56640
Bonjour, les items sont bien importés mais pas les contenus comme la "description" par exemple!

Hello, the items are well imported but not the contents like the "description" for example!
 

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.428 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