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:
- Registration with full user name; if registration does not work
- Registration with UserID; if registration does not work
- User name and password of the DSN Configuration if available; if registration does not work
- 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.