The essence of what. There is such a code here. I am trying to bring it into the form available for importing into WordPress. I tried to export it to exel in order to get columns with tags, and in the line all parameters. But I was so bored with the fact that the tag for example <param name="ΠšΠΎΡ€ΠΎΡ‚ΠΊΠΎΠ΅ описаниС"> , eksel does not create a separate column for it, but sculpts everything into a heap also into different lines.

Is there any way, either we can re-name in param1 and close it with the same tag, or somehow explain to Excel that these are different columns. There are a lot of such offers.

 <offer> 4271</offer> <param name="ΠšΠΎΡ€ΠΎΡ‚ΠΊΠΎΠ΅ описаниС">ΠšΠΎΠ»Π³ΠΎΡ‚ΠΊΠΈ ТСнскиС TRENDY MELANGE 60, Ρ€.2, chocolate</param> <param name="ΠœΠ°Ρ‚Π΅Ρ€ΠΈΠ°Π»">ΠΏΠΎΠ»ΠΈΠ°ΠΌΠΈΠ΄ 50%; полиэстСр 38%; эластан 12%</param> <param name="Π Π°Π·ΠΌΠ΅Ρ€">2,3,4</param> <param name="Π¦Π²Π΅Ρ‚">chocolate,grafit,grey,melanzana,verde</param> <param name="ΠŸΠ»ΠΎΡ‚Π½ΠΎΡΡ‚ΡŒ">60</param> <price>235</price>

    1 answer 1

    Import to Ecxel is easiest in the form of csv - the same label. It will be something like this:

         offer price Short description Material Size Color Density
     4271 235 Women's tights TRENDY MELANGE 60, p.2, chocolate 50% polyamide;  polyester 38%;  elastane 12% 2,3,4 chocolate, grafit, gray, melanzana, verde 60
     4271 235 Women's tights TRENDY MELANGE 60, p.2, chocolate 50% polyamide;  polyester 38%;  elastane 12% 2,3,4 chocolate, grafit, gray, melanzana, verde 60

    To convert xml-> csv I use XQUERY. For your example, you can do, for example, like the xml example in csv with xquery tools .

    Excel will look like this .

    To handle xml as an xquery processor, I use BASEX . It has GUI + very convenient tools for publishing as an API.