1. soura123
  2. RO CSVI
  3. Wednesday, 06 November 2024
  4.  Subscribe via email
on my vendor file xml the customfield is this way on the xml file
<features>
<feature title="Τύπος" value="K50 (C100)"/>
<feature title="Ισχύς (HP)" value="10-15"/>
<feature title="Αναρρόφηση (lt/min)" value="1240-1504"/>
<feature title="Στροφές (rpm)" value="1150 - 1400"/>
<feature title="Πίεση (bar/psi)" value="11/160"/>
<feature title="Κύλινδροι" value="2"/>
<feature title="Στάδια" value="2"/>
<feature title="Βολάν Διάμετρος (mm) / Λούκι Ιμάντα" value="550 / 2Β"/>
<feature title="Απόσταση Οπών (mm) Α(πλάτος) / Β(μήκος)" value="210 / 290"/>
<feature title="Λίπανση" value="SAE 15W50"/>
<feature title="Βάρος (kg)" value="71,5"/>
<feature title="Εγγύηση" value="12 μήνες"/>
</features>
how can i import them on my customfieldsforall customfield?
thanks in advanced
Accepted Answer Pending Moderation
Hello,
You did not send us the complete import XML file. Based on what you have posted use combine template field with Your field set to features/feature/title and using RO CSVI combine rule plugin
combine all features/feature/title nodes and apply it on custom_title field. Same way combine use combine template field with Your field set to features/feature/value and apply it on custom_param field. custom_value should be set customfieldsforall and that can be set in default value field. Check Custom Fields For All for VirtueMart document.
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
this is a full item on the xml feuares on some are empty or less or more for each item
<item>
<id>60821</id>
<code>608051</code>
<barcode>5204319674111</barcode>
<rtlprc>76.00</rtlprc>
<description>GOODYEAR: GY 17ATK ΑΕΡΟΚΛΕΙΔΟ 1/2" ΚΑΣΕΤΙΝΑ</description>
<availabilitystatus>2</availabilitystatus>
<availabilitydescription>Διαθέσιμο</availabilitydescription>
<templatedescr>Αερόκλειδα Bulle</templatedescr>
<recycle_value>0.000</recycle_value>
<imageurl>
https://static.app.unimac.gr/products/608051_800x800_1.jpg,https://static.app.unimac.gr/products/608051_800x800_2.jpg,https://static.app.unimac.gr/products/608051_800x800_3.jpg,https://static.app.unimac.gr/products/608051_800x800_4.jpg
</imageurl>
<htmldescription>
<strong>Στην κασετίνα περιλαμβάνονται:</strong> 1 αερόκλειδο, 10 καρυδάκια, 1 προέκταση, 1 φορητός ελαιωτήρας
</htmldescription>
<features>
<feature title="Καρέ Υποδοχής" value="1/2""/>
<feature title="Ροπή Βιδώματος (kgm)" value="31,8"/>
<feature title="Ροπή Ξεβιδώματος (kgm)" value="31,8"/>
<feature title="Στροφές (rpm)" value="7000"/>
<feature title="Μέση Κατανάλωση Αέρα (lt/min)" value="142"/>
<feature title="Πίεση Λειτουργίας (bar)" value="6,3"/>
<feature title="Μήκος Σώμα / Ολικό (mm)" value="155/180"/>
<feature title="Λίπανση" value="SAE 10"/>
<feature title="Διαστάσεις Συσκ.ΜxΠxΥ (mm)" value="270x105x280"/>
<feature title="Βάρος (kg)" value="2,1"/>
<feature title="Βάρος Συσκευασίας (kg)" value="4,2"/>
<feature title="Εγγύηση" value="12 μήνες "/>
</features>
</item>
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
i did what you said, but it reads only the first title and at all the value
i attach the template for you to see
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
this is a full item on the xml feuares on some are empty or less or more for each item

CSVI cannot count the number of nodes in XML and create combine fields based on that. You need to add maximum possible combine fields in template fields. Make sure that custom_title,custom_value and custom_param have same count of values.

