F.A.Q. about Advanced Direct Remailer. Databases.
|
30. What are the mailing lists with .SQL extension? This list is a mailing list which is formed by database SQL-request on fly. File with SQL-request have to be added to mail box instead of mailing list; it should have .SQL extension and the following format:
<ODBC Data Source>, <Username>, <Password>, <SQL Transaction> If access to ODBC data source doesn't require the username and password, leave these fields blank. For example:
Customers,Admin,KmiaN82,SELECT email FROM customers WHERE account>3000 FromSQL,,,SELECT name,'<'+email+'>' FROM customers WHERE email<>NULL SQL-request can return a several columns, in this case the column values will sequentially form the mailing list line. The space character is used as separator for columns. The result of SQL-request is the list with the same limitations as a simple text mailing list. This list can contain only emails, but it can contain real recipients names to fill in "To:" field as well. |
|
31. Can ADR perform a personified mailing by database? Use SQL-lists together with FromSQL plugin for full-function merge of mail delivery and database. The FromSQL plug-in expand macros in letter which play a role of template with information from database. Build SQL-request to extract information from database, its parameters will be replaced by email address of message recipient. See "About FromSQL plugin" article in program help system fot details. |
|
32. What databases ADR can work with? ADR works with databases through ODBC SQL. So it can work with any DBMS which have ODBC drivers. For example, with Microsoft SQL Server, Oracle, MySQL. There are ODBC drivers even for structured text, Microsoft Excel documents and etc. |
|
33. How to mail by Microsoft Excel document? ADR works with databases through ODBC SQL, and Microsoft Excel document may be used as a data source. For that ODBC drivers for Excel (from Microsoft Office) must be installed, of course. Choose "ODBC Data Source" item in "Control Panel". Choose Excel driver and create user DSN. Before using such document as database table, give a name for each list area which plays a part of table ("Insert" -> "Name" -> "Define"). The names of table columns are the values of the first cells of named area (e.g., A1, B1, C1 cells). You can use SQL format of mailing lists for extraction addresses from Excel file during mailing. See "About FromSQL plugin" article of program help system for details. |