Exporting Data to a CSV File

You may occasionally want to export large sets of data from the Vocera database to a CSV file.

Exporting data is useful when you want to examine all your data or make global changes that would be time consuming to make in the Administration Console.

For example, suppose changes to the phone system caused your organization to reassign desk extensions for all users. You can export the existing user data to a CSV file, make the changes to desk extensions, and then use the Update feature to replace the existing user data with the data in your CSV file.

Exporting data does not remove it from the database. See Emptying the Vocera Database.

Note: Vocera supports numeric values in name fields. The Administration Console lets you create a purely numeric name that begins with a zero, such as 01234, and exports it to a .csv file correctly. However, Excel strips initial zeros from numeric values without warning. If you are using numeric values that begin with zero in name fields, do not use Excel to edit your .csv files.

To export Vocera data:

  1. Click Maintenance in the navigation bar.
  2. Click the Export tab to display the Export page.
  3. Use the Site filter to specify which site to export data from.
  4. Specify the data to export in the Export Data to File section.
  5. Click Export.
    Windows displays the File Download dialog box.
  6. Specify whether to save the file or to open it for viewing:
    • Click Open to view the file. You can open a CSV file in Microsoft Excel, a text editor, and many other applications.

    • Click Save to browse to a location and enter a file name for the file.

      The data you export is in CSV format, appropriate for importing again.

      Note: Only users, groups, and devices can be updated by importing a CSV file. Other types of Vocera entities can be imported only once.