Device data are imported from files with the file extension TXT, CSV, ASC and from MS-Excel files (*.XLS, *.XLSX, *.XLSB, *XLSM) into an EPLAN project that is open or is marked in the page navigator.

Preconditions:

• You have opened a project.
• Device data from an external program are available in the form of a text or an MS-Excel file.

1. Select the Project data > Devices > Import menu items.
2. Select the file type ("Text" or "Excel") from which you want to import device data in the Type of data source field of the dialog Import device data.
3. Click [...] next to the Data source field.
   
4. In the dialog Select data source select the file from which importing is to be carried out and carry out the required settings.
5. Click [OK].
   
   The dialog Select data source is closed and the dialog Import device data is displayed.
6. In the Import device data dialog, click [...] next to the Field assignment field.
   
7. Specify in the Property column of the dialog Field assignment which EPLAN properties are to be assigned to the designations of the external data fields that are listed in the External data field name column.
8. Click [OK].
   
   The dialog Field assignment is closed and the dialog Synchronize devices is displayed. This dialog displays the device data from the data source and their assignment to devices in the EPLAN project. In the process an analysis is carried out and the Status column then displays whether devices are not yet contained in the project, whether they already exist in the project, or whether the devices in the data source and in the project have different editing states (for example other property values). Fields with changed property values have a dark-gray background.
9. Specify in the Action column in the dialog Synchronize devices what is to happen with the devices depending on the displayed status:
   
   

Status		Action
	New	Import or None
	Identical	None
	Additional	Delete or None
	Changed	Apply change or None

10. You can set a trade-specific filter in the Filter field in order to reduce the scope of display in the dialog Synchronize devices to the desired devices.
11. In order to display the devices to be imported in accordance with their current status select a status from the drop-down box in the Filter (status) field.
12. In a marked row in the dialog Synchronize devices select the popup menu item Assign part to automatically assign a suitable part number from the parts database to the devices to be imported.
13. If no automatic assignment is possible, click the [...] button in the Part number column to open the part selections and select a part there manually.
14. Click [OK].
    
    The import or the selected actions are carried out.
    
    The dialog Synchronize devices is closed.
    
    

Status		Action	Result
	New	Import	Devices are imported
	Identical	None	Device remains in the project
	Additional	Delete	Device is deleted from the project
		None	Device remains in the project
	Changed	Apply changes	Changed property values are applied
		None	Changed property values are not applied

See also

Importing Connection Data and Routing Connections