|
|
Rank: Newbie
Joined: 7/19/2015
Posts: 1
|
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.
|
|
Rank: Member
Joined: 8/21/2019
Posts: 10
Location: United Kingdom
|
Did you ever find a solution for this?? I'm attempting to do something very similar.
Much smaller files work perfectly fine, and it's fast... But as soon as you start matching 100's / 1000's of records, then we're talking 45 minutes to 1-2 hours.... I don't understand why?
|
|
Rank: Advanced Member
Joined: 6/16/2006
Posts: 486
Location: AT
|
The best solution for such mappings is to put your lookup tables into a database (even SQLite will do) and use the SQL-WHERE component in the mapping to find the matching record(s).
|
|
|
guest |
