Bulk Export of Model Data

1. Choose the hierarchy to which the model belongs.

2. Choose the items to be exported from the List view and click the Action > Export.

3. From the Export format drop-down, choose the required export format and click OK to export the selected items. The following file formats correspond with the selected drop-down item in the list:

   • JSON - an export containing data in JSON format as in the system database. Item properties such as strings that are empty or Boolean values that are not set, are not included. The filename format is:

     export_YYYY-MM-dd_HH_MM_SS.nnnnn.json.zip

   • Excel - an export containing data and Excel columns for all fields as shown in the JSON export format. The filename format is:

     <type>_<name>_exportedsheet_CCYY-MM-DD_HH-MM-SS.xlsx.

     An example would be:

     data_User_exportedsheet_2015_01_01_12-25-22.xlsx.

   • Excel(formatted) - an export containing data and Excel columns as arranged by any Field Display Policies that apply. The columns correspond with those of a Bulk Load Template export sheet. This sheet can therefore be used to modify and update data if required. The filename format is:

     <type>_<name>_exportedsheet_formatted_CCYY-MM-DD_HH-MM-SS.xlsx.

     An example would be:

     data_User_exportedsheet_formatted_2015_01_01_12-25-22.xlsx.

4. If required, the export JSON file can be decompressed, and the JSON file (.json) can be opened in a text editor. The XLSX file can be opened in MS Excel.

Note

The bulk export of Device Model data will export locally cached data, not data on the device itself.