KB‎ > ‎

Excel Import Properties - Drill-Down Behaviour Corrupted

Ref: 2614785 (201204041637)
Last Edited: April 4th, 2012
 
 
Description:
When properties are imported from Excel for an Activity that is configured to drill down to a child Node, the drill-down behaviour is switched to link to document. The parent-child relationship between the Activity and the Node is lost.
 
To reproduce:
1. Create a map:
Node - Node 1
Activity - Activity 1
Deliverables - Deliverable 1, Deliverable 2
Connect:
Deliverable 1 -> Activity 1 -> Deliverable 2
and save it.
2. Set the Activity's Responsibility property.
3. Set the navigation behaviour of the Activity to external drill-down, and specify an external file.
4. Execute the drill-down to create the target file and establish the links.
5. Save the files.
6. Export the upper-level map to Excel.
7. In the Excel file, change the Activity's Responsibility.
8. In Process Navigator, load the upper-level map, and import properties from Excel.
9. Open the upper-level map in Visio, and check the navigation behaviour.
 
Cause:
Spurious load-time actions are added to the map file.
<LoadTimeProcessing>
    <UpdateCustomProperties>
        <UpdateCustomProperty>
            <ElementType xmlns="">1</ElementType>
            <UniqueID xmlns="">{599389D1-BE90-42EF-8887-1B8AA88E6E3B}</UniqueID>
            <PropertyName xmlns="">shadow</PropertyName>
            <NewValue xmlns="">False</NewValue>
        </UpdateCustomProperty>
        <UpdateCustomProperty>
            <ElementType xmlns="">1</ElementType>
            <UniqueID xmlns="">{599389D1-BE90-42EF-8887-1B8AA88E6E3B}</UniqueID>
            <PropertyName xmlns="">responsibility</PropertyName>
            <NewValue xmlns="">IT - director</NewValue>
        </UpdateCustomProperty>
        <UpdateCustomProperty>
            <ElementType xmlns="">1</ElementType>
            <UniqueID xmlns="">{599389D1-BE90-42EF-8887-1B8AA88E6E3B}</UniqueID>
            <PropertyName xmlns="">hyperlinksubaddresscache</PropertyName>
            <NewValue xmlns=""></NewValue>
        </UpdateCustomProperty>
    </UpdateCustomProperties>
</LoadTimeProcessing>
 
Workaround:
The drill-downs need to be re-established by resetting the navigation behaviour to external drill-down, and re-executing the drill-downs to correct the links.
 
Applies to:
  • Process Navigator 11.1.