Support is offline. We are back Monday 23 November, 09:00.

separator for the file_url field #67422

Open webmarketingtrento opened this topic Thursday, 24 June 2021 · 9 replies
Author

hi, i'm creating the product export feed for facebook, everything works but i have a problem with the additional_image field i'm populating with file_url. The column is correctly populated with all the images present for the product but as a separator between one url and another it puts | while facebook asks for a comma ","

I would like to know if there is a way to handle the separator for the file_url field being able to change it. I also tried with the rules by setting a find and replace but nothing ...

Thanks

Support

Hello,

You need to use the field picture_url instead. This has the full URL to your images and RO CSVI will create the correct XML elements. This field has multiple images separated by a comma. The file_url is a relative URL so that cannot be used by Google.

Let us know how it goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I need the feed for facebook not google, I'm creating a csv to be generated automatically thanks to the cron. Facebook for images asks:

image_link (product image)
additional_image_link (additional product images separated by commas)

For image_link I use picture_url. In the template Number of pictures is set to 1.

While for additional_image_link I use file_url which gives me all the images and thanks to a rule I set the complete path but as a separator it uses "|" while facebook asks me for the "," comma

Support

Hello,

While for additional_image_link I use file_url which gives me all the images and thanks to a rule I set the complete path but as a separator it uses "|" while facebook asks me for the "," comma

By default separator is set to | in code, there is no option to edit this separator from template. You can create an override for product export and in the override file change the separator from | to comma(,) for file_url field. You need to make sure to set Text enclosure to " in template settings on File tab as comma is standard field delimiter for CSV file.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thanks, I have set the pattern override but it is not clear to me how to change the separator with the comma, I have searched and replaced '|' with ',' but still exports with the |. Can you help me?

Support

Hello,

Not sure where this is going but did you try the picture_url field? That has the full path to your images, the file_url is a relative path. I would expect Facebook to require a full URL.

If you want to keep using the file_url instead let me know which product export you are using. VirtueMart? HikaShop? J2Store? If I know that I can help you with that.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

thanks for the reply i'm exporting the products in virtuemart to pass to facebook, i need to change the separator for file_url from "|" to ","

Support

Hello,

Does Facebook just need the image name and not the URL to the image? So you can send Facebook just image.jpg instead of https://example.com/image.jpg?

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I need the feed for facebook not google, I'm creating a csv to be generated automatically thanks to the cron. Facebook for images asks:

image_link (product image)
additional_image_link (additional product images separated by commas)

For image_link I use picture_url. In the template Number of pictures is set to 1.

While for additional_image_link I use file_url which gives me all the images and thanks to a rule I set the complete path but as a separator it uses "|" while facebook asks me for the "," comma

i need to change the separator for file_url from "|" to "," is there any way to do it?

Support

Hello,

No need for me to ask questions that won't be answered.

i need to change the separator for file_url from "|" to "," is there any way to do it?

Assuming you created the override as explained in a previous post by Tharuna. Find line 1668 in your override file, this contains

$this->log->add('Found images: ' . $fieldValue);

After this line add the following code:

$fieldValue = str_replace('|', ',', $fieldValue);

That should output your images separated by a comma.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.