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
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
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
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
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?
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
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 ","
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
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?
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.