Resolved customfieldsforall import from vendor xml

the trick was on the rules to combine empty values to YES
it is ok now

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.

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>

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

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.

that did the trick , thank you
i will run it and let you know

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?

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

nevermind fixed it php path was incorrect
your guide to cron for joomla 4 and higher missing an example
best regards

after the customfields setup i get this
[ERROR] Unknown column 'parent_id' in 'WHERE'

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

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;

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

i fixed the table manually, but still the import does not save the customfields

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.

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

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.

i didnt see any attache printscreen
check my template for import customs,
it imports again again the same field (the first)

Hello,

i didnt see any attache printscreen

Looks like the image did not get attached. I have attached it again. Please check.

it imports again again the same field (the first)

Yes and that is because there is no fields set for other nodes. Did you read the document I linked in my previous reply? Importing multiple nodes with same name is a little tricky especially when you want to import to one field custom_title. It can only done using multiple imports and by using skip field. Say if you have 5 nodes of feature/feature/title then you need to run 5 imports where one node feature/feature/title is assigned to custom_title field and the rest should be set to skip field.Please check the linked document for example.

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