Project: HELiOS

Serial Document Input: Attribute Mapping Configuration Files

Various selection options are offered in the pull-down menu beneath Configuration for attribute initializationin the dialogue window for serial document input or document input via Drag & Drop if any have been stored in the system beforehand.

The corresponding files are located in the user-specific Windows directory of your current HELiOS Version at \AppData\Roaming\ISD Software und Systeme\HELiOS [VersionID]\Transfer\Import\.

Example: \AppData\Roaming\ISD Software und Systeme\Transfer\HELiOS 2018\Import\.

There you can find the files Helios.ImportConfig.General.Standard.xml and Helios.ImportConfigurations.General.xml.

The "General" in the file name stands for the general HELiOS configuration. The Attribute mapping, e.g. for MultiCAD interfaces, takes place in separate system files.

In the file Helios.ImportConfigurations.General.xml you can find an overview of all created configurations.

Here, only the the file Helios.ImportConfig.General.Standard.xml, which has been assigned the label "Standard", is initially stored via FileName.

In the file Helios.ImportConfig.General.Standard.xml attribute mappings are defined.

Default-Inhalt Helios.ImportConfig.General.Standard.xml

<?xml version="1.0" encoding="utf-16"?>

<ImportConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://isdgroup.de/Helios/Transfer"

Version="2.0">

<AttributeMappings

Type="Document">

<FilePropertyMapping

AttributeId="HEL_DOKUNUMMER"

Property="FileName"/>

<FilePropertyMappingSwitch

AttributeId="DOCUMENT_TYPE"

Property="FileNameExt">

<Case

PropertyValue=".SZA">

<SimpleStringValue

Value="HiCAD Konstruktion" />

</Case>

<Case

PropertyValue=".KRA">

<SimpleStringValue

Value="HiCAD Teil/Variante" />

</Case>

<Case

PropertyValue=".MSG">

<SimpleStringValue

Value="E-Mail" />

</Case>

<Case

PropertyValue=".XLS">

<SimpleStringValue

Value="Excel" />

</Case>

<Case

PropertyValue=".XLSM">

<SimpleStringValue

Value="Excel" />

</Case>

<Case

PropertyValue=".XLSX">

<SimpleStringValue

Value="Excel" />

</Case>

<Case

PropertyValue=".DOC">

<SimpleStringValue

Value="Word" />

</Case>

<Case

PropertyValue=".DOCX">

<SimpleStringValue

Value="Word" />

</Case>

<Case

PropertyValue=".DOCM">

<SimpleStringValue

Value="Word" />

</Case>

<Case

PropertyValue=".JPG">

<SimpleStringValue

Value="Bild" />

</Case>

<Case

PropertyValue=".PNG">

<SimpleStringValue

Value="Bild" />

</Case>

<Case

PropertyValue=".JPEG">

<SimpleStringValue

Value="Bild" />

</Case>

<Case

PropertyValue=".TIF">

<SimpleStringValue

Value="Bild" />

</Case>

<Case

PropertyValue=".BMP">

<SimpleStringValue

Value="Bild" />

</Case>

<Case

PropertyValue=".AVI">

<SimpleStringValue

Value="Film" />

</Case>

<Case

PropertyValue=".WMV">

<SimpleStringValue

Value="Film" />

</Case>

<Case

PropertyValue=".TXT">

<SimpleStringValue

Value="Sonstige" />

</Case>

<Case>

<SimpleStringValue

Value="Sonstige" />

</Case>

</FilePropertyMappingSwitch>

</AttributeMappings>

<InfoDialog

Show="false" />

</Settings>

</ImportConfig>

Within the XML tag "<AttributeMappings> (...) </AttributeMappings>" attribute assignments (mappings) are defined.

Generally, there are three types of attribute assignments:

1) FilePropertyMapping: A file property is assigned to an attribute.

2)FilePropertyMappingSwitch: Depending on the value of the file property, a specific value is assigned to an attribute.

3)FixValueMapping: A fixed value is assigned to the attribute.

Possible file properties for import mapping are:

