Importing contentACCESS configurations from files

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.

warning

Important!!! When importing Email archive and Email restore configuration sections, it is highly recommended to define the mailbox folders to be imported with wildcards (e.g. %INBOX%). Wildcards ensure, that the given mailbox folder (e.g. the “INBOX” folder) will be processed regardless of the language settings of the mailbox. This is important mainly for companies who archive mailboxes using different languages.

Since the backslash ““ is used as path separator, it can’t be used in folder name. If you want to include or exclude a folder which contains backslash in its name, enter it with “_|_” instead of ““.

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:

16. 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:

30. 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:

40. The root folders used in File Archive may be also imported into contentACCESS from files (read more here):

41. Servers/groups/mailboxes can be imported from files to the contentACCESS Address book using options “Import servers manually”/ “Import groups manually”/ “Import mailboxes manually” on the respective tabs as well (read more here):

To import a file follow these steps:

• Click the import button on the respective configuration page. The importer dialog opens.

• 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.)

  

• Further specify how the selected file should be imported. Choose one from the 3 available options (the available options are configuration specific, not all are available by all configurations):

  Make a new list, delete all existing items – select this option to create a completely new list of items; any already set items will be deleted

  Skip existing items, import new ones – select this option to add the new items from the list; the already configured items will be skipped

  Update existing items, import new ones – this option is available for importing root folders from files; it can be applied if the password has been changed and should be updated

• 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.