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			
			- dm
 - RO CSVI
 - Thursday, 20 July 2017
 - Subscribe via email
 
			
									0
								
				
					
				
			
		
	
						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.
			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
	Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
						Accepted Answer
						Pending Moderation
					
				
				Hi Tharuna,
in attachment the files.
Thanks,
Davide
			in attachment the files.
Thanks,
Davide
        Attachments (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
			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
	Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
						Accepted Answer
						Pending Moderation
					
				
				Hi Thauruna,
you're wonderful!! Thank a lot.
Last question, how can I remove the CDATA?
Thanks a lot,
Davide
			you're wonderful!! Thank a lot.
Last question, how can I remove the CDATA?
Thanks a lot,
Davide
						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.
			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
	Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
						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
			sorry, I haven't seen that option.
Thank you very much, wonderful support, like always!!!
Have a nice weekend!
Davide
						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
			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
						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.
			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
	Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
						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>.
			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
	Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
						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
- 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 »