1. oogloo
  2. RO CSVI
  3. Monday, 06 March 2017
  4.  Subscribe via email
Hi RolandD -

I am trying to import products, the process just runs fine and import records in virtuemart_products_en_gb, also in prices, categories etc tables. However, nothing is imported in virtuemart_products table. I have checked the log and there is no INSERT query for virtuemart_products but multiple update_queries exist.

Attached is a sample of file i am trying to import, and the log file and below are the versions. (both in one .zip file)

Joomla: 3.6.5
Virtuemart: 3.0.18
CSVI Pro: 7.0.2

Please let me know if I am missing anything or if there is some issue with this.

thanks and best regards,
Syed
Accepted Answer Pending Moderation
Hello Syed,
There is an update query running for virtuemart_products table as per your debug log and that is because of virtuemart_product_id field in your import file. Using the fields ending with _id will only do the update of records as it says that the record is already there in the database tables. CSVI imports products based on product_sku field so you can removed the virtuemart_product_id from your import file and then run the import.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thanks Tharuna -

I will do that and will get back to you with the updates.

thanks much.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
I have removed the virtuemart_product_id and PRODID mapping but the products are still not there in the virtuemart_products table?
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Can you post debug log of your last import to check? Also your import template XML file. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Please find attached the latest log and the template XML file.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Your files are missing in the post. Can you compress and post them?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
There is some file size issue, i am attaching them separately. Here is the XML Template File.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
It wont let me attach the 800KB log file?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Try the import with 5 products so you get a smaller debug log and it is easy to attach.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
PFA the log file.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Got the files?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
Yes got the files and your recent debug log shows there is still virtuemart_product_id in your import though your template don't have product_id mapped. Is this the latest debug log?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
This is the latest log, i had removed the PRODID and virtuemart_product_id - I am not sure why this is still there?
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
May be its in the cache? I am trying to completely redo this. will update shortly.
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
This is the latest log, i had removed the PRODID and virtuemart_product_id - I am not sure why this is still there?

I really doubt if its the latest debug log. The debug log file name you posted in your first post is com_csvi.log.7 and the last one posted is com_csvi.l.log.6 which seems to be debug log of old import. Please find the latest debug log file and post it.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
I did a fresh install by removing the virtuemart_product_id and that seemed to have worked, will try importing the whole file now, thanks. There is one additional question though. how do I import the product images? I had added product_id field (PRODID) such that I can use the same to import the images data as well. But now since we have removed PRODID, how will I ensure that correct images go for correct product? Do I use the SKU for that? If yes, could you please guide a bit on this.

thanks much.
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
how do I import the product images? I had added product_id field (PRODID) such that I can use the same to import the images data as well. But now since we have removed PRODID, how will I ensure that correct images go for correct product?

You need to file_url field for importing images and file_url_thumb for thumbnails for a product. By default CSVI will import images with same names as given in the import file.

Do I use the SKU for that? If yes, could you please guide a bit on this.

Yes, You can also use SKU for image names. In your template settings on Images tab, you can set "Image name based on" field to product SKU. If you don't see this option click on Advanced button on top corner. This setting will use product SKU as image name.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Great, thanks. You Rock!
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hi Tharuna -

I am encountering an issue related to the product images. There are about 50000 products I am trying to import.

1- When I set the option Process Images to NO, it stores the direct image url( external url ), in the DB. I have checked in the DB and the image URL is there, however, when VM loads the image, it prefixes the /images/stories/products and hence no image or thumbnail appears and it displays error VMError, File not found etc.
2- When I set it to process images and download image to the server, it takes forever to process because of too many images that require to be downloaded.

Could you please let me know what do I have to to ensure that in Step 1, image URL get stored in the DB and is loaded properly in the backend and frontend.

Thanks for all your help with this.

thanks and best regards,
Syed
  1. more than a month ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello Syed,
1- When I set the option Process Images to NO, it stores the direct image url( external url ), in the DB. I have checked in the DB and the image URL is there, however, when VM loads the image, it prefixes the /images/stories/products and hence no image or thumbnail appears and it displays error VMError, File not found etc.

You cannot store external URLs in database tables, and Yes, VirtueMart adds the default path to the image and so no image can be seen.

2- When I set it to process images and download image to the server, it takes forever to process because of too many images that require to be downloaded.

The only way is that you have to download the image to server. Importing images of 50000 products will take time. Have a look at Manage Timeout document to know to handle timeout error in case you get into it.

Could you please let me know what do I have to to ensure that in Step 1, image URL get stored in the DB and is loaded properly in the backend and frontend.

You cannot use step1 to process your images. You need to have images in VirtueMart product default path so VirtueMart can load your images.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!