FilePath (Storage location of the file)
FileDriveDir (Complete storage location of the directory in which the file is located, incl. file name and extension)
FileName (File name)
FileNameExt (File extension indicating the file format)
FileCreationTime (Date and time of file creation)
FileLastAccessTime (Date / time of last access to the file)
FileLastWriteTime (Date / time of last saving of the file)

"Property" in FilePropertyMappingstands for the file property which is, for instance, written into the HELiOS field of the AttributeID.

Example:

<FilePropertyMapping Property="FileName" AttributeId="BENENNUNG"/>

Here, the file name has been assigned to the attribute BENENNUNG.

Please note:

The file name attribute FileName contains the complete file name including the file extension. If you want to transfer the file name without the file extension, you can use the converter assignment "TruncateFileExtensionConverter".

Example row:

<FilePropertyMapping Converter="TruncateFileExtensionConverter" Property="FileName" AttributeId="BENENNUNG"/>

The pure file name ("FileName") without file extension (through specification of Converter="TruncateFileExtensionConverter") will then be written to the HELiOS attribute "BENENNUNG" (Designation).

With FilePropertyMappingSwitch a specific value is written to an attribute.

This procedure involves the XML tag Case with the properties AttributeValue and PropertyValue.

Via these properties it is specified which value the HELiOS attribute is to assume for a particular value of the file property.

Example:

<Case AttributeValue=”HiCAD Konstruktion” PropertyValue=”.SZA”/>

<Case AttributeValue=”E-Mail” PropertyValue=”.MSG”/>

<Case AttributeValue=”Word” PropertyValue=”.DOC”/>

<Case AttributeValue=”Word” PropertyValue=”.DOCX”/>

<Case AttributeValue=”Sonstige”/>

</FilePropertyMappingSwitch>

Here, a value that is dependent on the file extension (Property=FileNameExt) is assigned for the HELiOS attribute DOCUMENT_TYPE.

If the file ends on .SZA, the attribute obtains the value "HiCAD Konstruktion" ("HiCAD model drawing"); if it ends on .MSG, the attribute obtains the value "E-Mail"; if files end on .DOC, pr .DOCX, the attribute obtains the value "Word".

For all other file extensions which are not defined here, "Sonstige" ("Others") will be written to the attribute.

With FixValueMapping a fixed value is assigned to an attribute.

The property AttributeValue defines the fixed value.

Example:

<FixValueMapping AttributeId ="BENENNUNG2" AttributeValue ="Importdatei"/>

Here, the value "Importdatei" is assigned to the HELiOS attribute BENENNUNG2 (Designation2) for each entry of the serial input.

Furthermore, the file contains the following text block:

</Settings>

Here it is specified whether a dialogue will be shown upon each input, listing all possible file properties with their respective values.

If you want to create further configurations, do so according to the structure of the file Helios.ImportConfig.General.Standard.xml an. Assign a new name by creating a new GUID (Globally Unique Identifier), and exchange te term 'Standard‘ with this GUID in the file name.

Example:

Created new GUID: BBFCE593-764C-44D5-ADA2-8DFD706B7B97

New file name: Helios.ImportConfig.BBFCE593-764C-44D5-ADA2-8DFD706B7B97.xml.

In this file, you can then define the attribute assignments as described above.

To ensure that this configuration will be available for selection in the dialogue window for serial input, you need to expand the Helios.ImportConfigurations.General.xml accordingly - in this example, by the following text block:

The assigned text after UserLabelwill then be shown in the dialogue as the configuration name. After FileName the name of the file with the attribute assignments is shown.

For example, an initialization value could be defined in this file, writing the file name of the document to be entered into the HELiOS attribute field "BENENNUNG" ("DESIGNATION") ( <FilePropertyMapping Property="FileName" AttributeId="BENENNUNG"/>) while always assigning the fixed value "Importdatei" ("Import file") to the HELiOS attribute "BENENNUNG2" ("DESIGNATION2").

Please note:

A special case is the attribute mapping for E-mails, where the configuration file hel_fileattributes.ini applies.

Generation of Numbers

> Feedback on this topic