Resolved Full url in images

Hello Dennis,
Instead of using file_url use picture_url in your export fields. Check if you get full image URL then.

Geeeezzzzzz

I knew I was doing something this stupid..... q)

Sorry for bugging you!!!

Thanks again!

Dennis

Hi again Tharuna,

Any idea why picture_url returns an empty node while file url returns the image?

Thanks,

Dennis

Hello Dennis,
Is your picture_url field published in your template fields? How is the XML layout structured in your export template? Can you post screenshots of it?

Hi Tharuna,

Here's what happens...

All products were inserted via xml. Most of them return an empty node if picture_url is used.

I went in one of them, opened it in VM, saved it without doing anything and re-exported the xml.

The image node was populated correctly.

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

Do you have any idea?

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?

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,

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,

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,

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?

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,

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

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

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

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 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,
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,

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,

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,

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