# 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

1. Ensure you have obtained the directory database data in CSV format.

2. 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).

3. 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.

4. 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 | jon@ab.com | jsmith@ocs.ex.com
4d27aa3f | Pardos, Bob | 1123 | Yes | Sales | Phase 2 | 97271234 | bob@ab.com | bpardos@ocs.ex.com
dola1d41 | Lee, Kim | 1201 | Yes | Marketing | Phase 2 | 8881234 | kim@ab.com | klee@ocs.ex.com
5f0d1bc6 | Gilles, Pierre | 1222 | No | Receiving | Courtyard | 97266464 | pierre@ab.com | pgilles@ocs.ex.com

Parent topic: Standalone ADF
↑