Data field markers are used in a variety of different locations for specific purposes. The way to place a marker is an enclosed field name within a surrounding pair of markers. The way to set a data field marker is described here. The fields that could be used relate to the system set of fields,
Data fields can come from records from the data source. Each field can be marked in the templates, file paths and other outputs. For outputting data records, the best place to show the data is on the record template. Here each row of data will have its values put into the record template and the
A data source could be an Excel or similar spreadsheet where the data source is either an OleDB Jet connection for.xls files or and OleDb ACE for .xlsx files. We use these files using either the ODBC data source or the OleDB data source. To use you will have to have the appropriate software installed,
Using any ODBC data source and select statement, you can provide the data records to the transformation templates. you can use an SQL statement to get the data for the records passed to it. The dialog window looks like this. Connect String The connect string at the top tells the application how to get to
Using an OleDB data source and select, you can provide the data records to the transformation templates. you can use an SQL statement to get the data for the records passed to it. The dialog window looks like this. Connect String The connect string at the top tells the application how to get to the
You can use a text file as a data source by selecting Delimited file in the Data Source Dialog drop down for Data Source. A text file can be a data source if it meets certain conditions to allow the Windleafe application to find and use each data field with each ‘line’as a record It
The windows file system files in a directory or folder can be a data source for generating records, one per matching file. To set this once you have chosen File System as a data source type, find the folder that you’d like to report on by browsing to the folder or typing it in directly.
This is how you will get the records or rows to generate the output using the templates You will need to pick a type of data source from the drop-down list, then fill as much detail as the type of source needs to allow a connection to the data. Each source will have different settings
Data sources are where you set where you get your data records from There are a number of data sources that are used, each with its own requirements and quirks The main types used are : A text file, also known as CSV or flat file Data is separated by a delimiter like a comma,
The other dialog windows cover a variety of functions