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
- soura123
- RO CSVI
- Wednesday, 06 November 2024
- Subscribe via email
0
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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>
<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>
Accepted Answer
Pending Moderation
Hello,
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.
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.
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.
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
i m trying to set the cron (first time on joomla 5 and php 8.3)
i add this cron commant
and i get this
any ideas?
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?
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
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
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
your guide to cron for joomla 4 and higher missing an example
best regards
Accepted Answer
Pending Moderation
after the customfields setup i get this
[ERROR] Unknown column 'parent_id' in 'WHERE'
[ERROR] Unknown column 'parent_id' in 'WHERE'
Accepted Answer
Pending Moderation
Hello,
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
i fixed the table manually, but still the import does not save the customfields
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
I see on preview everything ok with the custom fields but inside the prodyct is empty
Accepted Answer
Pending Moderation
Hello,
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.
Please post latest debug log to check.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- 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 »