1. DarkoF
  2. RO CSVI
  3. Monday, 23 January 2023
  4.  Subscribe via email
Hi, I try import some Virtue Mart product prices via XML.

I follow documentation
https://rolandd.com/documentation/ro-csvi/import-xml

I assume that Identify XML paths and Identify CSVI fields ther is nothing need to be done is just for information, abaut structure.

Then I stop here at Add the fields

- From the Field name dropdown select the CSVI field

When I enter: Template fields -> New field -> at Edit template field

I don't have option to select at dropdown the CSVI field
Accepted Answer Pending Moderation
Hello,
Is working your test and xml from where I import, still i don't know why my sample don't working but is not matters.

There is an empty line before line <?xml version="1.0" encoding="UTF-8"?> in your file and so there are errors. Remove that empty line, save the file and run the import.

This time for parent product I made SKU - <sifra_nadartikla>,

I want import the first one A - with the same <sifra_nadartikla>NAD00367</sifra_nadartikla>
and I want skip others then again import the E and skip F

What kind of rule should I apply to achieve this?


You need to use CSVI Skip rule plugin to skip a node on 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. # 1
Accepted Answer Pending Moderation
Is working your test and xml from where I import, still i don't know why my sample don't working but is not matters. That's fine so I have one more question hope is the last one :)

I have few products with the same parent sku so:

<strugarstvo>
<izdelek>
<sifra>A</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>B</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>C</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>D</sifra>
<sifra_nadartikla>NAD00367</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>E</sifra>
<sifra_nadartikla>NAD999999</sifra_nadartikla>
</izdelek>
<izdelek>
<sifra>F</sifra>
<sifra_nadartikla>NAD999999</sifra_nadartikla>
</izdelek>
</strugarstvo>


This time for parent product I made SKU - <sifra_nadartikla>,

I want import the first one A - with the same <sifra_nadartikla>NAD00367</sifra_nadartikla>
and I want skip others then again import the E and skip F

What kind of rule should I apply to achieve this?

Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hi, yes your test.xml working.

and my test_product.xml dont, how is this possible?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
Please test with attached XML file and check how it goes. I can see that extra ; added with code on forum text.
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
I paste withaut :

<slika></slika>

but after submitting article add ;

<slika><;/slika>
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
actuality i paste without ;

<?xml version="1.0" encoding="UTF-8"?>
<strugarstvo>
<izdelek>
<sifra>018295</sifra>
<ean>3838909005324</ean>
<naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>
<enota>kos</enota>
<pakiranje>1</pakiranje>
<pro_sifra>600532</pro_sifra>
<mera>27x29 mm</mera>
<skupina>ROČNO ORODJE</skupina>
<cena>10.84</cena>
<zaloga>1</zaloga>
<rabat>41</rabat>
<ppc>18.38</ppc>
<davek>22</davek>
<opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540
polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO
10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>
<slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>
<teza>590</teza>
<bruto_teza>600</bruto_teza>
<proizvajalec>UNIOR</proizvajalec>
</izdelek>
</strugarstvo>

But when i add in code here code add ;
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi I made test xml file and try to import and don't work.

Thas is all file


<?xml version="1.0" encoding="UTF-8"?>
<strugarstvo>
<izdelek>
<sifra>018295</sifra>
<ean>3838909005324</ean>
<naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>
<enota>kos</enota>
<pakiranje>1</pakiranje>
<pro_sifra>600532</pro_sifra>
<mera>27x29 mm</mera>
<skupina>ROČNO ORODJE</skupina>
<cena>10.84</cena>
<zaloga>1</zaloga>
<rabat>41</rabat>
<ppc>18.38</ppc>
<davek>22</davek>
<opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540
polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO
10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>
<slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>
<teza>590</teza>
<bruto_teza>600</bruto_teza>
<proizvajalec>UNIOR</proizvajalec>
</izdelek>
</strugarstvo>
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
Thank you for posting the template XML. I found the problem is with <slika> node in your XML. There is a ; inside closing node which needs to be corrected. Also this node has special character & in its value and that is why XML is not read.


<slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;;/slika>


Two ways to solve this
1. Replace & with & using RO CSVI Multi replace rule so slika value becomes


<slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;/slika>


2. Second recommended way is to enclose <silka> value with CDATA so the parser ignores everything inside the CDATA section.


<?xml version="1.0" encoding="UTF-8"?>
<strugarstvo>
<izdelek>
<sifra>1018295</sifra>
<ean>3838909005324</ean>
<naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>
<enota>kos</enota>
<pakiranje>1</pakiranje>
<pro_sifra>600532</pro_sifra>
<mera>27x29 mm</mera>
<skupina>ROČNO ORODJE</skupina>
<cena>10.84</cena>
<zaloga>1</zaloga>
<rabat>41</rabat>
<ppc>18.38</ppc>
<davek>22</davek>
<opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540
polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO
10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>
<slika><![CDATA[https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg]]>;</slika>
<teza>590</teza>
<bruto_teza>600</bruto_teza>
<proizvajalec>UNIOR</proizvajalec>
</izdelek>
</strugarstvo>
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. # 8
Accepted Answer Pending Moderation
I attach file
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
Please post template XML file to check.To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.
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
Unfortunately still don't work

I have this structure xml to import



<?xml version="1.0" encoding="UTF-8"?>
<strugarstvo>
<izdelek>
<sifra>1018295</sifra>
<ean>3838909005324</ean>
<naziv>KLJUČ OBROČNI ART.180/1 Kromiran, glava polirana.</naziv>
<enota>kos</enota>
<pakiranje>1</pakiranje>
<pro_sifra>600532</pro_sifra>
<mera>27x29 mm</mera>
<skupina>ROČNO ORODJE</skupina>
<cena>10.84</cena>
<zaloga>1</zaloga>
<rabat>41</rabat>
<ppc>18.38</ppc>
<davek>22</davek>
<opis>Artikel: 180/1 material: krom vanadij površinska z aščita: kromiran po EN12540
polirane glave obročni del z LIF profilom v celoti izdelan v skladu s standardom ISO
10104 ( samo metrične dimenzije) kovan, v celoti poboljšan</opis>
<slika>https://b2b.lmmpro.si/image.ashx?id=018295&settings=3&.jpg<;/slika>
<teza>590</teza>
<bruto_teza>600</bruto_teza>
<proizvajalec>UNIOR</proizvajalec>
</izdelek>
</strugarstvo>



I want import only price and stock so i configure template fields:

Record name: izdelek

Field name: product_sku
Your field: sifra

Field name: product_price
Your field: ppc

Field name: product_in_stock
Your field: zaloga

Unfortunately when I import I get at preview message - Import file contains 0 lines

And there is 0 lines
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
I finally figure out lol
you was thinking that field like
product_sku = CSVI field

I try to find - CSVI field - not a - product_sku - name in drop down list as is written, uh.
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
SIr please see video

https://strugarstvo.com/ro-csvi-field.webm

I update the list of available fields
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,

I don't have option to select at dropdown the CSVI field
What do you see in the dropdown? Make sure you have updated the list of available fields as well by going to Available Fields and click the Update button.
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. # 14
  • Page :
  • 1


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