Technical: ETransL High Level Technical Overview



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 associated with each operation:
      • Title: MANDATORY / UNIQUE – All operations except ‘SK’ generate output and this output must be referenced by it’s Title.
      • Operation: MANDATORY / ONE OF [CF, CM, CO, IR, MC, RW, SK, TX)  – Describes an action to be performed by ETransL.
      • MetaData: MANDATORY depending on operation
      • Length: MANDATORY must be >= 0. If the value is zero, ETransL does not attempt adjust the computed result. A length other than zero will pad or trim the result so that it the desired length (see Padding).
      • Padding: MANDATORY defaults to R. If the length of the result is less than length the output needs to be padded. Padding is made up to two components:
        • L or R to describe where characters are to be added to the result (L = Left, R = Right)
        • The characters to be used as padding. If unspecified the default is set to <space>. Padding characters can be longer than 1 character.
      • Output: MANDATORY (defaults to Y)
      • Data: MANDATORY depending on operation
      • Notes: These are not referenced by ETransL
    • Total Rec Len: This is not referenced by ETransL. It is used to provide an indication of the output.  The value is computed by totalling the Length row of all those operations that have Output se to 'Y'.

  • Execute the Template file for each row of the Transaction file
    • Write the output to the transformation file
  • Close the log and transformation files
  • Alert the user that the processing has finished

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 clone and synchronise a GitHub repository on Android

Image
Introduction This project describes how I synchronise my  LogSeq  folder on GitHub on Android devices. I wanted to be able to work on topics in LoqSeq on my Android devices besides my PCs. Most of the screen shots and references relate to LogSeq, but you can adjust them to your needs. The solution described here is one in which the synchonization with the repository will be manual. In this scenario, one would synchronise with the repo before opening the tool (LogSeq in my case) and update the repo again when you're done. The Steps ( skip if you want to jump directly to the actions ) This tutorial describes how to install  Termux  on an Android device.  Termux  is an open-source Android terminal emulator and Linux environment application. After Termux is updated and running, a folder on the Android device is mapped to Termux.  GitHub  is installed, and the repo is cloned to this folder. The Termux folder used for the repo has to be  refle...
Read more