topic Re: Parsing XML in Data Quality

Parsing XML

veryimportantdude — Fri, 15 Nov 2024 23:12:20 GMT

Hello,

i have an XML with products and each product has multiple subtags etc.

</idents>

<base>

<name>APC BatteryKit 1000I 1000INET BP SU SUA</name>

<longname>APC BatteryKit 1000I 1000INET BP SU SUA</longname>

<categoryName value="I10002003">Diskovni sistemi in knjižnice / UPS / Baterije</categoryName>

<category sequence="1">Diskovni sistemi in knjižnice</category>

<category sequence="3">Baterije</category>

<warranty unit="month" value="0">Brez garancije</warranty>

<countryoforigin value="CN">China</countryoforigin>

</base>

<stock>

<backlog uom="ea" value="0" isotimestamp="2022 - 02 - 14T10:02: 40.004+00:00" unixtimestamp="1644832960" timezone="Europe/Ljubljana">20220225: Ni naročeno</backlog>

</backlogs>

</stock>

<picture sequence="0" view="Glavna slika" width="200" height="150" link="https://actebis-images.com/productimages/530fc204-60f3-41a8-9951-ba3f14d177d2.jpg">Glavna slika</picture>

<picture sequence="1" view="Product shot Right-angle" width="400" height="300" link="http://cdn.cnetcontent.com/10/37/1037ab71-d709-4e3b-9b46-2d66eda464ab.jpg">Product shot Right-angle</picture>

<picture sequence="2" view="Product shot Right-angle" width="200" height="150" link="http://cdn.cnetcontent.com/33/e9/33e9534a-7436-48af-be58-443cfe124f5f.jpg">Product shot Right-angle</picture>

<picture sequence="3" view="Product shot Right-angle" width="640" height="480" link="http://cdn.cnetcontent.com/9c/e4/9ce4f526-8748-4a94-a959-857f8659405a.jpg">Product shot Right-angle</picture>

<picture sequence="4" view="Product shot Right-angle" width="75" height="75" link="http://cdn.cnetcontent.com/f7/ab/f7ab1f4f-7b14-457d-a959-ead6c112b7c4.jpg">Product shot Right-angle</picture>

</pictures>

<specification lang="SL" name="Oblika baterije" value="9">Plug-in module</specification>

</attributes>

</product>

Now I need to put for example inside idents the first tag (sapid) into one field, ean into another.

</idents>

Same goes for eample for pictures.

sequence="0" has to go into one field sequence="1" into another etc.

I am kind of lost on how to specify the XMLs. Thank you

Best regard

Re: Parsing XML

Anonymous — Fri, 18 Feb 2022 04:50:19 GMT

Hello,

Could you please elaborate your case with an example with expected output values?

Best regards

Sabrina

Re: Parsing XML

veryimportantdude — Fri, 18 Feb 2022 09:15:21 GMT

Sure

I will write where the filed should be mapped in a new xml

</idents>

Also for pictures

<picture sequence="0" view="Glavna slika" width="200" height="150" link="https://actebis-images.com/productimages/530fc204-60f3-41a8-9951-ba3f14d177d2.jpg">Glavna slika</picture>

<picture sequence="1" view="Product shot Right-angle" width="400" height="300" link="http://cdn.cnetcontent.com/10/37/1037ab71-d709-4e3b-9b46-2d66eda464ab.jpg">Product shot Right-angle</picture>

<picture sequence="2" view="Product shot Right-angle" width="200" height="150" link="http://cdn.cnetcontent.com/33/e9/33e9534a-7436-48af-be58-443cfe124f5f.jpg">Product shot Right-angle</picture>

<picture sequence="3" view="Product shot Right-angle" width="640" height="480" link="http://cdn.cnetcontent.com/9c/e4/9ce4f526-8748-4a94-a959-857f8659405a.jpg">Product shot Right-angle</picture>

<picture sequence="4" view="Product shot Right-angle" width="75" height="75" link="http://cdn.cnetcontent.com/f7/ab/f7ab1f4f-7b14-457d-a959-ead6c112b7c4.jpg">Product shot Right-angle</picture>

</pictures>

new xml

<short_code>RBC6</short_code>

<picture1>https://actebis-images.com/productimages/530fc204-60f3-41a8-9951-ba3f14d177d2.jpg</picture1>

<picture2>http://cdn.cnetcontent.com/10/37/1037ab71-d709-4e3b-9b46-2d66eda464ab.jpg</picture2>

<picture3>http://cdn.cnetcontent.com/10/37/1037ab71-d709-4e3b-9b46-2d66eda464xxxxxx.jpg</picture3>

</product>

Re: Parsing XML

Anonymous — Wed, 23 Feb 2022 15:22:55 GMT

@none yebach this looks like the same XML that we were talking about the other day. Sorry I missed this one. Have you achieved this yet? I think the values you are talking about are the same ones that we worked on. Once you have them out, you can build a new XML structure with a tXMLMap component.

Re: Parsing XML

veryimportantdude — Thu, 03 Mar 2022 15:32:23 GMT

I solved the problem....

using extractXML field was needed due to large xml file anfterwards using this nottation the data was extracted

"./idents/ident[@type='partnumber']"

Re: Parsing XML

Anonymous — Fri, 04 Mar 2022 07:45:50 GMT

Hello,

Great you solved the problem and sharing the solution with us on community.

Best regards

Sabrina