# Exporting Form Data

You can export data from most forms in the System Administration Tool into a

- text file (. txt): readable by any text editor

- comma separated file (. csv): comma-delimited file also readable by any text editor

This feature is valuable if you need to update another application with data from MiVoice Business. For example, you could export the telephone directory entries from the Telephone Directory form to a . csv file and then run a software script to import the file into a third-party application.

NOTES

- Not all forms support the exporting of data and not all forms support all the export options. If options are not supported for a form, they will be disabled ("grayed out") in the export dialog window.

- If the maximum number of clustered elements is set to 250 in the License and Option Selection form, the Export All function will be disabled for the Telephone Directory and VM Network Users forms.

- For security, passwords and PINs in exported forms (such as the User and Services Configuration form) are masked using asterisks in the export file. On import, the passwords and PINs are preserved but only if the user associated with them still exists in the system database. If the user was deleted from the database after the export, the password and PIN get converted to asterisks on import. As only the digits 0-9 are allowed in passwords and PINs, the system responds with an error and stops the user from being added to the database. To successfully add the user, the import file would have had to contain a valid password or PIN.

You can also export System Diagnostics to a .tar file. See System Diagnostics Reporting.

## Requirements

- the XML components required for client-side rendering installed (see About the XML Components for installation details)

- a text editor or word processor installed on your client station in order to manipulate the exported data.

IMPORTANT: DO NOT use Microsoft Excel to create or modify import files. It will modify data and/or format it incorrectly. Instead, use a simple text editor such as Notepad. (Do not confuse Notepad with WordPad. The latter is a wordprocessor and not suitable for creating or editing import files.)

NOTE: You may need to change the security settings in Internet Explorer (IE) to allow the export file to download. If IE fails to prompt you to save/open the file or you get the message "To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options" follow these instructions,

1. Click Tools > Internet Options > Security > Trusted sites > Sites.

2. Enter the IP address of the MiVoice Business system as: https://<IP Address>

3. Click Add.

4. Click Close.

5. Click Custom level... and enable the following options:

- ActiveX controls and plug-ins > Automatic prompting for ActiveX controls

- Downloads > Automatic prompting for file downloads

6. Click OK, and then OK again to save the changes.

7. Exit Internet Explorer, and then restart it.

## Exporting Form Data

To export form data

1. If you want to export the data for a single record, click the record. To export a selection of records, click the first record that you want your selection to start with.

2. Click Export.

3. Choose the export range:

4. Click All to export all the records in the upper information frame

5. Click Selected Record to export the data for a single record from the lower frame.

6. Click Current Page to export the records in the currently displayed page

7. Click Pages and enter the page number or page range, for example 5-12.

8. Click Next " N" records and enter the number of records (1 to 999) beginning from the currently selected record. This option is only available in forms that contain large lists, such as the Telephone Directory or Multiline IP Sets forms. The maximum number of records that you can export is 999.

4. Choose file type:

5. Comma Delimited

6. Text

5. Click Export.

   CAUTION: Depending on the amount and type of data being exported, there could be a significant delay before the Save As dialog box is displayed. While data is being retrieved from the system database, other users cannot access or use the Desktop Tool, the Group Administration Tool, or the System Administration Tool.

6. Save the file. DO NOT open it.

By default, files are given filenames that use the following format:
Filename={Form Name (max 6 letters)}_{Switch Name (max 4 letters)}_{date followed by 24-hour time (YYYYMMDDHHMM}
Examples: UsePro_Mn96_16100305.csv
TelDir_Mn98_28031205.csv
AllLog_Mn99_19101115.txt

You can rename the file if you like. Ensure that the file extension is set correctly:

7. Text (comma delimited) (*. csv)

8. Text (. txt)

9. System Diagnostics (.tar) - for analysis by Mitel Customer Support

NOTE: For CSV files containing characters in the extended ASCII character set—that is, characters above 128—use UTF-8 file encoding when saving the file.

7. Open the csv file or . txt file or navigate to the folder it was saved in (your Downloads folder by default).

Related Topics

- Printing Form Data