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 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