Categories
View Replies (30)

Resolved Virtuemart image import

  1. alex_volhov
    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?
0
Responses (30)
rolandd
rolandd
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. # 1
alex_volhov
alex_volhov
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)
com_csvi.log.189.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
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. # 3
alex_volhov
alex_volhov
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. # 4
rolandd
rolandd
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. # 5
alex_volhov
alex_volhov
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. # 6
rolandd
rolandd
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. # 7
alex_volhov
alex_volhov
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. # 8
rolandd
rolandd
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)
patch_product_export_vm_20160310.zip
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. # 9
alex_volhov
alex_volhov
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)
kma_virtuemart_medias.csv
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
Apparently, they are first written, and then for some reason erased either by CSVI, whether Virtuemar.
I can tell you that CSVI doesn't add the data and then remove it again. Such would defeat the purpose of the extension :)

Did you check the database or the export file? If you check the database directly, do you also see an empty value?
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. # 11
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
Yes, I was wrong. Indeed, according to log file the value has file_url field.

But after importing these images are not displayed.
Moreover, the CSVI export file shows that these values are empty.

Apparently, they are first written, and then for some reason erased either by CSVI, whether Virtuemar.
  1. more than a month ago
  2. RO CSVI
  3. # 12
rolandd
rolandd
Accepted Answer Pending Moderation
I don't see any reason for it being empty. The debug log of your export may tell us something. Do you see the values in the database?
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. # 13
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
I made an export, and that field was empty it is for new products... Maybe the value was awarded, but it was empty?
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
Accepted Answer Pending Moderation
This log shows that the file_url is being set:
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`='',`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'


It is doing that for all images. Why do you think this is not being filled?
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. # 15
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
If I'm not mistaken, this is the log
Attachments (1)
com_csvi.log.155.zip
  1. more than a month ago
  2. RO CSVI
  3. # 16
rolandd
rolandd
Accepted Answer Pending Moderation
Need to fix the patch that big picture was recorded, but little was left empty.
I need the debug log of your import after using the patch. I don't see how the large image is empty when the only change in that patch is to leave the thumbnail empty. Perhaps something else is going on.
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. # 17
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
VirtueMart will create your thumbnails as the site is being visited. That is what you want or not?

Yes, I want exactly that.

That is what the patch was for, to leave the file_url_thumb field empty. This was to see if the thumbnail was being generated.

Conceived correctly, but the patch is also not allowed to record big picture file_url
Because of this, the small image may not been generated.
Need to fix the patch that big picture was recorded, but little was left empty.
  1. more than a month ago
  2. RO CSVI
  3. # 18
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

If there is no mini-image, or delete it, then mini-image is created automatically while browsing the category (product list)
Yes, I have seen that and at a few more places. So what is the problem you have now? If you turn off Create thumbnails in CSVI and use the patch that leaves the file_url_thumb field empty. VirtueMart will create your thumbnails as the site is being visited. That is what you want or not?

Unfortunately, no. This patch stopped to fill the field file_url_thumb that we wanted to try, but it does not fill up and file_url field. In the end Veruemart not see the original file to reduce.
That is what the patch was for, to leave the file_url_thumb field empty. This was to see if the thumbnail was being generated.

Yeah, just if you select this option, the database is filled with more fields than when I enter the products manually.
CSVI fills the title, description and meta field. If you leave some empty then yes. You could also import them as empty values if you want them empty.
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. # 19
alex_volhov
alex_volhov
Accepted Answer Pending Moderation
Virtuemart creates a mini-image yourself.
When and where does it happen?

If there is no mini-image, or delete it, then mini-image is created automatically while browsing the category (product list)

I think we can change that behaviour to keep the thumbnail empty now. Can you check if the attached patch file works for you?

Unfortunately, no. This patch stopped to fill the field file_url_thumb that we wanted to try, but it does not fill up and file_url field. In the end Veruemart not see the original file to reduce.

The fill media fields is not related to the thumbnails is it?

Yeah, just if you select this option, the database is filled with more fields than when I enter the products manually.
  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!