When a customer buys a product from my store, they must also complete some plug-ins and string type fields. I'd like to create a CSVImproved template that allows m,e to export these data along with the normal order details.
VirtueMart 3.0.16
Joomla 3.6.2
CSVI Pro 6.6.3
Hello,
The custom field data is stored in the product_attribute field. The value of this field depends on the custom field you are using. CSVI currently don't support more with custom fields other than product_attribute field in order export but improvements to this export is in our todo list of future developments.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you for your help. I have added product_attribute to my export file but it isn't exporting what is in the database field. I've provided an example of what data is in the database field product_attribute below.
The value of this field depends on the custom field you are using.
Most of the fields are 'Custom Field Text Input'.
{
"4": {
"202": {
"comment": "Homer"
}
},
"5": {
"201": {
"comment": "Simpson"
}
},
"6": {
"200": {
"comment": "11.05.1991"
}
},
"8": {
"198": {
"comment": ""
}
},
"7": {
"199": {
"comment": ""
}
},
"10": {
"203": "Male"
},
"11": {
"204": "Yes"
},
"12": {
"205": {
"comment": ""
}
},
"16": {
"206": {
"customsforall_option": "89"
}
}
}
Hello,
but it isn't exporting what is in the database field
What is it exporting in your case? I don't see anything weird at a first glance.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Rolandd,
It's exporting the other fields, whatever I add like order_id but the product_attribute field is exporting nothing, the part of the export file is blank. It's on a localhost server right now but I'll pop it on a dev server and PM you some access details if that is ok with you?
Hello,
Can you apply the attached patch file and see if the product_attribute export values as in database?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi tharuna,
This does export data, it dumps everything from that field. This is good progress! I would like to export the data in that field in a more formatted manner if possible, for example: Field title: field valueField title: field valueField title: field value such that an export might look like
order_id, product_attribute, date_created
17, custom_fname:Homercustom_lname:Simpson,01/01/2016custom_lname:Simpson,02/04/2016
18, custom_fname:Marge
Do you think this can be achieved?
Many thanks for your help so far.
Hello,
The custom field you are using seems to be for a 3rd party plugin, currently CSVI don't support it but we can look into adding it to our todo list so it is support in our future version. One other way for now is you can write your own custom code using override import/export routines feature to get it in the formatted way as you want.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Though there is one field that uses the custom fields for all extension (and I have installed your add-on plg_csviext_customfieldsforall_csvi_6.6.3), the main fields are the standard Custom field: textinput
I also wanted to ask, with the patch you provided, will any changes in that patch be overridden by any future updates to my CSVI Pro software?
Hello,
Though there is one field that uses the custom fields for all extension (and I have installed your add-on plg_csviext_customfieldsforall_csvi_6.6.3), the main fields are the standard Custom field: textinput
As already said all of these values will be stored in product_attribute field, you can write overrides to this export to get your output in required format.
I also wanted to ask, with the patch you provided, will any changes in that patch be overridden by any future updates to my CSVI Pro software?
The changes made in the patch file will be included in our next 6.6.4 release. So even with future updates changes will be still there.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks for your help on this.
Log in to reply to this topic.