Witam.
Mam taki oto problem. Posiadam plik XML (szablon) produktów, który chciałbym uzupełnić kolejnymi wartościami przygotowanymi w Excelu. Czyli mam przygotowane dane np parametr <name> kilkadziesiąt pozycji wklejam je podobnie jak to ma miejsce w exelu w odpowiednią kolumnę/miejsce itd. Potrzebne mi to jest do założenia kart produktów co bardzo usprawniłoby mi pracę.
Poniżej przedstawiam kod mojego XMLa.
<?xml version="1.0" encoding="UTF-8" ?> <products> <product> <id>16420074</id> <active>N</active> <name><![CDATA[KOSZULA nowa (2)]]></name> <price_brutto>2499</price_brutto> <tax>23</tax> <promotion>N</promotion> <promotion_price>0</promotion_price> <new>Y</new> <external_codes> <code name="Ean" /> <code name="Ceneo" /> <code name="Bdk" /> <code name="ProducerCode" /> <code name="CatalogId" /> </external_codes> <producent>BYTOM</producent> <deliver_code /> <short_description><![CDATA[]]></short_description> <html_description><![CDATA[]]></html_description> <params> </params> <keywords></keywords> <measurement>szt.</measurement> <availability>D</availability> <shipping_time>3</shipping_time> <post_dimentions>A</post_dimentions> <weight>0</weight> <height>0</height> <length>0</length> <width>0</width> <package /> <package_weight /> <package_height /> <package_length /> <package_width /> <packaging_levels> </packaging_levels> <categories> <category>Koszule</category> </categories> <photos> </photos> <variants_edit> <variant_edit> <variant_id>20268245</variant_id> <properties> <property name="Koszule">38 176/182</property> </properties> <variant_active>Y</variant_active> <variant_quantity>1</variant_quantity> </variant_edit> </variants_edit> </product> <id>16418213</id> <active>N</active> <name><![CDATA[KOSZULA B]]></name> <price_brutto>2499</price_brutto> <tax>23</tax> <promotion>N</promotion> <promotion_price>0</promotion_price> <new>Y</new> <external_codes> <code name="Ean" /> <code name="Ceneo" /> <code name="Bdk" /> <code name="ProducerCode" /> <code name="CatalogId" /> </external_codes> <producent>FIRMA</producent> <deliver_code /> <short_description><![CDATA[]]></short_description> <html_description><![CDATA[]]></html_description> <params> </params> <keywords></keywords> <measurement>szt.</measurement> <availability>D</availability> <shipping_time>3</shipping_time> <post_dimentions>A</post_dimentions> <weight>0</weight> <height>0</height> <length>0</length> <width>0</width> <package /> <package_weight /> <package_height /> <package_length /> <package_width /> <packaging_levels> </packaging_levels> <categories> <category>Koszule</category> </categories> <photos> </photos> <variants_edit> <variant_edit> <variant_id>20266260</variant_id> <properties> <property name="Koszule">38 176/182</property> </properties> <variant_active>Y</variant_active> <variant_quantity>1</variant_quantity> </variant_edit> </variants_edit> </product> </products>
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)