1. liuker
  2. RO CSVI
  3. Friday, 05 April 2019
  4.  Subscribe via email
Good evening, I'm doing an xml import of a virtual article code that contains multiple products.
I enclose the XML file for example:


<Products>
<Product>
<Code>113823</Code><Name>TAGLIAVERDURE LANETARIA KENWOOD CHEF MAJOR</Name><ProductType>Kit</ProductType><KitComponents>
<Product>
<Code>107315</Code></Product>
<Quantity>1</Quantity>
</KitComponents>
<Active>true</Active><ActiveOnWeb>true</ActiveOnWeb><CreationDate>2018-11-26</CreationDate><LastModifiedDate>2019-03-20</LastModifiedDate><Manufacturer>
<Id>88</Id><Name>Kenwood</Name></Manufacturer>
<MPN>KAX643ME+KAT001</MPN><Description><br> La Grattugia a rulli consente di affettare e sminuzzare a bassa velocita'' in continuo: questo significa poter lavorare ingredienti delicati come formaggi, cioccolato, salumi, frutta e verdura morbida, . senza rovinarli. In dotazione ci sono 5 rulli monotaglio in metallo per: sminuzzare fine e grosso, tagliare fine e grosso, grattugiare.
<br>
<br><b>Attenzione</b>
<br>
<br>Il Modello AT643 risulta essere FUORI PRODUZIONE pertanto verra' fornito il nuovo modello di tagliaverdure KAX643ME insieme all'adattatore per poter essere montato e utilizzato correttamente.

<br>Adatto sia a Chef che Major
<br>
<br>Modello fuori produzione : AT643
<br>
<br>Nuovo modello : KAX643ME+ kat001ME
<br><br>
<br>Attacchi motore: Bassa velocita'
<br>
<br>Capacita': In continuo<br>
<br>Importante: Per evitare errori nell'acquisto potete confrontare il modello di impastatore kenwood in vostro possesso con i modelli compatibili per l'accessorio qui in basso.<br>
<br><b><i>(I numeri di modello possono essere trovati sotto il mixer sulla targhetta.)</b></i></Description><Description2><div style="width:90%;height:250px;overflow-y: scroll; border:1px solid black;">
KM220 <br>
KM001 <br>
KM002 <br>

</WebDescription><CustomTableDescription1>ORIGINALE</CustomTableDescription1><CustomTableDescription2>CODICE VIRTUALE</CustomTableDescription2><CustomTableDescription3 /><CustomTableDescription4>35</CustomTableDescription4><CustomTableDescription5 /><CustomTableDescription6 /><CustomTableDescription7 /><CustomTableDescription8 /><CustomField1>ricambi kenwood, ricambi cooking, tagliaverdure kenwood, accessorio tagliaverdure kenwood</CustomField1><CustomField2 /><CustomField3 /><UMSelling>PZ</UMSelling><UMInventory>PZ</UMInventory><QtyAvailable>0</QtyAvailable>
<QtyAvailableWeb>0</QtyAvailableWeb>
<QtySuppliersOrders>0</QtySuppliersOrders>
<ReorderTime>0</ReorderTime><MainCategory>2620</MainCategory><MainProdCategory>2620</MainProdCategory><ProdCategories>
<ProdCategory>
<Id>2620</Id><Code /><Name>ACCESSORI</Name><FullPathName>RICAMBI E ACCESSORI / IMPASTATRICE / ACCESSORI</FullPathName></ProdCategory>
</ProdCategories>
<GrossWeight>2</GrossWeight>
<Volume>0</Volume>
<PackageLength>0</PackageLength>
<PackageWidth>0</PackageWidth>
<PackageHeight>0</PackageHeight>
<Tax>
<Id>1</Id><PercentAmount>22</PercentAmount>
</Tax>
<SellingPrices>
<SellingPrice>
<PriceListId>4</PriceListId><Price>118.85</Price>
<PriceIncludingVAT>145</PriceIncludingVAT>
</SellingPrice>
</SellingPrices>
<OfficialPriceList>
<Price>0</Price>
<PriceIncludingVAT>0</PriceIncludingVAT>
</OfficialPriceList>
<Photos><Photo>
<IdType>1</IdType><Name>Tagliaverdure AT643 kenwood accessorio planetarie</Name><RelativeFilePath>readyprodierre_Files/Foto/42133_871.jpg</RelativeFilePath></Photo>
</Photos>
<Barcodes>
<Barcode>
<Code>113823</Code></Barcode>
</Barcodes>
</Product>

