After you have configured the connector and the template files, you can start the connector, and verify that the data is extracted successfully.
To start the connector
connector_EXAMPLEDATABASE_datastore.db
. Deleting this file resets the connector so it retrieves the same data again (the data in the database has not changed).To verify that the data has been extracted successfully, open the file database_records.idx
, in the CFS installation folder. The new information should now be included in the document, for example:
#DREREFERENCE 012345 #DREFIELD OrderDate="16/10/2012 15:27:11" #DREFIELD Customer="2563" #DREFIELD Status="Order complete" #DRECONTENT Order information Date Received: 16/10/2012 15:27:11 Status: Order complete Customer information Name: Mr. John Smith Address: 1234 North Road, Cambridge, POST1234 Items ITEM 5001, Item 5001 description, QTY 1, £399 ITEM 5002, Item 5002 description, QTY 1, £29 #DREENDDOC
The main template and the two sub-table templates (for customer information and item information) have been combined and used to generate a single document.
In this example, the Item Details query has also returned two rows from the combined Items
and Products
tables.
|