i did what you said, but it reads only the first title and at all the value

Rules were not added on custom_title and custom_param fields but were added on combine fields. Also combine character in rule was empty. I have modified the template to read two feature/combine nodes. See attached template.
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. # 4
Accepted Answer Pending Moderation
that did the trick , thank you
i will run it and let you know
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
i m trying to set the cron (first time on joomla 5 and php 8.3)
i add this cron commant

/home/ntagiantascom/public_html/2025.ntagiantas.com.gr/cli/joomla.php -vvv rocsvi:import --template_id=24--key=unimacnewimport

and i get this

/usr/local/cpanel/bin/jailshell: /home/ntagiantascom/public_html/2025.ntagiantas.com.gr/cli/joomla.php: Permission denied



any ideas?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
ok i was missing the php in front
i add it and now i get this without anything happening
X-Powered-By: PHP/8.3.13
Content-type: text/html; charset=UTF-8
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
nevermind fixed it php path was incorrect
your guide to cron for joomla 4 and higher missing an example :)
best regards
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
after the customfields setup i get this
[ERROR] Unknown column 'parent_id' in 'WHERE'
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
i attach some prints for help i see on preview everyting great but on the import the product is blank i also attach the log file
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
Unknown column 'parent_id' in 'WHERE'

The field parent_id is a column in
#__virtuemart_custom_plg_customsforall_values
table and is created with installation of customfieldsforall extension. Your customfieldsforall installation did not create this field and so you have error on import. Create this field in `#__virtuemart_custom_plg_customsforall_values` and check. This should be the reason product custom fields are blank after import.


CREATE TABLE IF NOT EXISTS `#__virtuemart_custom_plg_customsforall_values` (
`customsforall_value_id` int(11) NOT NULL AUTO_INCREMENT,
`customsforall_value_name` varchar(255) NOT NULL COMMENT 'Is the value of a custom field',
`customsforall_value_label` text NOT NULL COMMENT 'Used for string descriptions and color labels',
`virtuemart_custom_id` int(11) NOT NULL DEFAULT '0',
`parent_id` int(11) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`customsforall_value_id`),
KEY `virtuemart_custom_id` (`virtuemart_custom_id`),
KEY `parent_id` (`parent_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
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. # 11
Accepted Answer Pending Moderation
1. i run the sql no parent_id is import i run a simple xml from my desktop for speed up proccess i attach it here for you to check it has no errors
2. customs is still empty on product i attach the latest log
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
i fixed the table manually, but still the import does not save the customfields
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
Latest debug log shows no processing of custom fields. Checking more you don't seem to have custom fields created in VirtueMart which are used in custom_title field. You need to have them created first so on import values are linked with product. VirtueMart product import does not create custom fields, you need to use VirtueMart custom fields import for that. First create custom fields and then run the product import.
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. # 14
Accepted Answer Pending Moderation
ok i suspected that
a question
i will use the same rules but it does not combine fields
which is the combine characters so that i can import from 5-10 fields dependable from the xml of a product based the xml i send
i did a run already and on title id adds all the fields in one with the combine character in the title
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,
VirtueMart custom fields import does not support multiple values. Each value is one row so custom_title can have only one value. That is the reason all the values are added to title. There is no way to import all values of feature/feature/title node with one import. All you can do is import one node value per import and rest of nodes set to Skip fields. See attached screenshot. Also check Import XML with same node names document. That is the same logic here but with feature/feature/title node.
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. # 16
Accepted Answer Pending Moderation
i didnt see any attache printscreen
check my template for import customs,
it imports again again the same field (the first)
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
I fixed the parend sql issue but i have post an answer after that
I see on preview everything ok with the custom fields but inside the prodyct is empty
  1. more than a month ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Hello,
I fixed the parend sql issue but i have post an answer after that

I answered in my previous reply that parent_id error could be a reason for it. There is no details on custom fields processing in debug log attached in your previous post.

I see on preview everything ok with the custom fields but inside the prodyct is empty

Please post latest debug log to check.
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. # 19
  • Page :
  • 1


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