Resolved Virtuemart image import

Hello Alex,

The export of goods I found that of goods imported in the database is not filled field picture_url and picture_url_thumb.

The fields picture_url and picture_url_thumb are not database fields.These are CSVI fields and only used for exporting images to 3rd party sites like Google.

To work with images on your site you should be using the file_url and optionally file_url_thumb fields. Did you use those fields?

As for the image you sent, it's just a picture of watch, nothing I can deduct from there. The debug log is what I need to see what is going on.

As for the image you sent, it's just a picture of watch, nothing I can deduct from there. The debug log is what I need to see what is going on.

I didn't create a debug log. Re-import no longer want I just turned off image processing when importing.
This is a common picture, but it is not processed as the others. When you import CSVI permanently delete the file extension. But if no such problems were seen, we can this picture not be taken into account.

To work with images on your site you should be using the file_url and optionally file_url_thumb fields. Did you use those fields?

Yes, of course. I used file_ur, the second field is not used, wanted mini image formed using virtuemart.

The fields picture_url and picture_url_thumb are not database fields.These are CSVI fields and only used for exporting images to 3rd party sites like Google.

Understood. But why is the export of goods entered manually, those fields are filled in, and the export of goods that I imported - they are empty? If these fields are not filled in, perhaps something is missing in the database?

Hello,

This is a common picture, but it is not processed as the others. When you import CSVI permanently delete the file extension.

You know that but I don't know that. That is why I always ask for a debug log, so I can see something. My crystal ball is retired

But if no such problems were seen, we can this picture not be taken into account.

Understand, I will check what happens with this image. Hmmm, I think the extension is not identified because you have 4 extensions on the image.

If these fields are not filled in, perhaps something is missing in the database?

There must be something missing in the database, the field will come out empty if there is nothing in the file_url field or the relation between product and image doesn't exist.

It may be good to find out why your images don't import. There are no known problems with the image import at the moment.

There must be something missing in the database, the field will come out empty if there is nothing in the file_url field or the relation between product and image doesn't exist.

In this case, I think the picture of the product would not have been displayed on the website. I checked the export file: file_url field is filled. Regarding the relationship between product and image - I don't know how to check it, but the image is normally displayed:
http://qwatch.ru/katalog/naruchnye-chasy/SMW-SMW.M7.4N.C1G-detail
I care that later can be detected any problems.

It may be good to find out why your images don't import. There are no known problems with the image import at the moment.

Well, You convinced me, I'll try a few more times, including with the old file (which was losing the extension after you import). Will save the log and send it to you.

Overall I must say that the import of other products was happening, I turned off image processing because I have over 20,000 images will be imported, and among them may also be similar to losing the extension. Then I'll correct them infinite time.

In addition, I was not able to set up so that once images are imported, they reformed with the help of virtuemart, when in settings change the resolution of a small picture.

However, I did not include the creation of mini-images during import. Will try, maybe this will help.

Also have another question - when importing multiple images to one product all the is successful and identical to products entered manually, except for one field: file_ordering
When you import a field file_ordering received value 1|1|2, and manually entered all the numbers were consecutive and not repeated, for example: 1|2|3|4 or 1|2|3|4|5|6|7 It's some kind of bug, or I something not so made?
To enter all images, I used only the fields file_url and file_title (text identical), e.g. "SMW-SMW.M7.4N.C1G.jpg|SMW-SMW.M7.4N.C1G-1.jpg|SMW-SMW.M7.4N.C1G-2.jpg"

Hello,

Well, You convinced me, I'll try a few more times, including with the old file (which was losing the extension after you import). Will save the log and send it to you.

Let's take it step by step and I am sure we can figure out any issues you may have.

I turned off image processing because I have over 20,000 images will be imported, and among them may also be similar to losing the extension.

I have an idea why that may be happening as written in my last post but still need to verify that.

In addition, I was not able to set up so that once images are imported, they reformed with the help of virtuemart, when in settings change the resolution of a small picture.

If you only import the large image and not the thumbnail, so the thumbnail doesn't exist on the server, I think VirtueMart would pick it up and then create the thumbnail.

When you import a field file_ordering received value 1|1|2, and manually entered all the numbers were consecutive and not repeated, for example: 1|2|3|4 or 1|2|3|4|5|6|7 It's some kind of bug, or I something not so made?

If you import the value 1|1|2, the images will be assigned 1|1|2.

Let's take it step by step and I am sure we can figure out any issues you may have.

For a start, I realized, in some cases not filled picture_url field and picture_url_thumb
This occurs if you do not specify the "Fill media fields"
It turns out that without using the image processing some required fields are not filled in.

I have an idea why that may be happening as written in my last post but still need to verify that.

I repeated the import from the old file, the same error (the extension erased). Debug log attached

