Categories
View Replies (6)

Resolved CSVI 7.17 not importing file_url fields

  1. Twototango
    Twototango
  2. RO CSVI
  3. Thursday, 03 September 2020
  4.  Subscribe via email
Hi Roland,

Using Joomla 3.9.21 and Virtuemart 3.8.4. I updated CSVI to version 7.17.
My existing export templates work fine.

But the my import templates do not import the file_url field.
Maybe I'm missing the obvious here, I can't find a way to make the template import the field values for file_url from CSV.
Prior to the update this all worked fine (been doing it this way for many years now, and I never had any problem with importing image urls)

I made a small test CSV with the exact same values and columns (attached)
Also attached the log file for this file
And a backup from the template used.

The site and shop are in English and Dutch.

Any help or insight to solve this small (I'm sure ;-) issue is much appreciated.

Thank you, Jack
Attachments (3)
B2C_VM_export_products_NL_03-09-2020_incl_corr_bijbehorend.csv
csvi_templates_192.168.1.191_20200903.xml
com_csvi.log.137.zip
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jack,
Two settings with images

1. When Update media link only is set to Yes -> RO CSVI does not do any processing on images, not even checks if the image exists in the folder. It will only check if there is a file_url URL exists in #__virtuemart_medias database table, if exists a link between product and image is created.
2. When Process image is set to Yes -> RO CSVI will check if image exists and do the image processing as set in the import template and also links the image to the product.

RO CSVI will look for Update media link setting first and does Processing of image only when Update media link is set to No. From the debug log i can see that you have both of the these settings set to Yes. RO CSVI will do Update media link as prioritised setting. You should have either of these setting set to yes and the other should be set to No. Set Update media link to No, Process image to Yes, save the template and run the import.

If you still have issues, post the latest import debug log to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Jack,
Any help or insight to solve this small (I'm sure ;-) issue is much appreciated.

Yes it is a small issue by the looks of it :D. In your import template on Image tab you have set Process images field to No, you need to set this to Yes for RO CSVI to process images on import. Change this setting and do the import. Let me know how that goes.
Kind regards,

Tharuna

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

Thank you for your response, setting the image processing to YES, but this gives me an error.
Maybe there's something amiss under the bonnet?

Maybe I'm interpreting these settings wrong but the images themselves actually do not need processing, it's just the image url that needs to imported.
Hence my choice for no image processing.

B.t.w. before I did not have to process the images, I just put the correct url in the file_url field and it imported the fields just fine.
(See attachment from the 7.17 and 7.12 install from an older site version)

New Log file is also attached.

Jack
Attachments (4)
com_csvi.log.139.zip
Schermafbeelding 2020-09-04 om 09.54.34.png Schermafbeelding 2020-09-04 om 09.54.34.png
Schermafbeelding 2020-09-04 om 09.54.42.png Schermafbeelding 2020-09-04 om 09.54.42.png
Schermafbeelding 2020-09-04 om 09.42.35.png Schermafbeelding 2020-09-04 om 09.42.35.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for your response, setting the image processing to YES, but this gives me an error.
Maybe there's something amiss under the bonnet?

This error is not because of processing image but it has to do with Breakdesigns customfieldsforall plugin. With recent changes this plugin has introduced a new field parent_id in #__virtuemart_custom_plg_customsforall_values table. This field should be missing in your database table and so the error. You can run the below query from PHPMyAdmin to get the parent_id field added to the table. Make sure to replace #__ with Joomla table prefix.



ALTER TABLE `#__virtuemart_custom_plg_customsforall_values` ADD `parent_id` INT NOT NULL AFTER `ordering`;


B.t.w. before I did not have to process the images, I just put the correct url in the file_url field and it imported the fields just fine.
(See attachment from the 7.17 and 7.12 install from an older site version)

Ok with Process images set to No and with Update media links only set to yes, RO CSVI checks if the file_url already exists in the database and if it exists it links that image to the product else it just says that the file_url does not exists. The debug log you have posted shows that the product and the image are linked, see the query from your debug log. You don't see image for this product on backend?



UPDATE `shop_virtuemart_product_medias` SET `virtuemart_product_id`='14084',`virtuemart_media_id`='1051',`ordering`='1' WHERE `id` = '92378'
Kind regards,

Tharuna

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

The SQL query solved the error, thank you.
And thank you for explaining the inner working of the image settings, clear how that works ;-)

So I have the Image processing set to YES now, but still no Images are linked to the articles.

All images are visible and active in VM media files, but in the article itself there's no data for the images.
All image urls in the csv file are seemingly correct, as I paste them behind the root url they show.

Jack
Attachments (6)
Schermafbeelding 2020-09-04 om 11.30.00.jpg Schermafbeelding 2020-09-04 om 11.30.00.jpg
Schermafbeelding 2020-09-04 om 11.29.29.png Schermafbeelding 2020-09-04 om 11.29.29.png
Schermafbeelding 2020-09-04 om 11.09.41.png Schermafbeelding 2020-09-04 om 11.09.41.png
Schermafbeelding 2020-09-04 om 11.25.59.png Schermafbeelding 2020-09-04 om 11.25.59.png
Schermafbeelding 2020-09-04 om 11.26.11.png Schermafbeelding 2020-09-04 om 11.26.11.png
com_csvi.log.144.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
Twototango
Twototango
Accepted Answer Pending Moderation
Hi Tharuna,

Thank you, this just saved my deadline :D

I can't believe how I got confused about these setting, been importing with CSVI for a long time.
So glad you explained this to me in detail and all is working fine now.
All images are linked to the articles.

Very much appreciated, thank you.... another good review on JED for sure!

Jack
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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