Parameters |
Description |
DATACONFIGURATIONFILE |
File path of the file to be imported. |
PROGRESSTITLE |
Specifies the title of the progress bar (optional). |
IMPORTMODE |
Import mode (optional, 0 = Add new records only, 1 = Update existing records only, 2 = Update existing records and add new ones). |
IDENTIFYBYNAMEINSTEADOFID |
Record identification (optional, 0 = Identification via object ID, 1 = Identification via name). |
The two options for the record identification (
- 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.
Importing parts data which was previously changed in external editing:
XMImportDCArticleDataAction /DataConfigurationFile:c:\\EPLAN\\DataCfgFile.edc