Categories
View Replies (7)

Resolved How to prevent image saving multiple times?

  1. icinfo
    icinfo
  2. RO CSVI
  3. Friday, 12 January 2018
  4.  Subscribe via email
Hi,
we noticed that when we use the same image-file for several products, the same image is saved in the database several times, with different names.
For example:

image1.jpg is added to the product-folder.
3 products are imported with the same image1.jpg file-name.
After import we have the following images in the database:
image1.jpg
image13.jpg
image17.jpg
image18.jpg

So the import has created 3 new images to the database (+ thumbnails for each). Our store had about 1600 products and many images we use can be used for several products (tires do not look that different, expecailly when the difference is only in size). We need to prevent this happening and only use the one image we have set in the CSVIMproved import-file.
Attached you'll see our IMage tab settings in the import-template. Please advise how to prevent this recreating images multiple times. Thank you!

-Anne
0
Responses (7)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Anne,

First I want to say something about your text enclosure. You can use the " as text enclosure and use it in your descriptions but you need to follow the CSV specifications. The specifications say that if you have the " as text enclosure you need to double it in your text. So it would look like this "This is ""a quoted"" text". This will import fine.

The new debug log you posted does not show the duplicating of the images. So I first had a look at the image Continental_hsl2_plus.jpg as this is used for 5110450000 and
5110740000. This is stored as follows
UPDATE `rossi_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='Continental_hsl2_plus.jpg',`file_description`='Continental_hsl2_plus.jpg',`file_meta`='Continental_hsl2_plus.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/Continental_hsl2_plus.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/Continental_hsl2_plus.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id` = '744'
This image is then used for both products stored as
INSERT INTO `rossi_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('1922','744','1')
and
INSERT INTO `rossi_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('1921','744','1')


The 1922 and 1921 are the IDs of the products and 744 is the ID of the image. Are you sure you are seeing duplicate images generated by CSVI?
Kind regards,

RolandD

=========================
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
icinfo
icinfo
Accepted Answer Pending Moderation
Hi,
sorry, that was only thing that was in the log. I think the issue with using " marks in the text has messed up the import.
I have another one here:

VIRTUEMART3 Continental Uudet 11.1.2018 PERUS (1).csv


com_csvi.log.241.zip

Hope this helps!

- Anne
Attachments (2)
VIRTUEMART3 Continental Uudet 11.1.2018 PERUS (1).csv
com_csvi.log.241.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Anne,
Can you post the complete debug log as requested? CSVI does not create duplicate rows in media table, in fact it checks for value in file_url field and would create a new row in media table only when the value do not exists else the value is always updated. Your debug log can confirm this information. Please post it 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. # 3
icinfo
icinfo
Accepted Answer Pending Moderation
Hi,
the issue/problem we have in this is that we have the same image in the database 4 times. 1 time the original image and then 3 times a copy of the image. 4 images when we could use just one image, the original. Is there any way to use ONLY the original image and not create a copy of the fullimage? I though with the settings I've set (see the image of the image-tab-settings), CSVI would not recreate the image in the database.

This current method being used, created unnessessary images to the database, when we could use only the original one. Considering also that each image takes space and makes the site slower, this copying the image again and again is really unnessessary. :huh:

- Anne
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Anne,
The debug log you posted is not complete. You need to send us the full debug log to check.

You will see that for example this image: continental_Conti_EcoPlus_hd3.jpg
has multiplied (used 3 times for 3 different products).

Looking at your import file you have used continental_Conti_EcoPlus_hd3.jpg image for file_url field for 3 products with product_sku 5650240000, 5650290000 and 5650300000 and so it is been added for 3 products. That is the normal behavior as what is in import CSV file is what goes into your database. What is the issue you see in this?
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. # 5
icinfo
icinfo
Accepted Answer Pending Moderation
Hi,
attached is the log-file and the csv-file. Please note that the csv-file had issues due to the descriptions using " mark and that being the text-delimiter also. But we have not changed the " delimiter to ¤ in all the templates we have done. So please ignore that issue on the csv-file.

You will see that for example this image: continental_Conti_EcoPlus_hd3.jpg
has multiplied (used 3 times for 3 different products).

image-multiplying.png


com_csvi.log.243.zip
VIRTUEMART3 Continental Uudet 11.1.2018 PERUS .csv

Greetings,
Anne
Attachments (3)
com_csvi.log.243.zip
VIRTUEMART3 Continental Uudet 11.1.2018 PERUS .csv
image-multiplying.png image-multiplying.png
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Anne,
Can you also post your import debug log and sample import file to check? To know on how to get the debug log check How to collect debug information? document.
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. # 7
  • Page :
  • 1


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