Skip to Content
author's profile photo Former Member
Former Member

Loading Heirarchies from Flat Files

Hi Guys,

I have a really simple question. I want to load a heirarchy from a flat file and I have 2 questions.

Before the questions this is the structure of the hierarchy.

Node1 Node2 Node3 (level 1)

Node1A Node2A Node3A (Level 2)

Leaf1 leaf4 leaf7

Leaf2 leaf5 leaf8 (level 3)

leaf3 leaf6 leaf9

Level 1 & 2 are just Texts e.g.,Nothern Region

Level 3 are the actual values e.g, Ontario

level 3 values should be able to be sumarised in Level 1 and 2.

Now my question is.

What selections should I make when creating the Object?

What will be structure of the flat file?

There is no time dependency!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2005 at 02:31 PM


    In the foolowing link,the structure of flat file is clearly mentioned .

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2005 at 02:55 PM

    Hi Anil,

    I have looked at that before. It does not tell me what I want know. Probably because I don't know, I am not interpreting it correctly.

    Based on the example I have above. The leaves for my hierarchy are up to 8000 values. How do I structure the nodes and the leaves in a flat file.

    Can someone give me an example pls.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi!

      you use the 0HIER_NODE -for infoobject of Text nodes that is level 1& 2 nodes

      any infoobject (ex.0region) for the leaf nodes.

      your flatfile might look like this if i asume your leaf nodes as 0region.

      Node ID;InfoObject name;Node name;Catalog ID;Parent node;First subnode;Next adjacent node;Language key;Description - short;Description - medium;Description- long;0Region
      7;0region;;;4;;;;;;;Leaf 1
      8;0region;;;4;;;;;;;Leaf 2
      9;0region;;;4;;;;;;;Leaf 3
      10;0region;;;5;;;;;;;Leaf 4
      11;0region;;;5;;;;;;;Leaf 5
      12;0region;;;5;;;;;;;Leaf 6
      13;0region;;;6;;;;;;;Leaf 7
      14;0region;;;6;;;;;;;Leaf 8
      15;0region;;;6;;;;;;;Leaf 9

      it might be a bit different for your compleate data model but i just gave a sample...

      hope it helps.

      with regards


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.