Translation

MailRules can use a datasource definition to copy data from your datasource into either a Microsoft Access Database, a user-defined delimited file (such as a .csv) or an ODBC Source, this process is known as Translation. This feature can be activiated via an Inbound Rule or by the saving of an Advanced Outbound Rule at the remote MailRules destination.

The datasource export option is available only after a datasource has been created and saved by the user. After a datasource has been defined, reviewing the Properties of a datasource will reveal the Translation button. Click Translation to access the Translation Definition screen.

Translating the Datasource to a Microsoft Access database

1. Select MS Access DB as the translation type.
2. Locate the destination database using the browse button. MailRules will display the names of the tables it finds in the database.
3. Select the destination table from the Table listing. MailRules will display the names of all the fields in the table.
4. Link your fields. Click on a field in the Datasource field listing and click the destination field in the table field listing. Click the Link button. The Link Details tab below will show the link you have selected. Confirm this link by clicking the Set button. Repeat this step for each field you require.
5. Click Save to save your changes.

Translating the Datasource to a comma separated file (.csv)

1. Select CSV File as the translation type.
2. In CSV Filename enter the file that will be used at the destination for the translation.
3. Decide what you want to do in the event that the file already exists. Select Delete file to delete the existing file or select Autoincrement filename to append a number to the filename to create a unique filename.
4. Enter the character that should be used to separate the fields in Field Delimiter (a comma is normal).
5. If desired, enter the character that should be used to wrap text fields in Text Qualifier (quotation mark is normal).
6. Click Save to save your changes.

Translating the Datasource to an ODBC source

1. Select ODBC Source as the translation type.
2. Locate the destination ODBC Source using the browse button. MailRules will display the names of the tables it finds.
3. Select the destination table from the Table listing. MailRules will display the names of all the fields in the table.
4. Link your fields. Click on a field in the Datasource field listing and click the destination field in the table field listing. Click the Link button. The Link Details tab below will show the link you have selected. Confirm this link by clicking the Set button. Repeat this step for each field you require.
5. Click Save to save your changes.