1. alex_volhov
  2. RO CSVI
  3. Sunday, 06 March 2016
  4.  Subscribe via email
The whole day was trying to customize the virtuemart import images. In the settings indicated: Process images - Yes

However, faced a number of difficulties. In particular, one article categorically did not want to be imported, the image is not shown. Moreover, the process of import was deleted on the server the extension of the picture.

I compared the name of the image file, checking the format, put it in different places in your import file. I did everything but nothing helped.

In the end I just completely replaced the new file with the same name, and it worked. What was it - don't know, but I send this file to search for bugs.

In the future I could configure so that when you change the settings in Virtuemart the size of the thumb images, they are automatically formed when viewing the product list. For some reason after importing they show up in the database, their website showed, but actually they were not in the folder with thumb images

In the end, I simply disabled the image processing in the template settings, and everything was fine. Only one question left:

The export of goods I found that of goods imported in the database is not filled field picture_url and picture_url_thumb. Of goods entered by hand, they are. In the import template has no such fields. How to ensure that after importing in the database have all the fields?
Accepted Answer Pending Moderation
I checked the database table ***_virtuemart_medias.
It's weird, but the file_url field in it filled in.
However the pictures on the website do not appear in the CSVI export this field also gets empty.
I have attached export of database file.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hello,

The data looks fine in the database if you ask me. Attached is a patch file that I would like to ask you to load. After that run your product export and post the debug log. You will need to enable the logging in the template before youe export. This should tell us how and which data CSVI is finding for the file_url field.

I am curios what that will give in your case, hopefully it will tell us why the field is empty.
Attachments (1)
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. # 22
Accepted Answer Pending Moderation
Trying to configure an export template, got this error message:
Error
Table 'qwatch33.kma33_virtuemart_categories_en_gb' doesn't exist SQL=SELECT `x`.`category_parent_id` AS `parent_id`,`x`.`category_child_id` AS `id`,`l`.`category_name` AS `catname` FROM `kma33_virtuemart_categories` AS `c` LEFT JOIN `kma33_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `kma33_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id`

https://www.dropbox.com/s/7okfn3x6yer1lgr/%D0%A1%D0%BA%D1%80%D0%B8%D0%BD%D1%88%D0%BE%D1%82%202016-03-10%2017.06.19.png?dl=0
  1. more than a month ago
  2. RO CSVI
  3. # 23
Accepted Answer Pending Moderation
Please check the article Setting up a VirtueMart multi-language shop and the section CONFIGURE VIRTUEMART. That is all that is needd, so the missing tables are added.

After that you can select the correct language for your system on the Options tab of your export template.
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. # 24
Accepted Answer Pending Moderation
Sorry for the silence - a son was born, was busy doing other things :)

Rolandd, this is the only way to solve the problem?
I really didn't want to make a multilingual website. I specifically removed all languages except for native to cut out unnecessary data in the database.
  1. more than a month ago
  2. RO CSVI
  3. # 25
Accepted Answer Pending Moderation
Congratulations Alex :)

You are not making a multi-lingual website by doing that, it is just to get VM to create the missing tables. After that you can remove the language from the VM configuration again.

Since en-GB is the default Joomla language, CSVI uses that as a fall-back. This means this language is still existent in your site, so the tables are needed as well. Or you need to modify Joomla and remove the en-GB language as well.

The tables really don't take up that much space.
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. # 26
Accepted Answer Pending Moderation
I connected the English language and then switched it off.
Tried several import options
1) If you import products without processing images, Virtuemart creates the thumbnails automatically on first entry to the category page. This option is fine with me.
2) If you import products with image processing, but without creating a mini-image, the more features available, but Virtuemart in the future does not generate a mini-image on first entry to the category page. Everywhere it uses large images that increases page load time.
3) If you import products with image processing and the creation of mini-images in a folder "resized" get full image, not scaled down to the specified sizes. However, when removing them, at first entry to the category page Virtuemart generates them again. But this import method is not suitable when a lot of goods on the website and need to import a small number of new. In this case, remove all the old mini-image incorrectly.
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
Hello Alex,

Option 1, makes sense.
Option 2, makes sense as well because you will need to include the file_url_thumb field with the correct value like resized/myimage.jpg. You will need to create the thumbnails yourself.
Option 3, This would require a debug log to see why the image is not resized.
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. # 28
Accepted Answer Pending Moderation
Option 3, This would require a debug log to see why the image is not resized.

Log attached.

I found that I have now does not work export. He starts, but doesn't stop.
Perhaps this is due to the patches that we have installed. I tried to back out, but the export did not work.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 29
Accepted Answer Pending Moderation
Hello Alex,

The debug log shows the thumbnail is being created:
Create thumbnail from /var/www/alexvolhov/data/www/http://qwatch.ru/images/stories/virtuemart/product/TRASER-105471.jpg to /var/www/alexvolhov/data/www/http://qwatch.ru/images/stories/virtuemart/product/resized/TRASER-105471.jpg

The thumbnail is being stored as well
UPDATE `kma33_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='',`file_description`='',`file_meta`='',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/TRASER-105471.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/TRASER-105471.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`='58'


You are saying this thumbnail image is not showing up?

I found that I have now does not work export. He starts, but doesn't stop.
That is another issue for another topic. One thing you can try is to uninstall CSVI and install version 6.5.5. This will keep your database tables but cleans up the files on the server.
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. # 30
  • Page :
  • 1
  • 2


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