1. davidex21
  2. RO CSVI
  3. Monday, 25 January 2021
  4.  Subscribe via email
Hello. I have a problem with the product_attribute field. On the database it looks like this:

{
"73": {
"83288": {
"width": "250",
"height": "300"
}
},
"55": {
"83291": {
"invala": "250"
}
},
"89": {
"83374": {
"customsforall_option": "10"
}
},
"90": {
"83375": {
"customsforall_option": "14"
}
},
"91": {
"83376": {
"customsforall_option": "17"
}
},
"92": {
"83377": {
"customsforall_option": "19"
}
},
"88": {
"83373": {
"customsforall_option": "7"
}
},
"53": {
"83297": {
"imagepath": "",
"imagepathfolder": ""
}
}
}

But when I export it some values ​​are replaced by "Array":

Installazione rullo ad incasso interno o esterno? - Installazione a Parete-Soffitto|Array|Array|Scegli il Tessuto per la tua tenda - Tessuto Leggero B03|Verso di avvolgimento - Rullo dietro alla stampa|Array




How can I do?
Accepted Answer Pending Moderation
Hello,
From what i can see is that you have custom fields for all values saved in product_attribute field and not all values are stored in same format. Please load the attached patch file and try the export. Can you post the value you get in export file for product_attribute with the patch file?
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. # 1
Accepted Answer Pending Moderation
Hello. with the patch I installed, product attribute is now completely blank.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Attachment log
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Please send me Joomla administrator login details of your site to check. You can post the details in Site details under your reply.
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. # 4
Accepted Answer Pending Moderation
ok
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Thank you for posting the site login details. I did some fix to code with patch file and ran the export. Array now shows as ""Installazione rullo ad incasso interno o esterno?~Dimensioni della Tenda a Rullo~Lunghezza del rullo (deve coincidere con la larghezza scritta sopra) ~Scegli il Tessuto per la tua tenda ~Verso di avvolgimento~Carica Immagine";"Installazione rullo ad incasso interno o esterno? - Installazione a Parete-Soffitto|##############################|###############################|################################"" which means custom field is getting empty values. I need to check what is stored in database in VirtueMart tables. Is it possible to send the FTP details? You can post it on same Site details tab under your reply.
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. # 6
Accepted Answer Pending Moderation
can i give you the login details to mysql database directly?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Database credentials
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Thank you for posting the database details. I will check and let you know on what i find.
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,
I found the cause for Array in product_attribute field in export. The values which are exported as array belongs to plugin orderfilesupload. RO CSVI does not support this plugin and so the values of this plugin are not processed on export. RO CSVI supports values of all VirtueMart core custom fields along with Breakdesigns Stockablecustomfields and Customfieldsforall.

The solution here would be to write some custom code as override for VirtueMart Order export to process the values of Array to actual values.
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. # 10
Accepted Answer Pending Moderation
Hello. Can you do it? Can you give me a quote? In the meantime, could you restore the configuration with the initial parameters?
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
Patch file installed on your site has been restored to original file. Any changes to RO CSVI code will be considered as custom job and we will get back to you on that.
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. # 12
Accepted Answer Pending Moderation
Hello,
Can you send us the orderfilesupload plugin files? You can send it to tharuna@rolandd.com. I will install it on our test site and see how it works. Based on that we can tell you the hours needed on modifying our RO CSVI code.
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. # 13
Accepted Answer Pending Moderation
Ok. I send you orderfilesupload plugins and istraxx plugins too. Istraxx is always present in product_attribute with the wording array.
Please, in the quote I would also like to ask you to join together and tables. I need to add 1 field of another table to Virtuemart order export template
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Thank you for posting the plugin files. I installed it and was trying to add custom field for a product but it asks me to enter the subscription details. See attached screenshot. Please send me the subscription details so i can see how this plugin actually works with VirtueMart Products.
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. # 15
Accepted Answer Pending Moderation
Hi, I believe the plugin can only be used on one domain. If you want and you can create a test product on my site
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
Thank you. We are looking into the plugin to see how it works. Will send you a quote once it is ready.
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. # 17
Accepted Answer Pending Moderation
Ok Thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello Davide,

There is a question I have about the Acymailing table you want to join. You want to join the table acym_user_has_field but this table has multiple values for each user. For example for user ID 653 there are 5 field IDs and 5 values. Is there a specific field you want to export or all fields? Just the field_id or also the field_value?
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. # 19
Accepted Answer Pending Moderation
Hi. I'm interested in exporting ID field 29 value
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1


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