Preconditions:

• You have exported project data for external editing and not selected the option Edit in external application and reload in the process.
• You have edited the data in the chosen external application and saved the file.
• You have opened the project into which the data is to be imported.

1. Select the following commands: File > Import > Command group Project data > Project data > Command group External editing > Properties.
2. In the Open dialog, select the directory where the file to be imported is located, then select the file and click [Open].
   
   The data is imported. A progress bar shows the progress of larger data volumes.

Preconditions:

• You have exported parts data for external editing and not selected the option Edit in external application and reload.
• You have edited the data in the chosen external application and saved the file.
• You have opened the Parts management dialog (Tab Master data > Command group Parts > Management). In the Parts management dialog you have opened a parts database into which data is to be imported using [Extras] > Settings.

1. Select the menu items Edit properties externally > Import data in the dialog Parts management below the button [Extras].
2. Enter the file name of the import file into the File name field in the dialog External editing: Import parts data, or click to select the file interactively. Multiple selection is possible.
3. In the group box Record identification specify whether the identification is to take place via the Object ID of the parts management or via the name. The identification via the name is used when you import parts data which were created in external systems into the own parts database.
4. In the group box Import use the options to specify the treatment of new or existing records during import.
5. Click [OK].
   
   The data is imported. A progress bar shows the progress of larger data volumes.
   
   If new parts, addresses, etc. are generated during the import, a corresponding message is issued. If parts, addresses, etc. are already available or if data is missing in the import file, a corresponding message is also displayed.

Preconditions:

Importing project data:

• You have opened a project.
• You have opened a navigator and the project in the tree view or list view, and have selected one or more pages or one or more records.
• You have selected the following commands: File > Export > Command group Project data > Project data > Command group External editing > Properties.

Importing parts data:

• You have opened the Parts management dialog (Tab Master data > Command group Parts > Management).
• You have selected one or more parts or other records in the tree view.
• You have the selected the menu items Edit properties externally > Export data in the dialog Parts management below the button [Extras].

1. In the dialog Edit externally, select a scheme from the Settings drop-down list. If you want to create new functions, select a scheme for which the object type is set to All functions. The "Device" scheme is available as a default for this purpose. If you want to create new parts, select a scheme with the object type Parts. The "Default" scheme is available to this purpose. The "Parts including function templates" scheme is available for editing and creating parts with function templates.
2. Select the Edit in external application and reload option in the Edit externally dialog.
3. Click [OK].
   
   The data are exported to Excel.
   
   Excel is opened with the exported properties.
   
   

   Example:

   		Function definition	Function group	Function category	DT (full)	DT (displayed)
   3	17/65581	1	1	200	=GAA+A1-K4	-K4
   4	17/65581	1	1	200	=GAA+A1-K4	-K4
   5	17/65581	1	1	200	=GAA+A1-K4	-K4
   6	17/65581	1	1	200	=GAA+A1-K4	-K4
   7	17/65581	1	1	200	=GAA+A1-K4	-K4
   8

   
   
4. To create new objects, copy, for example, the rows of existing objects. For the functions change the entries in the copied lines in the columns DT (full) and DT (displayed). For parts change the entries in the copied lines in the columns Part number and Variant.
5. Lastly, change the entry in the first column of each Excel table by setting the number after the slash ("/") to zero. For a new function specify, for example, the value "17/0" and for a new part the value "117/0".
   
   

   Example:

   		Function definition	Function group	Function category	DT (full)	DT (displayed)
   3	17/65581	1	1	200	=GAA+A1-K4	-K4
   4	17/0	1	1	200	=GAA+A1-K5	-K5
   5	17/0	1	1	200	=GAA+A1-K6	-K6
   6	17/0	1	1	200	=GAA+A1-K7	-K7
   7	17/0	1	1	200	=GAA+A1-K8	-K8
   8

6. To create new subobjects for parts, copy the lines of existing subobjects, for example. Subordinate objects (such as function templates) do not have entries in the first column, but rather entries in the second column of the Excel spreadsheet, such as "99/117/65/1 (117/65:99/1)". The first number stands for the object ID of the subordinate object, here the function template. For function templates change the entries in the copied lines in the Function template / function definition: Category / Group / Definition column.
7. Finally, change the entry in the respective second column of the Excel spreadsheet by setting the object ID of main and subobjects to zero. For a new function template, enter the value "99/117/0/0 (117/0:99/0)", for example.
   
   
   

   Example:

   			Part number	<...>	Function definition	Function template / function definition: Category / Group / Definition
   3	117/0	117/1	EPL.2161500
   4		99/117/0/0 (117/0:99/0)	1		Black box	1303/1/1
   5		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   6		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   7		99/117/0/0 (117/0:99/0)	1		PE device connection point	1302/1/2
   8		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   9		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   10		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   11		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   12		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   13		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1
   14		99/117/0/0 (117/0:99/0)	1		Device connection point	1302/1/1

8. To make the new objects (and possibly also subobjects) available for EPLAN you must extend the range of the EPLAN values in Excel. To do this, press [Ctrl] + [F3].
   
   The dialog Name manager opens.
9. Click the "EPL_VALUES" name here and change the entry in the field References in such a way that it includes the newly added cells.
10. Click [Close].
11. Save the table, and close Excel.
    
    The data are exported.
12. Confirm the prompt regarding the data to be imported with [Yes].
    
    The objects created in Excel are imported. New parts are directly available in parts management. New functions are inserted in the device navigator as unplaced functions.