Views:

Question:
What do I have to consider when using ACTIVE IMPORT?

Answer:

  • If you import an HTML e-mail in original format in your file cabinet with ACTIVE IMPORT this e-mail is converted to an RTF file. This is because MAPI doesn´t provide a complete support of HTML.
  • Every ACTIVE IMPORT job opens a separate database connection. This involves a certain number of licenses, depending on the number of ACTIVE IMPORT jobs and on the database type. Take note of this above all if you only have a limited number of database licenses.
  • ACTIVE IMPORT cannot search for empty database entries (SQL_ZERO), which is why these entries cannot either be used as match code.
  • ACTIVE IMPORT uses the following ID/registration to access SQL tables:
    1. Registration with full user name; if registration does not work
    2. Registration with UserID; if registration does not work
    3. User name and password of the DSN Configuration if available; if registration does not work
    4. The ODBC registration dialog box opens.
      Several ODBC drivers, such as MS SQL Server, won’t allow you to store a user name and password in the DSN. In this case, the third point above will not function.
  • Please note that if you select/use a very large text file (> 10 MB) as a database for index enhancement, you may experience a noticeable time delay.