vData - category import - category needs a title

More
8 years 9 months ago #3420 by Matthias
My idea was to use the export file as template for the import.

Please Log in to join the conversation.

More
8 years 9 months ago #3421 by Daniel
Did you make any changes in the exported file? If not, Please share your backend & FTP login credentials via Contact us form, We'll look into it.

Thanks
Daniel

Please Log in to join the conversation.

More
8 years 9 months ago #3423 by Matthias
Hello,
i have only add a new entry in the file, all other are unchanged. For testing i have installed a brand new joomla site. I'll send you the login data via your contact form.

Here the test files from the new joomla site:

File Attachment:

File Name: test-files.zip
File Size:4 KB


Thanks
Matthias
Attachments:

Please Log in to join the conversation.

More
8 years 9 months ago #3426 by Daniel
Hello,
Which application are you using to Edit CSV file? You have incorrectly edited the file. You've enclosed all the columns within a single inverted commas ( "" ). Please correct that. You can use MS Excel or MAC's Number application to edit the CSV file.

Thanks
Daniel

Please Log in to join the conversation.

More
8 years 9 months ago #3429 by Matthias
Hi Daniel,
i use MS Excel 2016. I have removed the "" manuelly via the standard MS text editor. Now the import works, but when I edit the imported categories I get the error message "Error decoding JSON data: Syntax error". You can check this at the test site (category IDs 14 + 15).

Import File without ""

File Attachment:

File Name: import-joo...es-2.zip
File Size:0 KB


BR
Matthias
Attachments:

Please Log in to join the conversation.

More
8 years 9 months ago #3432 by Daniel
Hi,
Given CSV file is semi colon separated while it should be comma separated, Please keep it as it is as you exported. Though it works on semi colon as well, but you should set the semi colon as the delimiter in vData configuration as well. And JSON error is because params and metadata fields are not formatted properly, both fields are missing comma between JSON attributes. How did you get these two fields in this format?

Thanks
Daniel

Please Log in to join the conversation.

Cron Job Starts