# Import/Export a Distribution List

Distribution Lists can be imported or exported in CSV format.

This procedure assumes that Distribution Lists Configuration has been completed.

## Importing Distribution Lists

To import a Distribution List:

1. From the navigation tree, click Mailbox Maintenance, and then click Mailboxes.

2. Search for the mailbox you wish to update.

3. Click the mailbox link OR select the mailbox in the list, and then click Edit. The Mailbox data view is displayed (Basic view).

4. Click Advanced.

5. On the Per Dist Lists tab, select the Number of the distribution list you wish to update.

6. Click Import List. The Import Distribution List window appears.

7. Click Choose File and browse to the location of the Distribution List.

8. Select the file, click Open and then click OK.

9. The Distribution List is now imported into the system.

## File Import Error Report

If you attempt to import a Distribution List that contains an error such as a non-existent mailbox number, the invalid data will be excluded and a dialog will display alerting you to the fact that an error report was created. You can access the report immediately by clicking the Download Error Report button and following the prompts or you can view the report at a later time by logging in to the system using SSH/PuTTY and then downloading the Distribution_list.txt file from the following location: /usr/vm/log/. The report lists the total number of "successful" and "unsuccessful" records that you have attempted to import and provides an explanation for each unsuccessful record (for example, "Does not exist", "Invalid type", etc.).

## Exporting Distribution Lists

Distribution Lists can also be exported to a specified location. Exporting a Distribution List does not remove it from the system; it is still available on the system from where it was exported.

To export a Distribution List:

1. From the navigation tree, click Mailbox Maintenance, and then click Mailboxes.

2. Search for the mailbox you wish to update.

3. Click the mailbox link OR select the mailbox in the list, and then click Edit. The Mailbox data view is displayed (Basic view).

4. Click Advanced.

5. On the Per Dist Lists tab, select the Number of the distribution list you wish to update.

6. Select a Distribution List to export.

7. Click Export. The File Download window appears.

8. Click Save and then specify a location for the file.

9. Click Save again.

10. The Distribution List is now exported to the specified location.

You may now modify the list in a speadsheet application such as OpenOffice Calc. You can add, delete and update data.

Note:

- The CSV file name has the following format: DL_<mailbox_number>_<DL_number>.csv

- The CSV file has two columns:

  - Type: The item type (Mailbox, Personal Distribution List, System Distribution List, AMIS Analog, Phone Number, Remote Mailbox on Network, Remote Mailbox). The records in this column do not need to be in any particular order. For example, Phone Number entries can be listed before Mailbox entries.

  - Number: The mailbox and distribution list number.

- As a minimum, the CSV file requires one entry (a single complete row in the file).

- When you import a CSV file, matching entries will be overridden to avoid duplicating data.

- The CSV file requires valid data. For example, you cannot import an entry for a mailbox that does not exist. Nor can you import an entry with non-numeric characters.

- The Distribution List export/import feature is supported only in the NuPoint Web Console. It is not available in the Text Console or Web View.