process4.biz 7.x Documentation

features description for Process4.biz

Connecting diagram objects to external data

The Visio function “Link data with shapes” can also be used for process4.biz objects. This means that you can connect Excel rows directly with process4.biz objects. This information is stored in the database and can be displayed on all diagrams where the object is used. A simple example shows how to create this connection. 
You have created for example this process4.biz diagram:

329089

At the same time you have an Excel file in which object properties (such as color, here) are described.

329091

You now want to connect the process4.biz objects on the diagrams with the Excel rows. Here external data should not be imported as process4.biz properties in the database, but they should be preserved in the Excel file and be connected to internal objects in the database. To connect to external data, open from the Visio menu Data the entry Custom Import and select Microsoft Excel workbook.

329143

329141

Select the Excel file that should be linked.

329145

Define which Excel worksheet you want to use.

329147

Select here columns and rows that you want to display on the diagram:

329137

Select this column, by which Excel data on diagrams should be identified and later updated. For example, the column Name or ID can be selected.

329139

Then click Finish.

329125

The Excel file is linked to the diagram. An image of the Excel table is displayed on the side (or bottom, depending on your UI settings in Visio) of the diagram.

329127

Now you can link the desired row with the object using drag& drop. The linked data are displayed according to the selected visualization, for example as a text on the right of the shape. The appearance of the text or the type of visualization can be changed by means of the data graphics. This window can be opened on the right of the diagram via the Visio menu Data  Shape Data… and allows you to display the data as text, data bars, icon set or color according to value. In Visio 2060 the data graphics view can be adjusted under menu Advanced Data Graphics:

329129

In our example, there is as yet no process4.biz property to synchronize with the shape data; therefore, it is now produced and configured. 
Right-click on the shape of the object and choose Equip with p4b properties → Equip the shape with object-properties of Process4.biz. Thus, the following window opens.

329117

Now click on the property group e.g. Definition and click the New button to create a new property. Enter a name (e.g. Color), set the property Shape-specific to True and the property sync to Visio => P4B. If you do not want or do not need that the same object has different values of this property on the different shapes, leave the property Shape-specific to False. Now click OK to close the property window. (This process can also be carried out in the Designer).

Now select the property Color to activate the synchronization, and select the value Description for the property Visio Shapes target cell. The Visio shape data have been already generated by Visio. Define the synchronization Visio => P4b. Click OK to close the window.

328175

Then save the diagram. The shape-specific process4.biz property Color has now the value of the shape data (actually the value from an Excel row). You can see the value also in the Property Explorer window.

328177

Now the Excel document is changed, e.g. the color is changed from red (R) to pink (p) and is saved.

328176

To update the external data to Visio, click Refresh All in the Visio menu.Visio displays a window and informs you about the successful update. This window can be closed. The updated Excel value appears now in the Visio shape data and in the process4.biz shape-specific property.

328174