contentACCESS allows to import data from files in the following available file formats: CSV, XML, Tab delimited files and Space delimited files. This simplifies adding of huge amount of data to different configuration sections in contentACCESS instead of entering each entry manually. There’s an option to set if we want to overwrite the existing items, update or skip them. The user may also download a sample file to check if the file that he wishes to import contains all necessary information (column) for the given configuration section. Column names are displayed in the sample file if the “First row is header” option is turned on in the respective importer dialog.

After browsing the file to be uploaded and configuring the importer, the file can be uploaded. After the initial upload, the file’s columns can be mapped to the importable entry’s fields by dragging the column headers. When the mapping is finished, the newly imported entries will be added to the configuration section.

contentACCESS allows to import the folders to be archived/restored/recovered/excluded:

1. to File archive, File restore, File recovery jobs
   The import option is available on the respective job configuration page, under sections “Folders to process” and “Exclude folders”:


An importable file with Folders to process contains the following rows:

Root – mandatory
Relative path – nullable

Example in case of a CSV file:



An importable file with Folders to exclude contains the

Exclude pattern, e.g. if folder called “test” needs to be excluded, the CSV will look like this:


2. to Email archive, Email restore, Email recovery jobs
   The import option is available on the respective job configuration page, under section “Exclude folders” and “Exclude addresses”:


An importable file with Excludable folders contains the Exclude pattern, e.g. if mailbox folder called “test” needs to be excluded, the CSV will look like this:



An importable file with Exclude addresses contains the:

Address(es) to include
Exclude type(s) – Sender/Recipients/All

Example in case of a CSV file:


3. File Archive provisioning job (used to synchronize the users in the Active Directory with contentACCESS) also uses this feature to import the objects to be provisioned:


The importable file must include the:

Name
Object type

Example in case of a tab delimited file:


4. The root folders used in File Archive may be also imported into contentACCESS from files (read more here):
   
5. Servers/groups/mailboxes can be imported from files to the contentACCESS Address book using options “Import servers manually”/ “Import groups manually”/ “Import mailboxes manually” as well (read more here):
   

To import a file follow these steps:

From the Import method dropdown list select an import method to be applied (in our case CSV) and download a sample file using the Download sample option. Based on the sample file, prepare the file to import and verify if your prepared file contains all necessary information for the respective configuration section.

Further click “Browse” and locate the file to be imported. (On the picture below we have selected a CSV file.)

Depending on the selected import method, the user is further required to specify the following settings:


In case of CSV:

Specify the CSV separator (in our case it is a comma). If the first row in the CSV file is a header, mark the respective checkbox. Further specify the escape character, if such exists in your CSV file (in our case quotation marks)

In case of Tab delimited file
If the first row of the file is a header, mark the respective checkbox. Further specify the escape character, if such exists in the file.

In case of Space delimited file
If the first row of the file is a header, mark the respective checkbox. Further specify the escape character, if such exists in the file.

In case that the file to be imported is an XML, no further settings are required.

• Click Upload selected file to upload the file with the desired items.
  
• Click “OK”. The list of imported items will be added to the respective section.

  In a file containing multiple columns the user may specify, which column should be imported. Simply drag and drop the column header (on the picture below the Database ID header) over the respective column that should be imported.