.. _bulk-export-of-model-data:

Bulk export of model data
-------------------------

.. _18.1-Patch-Bundle-3|VOSSUC-18236:

#. Choose the hierarchy to which the model belongs.
#. Choose the items to be exported from the List view and click **Export**.
#. From the **Export format** list, choose the required export format
   and export the selected items. 
   
   The following file formats
   correspond with the selected item in the list:

   .. tabularcolumns:: |p{5cm}|p{10cm}|

   +--------------------------------+-------------------------------------------------------------+
   | File format                    | Description                                                 |
   +================================+=============================================================+
   | 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      |
   |                                | export filename also contains a date stamp.                 |
   +--------------------------------+-------------------------------------------------------------+
   | Excel                          | An export containing data and Excel columns for all fields  |
   |                                | as shown in the JSON export format. The export filename     |
   |                                | also contains a date stamp and reference to the export      |
   |                                | data type.                                                  |
   +--------------------------------+-------------------------------------------------------------+
   | 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 export filename also contains a date stamp |
   |                                | and reference to the export data type.                      |
   +--------------------------------+-------------------------------------------------------------+

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 for example be opened in MS Excel.


.. note::

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