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
- webmarketingtrento
- RO CSVI
- Thursday, 24 June 2021
- Subscribe via email
0
Accepted Answer
Pending Moderation
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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
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
Accepted Answer
Pending Moderation
Hello,
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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?
Accepted Answer
Pending Moderation
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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 ","
Accepted Answer
Pending Moderation
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?
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
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?
Accepted Answer
Pending Moderation
Hello,
No need for me to ask questions that won't be answered.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »