TT(O)M

Quick overview The template workbook is the document that drives the ETransL engine. It is possible to have different templates processing the same transaction file. ETransL computing engine will, for each row in the transaction file, process the template, commencing at column B onwards until it encounters the first blank column. This module will: size arrays for the different parameters that will be read from the template file validate that all the columns in the template are valid populate the arrays with the read data. Flow Diagram Solution walk through Determine the total number of columns that are make up the Template Workbook. The starting position is user defined. Create arrays to store the different parameters that make up a single template column. The following arrays will be created: Title - Each column must have a unique title. This is because an operation may reference another column and the title is the way these can be uniquely identified. Operation - This describes the...

ETransL execution is as follows: Initialises the environment, reads from the Inputs  Worksheet the inputs and logs everything: Mandatory parameters: Transaction Workbook Name Transaction Workbook Sheet Template Workbook Name Template Workbook Sheet First Transaction Row Parameters that will be auto filled if left blank: First Transaction Row - Assumed to be ' 1 ' Last Transactions Row - Assumed to be ' 1048576 ' Template Start Row - Assumed to be ' 1 '  Transformation File - ETransL will set the name to execution date and time ( yyyyMMdd-hhmm.txt )  Log file name - ETransL will set the name to execution date and time ( yyyyMMdd-hhmm.log )  Append to Existing Log File - Assumed ' Y ' Read in and process the Template file. The template file is laid out in columnar fashion with each column representing a single operation. Operations are described in detail elsewhere. Different operations can take additional parameters.  The following parameters are associat...