</Products>


the problem lies in this string that stops me from loading:
<KitComponents>
<Product>
<Code>107315</Code></Product>
<Quantity>1</Quantity>
</KitComponents>


below I attach the photos of the problem, as it blocks the passage of all the other fields.
Screenshot 2019-04-05 18.00.25.png Screenshot 2019-04-05 18.05.02.png
Accepted Answer Pending Moderation
Hello,
Thank you for confirming that patch is working. This fix will be included in our upcoming CSVI release.

Also Please leave us a review on Joomla Extension Directory.
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
You were very fast and very kind.
Problem solved, now everything works properly!
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
We have identified the issue when reading the XML and fixed it in code. You can load the attached patch file and try the import again.
Since you don't need to import KitComponents, KitComponents/Product, KitComponents/Product/Code or KitComponents/Quantity fields, you can remove those Skip fields from your template fields.
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. # 3
Accepted Answer Pending Moderation
Hello,
I can see the issue with your template and import file. Looking into the issue and will get back with an update.
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
Send you a file for test.:
[attachment]csvi_templates_http://www.dierreonline.com_20190409.xml[/attachment] pro.xml
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
Can you send me the template XML file with latest changes? Also send me the import file you are using. Will run the import here and 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. # 6
Accepted Answer Pending Moderation
Unfortunately, he does not read further, I do not know what is sincerely wrong. Screenshot 2019-04-09 13.19.40.png
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
The skip fields in your template fields is not same as the one i posted. You do not have skip field set for KitComponents. Can you try creating skip field same as in the screenshot i sent?

With template fields as in my screenshot i see product 113828 loads fine. Check attached screenshot.
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. # 8
Accepted Answer Pending Moderation
Unfortunately, even if the code 113828 has only one node, it does not generate the article but blocks the following fields, as in the photo.
Screenshot 2019-04-09 12.47.17.png
I tried to make the different skips but the problem persists, I attach photo for security:

Screenshot 2019-04-09 12.48.40.png
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
Ok i think i understand the actual issue. For product 113828, under <KitComponents></KitComponents> you have two product nodes but with 118165 there is one product node. You have set one Skip field for KitComponents, KitComponents/Product and KitComponents/Product/Code which ignores one product node but there is still one more for product 113828. This works for 118165 because it has only one product node under <KitComponents></KitComponents>.What if you create one more set of skip field for KitComponents, KitComponents/Product and KitComponents/Product/Code like in the screenshot attached? Does it work for you then?
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. # 10
Accepted Answer Pending Moderation
I would like the code 107315 in KitComponents / Product / Code to be skipped and not taken into consideration.
This:
<KitComponents>
<Product>
<Code>107315</Code></Product>
<Quantity>1</Quantity>
</KitComponents>
this must not be taken into consideration to continue reading the fields.

Unfortunately, this does not happen as it interrupts the import of the subsequent data as in the photo

Screenshot 2019-04-09 12.12.32.png Screenshot 2019-04-09 12.12.51.png
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
<KitComponents>
<Product>
<Code>107315</Code></Product>
<Quantity>1</Quantity>
</KitComponents>

You mentioned that the product code are not loaded from this part of the XML. From what i noticed from your template is that, the XML path to read the code 107315 is KitComponents/Product/Code and you have set that to Skip field and so it is skipped. You cannot have two different XML paths set to one field in import. Since there are two different XML paths for product_sku as per your XML, you need to create two different import templates. One template where XML path for product_sku will be Code(as per the current template) and the second template you need to set product_sku XML path as KitComponents/Product/Code. Let me know if it solves your issue.
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
To help the solution, I forward the xml file containing two articles, a virtual one and a standard article.
From the configuration that can be displayed in the previous messages of the corresponding fields, the first (virtual) code is generated without the information, generating the articles that compose it as contained in the file information in <code>.

The second standard code is generated without problems.

