Categories
View Replies (9)

Resolved Virtuemart product export: additional images

  1. dm
    dm
  2. RO CSVI
  3. Thursday, 14 March 2019
  4.  Subscribe via email
Hello,

I need to export the additional images.

I'm using the product export, but the images are exported all in one fields.
I created 5 fields, one for each image.

How can I have each image in each field?


Thanks.
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I created 5 fields, one for each image.
I am afraid it doesn't work like that. Each field contains all the data.

How can I have each image in each field?
What you could do is apply a rule on the image field where you replace the CSVI separator with the export separator. So let's say the CSVI separator is | and your export separator is a comma. In the replace rule you find the | and replace it with , then in your export file all the images will be in their own column.
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
dm
dm
Accepted Answer Pending Moderation
Hello Roland,

yes, I know.

I tested the rule before open the post, but no success.

I always have double quote like this: "";"" where I replace the , and the next columns forward...

Thanks.
Davide
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Davide,

Please show me what your output is before the rules and I will check that. What do you see after you apply the rule?
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. # 3
dm
dm
Accepted Answer Pending Moderation
Hello Roland,

here's the rule I'm using for the picture_url field.



jpg,https

jpg";"https


In attachment the export.


Thanks.
Attachments (1)
export-demo.csv
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

What I am thinking is that you don't use the double quotes as text enclosure but apply a rule to the fields you want to use them. For example description you can add a rule to add a double quote at the beginning of the field and one at the end. So this is still quoted. As for the images, they would just keep their semi-colon so that field looks like abc.jpg;def;ghi.jpg.

That should give you a valid CSV with the images in their own fields.
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
dm
dm
Accepted Answer Pending Moderation
Hi Roland,

ok, tomorrow morning I will do a check and I will update you, thanks.


Regards.
  1. more than a month ago
  2. RO CSVI
  3. # 6
dm
dm
Accepted Answer Pending Moderation
Hi Roland,

i did it.

Everything is right, but if the images are 3, instead of 5(number of columns), the next columns are wrong...

Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

That is why the images should be the last field to export. In that case it shouldn't matter how many columns you have. You can add extra column headers for the other images and just use the field custom as export field and leave it empty. If there are 3 images instead of 5, the last 2 columns will just be empty.
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. # 8
dm
dm
Accepted Answer Pending Moderation
Hello Roland,

yes, I know.

I hope that it will be ok for the receiver! ;)


Regards,
Davide
  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!