Resolved import file

You don't happen to have a tutorial for Excel or Open Office according rules to import with: , or ; or / or.. the do's or dont's :-(

regards,
Hennie

Hello,

Have started all over again made new-template and file. But still een error log. The images could not be downloaded. (have checked the url this time :-)
Have send the details again.

com_csvi.log.91.zip csvi_templates_j3x.mx-onlineshop.nl_20180618(2).xml



kind regards,
Hennie

Hello Hennie,

Can't get it right yet. I have ordered the template fields according to the file I want to import.
But the import mixes the coloms.

From your last reply it looks like you have solved this.

The file is in .csv extension (ods is not allowed?)

Yes, .ods files are supported. The supported extensions by CSVI are csv, tsv, txt, xml, xls and ods

You don't happen to have a tutorial for Excel or Open Office according rules to import with: , or ; or / or.. the do's or dont's :-(

We dont have a tutorial for rules separately. Just that we have a tutorial which explains how to save a CSV file as UTF 8 encoded document.

Have started all over again made new-template and file. But still een error log. The images could not be downloaded. (have checked the url this time :-)
Have send the details again.

You are not seeing images because you don't have file_url field added in your template. Add this field and map it to the image field in your import file to see the images.

Hello Tharuna,

Yes one file did the job, but I have multiple files from different suppliers and don't understand when the files look the same they act differently.
I send you the file I used this time,( did have an url present) that's why I don't understand it.



kind regards,
Hennie

Hello Hennie,
Ok i see the issue now, you have mapped productafbeelding column to product_url field in your template fields but it should be file_url and not product_url. product_url is for product manufacturer URLs. Change the field name and you should have your images loaded.

Hello Tharuna,

thanks for sticking with me :-)

4 Attachments, I hope you can tell me whats wrong... :-(

Kind regards,
Hennie

com_csvi.log.101.zip

did change the name of the colum productafbeelding: however no affect. I am stuck with the separation of the collums ??

Hello Hennie,
Please check your file using CSVI Analyser, if your file has any formatting issues Analyser will show it. If you are having any difficulty then post the import file so i can check it for you.

Attached the Analyser report.
Nothing wrong?
I don't get it :-((

kind regards,
Hennie

Er is een fout opgetreden tijdens de 1import. Hieronder staat het antwoord van de server.
Status error: 200
Status message: OK
Warning: Division by zero in /var/www/vhosts/http://mx-onlineshop.nl/J3X.mx-onlineshop.nl/plugins/csviaddon/virtuemart/com_virtuemart/model/import/product.php on line 910 {"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"Duplicate entry '0' for key 'PRIMARY'"}

this is the message I get after importing the same file....

Hello Hennie,

Attached the Analyser report.
Nothing wrong?
I don't get it :-((

Can you post your import file so i can check?

Er is een fout opgetreden tijdens de 1import. Hieronder staat het antwoord van de server.
Status error: 200
Status message: OK
Warning: Division by zero in /var/www/vhosts/http://mx-onlineshop.nl/J3X.mx-onlineshop.nl/plugins/csviaddon/virtuemart/com_virtuemart/model/import/product.php on line 910 {"error":true,"process":false,"url":"administrator\/index.php?option=com_csvi&view=imports","message":"Duplicate entry '0' for key 'PRIMARY'"}

Looks like there is a entry in your virtuemart_products or virtuemart_products_xx_xx (xx_xx is your language table) with virtuemart_product_id as 0 and so this duplicate entry error. Can you check these tables with entry 0 for virtuemart_product_id?

com_csvi.log.105.zip

regards,
Hennie

Hello Hennie,
I would need your import file you used for import and not the import debug log. I will run the import here and see what happens. Can you please post that?

Kenny-test2.csv

Hello Hennie,
In your template settings on File tab you have set Autodetect delimiters to Yes, set it to No and in Field delimiter field enter ; and save the template. Run the import with your file and check.

YES YES YES !!

That did it :-)

Thanks so much, Now I can move on.....

kind regards,
Hennie