ETransL Technical: Load and Validate the Template Workbook

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

Image

Image

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 action ETransL will perform on the data. The following instructions are catered for:
      • SK - Skip - this is the only operation that doesn't take any other parameter
      • CO - Constant value
      • TX - TEXT Formatting
      • MC - Multiple Choice conversion
      • CF - Cell reference to transaction file
      • CM - Data read from cell in transaction file
      • IC - Incremental Counter
      • RW - Transaction file row reference
    • MetaData - varies depending on the operation
    • Length - The length of the processed output
    • Padding - The direction and character(s) to be used to pad the output to the desired length (or crop it if longer)
    • Output - Whether the result should be included in the transformation file
    • Data - The data that will be evaluation. How information included here is handled will vary depending on the operation.
  • For each column
    • If the trimmed Title is either blank or has already been used, log the error and stop further processing
    • If the Operation is invalid log the error and stop further processing
    • If the Operation is not SK,
      • If Output (case insensitive) is neither Y nor N, log a warning and set it to Y
      • If the first character of Padding (case insensitive) is neither L nor R, log a warning and set it to R
      • If Length is not a number or if it is less than zero, log the error and stop further processing
      • If Operation is MC or TX and Data is blank, log the error and stop further processing
      • If Operation is MC or TX and MetaData is blank, log the error and stop further processing
      • If Operation is MC and MetaData does not match the expected search / replace format, log the error and stop further processing


Join the effort ,;, Use the tool ,;, Spread the word

    Project Source and more @: https://www.github.com/chribonn/ETransL

Comments

Post a Comment

Popular posts from this blog

20150628 Giarratana Circular

Statistics Date: Jun 28, 2015 4:34 pm Distance: 15.21 km Duration: 2h:35m:36s Avg Speed: 5.87 km/h Max Speed: 7.40 km/h Min Altitude: 489 m Max Altitude: 594 m Ascent: 249 m Descent: 261 m Route Open route in new window: https://www.google.com/maps/d/edit?mid=z6HKMq7G_wEk.keh2K8cXD6Cc&usp=sharing Photos (Geotagged) Open photos in new Windows: https://plus.google.com/photos/105470926677245165774/albums/6166646868710719889
Read more

HOWTO setup OpenVPN server and client configuration files using EasyRSA

Image
Introduction OpenVPN allows client computers to tunnel into a server over a single UDP or TCP port securely. This HOWTO article is a step-by-step guide that explains how to create the server and client OpenVPN configuration files that makes this possible. In the process this article explains how to create the public key infrastructure (PKI) so that a client can securely communicate with the server. OpenSSL is the foundation for the security functionality of OpenVPN. For this tutorial you will need the following software: OpenVPN. You can download the latest version of OpenVPN from https://openvpn.net/index.php/open-source/downloads.html EasyRSA is the tool people use to create the Public Key Infrastructure (PKI) for OpenVPN. Download the latest release of EasyRSA from https://github.com/OpenVPN/easy-rsa/releases . There is not installation required. Extract the contents of the archive into a folder. OpenVPN is available on various platforms. The generation of the
Read more

How To Reset the firmware, wifi on GoPro Hero 3, 3+ and sync it with latest version of GoPro Quik

Image
Like others, I fished out my old Go Pro HERO 3+ and found that I could not link to it via WiFi because I had forgotten the password. A quick search on the internet and it seems that there are still many users of this good, albeit old Action Cam. Some had purchased one off eBay or from a second-hand shop while others, like me, found it in a drawer and decided to repurpose it. If the GoPro has not been used for a while it might not be on the latest firmware. Note that these models are no longer supported. The common thread is that without the Wi-Fi SSID and password, it isn't possible to control the camera from the phone using GoPro's Quik software. I referenced these sites: 1.  HERO3/3+ Information And Troubleshooting : This is an official GoPro Site from where you can download the camera firmware and update the camera Wi-Fi for the HERO 3 and HERO 3+. 2.  Software Update and Reset for GoPro Hero 3, 3+ and 4 : This is another source for firmware (covers more models) and there is
Read more