Resolved Full url in images

As always... a lifesaver!!!

Thank you Tharuna, your tip was all that was needed!

Have a nice week ;-)

Hello Dennis,
The problem is with your Update stollas template settings. In this template on Images tab you have set Create image name to Yes, this setting will generate a image name using product_sku file(Image name based on) and that is updating your media table rows. You should set this to No if there is no image name to be created or no images to process. Change this setting and run the import. Let me know how it goes.

Sure!

Thanks again for your time!

Dennis csvi_templates_adagio.gr_20180202.xml stollas.xml

Hello Dennis,
That is really strange as the last debug log you had sent does not have queries to say any processing happened on VirtueMart tables. Can you send me the two import template XML files and the import file used? I will run the insert and update here and see what i find. To get the template XML file go to CSVI maintenance menu, select CSVI Pro in first option and Backup templates in second option. Select the import templates and click continue. Post the downloaded XML file.

Hi again Tharuna,

One of the two templates is creating the problem.

Yesterday I updated all medias table inserting image/jpeg in all empty fields and today after the last xml import, all fields are empty again...

Thanks

Dennis

Hi Tharuna,

It was for the update and this one attached here is for the import.

Let me know what you think.

Thanks

Dennis com_csvi.log.1196.zip

Hello,

When importing for the first time I set overwrite existing data to no and skip new records to no.

When importing for the first time and when the product does not exist in database table then setting overwrite existing data to no will work as CSVI is going to insert new records.

After that I create two templates one for importing new products which has the same settings as above and another which only updates and has overwrite to yes and skip to yes.

Which one do you think creates the problem?

The two templates you have don't seem to be a problem. Was the import for which the debug log sent was for an update or insert? It looks like update has been done with a template settings for new records because overwrite existing data is set to no in debug log and you have records in the database as you are saying file_mimetype field is empty.

Hi Tharuna,

When importing for the first time I set overwrite existing data to no and skip new records to no.

After that I create two templates one for importing new products which has the same settings as above and another which only updates and has overwrite to yes and skip to yes.

Which one do you think creates the problem?

Thanks!

Dennis

Hello Dennis,
The debug log you posted do not have any details on the queries which has ran in your import. That is because you have set Overwriting Existing data to No in your template settings on File tab. This will skip updating the records in the database and i think that should be the cause for file_mimetype field to be empty. Can you set Overwriting Existing data to Yes and try the import?

Hi Tharuna,

Its's logical since the old site is no longer there...

As I told you the debug logs have been deleted prior to publishing the site BUT here's a debug log from another installation which has the same problem.

Thanks for your time!

Dennis com_csvi.log.1193.txt.zip

Hello Dennis,
Thank you for posting the XML file and image settings. Unfortunately the image links from your XML file don't seem to work for me. I get below error when pasting the link on browser and in CSVI debug log i get message that image has been moved "HTTP response:HTTP/1.1 301 Moved Perma". May be access for these images from external IPs have been blocked.

http://www.zozef.gr is currently unable to handle this request.
HTTP ERROR 500

Can you send me your import debug log, that should help me find what is happening with file_mimetype field?

Hi again Tharuna,

Found the same issue on another installation so I must be doing something very wrong with the import process...

Let me know if you find something.

Thanks!

Dennis

Hi Tharuna,

Here's an excerpt of the xml and the screenshots of the template settings.

Let me know if you find anything ;-)

Many thanks! zozefgr.xml

Hello Dennis,

The import file meaning the xml I used? It's more than 6MB... Unfortunately I deleted the logs before publishing the website...

Yes the XML used, you can post a sample of the import file so i can run import here and check for the file_mimetype field.

Your solution worked like a charm!!! Thanks again!

Glad to know it worked. Please give us an review on Joomla Extension Directory

The import file meaning the xml I used? It's more than 6MB... Unfortunately I deleted the logs before publishing the website...

I'll keep an eye for this in any future import and let you know when and if this occurs again.

Your solution worked like a charm!!! Thanks again!

Dennis

Hello Dennis,

I only use CSVI pro for everything related to importing/exporting ;-) so yes. Maybe I should have checked something in the import template?

Can you post the import file and debug log of the import to check?

Hi Tharuna,

I only use CSVI pro for everything related to importing/exporting ;-) so yes. Maybe I should have checked something in the import template?

I'll try via phpmyadmin and let you know.

Thanks!

Dennis

Hello Dennis,

No, file_mimetype is only populated for a few of the medias. Can I fix that with a query in phpmyadmin?

That is the issue why your picture_url is empty. The query running to get picture_url value looks for file_mimetype value too. Were these images imported using CSVI? I am asking this because CSVI does inserts file_mimetype value when processing images during import.

If you are pretty sure that all of your images are of .jpg extension then you can run the below query(replace #_ with your table prefix). But if the extension is different then file_mimetype value will be according to the image extension.

UPDATE #__virtuemart_medias set file_mimetype = 'image/jpeg' 

Hi Tharuna,

Yes I can see all images both in thumbnails and in product details.

No, file_mimetype is only populated for a few of the medias. Can I fix that with a query in phpmyadmin?

Thanks!

Dennis

Hello Dennis,

I presume something went wrong during the import but don't know what.

Do you have any idea?

Do you see images on VirtueMart product details page after the import?
Also in your #__virtuemart_medias table do you have file_mimetype field populated? Can you post screenshot of your #__virtuemart_medias table records?