process4.biz 7.x Documentation

features description for Process4.biz

IEM_001: Importing of object links

Problem

You have created objects and link types in the p4b database. Now you want to create manual links between these objects via the ExcelImport Wizard.

Solution

An example:

 

Object Name

LanguageID

Unit

Class

Object Links

someID

NameOfObject01

EN

UnitName

ClassName

ListOfLinks

someID

NameOfObject02

EN

UnitName

ClassName

ListOfLinks

  • The name of the columns “Unit” and “Class” should be consistent to the current database language (i.e.”Class” for English, “Klasse” for German, “Classe” for French). All other columns should have the same (english) name, as shown above.
  • LanguageID can take on the values: EN (English), DE (Deutsch), FR (Francais), regardless of the desired languages, but should correspond with the language of the object data, i.e. objects with LanguageID “DE” should also have a German “ObjectName” in order not to buffle the import process.
  • Each object has an ID. The easiest way to obtain it  is to export the selected class, choosing only the class name in the Data selection window. This process requires all objects to be already placed in the database.
  • The cell ListofLinks should be formatted in such a way that a link is created per cell **within the same cell. **To create a line break in Excel in the same cell, press Alt+Enter.

Here is the link:

Direction

LinkType

(Distance)

Class

(Distance)

Object

Direction

[ LinkType ]

space

Class

colon with space (" : ")

Object

  • Direction can take on the values: > (direct link from our object to the object described in this cel)l, < (direct link from the object described in this cell to our object), <> (indirect link between these objects.)
  • The LinkType is the full name of the link type in square brackets. Please note that in direct links the full name and not the direct or opposite name is given.

Example:
> [ linked to ] SomeOtherObjectClass : Object1_Class2
< [ linked to ] SomeOtherObjectClass : Object2_Class2
<> [ linked with ] SomeOtherObjectClass : Object3_Class2

See also the attached excel spreadsheet Example.xls.

Summary:

1. Create an excel file with the Excel-Export. Choose the selected class and choose only the class name in the Data selection window.

2. Enter the desired links in the column Object Links, whereby each link needs to be referenced only once, e.g. only from the outgoing from-object.

3. Import the final Excel spreadsheet. Select “Import object links”. You can also delete all previously created links of the respective objects via “Overwrite object links with Excel”, before importing the new links from the Excel file.