| babyhuys |
| Newbie |
|
|
|
|
| None Specified |
|
| Sunday, July 19, 2015 |
| Sunday, July 19, 2015 2:37:21 PM |
1
[0.01% of all post / 0.00 posts per day] |
|
I am currently converting an XML master feed with about 6.000 products to an excel file to be imported in to a new website.
Inside the Infozuilfeed.xml there are two elements of importance:
- Products -> Product -> Attribute ID & Value. The attribute ID is the ID for e.g. Brand,colour,EAN etc. The value is Blue,White,Red etc (both are numeric)
- Outside the Products parent there is another value supplied in the XML file: Attributes -> Attribute ID and Value. The attribute ID from the Product child matches the ID and the Name of the ID is then Colour,EAN etc. Based on an Equal filter both ID's are being matched and if equal the Name (brand,colour) is being used as an output.
The goal is to use the value from the ID name in the matching columns name to the excel file. Every ID name has it's own column, this is because not every product is using the same Attributes ID name and values. This results in rather a large excel file.
KenmerkV3 custom function is used to compare all the possible ID names to see if they match the one being supplied within the child product.
The result will output either null or the value. I added a CSV with all the 260+ names to compare them with another Equal custom function based on filters.
EqualFilter
The above rather messy solution works perfectly and the output is matching what i am looking for.
The downside right now is that processing a trimmed master XML feed is still taking 2 hours to generate for only 100 products.
Is there a smarter way to compare the different values from a child element and then output it to the matching output column name within an excel file?
Any advise or suggestions are highly appreciated.
|
|
