This functionality is only available for certain module packages. Info / Copyright

Action: XMImportDCArticleDataAction


Parameters

Description

DATACONFIGURATIONFILE

File path of the file to be imported.

PROGRESSTITLE

Specifies the title of the progress bar (optional).

SHOWIMPORTMESSAGES

Display of the import message (optional, 0 = no dialog is displayed, 1 = dialog (with quantity of the added parts) is displayed).
If nothing is specified, a dialog is displayed.

IMPORTMODE

Import mode (optional, 0 = Add new records only, 1 = Update existing records only, 2 = Update existing records and add new ones).
If nothing is specified, the records are updated. If new records exist in the file, a query is displayed whether new records are to be created.

IDENTIFYBYNAMEINSTEADOFID

Record identification (optional, 0 = Identification via object ID, 1 = Identification via name).
Default value: 0

The two options for the record identification (IDENTIFYBYNAMEINSTEADOFID parameter) are intended for different use cases:

  • When you export data from the parts management, edit it and import it into the same parts database, the identification of data via the Object ID is the right way for identification (/IDENTIFYBYNAMEINSTEADOFID:0). In this case it is possible to change the identifying names (for example the part number) of the data as long as they do not already exist in the parts database.
  • If you want to import the data from a different data source (external systems such as an ERP system), you generally do not have an Object ID from EPLAN. In this case use the Identification via name to import the data (/IDENTIFYBYNAMEINSTEADOFID:1).

Nevertheless, the object ID has to be specified in the first column of an Excel file when importing with identification via name. The type of object is defined via the object ID, meaning whether, for example, the data contains a part, an address or an accessory list.

The supported main types are:

  • 117 = Part
  • 156 = Drilling pattern
  • 157 = Connection point pattern
  • 213 = Accessory list
  • 226 = Accessory placement
  • 135 = Address

The import supports not only main types but their subtypes as well. Since they do not have identifying names, but are rather identified as a subobject of the main object, the subobjects have to be identified in the second column of an Excel file.

The supported subtypes for a part are:

  • 99 = Function template
  • 85 = Module / assembly item
  • 224 = Drilling patterns (manufacturing)
  • 215 = Accessories
  • 242 = Safety-related values

The supported subtype for a drilling pattern is:

  • 158 = Drilling pattern position

The supported subtype for a connection point pattern is:

  • 159 = Connection point pattern position

The supported subtype for an accessory list is:

  • 214 = Accessory list position

The supported subtype for an accessory placement is:

  • 227 = Accessory placement position

The subobjects are defined in the second column as follows:
"99 (117:99/1)"

Here the first number indicates the subtype (here the "99" for function template) and the bracket the relationship: Contains the relationship to a main object and its index.

"99 (117:99/1)" means, therefore, that it is a function template (first "99"). The function template refers to a part ("117"). This function template has the index 1 ("99/1"). This means that it is the function template in the first line of the Function templates tab.

In the file to be imported, the subobjects must follow the respective main object directly.