Imports

What are imports?

An import is the operation that lets you automatically create, within Qboxmail systems, a list of domains and/or email accounts in bulk through a specifically formatted CSV file, making the process of adding a large number of domains and/or accounts simpler and faster.

Who can perform an import?

Imports can be performed by an Admin, a Team member, or a Manager authorized to manage domains.

What can be imported?

You can import domains, email accounts, domain aliases, email aliases, and their respective passwords. Each CSV file can contain up to 250 items.

Create a CSV file for an import

To perform an import, you need to create a specific CSV file by following the specifications provided in the 0-ITA-LEGGIMI-IMPORTAZIONI.txt file included in Imports.zip.

You can choose between a basic and an advanced import. Basic import lets you create Domains and Email Accounts by specifying only the name and password. Advanced import lets you specify additional fields in the CSV.

The field separator is ; (semicolon). You can also use a text delimiter if the password contains a special character or the field separator itself. The text delimiter is " (quotation marks). See the importazioni-delimitatori.txt file.

Import with password hashes

You can also specify a Hash in the password field of the CSV if you do not have the current password available. Hashes represent passwords in encrypted format, which is usually how they are stored in databases. Currently, you can enter these hash formats in the CSV:

• MD5-CRYPT
• SHA512-CRYPT

In this case, the password field must contain the name of the password scheme used enclosed in curly brackets.

• Example: {SHA512-CRYPT}$6$xVM3rIc...

You can also import many other types of Hashes. If the one available to you is not among those supported by CSV import, contact our technical support.

The complete list of supported hashes is shown below:

• BLF-CRYPT
• SHA512-CRYPT
• SHA256-CRYPT
• MD5-CRYPT
• CRYPT
• PLAIN-MD5
• SHA
• SSHA
• SHA256
• SSHA256
• SHA512
• SSHA512
• SSHA256.hex
• SSHA512.hex

CSV files for basic imports

To perform a basic import, you need to create a CSV file where each object to import is defined by fields, separated by the field separator ; (semicolon) and, if they contain a semicolon, enclosed by a text separator " (double quote).

Format for basic email account Import:

• 2 columns
• Email Account(required);Password(required)

Format for basic domain Import:

• 2 columns
• Domain(required);Postmaster password(required)

Format for domain alias Import:

• 2 columns
• Real domain(required);Domain Alias(required)

Format for email alias Import:

• 2 columns
• Email Alias(required);Recipients(required, max 20 separated by comma)

CSV files for advanced imports

For domain and email account imports, an advanced mode is available and can be selected when uploading the CSV file from the control panel. Advanced mode requires that optional CSV fields/columns are also present, even if empty. Therefore, in the CSV, when "advanced" mode is selected, the comma-separated fields must be present even if they are empty.

Format for advanced email account Import

• 5 columns
• Email Account(required);Password (required);First name(optional);Last name(optional);Forward(optional, max 20 separated by comma)

Format for advanced domain Import

• 3 columns
• Domain(required);Postmaster password(required);Manager codes(optional)

Run an import

To run an import, click Imports in the control panel sidebar, then click the + Import button and complete the steps in the creation wizard. Once the procedure is complete, the import will be visible in your imports list.

• Imports > + Import

1. Select the type of import you want to run.
2. Upload the CSV file you previously prepared.

To complete the procedure, click the Import button. Once the import addition procedure is complete, it will be visible in your imports list.

Imports list

The imports list contains all imports added to Qboxmail systems belonging to an Admin, with their detailed information. To view the imports list, click Imports in the control panel sidebar.

Information shown in the imports list:

• Import status.
• Name of the user who requested the import.
• Import code.
• Import type.
• Resources included in the import.
• Any errors in the import procedure.
• Date and time of the import or import attempt.

Delete an import

To delete an import from the imports list, click the Trash button next to the import, confirming the operation by clicking the Delete button in the modal.

Deleting an import that has already taken place deletes only the import record. If the import has already been completed successfully, the imported domains and accounts will not be deleted. If the import was only scheduled, deleting the record also deletes all the scheduling that had already been prepared.