CSV Files for Mailbox Import

CSV files for mailbox import must meet special requirements.

To ensure that an external CSV file containing mailbox information can be imported into the Control Panel without errors, rules regarding the file extension and content structure must be observed.

Rule for the file extension

  • The extension of the import file is .csv. Other file extensions, such as .txt or .docx, will not be accepted.

Rule for columns and rows

  • The CSV file contains three columns separated from each other by a semicolon.
  • The first row contains the column names. The first column is for primary mailboxes, the second one is for alias mailboxes and the third one is for the environments of the mailboxes.
  • The rows of the CSV file end without any punctuation sign.

Column names:

name;aliases;environment

Rule for the formatting of mailbox addresses

  • The mailbox addresses are correctly formatted (according to the pattern "local-part@hostname.top-level-domain").
    Important:

    Incorrectly formatted addresses are not considered during the import.

  • The mailbox addresses belong to domains that have been defined for the customer in the Control Panel.
    Important:

    Mailbox addresses from other domains are not imported into the Control Panel.

Rule for primary mailboxes

  • From the second row on, the CSV file contains an address of a primary mailbox in each row of the first column.
  • The first column must not be empty in any row.

Rules for alias mailboxes

  • From the second row on, the addresses of alias mailboxes defined for the primary mailboxes listed in the left column can be entered in the second column.
  • In case of primary mailboxes that do not have any alias mailbox assigned, the second column remains empty.
  • If a cell in the second column contains several alias mailboxes, the addresses are separated from each other with commas.

Primary mailbox without an alias mailbox and with the primary environment:

primarymailbox@only.com;;primary

Primary mailbox with an alias mailbox and the primary environment:

primarymailbox@example.com;aliasmailbox@example.com;primary

Primary mailbox with several alias mailboxes and the primary environment:

primarymailbox@example.com;alias1@example.com,alias2@example.com;primary

Rules for environments

  • From the second row on, the third column contains the names of the environments that shall be assigned to the mailboxes listed in the left column in the Control Panel.
    Note:

    The environment determines to which destination server the inbound email traffic of a mailbox is routed (see Secondary Environments).

  • Each row contains the name of an environment. For the primary environment, the name primary is used. For secondary environments, the name under which the secondary environment is displayed in the Control Panel is used. The names of the environments are not case-sensitive.
    Important:

    Records with secondary environments can only be imported from a CSV file if the secondary environments have been previously created in the Control Panel (see Creating a Secondary Environment).

  • The third column must not be empty in any row.

Primary mailbox with an alias mailbox and the primary environment:

primarymailbox@example.com;aliasmailbox@example.com;primary

Primary mailbox with an alias mailbox and a secondary environment:

primarymailbox@example.com;aliasmailbox@example.com;environment 2

Rules for duplicated entries

  • Duplicated entries do not affect the processing of the CSV file, but should be avoided.
  • The file must not contain multiple rows that share the same content in the left column but have different content in the other columns.
Important:

Rows with the same primary mailbox are not imported if the CSV file contains another row with the same primary mailbox but with different alias mailboxes or a different environment.

Invalid rows with the same primary mailbox, different alias mailboxes and the primary environment:

primarymailbox@example.com;alias1@example.com,alias2@example.com;primary primarymailbox@example.com;alias3@example.com;primary