Create an ADF Data File

To use the Additional Database Field (ADF) functionality, you must have an external comma separated value (CSV) data file that contains the raw data for your directory database and an additional mapping file that enables the console to interpret the raw data values in the Data file.

The CSV data consists of a series of records, one per line, where the data fields are separated with a comma.

Once you have obtained and verified the CSV file of directory data, you can create an ADF Mapping File.

Obtaining and Verifying the Data File

Directory data may be exported in CSV format from the MiVoice Business ESM Telephone Directory, the ESM Phonebook Directory or saved using another database, spreadsheet, email, or contact manager application.

To create a ADF files from a MiVoice Business export, see Create Phone Book Directory based ADF files.

The Data file can have one or more optional column header lines; however, the Mapping file reads only the data after the column header line(s).

To verify a Data file

Ensure you have obtained the directory database data in CSV format.
Verify that the Data file meets the following requirements:
- It has complete data to meet the mandatory field requirements.
- It contains a maximum of 130,000 directory records.
- Each directory record is contained in one line and has a maximum of 30 fields.
- Each data file field has a maximum of 130 characters, including any double quotes (for example, " " equals 2 characters).
- The size of the data file does not exceed 30 MB (to avoid out-of-memory errors).
Save the file in CSV format with any name you choose. You may wish to use a name that makes the Data file easily recognizable, for example, Directory_Data.CSV

You may be prompted to confirm that you wish to save in CSV format.

Note: When you are ready to specify the Directory File names and paths, it is recommended that you save both the Mapping file and the Data file together in the same directory.
Proceed to specify the directory file names and paths.

Example Data File

The following illustrates a data file with the first row as a column header.

Note:
If the data file has a column header line, then the mapping file must be configured to ignore this line.

Unique ID	Full Name	Extension	DN Privacy	Department	Location	Cell	Email	IM
aa08874b	Smith, Jon	1134	No	Research	Lab 6	8886666	[email protected]	[email protected]
4d27aa3f	Pardos, Bob	1123	Yes	Sales	Phase 2	97271234	[email protected]	[email protected]
dola1d41	Lee, Kim	1201	Yes	Marketing	Phase 2	8881234	[email protected]	[email protected]
5f0d1bc6	Gilles, Pierre	1222	No	Receiving	Courtyard	97266464	[email protected]	[email protected]

↑