Data integration hub

PATH: Administration > Data Import/Export > Data Integration Hub.

All import definitions are administrated in this list.

Window settings, Template and Multiselect are supported. Authorization: Import

Items are sorted by area, import structure description and ID.

DIH_2020.09

Window importkopf_browse.psr

Column description

Field	Description
... (bitmap)	The icon defined for the definition.
Type	Type of the definition: import, PDM, CAD etc.
Table structure	Target table of the import .
ID	Unique ID for the import definition.
Description	Description of the import definition.
Status	Processing status of the definition.
Status description	Description of the status.
Status %	Completion in % .
Last run	The date of the last import.
Executions	The number of times the import has been executed.
Error	Number of detected errors.

Further columns to be displayed can be added in window settings.

Functions

Name

Description

Open

Opens the selected entry for editing.

End

Closes the window.

Start Import

Starts the import of the selected row.

open Hub Templates

By clicking on this button, you can access the folder with Excel templates for each table definition in Beas.

For each table you can generate an excel file with all columns marked as Import =yes. The information, then, can be saved in Excel template (.xlts) format in the Beas folder program\DIH_templates.

Match the field information stored in the Excel table

The first line in the Excel sheet stores the exact field ID.

The second line in the Excel sheet stores the necessary information related to a field - the exact field ID, description, data type and possible values. (see image below)

Orange fields are mandatory.
Blue fields are optional.

To match the information from the Excel sheet, the system uses the first line containing each field ID. The below image demonstrates how the information from the Excel table matches the target fields of the Beas window.

Note: Remember to delete the second row of the excel when you prepare the file for import!

See Automatch

Example:

Mandatory fields with "Mandatory: YES" in orange:
PERS_ID (Employee number)
NAME 1 (First name)
NAME 2 (Last name)
KSTST_ID (Cost center)

DIH_Excel_table

Search field

Add information to filter the Import definition list

Right-click menu options

Name	Description
Protocol	Opens the error protocol for the current entry. Note: At each renewed import the protocol is deleted first.
New	Create new definition
Duplicate	Duplicates the current entry.
Remove	Deletes the selected entries. Multiselect is supported.
Planned activities	Opens the Planned activities window, where import operations can be scheduled and automated.
Counter: Reset	Resets the error error counter for the selected entry.
Column definition: Reload	Reloads the column definition (database description) in the current database. This occurs usually at each program update.
Export Definition	Definition of the selected rows are exported to a file. Multiselect is supported.
Import Definition	Import definitions, that have been exported can be imported. If an ID already exists, it is renamed automatically.

Help URL: https://help.beascloud.com/beas202102/index.html?import.htm