roduct>
<Code>113828</Code><Name>MACINA CEREALI / MACINAGRANAGLIE ACCESSORIO KENWOOD AT941 AWAT941A01 (KAX941+KAT001)</Name><ProductType>Kit</ProductType><KitComponents>
<Product>
<Code>106430</Code></Product>
<Quantity>1</Quantity>
<Product>
<Code>109548</Code></Product>
<Quantity>1</Quantity>
</KitComponents>
<Active>true</Active><ActiveOnWeb>true</ActiveOnWeb><CreationDate>2018-11-27</CreationDate><LastModifiedDate>2019-04-04</LastModifiedDate><Manufacturer>
<Id>41</Id><Name>De Longhi</Name></Manufacturer>
<MPN>KAX941+KAT001</MPN><Description><b>RICAMBIO ORIGINALE</b>
<br>
<br>Modello fuori produzione : AT941
<br>Nuovo modello : KAX941PL + kat001ME
<br><br>
<b>ATTENZIONE:</b><br>
Il Modello AT941 risulta essere FUORI PRODUZIONE pertanto verra'
fornito il nuovo modello di MACINA CEREALI KAX941PL insieme all'adattatore per poter essere montato e utilizzato correttamente.
<br><br>
Il Macinagranaglie Kenwood e' ideale per macinare i cereali che preferite ed ottenere cos? speciali miscele di farine, personalizzate in base ai propri gusti, come farine senza glutine oppure ottenute dai legumi.
<br><br></Description><Description2><div style="width:90%;height:250px;overflow-y: scroll; border:1px solid black;">
 - A900CHEF <br>
 - A900MAJOR <br>
 - KMM777 KITCHEN MACHINE - MAJOR - GRAPHITE + AT358 <br>
 - PM500 <br>
