# About Importing Form Data

You can import data into the system database using the Import functionality accessed in all configurable forms except the following:

- Console Softkeys

- Console Softkeys -> Softkeys

- Device Connectivity - All

- Device Connectivity - Moved

- DHCP Lease Viewer

- Dimension Selection

- Embedded Media Sources -> Embedded Media Source Usage

- License and Option Selection

- MiXML Applications

- MiXML Applications -> MiXML Application Features

- VM Network Users

- Personal Speed Calls

- Personal Speed Calls -> Speed Calls

- Restore

- Shared Form Configuration

- System Audio Source Update

- System Diagnostics Reporting

Importing data can save you considerable configuration time, and reduces the likelihood of data-entry errors.

This functionality is valuable

- for adding user and device data during initial system configuration (that is, when you are installing and configuring a new system).

- when you wish to add a large number of new users to an existing system database.

The data is entered into a Microsoft® Excel spreadsheet supplied with MiVoice Business (see Obtaining the Import Spreadsheet) and saved as .CSV
Comma Separated Values. A type of database file that separates data fields with a comma. files for import. You can also import an existing spreadsheet of configuration data in .CSV format provided it is in the appropriate format, as described in Import Spreadsheet.

## Requirements

- You need a Zip archive application like WinZip® installed on your client station in order to open the Import Spreadsheet form after downloading it.

- You need Microsoft® Excel 97 (SR-2), Excel 2000 (SP 3), Excel 2003 (SP 2) or higher installed on your client station in order to download and read the Import Spreadsheet form, and to manipulate the data to be imported to the system database.

- 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. In Microsoft Excel, select 'Unicode Text' instead of 'CSV (Comma Delimited)' from the Save As Type file-type list. Also ensure that the file extension is CSV not TXT.

- If using Internet Explorer 9 (IE9) on Windows 7, ensure that you have the corresponding 32-bit or 64-bit Java plugin installed. The version of IE9 installed with Windows 7 Pro is 64-bit.

NOTE: You may need to change the security settings in Internet Explorer to allow file imports. If you get a "C:\fakepath" or similar error message while attempting an import, 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.

8. Retry the file import.

Related Topics

- Overview of the Import Process

- About Importing User and Device Data

- Obtaining the Import Spreadsheet

- Collecting and Recording Data

- Creating an Import File

- Preparing an Existing Spreadsheet for Import

- Previewing and Importing the Spreadsheet

- Troubleshooting Import Issues