1. dm
  2. RO CSVI
  3. Thursday, 20 July 2017
  4.  Subscribe via email
Hello,

I need to export the product attributes (simply custom fields) in the order export.
I inserted the field but it exports an empty string.

How can I retrieve this data?


Thanks a lot,
Davide
Accepted Answer Pending Moderation
Hello Davide,
If you have the data saved in product_attribute field you should be seeing it in export. Can you post the screenshot of your #__virtuemart_order_items table so i can check the content in product_attribute field? Also post your export debug log 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. # 1
Accepted Answer Pending Moderation
Hi Tharuna,

in attachment the files.


Thanks,
Davide
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Davide,
Can you try to load the attached patch file from CSVI maintenance page and then run the export? See if product_attribute field gets values then.

patch_vm_order_advanced_2017_07_21.zip
Attachments (1)
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
Hi Thauruna,

you're wonderful!! Thank a lot.

Last question, how can I remove the CDATA?


Thanks a lot,
Davide
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Davide,
You can set Use CDATA tag field to No in CSVI template fields page and by editing a template field.
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. # 5
Accepted Answer Pending Moderation
Hi Tharuna,

sorry, I haven't seen that option.

Thank you very much, wonderful support, like always!!!

Have a nice weekend!
Davide
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi Tharuna,

I have a last question, if possible...

Now I export the attributes like that:
<description>Attribute 1 | Attribute 2 | Attribute 3</description>

Is there any way to have something like that:
<variante>Attribute 1</variante>
<variante>Attribute 2</variante>
<variante>Attribute 3</variante>


Thanks a lot,
Davide
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Davide,
There is no direct way to do it but you can create Override file for your export and write custom code for product_attribute field to export value as required.
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. # 8
Accepted Answer Pending Moderation
Hello Davide,
One other idea is that you Find and Replace | with </variante><variante> using CSVI Multi replace rule plugin. The front and end tags can be got from layout if you use <variante> instead of <description>.
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. # 9
Accepted Answer Pending Moderation
Hello Davide,
One other idea is that you Find and Replace | with </variante><variante> using CSVI Multi replace rule plugin. The front and end tags can be got from layout if you use <variante> instead of <description>.


Hi Tharuna,

no words, simply a GENIUS! :)

THANKS a LOT!
Davide
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


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