Converter from .xml to .xlsx

Data Parsing, Data Processing — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original You need a converter from .xml to .xlsx to put the .xml file structure in the .xlsx line.For example there are: 70*70 Brend Satin by 34029 HTTPS://abc.ua/komplekt-navolochek by UAH of 89 1 390 310,000 HTTPS:/abc.ua/image/.jpeg HTTPS://abc.ua/image1/.jpeg Brend by 34029 by Satan The Black Set of wheels: 70x70 cm - 2 pieces 100% cotton, satin 70*70 cm Ordinary with plant printing In .xlsx you need to create a headline with the names of all tags, one tag=one column (offer id, name, model, url, currencyId, quantity_in_stock, price, price_opt, picture, picture, vendor, vendorCode, description, Material, Color, Additional characteristics, Material characteristics, Size, Type, Decoration) and place there the values of these tags.The main points: 1 .The structure in the feed is not the same, somewhere can be one picture, somewhere five, param name can be two in one offer, and may be seven.Additionally, the param name is not the same, somewhere it may be "Type", and somewhere "Weight" and "Type" is absent at all.Therefore, if the first line we have is offer with a seven picture, and the second line offer with two picture, then in the second line only the values for two picture are filled, and five columns remain empty.Whatever in the second line does not present the value from the vendor in the column that for the first line is responsible for the third picture.It is necessary that each matching parameter in different offer id appears in one column, not for example, in one offer id will be the "Color" parameter in the column C1 and in the other that same parameter will be in the column E1 because in the first offer id there were two images, and in the other offer id there were 4 images and went the shift by the columns to the right.2ndDifferent feeds may have different tags names, for example, VendorCode can be vendor code, art, etc.That is, setting a universal name will not come out immediately.Additionally, somewhere offer can be enrolled in offers and somewhere it will already be item enrolled in items etc.and d.ThreeFeed can be both a file and a link.Per the curve has explained something, ask the clarificing questions.

Proposals 6