|
Create Fields From Database
option allows you to set up Field Extractor so that it will automatically create
the fields that you have in your database. The option is very useful if you have
a large database. Using this option you can automatically add the fields from
your database to Field Extractor instead if manually entering the settings for
each field.
To activate this option, select
Field Extractor ->
Create Fields From Database.
Create Field(s) window
will be displayed.
Click Select Database
button to select your database.
If you have several tables in your database, select the name
of the table in the Table Name field. You
will see the fields of this table on the screen.
ATTENTION!
|
|
If a field name appears marked by
red, it means that you use the program's reserved fields. Reserved
keywords are part of the grammar of the Transact-SQL language used by G-Lock
Email Processor.
If you are going to set up Database Manager, you should
change red field names in order to avoid errors. You can use lowercase and
uppercase letters, numbers from 0 to 9 and the underline _ symbol, for
example:
Date -> DateM
From -> From1
To -> To_ |
Database Field Name
shows the fields from the selected table. You can delete a field you do not want
to add to Field Extractor. To do this, select the appropriate string and press
Delete on the keyboard.
GEP Field Name
specifies the name of the appropriate field in the Field Extractor.
Search String (Start After)
specifies the text after that the program will search for the appropriate field.
Field Data Type
specifies a type of the field from the selected table.
If you click the right mouse
button on any string in the table, you will display the popup menu with the
following options:
Edit GEP Field Name - use this option if you want to edit the name that
the program assigned to the appropriate field from the database.
Edit Search String - use this option if you want to edit Search String.
Select All - allows you to select all the fields from the database.
To set up Field Extractor, click
Create.
|
