Skip to main content

Hi all,

I’m still quite new to timextender so I appreciate all the help you guys give me.

I have quite alot of different XML files containing alot of data. It’s product catalogs with porentially 40K products that contains different kind of parameters .. each product’s parameters varies from product to product .. som tell you the country of origin, som dont .. on some of the products there is information about delivery dates some and on some there aren’t.

So all-in-all the different products and the different files varies a quite alot. 

The content of these files can change each day and some multiple times each day .. I would think that we all in all are talking about 600.000 different products.

How would you approach this ?

Is it possible for timextender to handle this or do I have to make some kind of XML-parser ?

I guess I’m going to make a unique key there is based on the products no. and another parameter, but would you predefine the different parameters as a Field so I have to add a new field when there is a new parameter in the XML files, or are smarter and more dynmaic way to do this ?

 

Hi,

product catalogue implementations tend to follow the EAV-like models which is not very conducive to reporting scenarios. You will need to decide what kind of model to apply and can then use this feature to decompose the data: 

I think you will need to do some XML SQL to map all your input into Entity, Attribute, Value tuples.

If your XML structures have little overlap, you will have few dimensional attributes to filter on. Similar to how an online store will not have filters for “number of toggle switches” across all their products.

Reply


Terms and ConditionsCookie settings