</DIV></Description2><Notes>MACINA CEREALI / MACINAGRANAGLIE ACCESSORIO KENWOOD (KAX941+KAT001) PER PLANETARIE</Notes><WebDescription><b>RICAMBIO ORIGINALE</b>
<br>
<br>Modello fuori produzione : AT941
<br>Nuovo modello : KAX941PL + kat001ME
<br><br>
<b>ATTENZIONE:</b><br>
Il Modello AT941 risulta essere FUORI PRODUZIONE pertanto verra'
fornito il nuovo modello di MACINA CEREALI KAX941PL insieme all'adattatore per poter essere montato e utilizzato correttamente.
<br><br>
Il Macinagranaglie Kenwood e' ideale per macinare i cereali che preferite ed ottenere cos? speciali miscele di farine, personalizzate in base ai propri gusti, come farine senza glutine oppure ottenute dai legumi.
<br><br></WebDescription><CustomTableDescription1>ORIGINALE</CustomTableDescription1><CustomTableDescription2>CODICE VIRTUALE</CustomTableDescription2><CustomTableDescription3 /><CustomTableDescription4>44</CustomTableDescription4><CustomTableDescription5 /><CustomTableDescription6 /><CustomTableDescription7 /><CustomTableDescription8 /><CustomField1>accessori kenwood, macinacereali kenwood, accessorio macinacereali</CustomField1><CustomField2 /><CustomField3 /><UMSelling>PZ</UMSelling><UMInventory>PZ</UMInventory><QtyAvailable>0</QtyAvailable>
<QtyAvailableWeb>0</QtyAvailableWeb>
<QtySuppliersOrders>0</QtySuppliersOrders>
<ReorderTime>0</ReorderTime><MainCategory>2620</MainCategory><MainProdCategory>2620</MainProdCategory><ProdCategories>
<ProdCategory>
<Id>2620</Id><Code /><Name>ACCESSORI</Name><FullPathName>RICAMBI E ACCESSORI / IMPASTATRICE / ACCESSORI</FullPathName></ProdCategory>
</ProdCategories>
<GrossWeight>1.2</GrossWeight>
<Volume>0</Volume>
<PackageLength>0</PackageLength>
<PackageWidth>0</PackageWidth>
<PackageHeight>0</PackageHeight>
<Tax>
<Id>1</Id><PercentAmount>22</PercentAmount>
</Tax>
<SellingPrices>
<SellingPrice>
<PriceListId>4</PriceListId><Price>114.75</Price>
<PriceIncludingVAT>140</PriceIncludingVAT>
</SellingPrice>
</SellingPrices>
<OfficialPriceList>
<Price>0</Price>
<PriceIncludingVAT>0</PriceIncludingVAT>
</OfficialPriceList>
<Photos><Photo>
<IdType>1</IdType><Name>Macina cereali accessorio kenwood KAX941+KAT001</Name><RelativeFilePath>readyprodierre_Files/Foto/42155_875.jpg</RelativeFilePath></Photo>
</Photos>
<Barcodes>
<Barcode>
<Code>113828</Code></Barcode>
<Barcode>
<Code>5011423058221</Code></Barcode>
</Barcodes>
</Product>
<Product>
<Code>118165</Code><Name>HOTPOINT ARISTON ESTRATTORE DI SUCCO CENTRIFUGA SORBETTIERA SJ15XLUP0</Name><ProductType>Standard</ProductType><Active>true</Active><ActiveOnWeb>true</ActiveOnWeb><CreationDate>2018-11-29</CreationDate><LastModifiedDate>2019-03-21</LastModifiedDate><Manufacturer>
<Id>14</Id><Name>HotPoint Ariston</Name></Manufacturer>
<MPN>SJ15XLUP0</MPN><Description /><Description2 /><Notes /><WebDescription /><CustomTableDescription1>ORIGINALE</CustomTableDescription1><CustomTableDescription2 /><CustomTableDescription3 /><CustomTableDescription4>42</CustomTableDescription4><CustomTableDescription5 /><CustomTableDescription6 /><CustomTableDescription7 /><CustomTableDescription8 /><CustomField1>centrifuga hotpoint ariston,estrattore di succo hotpoint ariston</CustomField1><CustomField2 /><CustomField3 /><UMSelling>PZ</UMSelling><UMInventory>PZ</UMInventory><QtyAvailable>3</QtyAvailable>
<QtyAvailableWeb>3</QtyAvailableWeb>
<QtySuppliersOrders>0</QtySuppliersOrders>
<ReorderTime>0</ReorderTime><MainCategory>2647</MainCategory><MainProdCategory>2647</MainProdCategory><ProdCategories>
<ProdCategory>
<Id>2647</Id><Code /><Name>ESTRATTORE DI SUCCO</Name><FullPathName>PRODOTTI FINITI / ESTRATTORE DI SUCCO</FullPathName></ProdCategory>
</ProdCategories>
<GrossWeight>0</GrossWeight>
<Volume>0</Volume>
<PackageLength>0</PackageLength>
<PackageWidth>0</PackageWidth>
<PackageHeight>0</PackageHeight>
<Tax>
<Id>1</Id><PercentAmount>22</PercentAmount>
</Tax>
<SellingPrices>
<SellingPrice>
<PriceListId>4</PriceListId><Price>118.85</Price>
<PriceIncludingVAT>145</PriceIncludingVAT>
</SellingPrice>
</SellingPrices>
<OfficialPriceList>
<Price>0</Price>
<PriceIncludingVAT>0</PriceIncludingVAT>
</OfficialPriceList>
<Photos></Photos>
<Barcodes>
<Barcode>
<Code>118165</Code></Barcode>
</Barcodes>
</Product>
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Thanks to the availability.
Unfortunately the problem occurs only when I have to enter virtual codes, as indicated above.

[attachment]csvi_templates_http://www.dierreonline.com_20190408.xml[/attachment]
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
Thank you for posting the import XML. Can you also post your template XML file to check? Setting up a sample import with few fields on my local site using your screenshot, XML values loads fine. Would like to check it with your template. To get template XML go to CSVI Maintenance page, select CSVI Pro in first dropdown and Backup templates in second dropdown and select your import template and click continue. Post the downloaded 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. # 15
Accepted Answer Pending Moderation
good morning the complete code is here