If you only import the large image and not the thumbnail, so the thumbnail doesn't exist on the server, I think VirtueMart would pick it up and then create the thumbnail.

That's the problem - virtuemart does not pick it up and then create the thumbnail.
But when I put in the template settings "Automatic thumbnail creation", a view is created, and after uninstalling virtuemart really pick it up and then create the thumbnail.
It is a pity that the mini-images generated by CSVI have a name different from the names of standard Virtuemart. In fact CSVI uses the same name. Virtuemart adds to the title the size of the mini image. For example:
TRASER-105471_350x350.jpg - Virtuemart
TRASER-105471.jpg - CSVI
I'd like to create a mini-image that made them Virtuemart itself. But if you remove the option to create mini-images, Virtuemart does not create them too for some reason

If you import the value 1|1|2, the images will be assigned 1|1|2.

I did not import this value. I imported only the file_url field. The value of the field file_ordering formed itself, and, unfortunately, differs from the standard.

By the way, where is described the meaning of all fields in the import images? In the instructions that I found, many fields are not explained. And when you move the cursor to the parameter prompts do not appear.

That's the problem - virtuemart does not pick it up and then create the thumbnail.

By the way, I noticed that if you use virtuemart "TOOLS - Tools & Migration - Reset Thumbs" then a mini-image of the imported goods are created. We have all the right connections. Apparently, just when you import the system somehow thinks that these images are already there and not creating them.

It turns out that without using the image processing some required fields are not filled in.

You will need to supply these fields in your import file in that case.

I repeated the import from the old file, the same error (the extension erased). Debug log attached

Yes I can see that in the debug log, that is because of the image type. That image has an identity string like this

Identity string: ffd8ffe20c584943435f50524f46494c45000101

. This is an unknown identity string. That is one mystery solved. The attached patch file has an update on the identity strings so that will fix the missing extension.

It is a pity that the mini-images generated by CSVI have a name different from the names of standard Virtuemart.

Not really a problem I think, whichever name you have VirtueMart will use.

I'd like to create a mini-image that made them Virtuemart itself.

Looking at the current VirtueMart code, it seems the thumbnails are only created when you save a product. This would explain why you don't see VirtueMart create any thumbnails when looking at the site itself. The alternative, as you found, is the Reset Thumbs option.

The value of the field file_ordering formed itself, and, unfortunately, differs from the standard.

I have misunderstood you then. The images don't have any ordering in your case?

By the way, where is described the meaning of all fields in the import images? In the instructions that I found, many fields are not explained. And when you move the cursor to the parameter prompts do not appear.

You have to click the Help button, this will show the explanation of each option in CSVI. If you are missing some, log in with English as they may not all be translated. The English language is complete.

This is an unknown identity string. That is one mystery solved

Yes, the import of this strange file was successful. Hope, and similar will be handled.

Looking at the current VirtueMart code, it seems the thumbnails are only created when you save a product. This would explain why you don't see VirtueMart create any thumbnails when looking at the site itself. The alternative, as you found, is the Reset Thumbs option.

No, You are wrong. Virtuemart creates a mini-image yourself. But with the imported this does not happen. I think it's because when generation of thumbnail pictures not configured, the field file_url_thumb gets the same link to a large image. That is, the system sees that the file is there, and do not starts creating mini-image. But in the end the site will work slower, if anywhere, will use large images.

The value of the field file_ordering formed itself, and, unfortunately, differs from the standard.
- I have misunderstood you then. The images don't have any ordering in your case?

I solved the problem. If you do not import field file_title, file_ordering field is automatically configured and without errors.

At the moment I came to the conclusion that it is better to do without creating a mini-image and without the "fill media fields". And after import to start the process Virtuemart "Reset Thumbs" In this case, all fields are identical to the items added manually. Unfortunately, it will be inconvenient when the goods will be many, and it will be necessary to import small quantities of goods, so as to create mini-images throughout the site will be a continuous process.

Another small question: now when you import, if there is no such image on the server, the information is not recorded in the database. Is it possible to correct and to write always, regardless of presence of a picture? I did that earlier, and when he discovered that some of the images no, I recorded them on the server separately.

Virtuemart creates a mini-image yourself.

When and where does it happen?

I think it's because when generation of thumbnail pictures not configured, the field file_url_thumb gets the same link to a large image.

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

I solved the problem. If you do not import field file_title, file_ordering field is automatically configured and without errors.

These fields are not related to each other. The file_title is stored with the image details and the file_ordering is stored in the relation table.

At the moment I came to the conclusion that it is better to do without creating a mini-image and without the "fill media fields".

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

Is it possible to correct and to write always, regardless of presence of a picture?

I will see what I can do about that.

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.

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.

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.

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.

If I'm not mistaken, this is the log

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?

I made an export, and that field was empty it is for new products... Maybe the value was awarded, but it was empty?

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?

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.

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?