TreeMover File Formats

As delivered, TreeMover uses seven different file layouts. All the data for an exported tree is contained in a single file. Prior to a change in the file layout used for the export file, TreeMover writes a header record to the file to indicate what the next file layout is. The following table lists the standard file formats, along with their actual file layout name and the text of the header record that precedes a given layout data.

File Layout Description Header Record Text

TREE_VERSION

Contains the PeopleTools release number used to create the export data file. If a tree version is not provided, then the TreeMover import program assumes that the tree data is from a database before 8.1.

999TREE_VERSION

TREE_STRUCTURE

Used for data from the PSTREESTRCT table.

999TREE_STRCT

TREE_DEFN

Used for data from the PSTREEDEFN table.

999TREE_DEFN

TREE_USERLEVEL

Used for data from PS_TREE_LEVEL_TBL.

999TREE_USERLVL

TREE_LEVEL

Used for data from the PSTREELEVEL table.

999TREE_LEVEL

TREE_USERNODE

Used for data from PS_TREE_NODE_TBL.

999TREE_USERND

TREE_NODE

Used for data from the PSTREENODE and PSTREELEAF tables.

999TREE_NODE

The TreeMover export program processes the data in the order listed in the preceding table.

If you write your own export file, then you must adhere to the following rules:

  • The Tree Structure record, if present, must always come first in the file.

    If it is not present, the TreeMover import program defaults to the record layouts used prior to release 8.1.

  • The Tree Definition record, if present, must come after the Tree Structure record.

  • The Tree Level records—only for trees with levels—must come before the Tree Node and Leaf records.

  • The Tree Node and Leaf records are required for any export file.

  • Prior to the change in the record layout, you must precede the next data record with the appropriate header record for that file format.

The TreeMover file formats and contents are:

  • 999TREE_VERSION

    Tree Version Data

  • 999TREE_STRCT

    Tree Structure Data

  • 999TREE_DEFN

    Tree Definition Data

  • 999TREE_USERLVL

    Tree Level Data 1

    Tree Level Data 2

  • Tree Level Data N

  • 999TREE_LEVEL

    Tree Level 1

    Tree Level 2

  • Tree Level N

  • 999TREE_USERND

    Tree Node Data 1

    Tree Node Data 2

  • Tree Node Data N

  • 999TREE_NODE

    Tree Node 1

    Tree Node 2

  • Tree Detail 1

  • Tree Detail 2

  • Tree Node 3

  • Tree Node 4

  • Tree Node N

  • Tree Detail 5

  • Tree Detail N

This is an example of TreeMover.

Example of TreeMover