<Product>
<Code>116110</Code><Name>IGIENIZZANTE ANTI MUFFA CURA LAVATRICE SOFFIETTO GOMMA OBLO E CESTO X2 ELECTROLUX</Name><ProductType>Kit</ProductType><KitComponents>
<Product>
<Code>115239</Code></Product>
<Quantity>2</Quantity>
</KitComponents>
<Active>true</Active><ActiveOnWeb>true</ActiveOnWeb><CreationDate>2018-11-29</CreationDate><LastModifiedDate>2019-04-04</LastModifiedDate><Manufacturer>
<Id>44</Id><Name>Electrolux - Rex - Zanussi</Name></Manufacturer>
<MPN>9029797264X2</MPN><Description><b>RICAMBIO ORIGINALE</b>
<br>
<br>Prodotto universale per pulire la gomma soffietto oblo lavatrice, elimina la muffa e altri residui.
<br><br>
Per avere la certezza che il vostro modello sia compatibile con il nostro ricambio originale controllate la lista dei modelli e paragonatela con il codice dell'etichetta posizionata all'interno dell'oblò della vostra lavatrice.
<br><br></Description><Description2><br>
2 CONFEZIONI, IN OGNI CONFEZIONE CI SONO 2 BUSTINE DA 50 GRAMMI
<br></Description2><Notes>PRODOTTO PER LA CURA DELLA LAVATRICE, 2 CONFEZIONI DA 2 BUSTINE CON 50 GRAMMI PER ELIMINARE MUFFA E CALCARE POSTI SUL SOFFIETTO IN GOMMA DELL'OBLO LAVATRICE.</Notes><WebDescription><b>RICAMBIO ORIGINALE</b>
<br>
<br>Prodotto universale per pulire la gomma soffietto oblo lavatrice, elimina la muffa e altri residui.
<br><br>
Per avere la certezza che il vostro modello sia compatibile con il nostro ricambio originale controllate la lista dei modelli e paragonatela con il codice dell'etichetta posizionata all'interno dell'oblò della vostra lavatrice.
<br><br></WebDescription><CustomTableDescription1>ORIGINALE</CustomTableDescription1><CustomTableDescription2>CODICE VIRTUALE</CustomTableDescription2><CustomTableDescription3 /><CustomTableDescription4>35</CustomTableDescription4><CustomTableDescription5 /><CustomTableDescription6 /><CustomTableDescription7 /><CustomTableDescription8 /><CustomField1>disincrostante lavatrice, disincrostante lavastoviglie, anti muffa lavatrice, cura lavatrice, decalcificante lavatrce</CustomField1><CustomField2 /><CustomField3 /><UMSelling>PZ</UMSelling><UMInventory>PZ</UMInventory><QtyAvailable>0</QtyAvailable>
<QtyAvailableWeb>0</QtyAvailableWeb>
<QtySuppliersOrders>0</QtySuppliersOrders>
<ReorderTime>0</ReorderTime><MainCategory>622</MainCategory><MainProdCategory>622</MainProdCategory><ProdCategories>
<ProdCategory>
<Id>622</Id><Code>023550</Code><Name>DISINCROSTANTI</Name><FullPathName>RICAMBI E ACCESSORI / LAVATRICI / DISINCROSTANTI</FullPathName></ProdCategory>
</ProdCategories>
<GrossWeight>0.8</GrossWeight>
<Volume>0</Volume>
<PackageLength>0</PackageLength>
<PackageWidth>0</PackageWidth>
<PackageHeight>0</PackageHeight>
<Tax>
<Id>1</Id><PercentAmount>22</PercentAmount>
</Tax>
<SellingPrices>
<SellingPrice>
<PriceListId>4</PriceListId><Price>12.3</Price>
<PriceIncludingVAT>15</PriceIncludingVAT>
</SellingPrice>
</SellingPrices>
<OfficialPriceList>
<Price>0</Price>
<PriceIncludingVAT>0</PriceIncludingVAT>
</OfficialPriceList>
<Photos><Photo>
<IdType>1</IdType><Name>IGENIZZANTE CURA LAVATRICE ANTI MUFFA PER SOFFIETTI OBLO</Name><RelativeFilePath>readyprodierre_Files/Foto/42170_916.jpg</RelativeFilePath></Photo>
</Photos>
<Barcodes>
<Barcode>
<Code>116110</Code></Barcode>
</Barcodes>
</Product>
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Hello,
The XML you posted is not valid. There are Opening and ending tag mismatch errors when i run the XML. If you can see the there is no opening tag for </WebDescription> and for <Description2> there is missing closing tag </Description2>. Is this the full XML of a product or part of it?
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
  • Page :
  • 1


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