Import and Export CSV Files

You can export all the columns on the Services page to a comma-separated value (.csv) file. You can also import information from a CSV file.

Starting in Junos Space Security Director Release 20.3, you can import service objects from a CSV file. While importing a service object, you can resolve object conflicts, if any. Junos Space Security Director uses object name as the unique identifier for the object (per domain). During import, all the Security Director objects and device objects are compared by name.

If the object name does not exist in Security Director, the object is added to Security Director.
If the object name exists in Security Director with the same content, the existing object in Security Director is used.
If the object name exists in Security Director with different content, the object conflict resolution screen is displayed.

Note:

Objects that are not linked to a policy are imported into Security Director and then removed from the device configuration as part of device update.

Import from a CSV file

To import configurations from a CSV file:

Select Configure > Shared Objects > Services.
The Services page is displayed.
Right-click a service object and select Import from CSV. You can also select Import from CSV from the More list.
The Services Import CSV Wizard page is displayed.
Click Browse to locate the CSV file that you want to import and then click Upload to upload the file to the Security Director database.
Note:
To view a sample CSV file, click View sample CSV file.
Click Next.
Resolve object conflicts, if any.
An object conflict occurs when the name of the object to be imported matches an existing object, but the definition of the object does not match. You can take the following actions for the conflicting objects:
- Rename Object—Provide a new name to the conflicting object. "_1" is added by default to the name, or users can specify a new unique name. Device Preview or Update deletes the original object and adds the object with the new name.
- Overwrite with Imported Value—Overwrite the existing object with the new object. The object is replaced in Security Director with the new object. The change appears in the next preview/update for all other devices that use this object.
- Keep Existing Object—Keep the existing object and ignore the new object. The object in Security Director is used instead of the device object.
Click Finish.
A summary of configuration changes is displayed.
Click OK to import the CSV file.

Example: During import, when object conflict occurs between the device and Security Director you must choose a conflict resolution as in Table 1.

Table 1: OCR While Importing Services to Security Director
Object Name	Object Type	Value	Imported Value	Conflict Resolution	New Object Name
Service1	Service	Service_1, Protocol:TCP, Destination Port:25	Service_1, Protocol:TCP, Destination Port:26	Rename Object	Service1_1
Service2	Service	Service_2, Protocol:TCP, Destination Port:30	Service_2, Protocol:TCP, Destination Port:31	Overwrite with Imported value	Service2_1
Service3	Service	Service_3, Protocol:TCP, Destination Port:40	Service_3, Protocol:TCP, Destination Port:41	Keep Existing Object	Service3_1

The object values and the result after resolving conflicts are listed in Table Table 2.

Table 2: After Importing Services to Security Director
Discovered Object Name in Security Director	Discovered Value in Security Director	Result
Service1	Service_1, Protocol:TCP, Destination Port:25	No change
Service2	Service_2, Protocol:TCP, Destination Port:31	Value changed
Service3	Service_3, Protocol:TCP, Destination Port:40	No change
Service1_1	Service_1, Protocol:TCP, Destination Port:26	Service1_1 created

Note:

Once the initial conflict is resolved, the object conflict resolution checks for further conflicts with the new name and definition until resolution is complete. If Security Director finds further conflicts, the Conflict Resolution page is refreshed to display the new conflicts.

Export to a CSV File

To export configurations to a CSV file:

Select Configure > Shared Objects > Services.
The Services page is displayed.
Right-click the service object that you want to export and select Export to CSV. You can also select Export to CSV from the More list.
The Export Services pop-up is displayed.
Click Export All or Export Selected.
The Services Export CSV Status page is displayed with the status of download percentage.

When the CSV file is available, you can open or save the file.

ON THIS PAGE

Import and Export CSV Files

Import from a CSV file

Export to a CSV File

Related Documentation