vData - category import - category needs a title
8 years 9 months ago #3420
by Matthias
Replied by Matthias on topic vData - category import - category needs a title
My idea was to use the export file as template for the import.
Please Log in to join the conversation.
8 years 9 months ago #3421
by Daniel
Thanks
Daniel
Replied by Daniel on topic vData - category import - category needs a title
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.
8 years 9 months ago #3423
by Matthias
Replied by Matthias on topic vData - category import - category needs a title
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:
Thanks
Matthias
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:
Thanks
Matthias
Please Log in to join the conversation.
8 years 9 months ago #3426
by Daniel
Thanks
Daniel
Replied by Daniel on topic vData - category import - category needs a title
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.
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.
8 years 9 months ago #3429
by Matthias
Replied by Matthias on topic vData - category import - category needs a title
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 ""
BR
Matthias
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 ""
BR
Matthias
Please Log in to join the conversation.
8 years 9 months ago #3432
by Daniel
Thanks
Daniel
Replied by Daniel on topic vData - category import - category needs a title
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?
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.