Hey there
I am trying to do my import but get the following error:
Warning
JFolder::create: Could not create folder.Path: /ods
Copy failed: /home/strato/www/ca/http://www.myname.de/htdocs/tmp/com_csvi/3137320441/TEMPLATE_import_Nov2017_V.0.2.ods to /ods/TEMPLATE_import_Nov2017_V.0.2.ods.zip
×
Error
Archive does not exist
Accepted Answer
Pending Moderation
Hello Julius,
Glad to know that it worked. Please leave us a review on Joomla extension directory
Glad to know that it worked. Please leave us a review on Joomla extension directory
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Julius,
To make it easy for users we have added an option of changing virtuemart_vendor_id field value to 0 from CSVI maintenance menu instead of looking for table in database and changing it manually. You need to load the attached patch file to get this new option. Once the patch file is updated, go to CSVI Pro >> Maintenance page. Select VirtueMart in first drop down and Fix related products/categories duplicates option in the second drop down, click Continue. This will fix the virtuemart_vendor_id value to 0. Now run the import and check if the related products are not duplicated.
patch_vm_maintenance_2017_11_09.zip
To make it easy for users we have added an option of changing virtuemart_vendor_id field value to 0 from CSVI maintenance menu instead of looking for table in database and changing it manually. You need to load the attached patch file to get this new option. Once the patch file is updated, go to CSVI Pro >> Maintenance page. Select VirtueMart in first drop down and Fix related products/categories duplicates option in the second drop down, click Continue. This will fix the virtuemart_vendor_id value to 0. Now run the import and check if the related products are not duplicated.
patch_vm_maintenance_2017_11_09.zip
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
No, i meant a tool for accessing your database tables which is normally PHPMyAdmin. FileZilla is for accessing files and folders of your site and that wont help here.
No, i meant a tool for accessing your database tables which is normally PHPMyAdmin. FileZilla is for accessing files and folders of your site and that wont help here.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
"Use the tool with which you access you site database and look for .."
Do you mean by tool my FileZilla in order to acess all the data where I also drop all the images? If yes, there are many folders and I would like to know which folder contains the file/table "#__virtuemart_customs". Please discribe the path.
Thanks
Do you mean by tool my FileZilla in order to acess all the data where I also drop all the images? If yes, there are many folders and I would like to know which folder contains the file/table "#__virtuemart_customs". Please discribe the path.
Thanks
Accepted Answer
Pending Moderation
Hello,
#__virtuemart_customs is a VirtueMart table and you need to look for it in your database. Use the tool with which you access you site database and look for #__virtuemart_customs table in the list(#_ will be your table prefix). In that table records check for rows with entries as "Related Products" and "Related Categories" in custom_title column. For these rows check column virtuemart_vendor_id and change its value to 0 if its entered as 1 and that will solve your issue. Hope it is clear now.
value virtuemart_vendor_id #__virtuemart_customs table
what do you mean by field? where do i find this? is that in the template or options? or under VM > configurations?
#__virtuemart_customs is a VirtueMart table and you need to look for it in your database. Use the tool with which you access you site database and look for #__virtuemart_customs table in the list(#_ will be your table prefix). In that table records check for rows with entries as "Related Products" and "Related Categories" in custom_title column. For these rows check column virtuemart_vendor_id and change its value to 0 if its entered as 1 and that will solve your issue. Hope it is clear now.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hey
the post is a little to advanced for me. I do not understand the different terms.
What I found is this, but do not know what to do or where to do the change from 0 to 1:
"For Virtuemart version 3 and above, the field value virtuemart_vendor_id is 0 in #__virtuemart_customs table for related products and related categories(core inserts of Virtuemart). CSVI script checks related products against value 0 and not 1. Changing virtuemart_vendor_id field for related products to 0 will solve the issue of inserting related products repeatedly.
value virtuemart_vendor_id #__virtuemart_customs table
what do you mean by field? where do i find this? is that in the template or options? or under VM > configurations?
the post is a little to advanced for me. I do not understand the different terms.
What I found is this, but do not know what to do or where to do the change from 0 to 1:
"For Virtuemart version 3 and above, the field value virtuemart_vendor_id is 0 in #__virtuemart_customs table for related products and related categories(core inserts of Virtuemart). CSVI script checks related products against value 0 and not 1. Changing virtuemart_vendor_id field for related products to 0 will solve the issue of inserting related products repeatedly.
value virtuemart_vendor_id #__virtuemart_customs table
what do you mean by field? where do i find this? is that in the template or options? or under VM > configurations?
Accepted Answer
Pending Moderation
Hello,
Check the post linked here with the same problem and solution to solve it. Try and let me know if it helps.
Check the post linked here with the same problem and solution to solve it. Try and let me know if it helps.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hey there
I managed to solve the 500 error problem: I just split the .csv into smaller pieces so there is not a list 260+ products, but four .csv with each around 50 products. I think the processsing power of the server did not do it.
However I have a new problem with the related products:
In my .csv ist there are three related products, but in the frontend there are now many. Please see the image attached or the link https://casa-eurabia.de/sch%C3%BCsseln/sch%C3%BCssel%E2%80%93marrakesch%E2%80%9326cm-grau-40-detail
I managed to solve the 500 error problem: I just split the .csv into smaller pieces so there is not a list 260+ products, but four .csv with each around 50 products. I think the processsing power of the server did not do it.
However I have a new problem with the related products:
In my .csv ist there are three related products, but in the frontend there are now many. Please see the image attached or the link https://casa-eurabia.de/sch%C3%BCsseln/sch%C3%BCssel%E2%80%93marrakesch%E2%80%9326cm-grau-40-detail
Accepted Answer
Pending Moderation
Hello,
As explained in the 500 error document check your server error logs for the real error. If you don't have access to it or don't know where to get it, ask your hosting provider and they should help you to get the error log file. Post the error log file here so we can check it. Your import file looks good to me.
As explained in the 500 error document check your server error logs for the real error. If you don't have access to it or don't know where to get it, ask your hosting provider and they should help you to get the error log file. Post the error log file here so we can check it. Your import file looks good to me.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hey,
now I am getting a new probelm. Please see image below. I also added the .csv
I checked: https://csvimproved.com/support/questions-and-answers/854-500-internal-server-error
correct priviliges: do not know where to check & change
I have: about 600 images around 100-150 kb
I have: PHP version 5.6.31
BOM in your file: do not know what that means
I tried: ERROR REPORTING: development but the message did not change.
Thanks for help
now I am getting a new probelm. Please see image below. I also added the .csv
I checked: https://csvimproved.com/support/questions-and-answers/854-500-internal-server-error
correct priviliges: do not know where to check & change
I have: about 600 images around 100-150 kb
I have: PHP version 5.6.31
BOM in your file: do not know what that means
I tried: ERROR REPORTING: development but the message did not change.
Thanks for help
Accepted Answer
Pending Moderation
Hello,
Thank you for posting the screenshot. The error you posted was an issue in importing .ods file and it is fixed in the attached patch file. Please load the patch file and try running the import again.
patch_ods_2017_11_06.zip
Thank you for posting the screenshot. The error you posted was an issue in importing .ods file and it is fixed in the attached patch file. Please load the patch file and try running the import again.
patch_ods_2017_11_06.zip
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello,
Can you tell us which version of CSVI you are using? Also please share screenshots of your import template settings.
Can you tell us which version of CSVI you are using? Also please share screenshots of your import template settings.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »