2 Replies Latest reply on Jul 12, 2018 10:50 PM by DeanF

    PI Builder - Heirarchy Element Import

    DeanF

      Hello,

       

      I'm attempting to Publish in PI Builder to AF a hierarchy structure of elements, here is a small sample of the list:

       

      Element

       

      PARENT

       

      DESCRIPTION

       

      AVI00

       

      AVI

       

      UNIT SPARES

       

      AVI00/B

       

      AVI00

       

      ELECTRICAL OUTPUT AND DISTRIBUTION PLANT

       

      AVI00/BA

       

      AVI00/B

       

      UNIT POWER TRANSMISSION SYSTEMS

       

      AVI00/BAT

       

      AVI00/BA

       

      AVI00 TSp UNIT SPARE-61.11MVA

       

      AVI00/BAT10

       

      AVI00/BAT

       

      3 PHASE UNIT COMMON EQUIPMENT

       

      AVI00/BAT10/AA

       

      AVI00/BAT10

       

      VALVES

       

      AVI00/BAT10/AC

       

      AVI00/BAT10

       

      COOLERS

       

      AVI00/BAT10/AC010

       

      AVI00/BAT10/AC

       

      OIL COOLER 1

       

      AVI00/BAT10/AC020

       

      AVI00/BAT10/AC

       

      OIL COOLER 2

       

      AVI00/BAT10/AP

       

      AVI00/BAT10

       

      PUMP SET

       

      AVI00/BAT10/AP010

       

      AVI00/BAT10/AP

       

      OIL PUMPSET 1

       

      AVI00/BAT10/AP010/-M01

       

      AVI00/BAT10/AP010

       

      OIL PUMP 1 MOTOR

       

      AVI00/BAT10/AP010/KP01

       

      AVI00/BAT10/AP010

       

      OIL PUMP 1 PUMP

       

      AVI00/BAT10/AP020

       

      AVI00/BAT10/AP

       

      OIL PUMPSET 2

       

      AVI00/BAT10/AP020/-M01

       

      AVI00/BAT10/AP020

       

      OIL PUMP 2 MOTOR

       

      AVI00/BAT10/AP020/KP01

       

      AVI00/BAT10/AP020

       

      OIL PUMP 2 PUMP

       

      AVI00/BAT10/AP030

       

      AVI00/BAT10/AP

       

      PUMP CONTROLS

       

      AVI00/BAT10/AP030/-H01

       

      AVI00/BAT10/AP030

       

      OIL PUMP 2 TRIPPED INDICATION

       

      AVI00/BAT10/AP030/-H02

       

      AVI00/BAT10/AP030

       

      OIL PUMP 1 TRIPPED INDICATION

       

      AVI00/BAT10/AP030/-H03

       

      AVI00/BAT10/AP030

       

      OIL PUMPS 1 AND 2 EMERGENCY STOP PUSHBUTTON INDICATION

       

      AVI00/BAT10/AP030/-S01

       

      AVI00/BAT10/AP030

       

      OIL PUMP 1 AND 2 DUTY SELECCTOR SWITCH (CENTRE RETURN)

       

      AVI00/BAT10/BB

       

      AVI00/BAT10

       

      TANKS

       

       

      I have AVI as an element already in AF but if I try to Publish the below, I get the invalid Parent error for each line from AVI00/B since I believe the Parent path requires the full path to the top parent.

      i.e the Parent for AVI00/BAT10 needs to be AVI\AVI00\AVI00/B\AVI00/BA\AVI00/BAT

       

      Selected(x)

       

       

      Parent

       

       

      Name

       

       

      ObjectType

       

       

      NewParent

       

       

      Description

       

       

      ReferenceType

       

       

      x

       

      AVI

       

      AVI00

       

      Element

       

       

      UNIT SPARES

       

      Parent-Child

       

      x

       

      AVI00

       

      AVI00/B

       

      Element

       

       

      ELECTRICAL OUTPUT AND DISTRIBUTION PLANT

       

      Parent-Child

       

      x

       

      AVI00/B

       

      AVI00/BA

       

      Element

       

       

      UNIT POWER TRANSMISSION SYSTEMS

       

      Parent-Child

       

      x

       

      AVI00/BA

       

      AVI00/BAT

       

      Element

       

       

      AVI00 TSp UNIT SPARE-61.11MVA

       

      Parent-Child

       

      x

       

      AVI00/BAT

       

      AVI00/BAT10

       

      Element

       

       

      3 PHASE UNIT COMMON EQUIPMENT

       

      Parent-Child

       

      x

       

      AVI00/BAT10

       

      AVI00/BAT10/AA

       

      Element

       

       

      VALVES

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AA

       

      AVI00/BAT10/AC

       

      Element

       

       

      COOLERS

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AC

       

      AVI00/BAT10/AC010

       

      Element

       

       

      OIL COOLER 1

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AC010

       

      AVI00/BAT10/AC020

       

      Element

       

       

      OIL COOLER 2

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AC020

       

      AVI00/BAT10/AP

       

      Element

       

       

      PUMP SET

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP

       

      AVI00/BAT10/AP010

       

      Element

       

       

      OIL PUMPSET 1

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP010

       

      AVI00/BAT10/AP010/-M01

       

      Element

       

       

      OIL PUMP 1 MOTOR

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP010/-M01

       

      AVI00/BAT10/AP010/KP01

       

      Element

       

       

      OIL PUMP 1 PUMP

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP010/KP01

       

      AVI00/BAT10/AP020

       

      Element

       

       

      OIL PUMPSET 2

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP020

       

      AVI00/BAT10/AP020/-M01

       

      Element

       

       

      OIL PUMP 2 MOTOR

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP020/-M01

       

      AVI00/BAT10/AP020/KP01

       

      Element

       

       

      OIL PUMP 2 PUMP

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP020/KP01

       

      AVI00/BAT10/AP030

       

      Element

       

       

      PUMP CONTROLS

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP030

       

      AVI00/BAT10/AP030/-H01

       

      Element

       

       

      OIL PUMP 2 TRIPPED INDICATION

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP030/-H01

       

      AVI00/BAT10/AP030/-H02

       

      Element

       

       

      OIL PUMP 1 TRIPPED INDICATION

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP030/-H02

       

      AVI00/BAT10/AP030/-H03

       

      Element

       

       

      OIL PUMPS 1 AND 2 EMERGENCY STOP PUSHBUTTON INDICATION

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP030/-H03

       

      AVI00/BAT10/AP030/-S01

       

      Element

       

       

      OIL PUMP 1 AND 2 DUTY SELECCTOR SWITCH (CENTRE RETURN)

       

      Parent-Child

       

      x

       

      AVI00/BAT10/AP030/-S01

       

      AVI00/BAT10/BB

       

      Element

       

       

      TANKS

       

      Parent-Child

       

       

       

      Can this be worked around so you are only required to stipulate the Parent name for each Element on each line in the Parent field rather than the full hierarchy path to the Parent?

       

      Cheers

       

      Dean

        • Re: PI Builder - Heirarchy Element Import
          jshaver

          Hi Dean,

          Unfortunately, each row in PI Builder is basically processed individually, although sometimes they are collected so operations can be done in bulk for better performance.  It isn't currently possible to incrementally build up paths to a parent from 1 row to another.  You either need to include the full path information to the each parent in the parent cell, or part of it and have the rest of the path information in the name cell.

          Sorry if this isn't the current answer for which you're looking, but I hope this helps.

          Jeff

            • Re: PI Builder - Heirarchy Element Import
              DeanF

              Thanks for clarifying Jeff.

               

              FYI. I attempted to add some formulas in Excel to try to get the full path by adding the parent and location field together and found I needed to append =Cell&"\"& to every new row but it didn't quite work when the next row had the same parent, it referenced the wrong cell when copied down, so this approach required too much manual processing.

               

              I guess the best solution to this is just to import all the location data and then drag and drop each Element under its parent to get the required hierarchy structure.