Import/Export
The Import/Export feature allows users to export SD Elements Library content to the format of their choosing. Refer to the help documentation in the Help tab from the Library > Import/Export page for a list of supported content types to import and export. Use this for bulk actions on Library items by exporting SD Elements content as files, modifying them, and then reimporting them. In addition, a full library can be downloaded as an export-only ZIP file.
For information about kinds of files that you can export and what they contain, refer to appropriate topics within the Library section.
|
File format
Supported formats for the import/export feature are:
-
xlsx (Excel) (Recommended when opening in Microsoft Excel. Note that Excel automatically truncates large files upon import.)
-
csv (Comma Separated Values format)
-
json (JavaScript Object Notation format)
-
yaml (Yet Another Markup Language format)
The full library export-only format is available as:
-
ZIP (Compressed file format)
Download full library in export-only format
Export the SD Elements content library for backup or to help with tracking changes. Follow the steps below to trigger an export:
-
The user has the permission Global role→Customization→Customize content.
-
Click Library→Countermeasures.
-
Select the Export icon.
-
Click Download.
The downloaded ZIP file contains low-level details about content (Additional Requirements, How-to’s, Weaknesses, Survey, and Countermeasures) including Match Conditions.
Export template/file structure
Use a content template as a basis for importing content to the system. To retrieve the template, follow the steps below:
-
The user has the permission Global role→Customization→Customize content.
-
Click Library→Import/Export.
-
Select the Export tab.
-
Under Templates, select the Empty option.
-
Select a File Type.
-
Click Export.
The template defines the headers you require, as illustrated below:
Export all content
Export the SD Elements content library for offline reading, making a backup, or modifying and reimporting it. Follow the steps below to trigger an export:
-
The user has the permission Global role→Customization→Customize content.
-
Click Library→Import/Export.
-
Select the Export tab.
-
Under Templates, select the All Data option.
-
Select a File Type.
-
Click Export.
Export specific content
Only export the content of Weaknesses, Countermeasures, or Glossary items.
-
The user has the permission Global role→Customization→Customize content.
-
Click one of the following:
-
Library→Weaknesses to export Weaknesses.
-
Library→Countermeasures to export Countermeasures.
-
Library→Glossary to export Glossary items.
-
-
Select the Export tab.
-
Under Templates, select the All Data option.
-
Select a File Type.
-
Click Export.
The library content you select is then exported in the format of your choosing.
Export a specific content template
Use a content template as a basis for importing specific content to the system. Supported types are Weaknesses, Countermeasures, and Glossary items.
To export a template, follow these steps:
-
The user has the permission Global role→Customization→Customize content.
-
Click one of the following:
-
Library→Weaknesses to export a Weaknesses template.
-
Library→Countermeasures to export a Countermeasures template.
-
Library→Glossary to export a Glossary template.
-
-
Select the Export tab.
-
Under Templates, select the All Data option.
-
Select a File Type.
-
Click Export.
The file template content you select is then exported in the format of your choosing.
Import content
Submit bulk changes to the content library using the import function. Up to 5 files are supported in a single import.
-
The user has the permission Global role→Customization→Customize content.
-
Click on Library→Import/Export.
-
Select the Import tab.
-
Click Choose File and select the .xlsx or .csv file containing your changes. If you have up to 5 files, click on Choose File and select each one.
-
Click Import.
-
Review the changes detected by the system.
-
New content will be displayed in green, and any old content (that will be overwritten) is displayed in red.
-
Only new or updated rows will be displayed.
-
-
Apply the changes by clicking Accept. Otherwise, click Cancel to abandon the import.
Review the changes carefully. You cannot reverse an import once you apply it. |
Troubleshooting
An error will be displayed if you import an unsupported file. For example:
-
Make any required changes to the file.
-
Click Close.
-
Restart the import process with the updated file.