1. webmarketingtrento
  2. RO CSVI
  3. Thursday, 24 June 2021
  4.  Subscribe via email
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
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
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?
  1. more than a month ago
  2. RO CSVI
  3. # 4
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
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 ","
  1. more than a month ago
  2. RO CSVI
  3. # 6
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?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
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?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!