Feb-08-2020, 06:01 PM
Hi,
I have huge XML file of size 500mb which I want to convert to CSV using Python.i tried lot and not able to get proper output . Can some one help me with this?
Sample input xml
-------
<?xml version="1.0" encoding="UTF-8"?>
<Feed xmlns="http://www.bazaarvoice.com/xs/PRR/ProductFeed/5.6" name="ikeaglobal" incremental="false" extractDate="2020-01-21T10:34:20.041000">
<Categories>
<Category>
<ExternalId>10364</ExternalId>
<Name>Storage furniture</Name>
<Names>
<Name locale="sk_SK">Úložné systémy </Name>
<Name locale="hu_HU">Tárolás </Name>
<Name locale="eu_ES">Biltegiratze-altzariak </Name>
<Name locale="cs_CZ">Úložné systémy </Name>
<Name locale="pt_PT">Móveis de arrumação </Name>
<Name locale="en_AU">Storage furniture </Name>
<Name locale="nl_BE">Opbergmeubels </Name>
<Name locale="fr_BE">Rangements bureau et salon </Name>
<Name locale="de_AT">Aufbewahrungsmöbel </Name>
<Name locale="nl_NL">Opbergmeubels </Name>
<Name locale="en_PT">Storage furniture </Name>
<Name locale="it_CH">Mobili </Name>
<Name locale="en_GB">Storage furniture </Name>
<Name locale="en_CH">Storage furniture </Name>
<Name locale="de_CH">Aufbewahrungsmöbel </Name>
<Name locale="fr_CH">Rangements bureau et salon </Name>
<Name locale="fr_CA">Meubles de rangement </Name>
<Name locale="en_CA">Storage furniture </Name>
<Name locale="hr_HR">Namještaj za odlaganje </Name>
<Name locale="ja_JP">収納家具 </Name>
<Name locale="en_KR">Storage furniture </Name>
<Name locale="ko_KR">수납가구 </Name>
<Name locale="ca_ES">Mobles d'emmagatzematge </Name>
<Name locale="es_ES">Mobiliario de almacenaje </Name>
<Name locale="it_IT">Mobili </Name>
<Name locale="de_DE">Aufbewahrungsmöbel </Name>
<Name locale="fr_FR">Rangements bureau et salon </Name>
<Name locale="en_NL">Storage furniture </Name>
<Name locale="en_US">Storage furniture </Name>
<Name locale="ro_RO">Mobilier pentru depozitare </Name>
<Name locale="en_ES">Storage furniture </Name>
<Name locale="en_JP">Storage furniture </Name>
</Names>
<CategoryPageUrl>https://www.ikea.com/se/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrls>
<CategoryPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="eu_ES">https://www.ikea.com/es/eu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_AU">https://www.ikea.com/au/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ja_JP">https://www.ikea.com/jp/ja/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_KR">https://www.ikea.com/kr/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ko_KR">https://www.ikea.com/kr/ko/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_JP">https://www.ikea.com/jp/en/catalog/categories/range/10364/</CategoryPageUrl>
</CategoryPageUrls>
</Category>
</Categories>
<Products>
<Product>
<ExternalId>ART-00015134</ExternalId>
<Name>SVALKA White wine glass</Name>
<Names>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="sk_SK">SVALKA Pohár na biele víno</Name>
<Name locale="hu_HU">SVALKA Fehérboros pohár</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="cs_CZ">SVALKA Sklenka na bílé víno</Name>
<Name locale="pt_PT">SVALKA Copo de vinho branco</Name>
<Name locale="nl_BE">SVALKA Wittewijnglas</Name>
<Name locale="fr_BE">SVALKA Verre à vin blanc</Name>
<Name locale="de_AT">SVALKA Weißweinglas</Name>
<Name locale="nl_NL">SVALKA Wittewijnglas</Name>
<Name locale="it_CH">SVALKA Bicchiere da vino bianco</Name>
<Name locale="en_PT">SVALKA White wine glass</Name>
<Name locale="en_GB">SVALKA White wine glass</Name>
<Name locale="en_CH">SVALKA White wine glass</Name>
<Name locale="de_CH">SVALKA Weißweinglas</Name>
<Name locale="fr_CH">SVALKA Verre à vin blanc</Name>
<Name locale="fr_CA">SVALKA Verre à vin blanc</Name>
<Name locale="en_CA">SVALKA White wine glass</Name>
<Name locale="hr_HR">SVALKA Čaša za bijelo vino</Name>
<Name locale="ca_ES">SVALKA Copa de vi blanc</Name>
<Name locale="es_ES">SVALKA Copa de vino blanco</Name>
<Name locale="it_IT">SVALKA Bicchiere da vino bianco</Name>
<Name locale="de_DE">SVALKA Weißweinglas</Name>
<Name locale="fr_FR">SVALKA Verre à vin blanc</Name>
<Name locale="en_NL">SVALKA White wine glass</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="ro_RO">SVALKA Pahar vin alb</Name>
<Name locale="en_ES">SVALKA White wine glass</Name>
</Names>
<Description>White wine glass</Description>
<Descriptions>
<Description locale="en_US">White wine glass</Description>
<Description locale="sk_SK">Pohár na biele víno</Description>
<Description locale="hu_HU">Fehérboros pohár</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="cs_CZ">Sklenka na bílé víno</Description>
<Description locale="pt_PT">Copo de vinho branco</Description>
<Description locale="nl_BE">Wittewijnglas</Description>
<Description locale="fr_BE">Verre à vin blanc</Description>
<Description locale="de_AT">Weißweinglas</Description>
<Description locale="nl_NL">Wittewijnglas</Description>
<Description locale="it_CH">Bicchiere da vino bianco</Description>
<Description locale="en_PT">White wine glass</Description>
<Description locale="en_GB">White wine glass</Description>
<Description locale="en_CH">White wine glass</Description>
<Description locale="de_CH">Weißweinglas</Description>
<Description locale="fr_CH">Verre à vin blanc</Description>
<Description locale="fr_CA">Verre à vin blanc</Description>
<Description locale="en_CA">White wine glass</Description>
<Description locale="hr_HR">Čaša za bijelo vino</Description>
<Description locale="ca_ES">Copa de vi blanc</Description>
<Description locale="es_ES">Copa de vino blanco</Description>
<Description locale="it_IT">Bicchiere da vino bianco</Description>
<Description locale="de_DE">Weißweinglas</Description>
<Description locale="fr_FR">Verre à vin blanc</Description>
<Description locale="en_NL">White wine glass</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="ro_RO">Pahar vin alb</Description>
<Description locale="en_ES">White wine glass</Description>
</Descriptions>
<CategoryExternalId>18870</CategoryExternalId>
<ProductPageUrl>https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrls>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/products/00015134/</ProductPageUrl>
</ProductPageUrls>
<ImageUrl>https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrls>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="sk_SK">https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hu_HU">https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="pt_PT">https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_BE">https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_BE">https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_AT">https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_NL">https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_CH">https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_PT">https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_GB">https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CH">https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_CH">https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CH">https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CA">https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CA">https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hr_HR">https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ca_ES">https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="es_ES">https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_IT">https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_DE">https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_FR">https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_NL">https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ro_RO">https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_ES">https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
</ImageUrls>
<Attributes>
<Attribute id="BV_FE_FAMILY">
<Value>P00015134</Value>
</Attribute>
<Attribute id="BV_FE_EXPAND">
<Value>BV_FE_FAMILY:P00015134</Value>
</Attribute>
</Attributes>
</Product>
</Products>
</Feed>
Desired CSV output sample
-----
extractDate,Categories__Category__ExternalId,Categories__Category__Name,Categories__Category__Names__Name__locale,Categories__Category__Names__Name__#Text,Categories__Category__CategoryPageUrl,Categories__Category__CategoryPageUrls__CategoryPageUrl__locale,Categories__Category__CategoryPageUrls__CategoryPageUrl__#Text,Products__Product__ExternalId,Products__Product__Name,Products__Product__Names__Name__locale,Products__Product__Names__Name__#Text,Products__Product__Description,Products__Product__Descriptions__Description__locale,Products__Product__Descriptions__Description__#Text,Products__Product__CategoryExternalId,Products__Product__ProductPageUrl,Products__Product__ProductPageUrls__ProductPageUrl__locale,Products__Product__ProductPageUrls__ProductPageUrl__#Text,Products__Product__ImageUrl,Products__Product__ImageUrls__ImageUrl__locale,Products__Product__ImageUrls__ImageUrl__#Text
2020-01-21T10:34:20.041000,10364,Storage furniture,sk_SK,Úložné systémy ,https://www.ikea.com/se/en/catalog/categories/range/10364/,sk_SK,https://www.ikea.com/sk/sk/catalog/categories/range/10364/,ART-00015134,SVALKA White wine glass,en_US,SVALKA White wine glass,White wine glass,en_US,White wine glass,18870,https://www.ikea.com/us/en/catalog/products/00015134/,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hu_HU,Tárolás ,,hu_HU,https://www.ikea.com/hu/hu/catalog/categories/range/10364/,,,sk_SK,SVALKA Pohár na biele víno,,sk_SK,Pohár na biele víno,,,sk_SK,https://www.ikea.com/sk/sk/catalog/products/00015134/,,sk_SK,https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg
,,,eu_ES,Biltegiratze-altzariak ,,eu_ES,https://www.ikea.com/es/eu/catalog/categories/range/10364/,,,hu_HU,SVALKA Fehérboros pohár,,hu_HU,Fehérboros pohár,,,hu_HU,https://www.ikea.com/hu/hu/catalog/products/00015134/,,hu_HU,https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg
,,,cs_CZ,Úložné systémy ,,cs_CZ,https://www.ikea.com/cz/cs/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,pt_PT,Móveis de arrumação ,,pt_PT,https://www.ikea.com/pt/pt/catalog/categories/range/10364/,,,cs_CZ,SVALKA Sklenka na bílé víno,,cs_CZ,Sklenka na bílé víno,,,cs_CZ,https://www.ikea.com/cz/cs/catalog/products/00015134/,,cs_CZ,https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg
,,,en_AU,Storage furniture ,,en_AU,https://www.ikea.com/au/en/catalog/categories/range/10364/,,,pt_PT,SVALKA Copo de vinho branco,,pt_PT,Copo de vinho branco,,,pt_PT,https://www.ikea.com/pt/pt/catalog/products/00015134/,,pt_PT,https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg
,,,nl_BE,Opbergmeubels ,,nl_BE,https://www.ikea.com/be/nl/catalog/categories/range/10364/,,,nl_BE,SVALKA Wittewijnglas,,nl_BE,Wittewijnglas,,,nl_BE,https://www.ikea.com/be/nl/catalog/products/00015134/,,nl_BE,https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,fr_BE,Rangements bureau et salon ,,fr_BE,https://www.ikea.com/be/fr/catalog/categories/range/10364/,,,fr_BE,SVALKA Verre à vin blanc,,fr_BE,Verre à vin blanc,,,fr_BE,https://www.ikea.com/be/fr/catalog/products/00015134/,,fr_BE,https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,de_AT,Aufbewahrungsmöbel ,,de_AT,https://www.ikea.com/at/de/catalog/categories/range/10364/,,,de_AT,SVALKA Weißweinglas,,de_AT,Weißweinglas,,,de_AT,https://www.ikea.com/at/de/catalog/products/00015134/,,de_AT,https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,nl_NL,Opbergmeubels ,,nl_NL,https://www.ikea.com/nl/nl/catalog/categories/range/10364/,,,nl_NL,SVALKA Wittewijnglas,,nl_NL,Wittewijnglas,,,nl_NL,https://www.ikea.com/nl/nl/catalog/products/00015134/,,nl_NL,https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,en_PT,Storage furniture ,,en_PT,https://www.ikea.com/pt/en/catalog/categories/range/10364/,,,it_CH,SVALKA Bicchiere da vino bianco,,it_CH,Bicchiere da vino bianco,,,it_CH,https://www.ikea.com/ch/it/catalog/products/00015134/,,it_CH,https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,it_CH,Mobili ,,it_CH,https://www.ikea.com/ch/it/catalog/categories/range/10364/,,,en_PT,SVALKA White wine glass,,en_PT,White wine glass,,,en_PT,https://www.ikea.com/pt/en/catalog/products/00015134/,,en_PT,https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_GB,Storage furniture ,,en_GB,https://www.ikea.com/gb/en/catalog/categories/range/10364/,,,en_GB,SVALKA White wine glass,,en_GB,White wine glass,,,en_GB,https://www.ikea.com/gb/en/catalog/products/00015134/,,en_GB,https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_CH,Storage furniture ,,en_CH,https://www.ikea.com/ch/en/catalog/categories/range/10364/,,,en_CH,SVALKA White wine glass,,en_CH,White wine glass,,,en_CH,https://www.ikea.com/ch/en/catalog/products/00015134/,,en_CH,https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_CH,Aufbewahrungsmöbel ,,de_CH,https://www.ikea.com/ch/de/catalog/categories/range/10364/,,,de_CH,SVALKA Weißweinglas,,de_CH,Weißweinglas,,,de_CH,https://www.ikea.com/ch/de/catalog/products/00015134/,,de_CH,https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,fr_CH,Rangements bureau et salon ,,fr_CH,https://www.ikea.com/ch/fr/catalog/categories/range/10364/,,,fr_CH,SVALKA Verre à vin blanc,,fr_CH,Verre à vin blanc,,,fr_CH,https://www.ikea.com/ch/fr/catalog/products/00015134/,,fr_CH,https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,fr_CA,Meubles de rangement ,,fr_CA,https://www.ikea.com/ca/fr/catalog/categories/range/10364/,,,fr_CA,SVALKA Verre à vin blanc,,fr_CA,Verre à vin blanc,,,fr_CA,https://www.ikea.com/ca/fr/catalog/products/00015134/,,fr_CA,https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,en_CA,Storage furniture ,,en_CA,https://www.ikea.com/ca/en/catalog/categories/range/10364/,,,en_CA,SVALKA White wine glass,,en_CA,White wine glass,,,en_CA,https://www.ikea.com/ca/en/catalog/products/00015134/,,en_CA,https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hr_HR,Namještaj za odlaganje ,,hr_HR,https://www.ikea.com/hr/hr/catalog/categories/range/10364/,,,hr_HR,SVALKA Čaša za bijelo vino,,hr_HR,Čaša za bijelo vino,,,hr_HR,https://www.ikea.com/hr/hr/catalog/products/00015134/,,hr_HR,https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg
,,,ja_JP,収納家具 ,,ja_JP,https://www.ikea.com/jp/ja/catalog/categories/range/10364/,,,ca_ES,SVALKA Copa de vi blanc,,ca_ES,Copa de vi blanc,,,ca_ES,https://www.ikea.com/es/ca/catalog/products/00015134/,,ca_ES,https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg
,,,en_KR,Storage furniture ,,en_KR,https://www.ikea.com/kr/en/catalog/categories/range/10364/,,,es_ES,SVALKA Copa de vino blanco,,es_ES,Copa de vino blanco,,,es_ES,https://www.ikea.com/es/es/catalog/products/00015134/,,es_ES,https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg
,,,ko_KR,수납가구 ,,ko_KR,https://www.ikea.com/kr/ko/catalog/categories/range/10364/,,,it_IT,SVALKA Bicchiere da vino bianco,,it_IT,Bicchiere da vino bianco,,,it_IT,https://www.ikea.com/it/it/catalog/products/00015134/,,it_IT,https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,ca_ES,Mobles d'emmagatzematge ,,ca_ES,https://www.ikea.com/es/ca/catalog/categories/range/10364/,,,de_DE,SVALKA Weißweinglas,,de_DE,Weißweinglas,,,de_DE,https://www.ikea.com/de/de/catalog/products/00015134/,,de_DE,https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,es_ES,Mobiliario de almacenaje ,,es_ES,https://www.ikea.com/es/es/catalog/categories/range/10364/,,,fr_FR,SVALKA Verre à vin blanc,,fr_FR,Verre à vin blanc,,,fr_FR,https://www.ikea.com/fr/fr/catalog/products/00015134/,,fr_FR,https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,it_IT,Mobili ,,it_IT,https://www.ikea.com/it/it/catalog/categories/range/10364/,,,en_NL,SVALKA White wine glass,,en_NL,White wine glass,,,en_NL,https://www.ikea.com/nl/en/catalog/products/00015134/,,en_NL,https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_DE,Aufbewahrungsmöbel ,,de_DE,https://www.ikea.com/de/de/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,fr_FR,Rangements bureau et salon ,,fr_FR,https://www.ikea.com/fr/fr/catalog/categories/range/10364/,,,ro_RO,SVALKA Pahar vin alb,,ro_RO,Pahar vin alb,,,ro_RO,https://www.ikea.com/ro/ro/catalog/products/00015134/,,ro_RO,https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg
,,,en_NL,Storage furniture ,,en_NL,https://www.ikea.com/nl/en/catalog/categories/range/10364/,,,en_ES,SVALKA White wine glass,,en_ES,White wine glass,,,en_ES,https://www.ikea.com/es/en/catalog/products/00015134/,,en_ES,https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_US,Storage furniture ,,en_US,https://www.ikea.com/us/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,ro_RO,Mobilier pentru depozitare ,,ro_RO,https://www.ikea.com/ro/ro/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_ES,Storage furniture ,,en_ES,https://www.ikea.com/es/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_JP,Storage furniture ,,en_JP,https://www.ikea.com/jp/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
I have huge XML file of size 500mb which I want to convert to CSV using Python.i tried lot and not able to get proper output . Can some one help me with this?
Sample input xml
-------
<?xml version="1.0" encoding="UTF-8"?>
<Feed xmlns="http://www.bazaarvoice.com/xs/PRR/ProductFeed/5.6" name="ikeaglobal" incremental="false" extractDate="2020-01-21T10:34:20.041000">
<Categories>
<Category>
<ExternalId>10364</ExternalId>
<Name>Storage furniture</Name>
<Names>
<Name locale="sk_SK">Úložné systémy </Name>
<Name locale="hu_HU">Tárolás </Name>
<Name locale="eu_ES">Biltegiratze-altzariak </Name>
<Name locale="cs_CZ">Úložné systémy </Name>
<Name locale="pt_PT">Móveis de arrumação </Name>
<Name locale="en_AU">Storage furniture </Name>
<Name locale="nl_BE">Opbergmeubels </Name>
<Name locale="fr_BE">Rangements bureau et salon </Name>
<Name locale="de_AT">Aufbewahrungsmöbel </Name>
<Name locale="nl_NL">Opbergmeubels </Name>
<Name locale="en_PT">Storage furniture </Name>
<Name locale="it_CH">Mobili </Name>
<Name locale="en_GB">Storage furniture </Name>
<Name locale="en_CH">Storage furniture </Name>
<Name locale="de_CH">Aufbewahrungsmöbel </Name>
<Name locale="fr_CH">Rangements bureau et salon </Name>
<Name locale="fr_CA">Meubles de rangement </Name>
<Name locale="en_CA">Storage furniture </Name>
<Name locale="hr_HR">Namještaj za odlaganje </Name>
<Name locale="ja_JP">収納家具 </Name>
<Name locale="en_KR">Storage furniture </Name>
<Name locale="ko_KR">수납가구 </Name>
<Name locale="ca_ES">Mobles d'emmagatzematge </Name>
<Name locale="es_ES">Mobiliario de almacenaje </Name>
<Name locale="it_IT">Mobili </Name>
<Name locale="de_DE">Aufbewahrungsmöbel </Name>
<Name locale="fr_FR">Rangements bureau et salon </Name>
<Name locale="en_NL">Storage furniture </Name>
<Name locale="en_US">Storage furniture </Name>
<Name locale="ro_RO">Mobilier pentru depozitare </Name>
<Name locale="en_ES">Storage furniture </Name>
<Name locale="en_JP">Storage furniture </Name>
</Names>
<CategoryPageUrl>https://www.ikea.com/se/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrls>
<CategoryPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="eu_ES">https://www.ikea.com/es/eu/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_AU">https://www.ikea.com/au/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ja_JP">https://www.ikea.com/jp/ja/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_KR">https://www.ikea.com/kr/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ko_KR">https://www.ikea.com/kr/ko/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/categories/range/10364/</CategoryPageUrl>
<CategoryPageUrl locale="en_JP">https://www.ikea.com/jp/en/catalog/categories/range/10364/</CategoryPageUrl>
</CategoryPageUrls>
</Category>
</Categories>
<Products>
<Product>
<ExternalId>ART-00015134</ExternalId>
<Name>SVALKA White wine glass</Name>
<Names>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="sk_SK">SVALKA Pohár na biele víno</Name>
<Name locale="hu_HU">SVALKA Fehérboros pohár</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="cs_CZ">SVALKA Sklenka na bílé víno</Name>
<Name locale="pt_PT">SVALKA Copo de vinho branco</Name>
<Name locale="nl_BE">SVALKA Wittewijnglas</Name>
<Name locale="fr_BE">SVALKA Verre à vin blanc</Name>
<Name locale="de_AT">SVALKA Weißweinglas</Name>
<Name locale="nl_NL">SVALKA Wittewijnglas</Name>
<Name locale="it_CH">SVALKA Bicchiere da vino bianco</Name>
<Name locale="en_PT">SVALKA White wine glass</Name>
<Name locale="en_GB">SVALKA White wine glass</Name>
<Name locale="en_CH">SVALKA White wine glass</Name>
<Name locale="de_CH">SVALKA Weißweinglas</Name>
<Name locale="fr_CH">SVALKA Verre à vin blanc</Name>
<Name locale="fr_CA">SVALKA Verre à vin blanc</Name>
<Name locale="en_CA">SVALKA White wine glass</Name>
<Name locale="hr_HR">SVALKA Čaša za bijelo vino</Name>
<Name locale="ca_ES">SVALKA Copa de vi blanc</Name>
<Name locale="es_ES">SVALKA Copa de vino blanco</Name>
<Name locale="it_IT">SVALKA Bicchiere da vino bianco</Name>
<Name locale="de_DE">SVALKA Weißweinglas</Name>
<Name locale="fr_FR">SVALKA Verre à vin blanc</Name>
<Name locale="en_NL">SVALKA White wine glass</Name>
<Name locale="en_US">SVALKA White wine glass</Name>
<Name locale="ro_RO">SVALKA Pahar vin alb</Name>
<Name locale="en_ES">SVALKA White wine glass</Name>
</Names>
<Description>White wine glass</Description>
<Descriptions>
<Description locale="en_US">White wine glass</Description>
<Description locale="sk_SK">Pohár na biele víno</Description>
<Description locale="hu_HU">Fehérboros pohár</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="cs_CZ">Sklenka na bílé víno</Description>
<Description locale="pt_PT">Copo de vinho branco</Description>
<Description locale="nl_BE">Wittewijnglas</Description>
<Description locale="fr_BE">Verre à vin blanc</Description>
<Description locale="de_AT">Weißweinglas</Description>
<Description locale="nl_NL">Wittewijnglas</Description>
<Description locale="it_CH">Bicchiere da vino bianco</Description>
<Description locale="en_PT">White wine glass</Description>
<Description locale="en_GB">White wine glass</Description>
<Description locale="en_CH">White wine glass</Description>
<Description locale="de_CH">Weißweinglas</Description>
<Description locale="fr_CH">Verre à vin blanc</Description>
<Description locale="fr_CA">Verre à vin blanc</Description>
<Description locale="en_CA">White wine glass</Description>
<Description locale="hr_HR">Čaša za bijelo vino</Description>
<Description locale="ca_ES">Copa de vi blanc</Description>
<Description locale="es_ES">Copa de vino blanco</Description>
<Description locale="it_IT">Bicchiere da vino bianco</Description>
<Description locale="de_DE">Weißweinglas</Description>
<Description locale="fr_FR">Verre à vin blanc</Description>
<Description locale="en_NL">White wine glass</Description>
<Description locale="en_US">White wine glass</Description>
<Description locale="ro_RO">Pahar vin alb</Description>
<Description locale="en_ES">White wine glass</Description>
</Descriptions>
<CategoryExternalId>18870</CategoryExternalId>
<ProductPageUrl>https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrls>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="sk_SK">https://www.ikea.com/sk/sk/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hu_HU">https://www.ikea.com/hu/hu/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="pt_PT">https://www.ikea.com/pt/pt/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_BE">https://www.ikea.com/be/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_BE">https://www.ikea.com/be/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_AT">https://www.ikea.com/at/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="nl_NL">https://www.ikea.com/nl/nl/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_CH">https://www.ikea.com/ch/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_PT">https://www.ikea.com/pt/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_GB">https://www.ikea.com/gb/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CH">https://www.ikea.com/ch/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_CH">https://www.ikea.com/ch/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CH">https://www.ikea.com/ch/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_CA">https://www.ikea.com/ca/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_CA">https://www.ikea.com/ca/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="hr_HR">https://www.ikea.com/hr/hr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ca_ES">https://www.ikea.com/es/ca/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="es_ES">https://www.ikea.com/es/es/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="it_IT">https://www.ikea.com/it/it/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="de_DE">https://www.ikea.com/de/de/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="fr_FR">https://www.ikea.com/fr/fr/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_NL">https://www.ikea.com/nl/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_US">https://www.ikea.com/us/en/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="ro_RO">https://www.ikea.com/ro/ro/catalog/products/00015134/</ProductPageUrl>
<ProductPageUrl locale="en_ES">https://www.ikea.com/es/en/catalog/products/00015134/</ProductPageUrl>
</ProductPageUrls>
<ImageUrl>https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrls>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="sk_SK">https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hu_HU">https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="cs_CZ">https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="pt_PT">https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_BE">https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_BE">https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_AT">https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="nl_NL">https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_CH">https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_PT">https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_GB">https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CH">https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_CH">https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CH">https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_CA">https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_CA">https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="hr_HR">https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ca_ES">https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="es_ES">https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="it_IT">https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="de_DE">https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="fr_FR">https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_NL">https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_US">https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="ro_RO">https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg</ImageUrl>
<ImageUrl locale="en_ES">https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg</ImageUrl>
</ImageUrls>
<Attributes>
<Attribute id="BV_FE_FAMILY">
<Value>P00015134</Value>
</Attribute>
<Attribute id="BV_FE_EXPAND">
<Value>BV_FE_FAMILY:P00015134</Value>
</Attribute>
</Attributes>
</Product>
</Products>
</Feed>
Desired CSV output sample
-----
extractDate,Categories__Category__ExternalId,Categories__Category__Name,Categories__Category__Names__Name__locale,Categories__Category__Names__Name__#Text,Categories__Category__CategoryPageUrl,Categories__Category__CategoryPageUrls__CategoryPageUrl__locale,Categories__Category__CategoryPageUrls__CategoryPageUrl__#Text,Products__Product__ExternalId,Products__Product__Name,Products__Product__Names__Name__locale,Products__Product__Names__Name__#Text,Products__Product__Description,Products__Product__Descriptions__Description__locale,Products__Product__Descriptions__Description__#Text,Products__Product__CategoryExternalId,Products__Product__ProductPageUrl,Products__Product__ProductPageUrls__ProductPageUrl__locale,Products__Product__ProductPageUrls__ProductPageUrl__#Text,Products__Product__ImageUrl,Products__Product__ImageUrls__ImageUrl__locale,Products__Product__ImageUrls__ImageUrl__#Text
2020-01-21T10:34:20.041000,10364,Storage furniture,sk_SK,Úložné systémy ,https://www.ikea.com/se/en/catalog/categories/range/10364/,sk_SK,https://www.ikea.com/sk/sk/catalog/categories/range/10364/,ART-00015134,SVALKA White wine glass,en_US,SVALKA White wine glass,White wine glass,en_US,White wine glass,18870,https://www.ikea.com/us/en/catalog/products/00015134/,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hu_HU,Tárolás ,,hu_HU,https://www.ikea.com/hu/hu/catalog/categories/range/10364/,,,sk_SK,SVALKA Pohár na biele víno,,sk_SK,Pohár na biele víno,,,sk_SK,https://www.ikea.com/sk/sk/catalog/products/00015134/,,sk_SK,https://www.ikea.com/sk/sk/images/products/svalka-pohar-na-biele-vino__27885_PE097378_S4.jpg
,,,eu_ES,Biltegiratze-altzariak ,,eu_ES,https://www.ikea.com/es/eu/catalog/categories/range/10364/,,,hu_HU,SVALKA Fehérboros pohár,,hu_HU,Fehérboros pohár,,,hu_HU,https://www.ikea.com/hu/hu/catalog/products/00015134/,,hu_HU,https://www.ikea.com/hu/hu/images/products/svalka-feherboros-pohar__27885_PE097378_S4.jpg
,,,cs_CZ,Úložné systémy ,,cs_CZ,https://www.ikea.com/cz/cs/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,pt_PT,Móveis de arrumação ,,pt_PT,https://www.ikea.com/pt/pt/catalog/categories/range/10364/,,,cs_CZ,SVALKA Sklenka na bílé víno,,cs_CZ,Sklenka na bílé víno,,,cs_CZ,https://www.ikea.com/cz/cs/catalog/products/00015134/,,cs_CZ,https://www.ikea.com/cz/cs/images/products/svalka-sklenka-na-bile-vino__27885_PE097378_S4.jpg
,,,en_AU,Storage furniture ,,en_AU,https://www.ikea.com/au/en/catalog/categories/range/10364/,,,pt_PT,SVALKA Copo de vinho branco,,pt_PT,Copo de vinho branco,,,pt_PT,https://www.ikea.com/pt/pt/catalog/products/00015134/,,pt_PT,https://www.ikea.com/pt/pt/images/products/svalka-copo-de-vinho-branco__27885_PE097378_S4.jpg
,,,nl_BE,Opbergmeubels ,,nl_BE,https://www.ikea.com/be/nl/catalog/categories/range/10364/,,,nl_BE,SVALKA Wittewijnglas,,nl_BE,Wittewijnglas,,,nl_BE,https://www.ikea.com/be/nl/catalog/products/00015134/,,nl_BE,https://www.ikea.com/be/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,fr_BE,Rangements bureau et salon ,,fr_BE,https://www.ikea.com/be/fr/catalog/categories/range/10364/,,,fr_BE,SVALKA Verre à vin blanc,,fr_BE,Verre à vin blanc,,,fr_BE,https://www.ikea.com/be/fr/catalog/products/00015134/,,fr_BE,https://www.ikea.com/be/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,de_AT,Aufbewahrungsmöbel ,,de_AT,https://www.ikea.com/at/de/catalog/categories/range/10364/,,,de_AT,SVALKA Weißweinglas,,de_AT,Weißweinglas,,,de_AT,https://www.ikea.com/at/de/catalog/products/00015134/,,de_AT,https://www.ikea.com/at/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,nl_NL,Opbergmeubels ,,nl_NL,https://www.ikea.com/nl/nl/catalog/categories/range/10364/,,,nl_NL,SVALKA Wittewijnglas,,nl_NL,Wittewijnglas,,,nl_NL,https://www.ikea.com/nl/nl/catalog/products/00015134/,,nl_NL,https://www.ikea.com/nl/nl/images/products/svalka-wittewijnglas__27885_PE097378_S4.jpg
,,,en_PT,Storage furniture ,,en_PT,https://www.ikea.com/pt/en/catalog/categories/range/10364/,,,it_CH,SVALKA Bicchiere da vino bianco,,it_CH,Bicchiere da vino bianco,,,it_CH,https://www.ikea.com/ch/it/catalog/products/00015134/,,it_CH,https://www.ikea.com/ch/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,it_CH,Mobili ,,it_CH,https://www.ikea.com/ch/it/catalog/categories/range/10364/,,,en_PT,SVALKA White wine glass,,en_PT,White wine glass,,,en_PT,https://www.ikea.com/pt/en/catalog/products/00015134/,,en_PT,https://www.ikea.com/pt/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_GB,Storage furniture ,,en_GB,https://www.ikea.com/gb/en/catalog/categories/range/10364/,,,en_GB,SVALKA White wine glass,,en_GB,White wine glass,,,en_GB,https://www.ikea.com/gb/en/catalog/products/00015134/,,en_GB,https://www.ikea.com/gb/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_CH,Storage furniture ,,en_CH,https://www.ikea.com/ch/en/catalog/categories/range/10364/,,,en_CH,SVALKA White wine glass,,en_CH,White wine glass,,,en_CH,https://www.ikea.com/ch/en/catalog/products/00015134/,,en_CH,https://www.ikea.com/ch/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_CH,Aufbewahrungsmöbel ,,de_CH,https://www.ikea.com/ch/de/catalog/categories/range/10364/,,,de_CH,SVALKA Weißweinglas,,de_CH,Weißweinglas,,,de_CH,https://www.ikea.com/ch/de/catalog/products/00015134/,,de_CH,https://www.ikea.com/ch/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,fr_CH,Rangements bureau et salon ,,fr_CH,https://www.ikea.com/ch/fr/catalog/categories/range/10364/,,,fr_CH,SVALKA Verre à vin blanc,,fr_CH,Verre à vin blanc,,,fr_CH,https://www.ikea.com/ch/fr/catalog/products/00015134/,,fr_CH,https://www.ikea.com/ch/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,fr_CA,Meubles de rangement ,,fr_CA,https://www.ikea.com/ca/fr/catalog/categories/range/10364/,,,fr_CA,SVALKA Verre à vin blanc,,fr_CA,Verre à vin blanc,,,fr_CA,https://www.ikea.com/ca/fr/catalog/products/00015134/,,fr_CA,https://www.ikea.com/ca/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,en_CA,Storage furniture ,,en_CA,https://www.ikea.com/ca/en/catalog/categories/range/10364/,,,en_CA,SVALKA White wine glass,,en_CA,White wine glass,,,en_CA,https://www.ikea.com/ca/en/catalog/products/00015134/,,en_CA,https://www.ikea.com/ca/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,hr_HR,Namještaj za odlaganje ,,hr_HR,https://www.ikea.com/hr/hr/catalog/categories/range/10364/,,,hr_HR,SVALKA Čaša za bijelo vino,,hr_HR,Čaša za bijelo vino,,,hr_HR,https://www.ikea.com/hr/hr/catalog/products/00015134/,,hr_HR,https://www.ikea.com/hr/hr/images/products/svalka-casa-za-bijelo-vino__27885_PE097378_S4.jpg
,,,ja_JP,収納家具 ,,ja_JP,https://www.ikea.com/jp/ja/catalog/categories/range/10364/,,,ca_ES,SVALKA Copa de vi blanc,,ca_ES,Copa de vi blanc,,,ca_ES,https://www.ikea.com/es/ca/catalog/products/00015134/,,ca_ES,https://www.ikea.com/es/ca/images/products/svalka-copa-de-vi-blanc__27885_PE097378_S4.jpg
,,,en_KR,Storage furniture ,,en_KR,https://www.ikea.com/kr/en/catalog/categories/range/10364/,,,es_ES,SVALKA Copa de vino blanco,,es_ES,Copa de vino blanco,,,es_ES,https://www.ikea.com/es/es/catalog/products/00015134/,,es_ES,https://www.ikea.com/es/es/images/products/svalka-copa-de-vino-blanco__27885_PE097378_S4.jpg
,,,ko_KR,수납가구 ,,ko_KR,https://www.ikea.com/kr/ko/catalog/categories/range/10364/,,,it_IT,SVALKA Bicchiere da vino bianco,,it_IT,Bicchiere da vino bianco,,,it_IT,https://www.ikea.com/it/it/catalog/products/00015134/,,it_IT,https://www.ikea.com/it/it/images/products/svalka-bicchiere-da-vino-bianco__27885_PE097378_S4.jpg
,,,ca_ES,Mobles d'emmagatzematge ,,ca_ES,https://www.ikea.com/es/ca/catalog/categories/range/10364/,,,de_DE,SVALKA Weißweinglas,,de_DE,Weißweinglas,,,de_DE,https://www.ikea.com/de/de/catalog/products/00015134/,,de_DE,https://www.ikea.com/de/de/images/products/svalka-wei-weinglas__27885_PE097378_S4.jpg
,,,es_ES,Mobiliario de almacenaje ,,es_ES,https://www.ikea.com/es/es/catalog/categories/range/10364/,,,fr_FR,SVALKA Verre à vin blanc,,fr_FR,Verre à vin blanc,,,fr_FR,https://www.ikea.com/fr/fr/catalog/products/00015134/,,fr_FR,https://www.ikea.com/fr/fr/images/products/svalka-verre-a-vin-blanc__27885_PE097378_S4.jpg
,,,it_IT,Mobili ,,it_IT,https://www.ikea.com/it/it/catalog/categories/range/10364/,,,en_NL,SVALKA White wine glass,,en_NL,White wine glass,,,en_NL,https://www.ikea.com/nl/en/catalog/products/00015134/,,en_NL,https://www.ikea.com/nl/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,de_DE,Aufbewahrungsmöbel ,,de_DE,https://www.ikea.com/de/de/catalog/categories/range/10364/,,,en_US,SVALKA White wine glass,,en_US,White wine glass,,,en_US,https://www.ikea.com/us/en/catalog/products/00015134/,,en_US,https://www.ikea.com/us/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,fr_FR,Rangements bureau et salon ,,fr_FR,https://www.ikea.com/fr/fr/catalog/categories/range/10364/,,,ro_RO,SVALKA Pahar vin alb,,ro_RO,Pahar vin alb,,,ro_RO,https://www.ikea.com/ro/ro/catalog/products/00015134/,,ro_RO,https://www.ikea.com/ro/ro/images/products/svalka-pahar-vin-alb__27885_PE097378_S4.jpg
,,,en_NL,Storage furniture ,,en_NL,https://www.ikea.com/nl/en/catalog/categories/range/10364/,,,en_ES,SVALKA White wine glass,,en_ES,White wine glass,,,en_ES,https://www.ikea.com/es/en/catalog/products/00015134/,,en_ES,https://www.ikea.com/es/en/images/products/svalka-white-wine-glass__27885_PE097378_S4.jpg
,,,en_US,Storage furniture ,,en_US,https://www.ikea.com/us/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,ro_RO,Mobilier pentru depozitare ,,ro_RO,https://www.ikea.com/ro/ro/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_ES,Storage furniture ,,en_ES,https://www.ikea.com/es/en/catalog/categories/range/10364/,,,,,,,,,,,,,,
,,,en_JP,Storage furniture ,,en_JP,https://www.ikea.com/jp/en/catalog/categories/range/10364/,,,,,,,,,,,,,,