|
|
|
|
The file you have selected is loaded into the MAP Datasource Wizard for you to define the fields that will instruct MailRules how to interpret the file.
There are two methods of defining fields:
The first thing you must do is indicate the method you will use by clicking either Text or Line. Use Text where only part of a line contains field data. Use Line where an entire line of the file contains field data.
Using the mouse, highlight whatever prefixes your field data. Whatever you have highlighted will be copied into the Original Field Name and New Field Name. If you would like to refer to this data by some other name, you can amend the New Field Name. Note that Field End Marker will default to {Line End} thereby taking all data from the end of your highlighted area to the end of the line. However, if your data has some alternate field markings (for example, XML tags) then you can replace {Line End} with whatever your end of field marker happens to be.
Once you are content that you have marked the field identifier and provided a suitable field name, click Set Field. You can now mark any other fields in the same manner.
Click the Show Fields button to display a list of all fields defined.
Using the mouse, click whichever line contains the data. As you do this, you will notice that Original Field Name and New Field Name are set to <<LINE(x)>> which indicates the line number you have selected. It is recommended that you provide an alternative field name by amending New Field Name to be something more meaningful.
Now click Set Field to save this line specification. You can now mark any other fields in the same manner.
Click the Show Fields button to display a list of all fields defined.
Option |
Description |
Datasource Name |
Here you should allocate a unique name for the Datasource. The name should be as meaningful as possible for you to enable easy identification. |
Remove Source Data |
The practical use of this feature is where you are generating data dynamically and you wish to clear it each time. For example, you may have a text file populated with data from a webpage containing e-mail addresses and files to e-mail to that recipient. After each individual dispatch of the Outbound Rule, the Datasource will be cleared so that you do not send the same information twice. This option should be used with caution as selecting this will remove all the data from the file that you are using to create your Datasource. If you are using a contacts database for example, you will clear all the data held in the table you are using to create the Datasource. Similarly any Excel worksheet will have all the data removed from it. In the case of Access or Excel, the table, worksheet or named range will remain but will be empty of any data. In the case of a text file, you can chose to delete the source file or just empty it of data (leaving either a file with zero bytes or a file with just the field names). Disclaimer: Responsibility for the safe use of this feature lies with the user. Computer Works will accept no responsibility for any data lost as a result of using this feature. However, MailRules 2.01.0040+ provides a limited safeguard against accidental destruction of your data - in such an event, contact MailRules Technical Support using the Help menu - but having said that, we make no guarantees that we can recover your data and ultimately the responsibility lies with the you, the user. |
Filename |
This shows the name and location of the file that this datasource will be applied to. Advanced Users may find it useful that it is possible to use the standard wildcards characters * and ? into the filename. For example, if the filename were set to c:\mydata\data?.txt then files named c:\mydata\data1.txt, c:\mydata\data2.txt would be processed by the datasource. This feature is intended to be used in conjunction with the Export feature. |
Original Field Name |
This will be the area highlighted in Text mode or the line number in Line mode. |
New Field Name |
This field allows you to define your own field names, as opposed to those detected by MailRules. |
Field End Marker |
The text contained in this box informs MailRules what text will define then end of the field. By default this is set to {Line End} which refers to the end of the selected line. |
Text |
Use this to indicate to MailRules that your next field definition will be in text select mode. |
Line |
Use this to indicate to MailRules that you next field definition will be in line select mode. |
Set as Field |
When a field definition is complete, clicking this button will store the definition. |
Show Fields |
This button will display the field list that accompanies this datasource. |
Save |
Save your changes and exit the Map Wizard. |
Cancel |
Abandon your changes and exit the Map Wizard. |
Remove |
Removes the currently selected field from the datasource definition. |