Import CSV
Import CSV |
|
|
The DV2000/DV4 allows you to import a list of mailboxes from a simple comma-separated value (CSV) file, which you should be able to export from any spreadsheet program.
The advantage of Mailbox Import is that you can plan out all of your mailboxes in a simple spreadsheet and then add them en masse using this feature, rather than having to add them one at a time.
CSV File FormatThe CSV file may be created using any standard text editor (such as Notepad) or may be exported from a spreadsheet program. Save the file with the .CSV file extension.
Note: If you are using MS Excel, save the file by selecting File | Save As and in the Save as type selection box, choose CSV (MS-DOS). For LibreOffice Calc, select File | Save As and in the Save as type selection box, choose Text CSV (.csv) (*.csv). For a Google Drive spreadsheet, select File | Download as | Comma Separated Values (.csv, current sheet). Note: The output of the mailbox export function (whether run on the same or any other compatible DV2000/DV4 system) is 100% compatible with mailbox import. So you can, for example, create a set of mailboxes on a test system, export them to CSV and then import them onto a customer system.
As with any CSV file, each line represents a single record. In this case, each line (except the first) represents a single mailbox or group of mailboxes. The first line is always used to tell Mailbox Administration what each column (or field) represents. The following table defines the valid column names. Note that they are not case sensitive, nor is there a required field order.
Data fields may be enclosed in double-quotes, but it is not required. Every line must have the same number of commas, even if some fields are left blank (see examples below).
Example MAILBOX,TYPE,FIRST,LAST,RANGE START,RANGE STOP 300,,John,Smith,,, ,Guest,,,601,609
In this example, the first line specifies the column names: mailbox number, mailbox type, first name, last name, and the start and end range values. The first record creates a single mailbox, 300, with the first name John and the last name Smith and all other settings defaulted. The second record creates 9 guest mailboxes, numbered 601-609, and uses the appropriate defaults for all other settings.
Note: If no mailbox type is specified in the CSV file, the system will create a standard mailbox by default.
Mailbox Import DialogTo open the Mailbox Import dialog, select Mailbox | Import CSV from the main menu.
Initially, the dialog will appear empty, with most options grayed out, as shown above. To open a CSV file, click the Load File button.
Navigate to the folder you placed the CSV in and select the file. Click Open to load the file into the Mailbox Import dialog, as shown below:
The lower portion of the dialog displays in tabular form all mailboxes that can be created based on the data contained in the CSV file. Each row in the table represents one possible mailbox, including the various configuration settings to be used in creating that mailbox. (Any column left blank will use the default setting appropriate for the given mailbox type.)
Note that each row has a check box in the mailbox column; the given mailbox will only be created if the box next to it is checked. To check (or uncheck) all rows at once, check (or uncheck) the box labeled Toggle immediately above the table of mailboxes. Otherwise, you can pick and choose the mailboxes to create by checking or unchecking the individual check boxes.
Creation OptionsFive other settings are provided to further customize how the mailboxes are created.
|
