Help / Advice needed to extract Hierarchical Data
Posted: Thu Feb 28, 2013 4:30 pm
I bought this software a few days ago as I want to extract products details from our site. The products are in various categories and sub-categories. These are of varying tree depth, between 2 & 5 deep.
So really I want to know how to start at the top of the category structure and recursive down the sub- categories extracting the category information along the way. Then when a defined “kind” is empty, signifying the final category, run an extract product sub-process.
Also I do not know how to store the category information. I would like the database structure to allow me to easily re-create the category hierarchy.
Should all the category information be stored in the same table?
Again I don’t know how to do this and preserve the hierarchy. Help Please!
On the bright side, I have successfully created extractions for individual categories and the products within them
I’m guessing that this must be quite a common task so hopefully someone will know how to do this.
Thanks
So really I want to know how to start at the top of the category structure and recursive down the sub- categories extracting the category information along the way. Then when a defined “kind” is empty, signifying the final category, run an extract product sub-process.
Also I do not know how to store the category information. I would like the database structure to allow me to easily re-create the category hierarchy.
Should all the category information be stored in the same table?
Again I don’t know how to do this and preserve the hierarchy. Help Please!
On the bright side, I have successfully created extractions for individual categories and the products within them
I’m guessing that this must be quite a common task so hopefully someone will know how to do this.
Thanks