You use Datacap Studio to
create the ExportDB ruleset. Also, you access the Datacap Studio actions library to
add functions to the ruleset.
To create the ExportDB ruleset:
- In the Rulesets pane, right-click
the TravelDocs node and choose Add
Ruleset.
- Rename the new ruleset from Ruleset1 to ExportDB.
- Rename the default rule from Rule1 to Export
Rental Agreement Data.
- Rename the default function from Function1 to ExportDB.
- Click the Actions library tab and
expand the ExportDB library.
- Select and add each of the following actions that are shown
in the following table to the Export Data function
by clicking Add to function. Then, set the
action parameters as shown in the following table.
| Action |
Parameter |
|---|
| ExportOpenConnection |
@APPVAR(*/exportdb:cs) |
| SetTableName |
Rental_Agreement |
| ExportBatchIDToColumn |
BatchID |
| ExportFieldToColumn |
Pickup_Date,Pickup_Date |
| ExportFieldToColumn |
Pickup_Location,Pickup_Location |
| ExportFieldToColumn |
Return_Date,Return_Date |
| ExportFieldToColumn |
Return_Location,Return_Location |
| ExportFieldToColumn |
Car_Type,Car_Type |
| ExportFieldToColumn |
Options,Options |
| ExportFieldToColumn |
Total_Cost,Total_Cost |
| AddRecord |
|
| ExportCloseConnection |
|
- In the Rulesets pane, click Save. Then,
click Lock/Unlock ruleset and choose Publish
ruleset.
