TT(O)M

Clarification There are many ways to distribute Python solutions, and this describes one method. For more information on alternatives, jump to the end of this article. Assumptions [DEV] and [PROD] are used to represent the development and production environments. The code is transferred from the [DEV] to the [PROD] environment. The solution will be run when no one is logged into the computer (via Windows Task Scheduler). Also, the [PROD] environment is a server environment where certain restrictions may apply. The account of the installer may differ from the account running the code. A requirements.txt file was created on the [DEV] side. If you are not familiar with this file and its purpose, visit https://www.freecodecamp.org/news/python-requirementstxt-explained/. The command is: pip freeze > requirements.txt During development, unused packages can accumulate in requirements.txt . This can occur, for instance, when evaluating similar packages. These redundant packages i...

The journey In the 1950s and 1960s, computer systems came bundled with source code that had to be compiled. Because of the high acquisition and operation costs of computers, only universities and large companies could afford them. These same entities had the resources to find and fix bugs in the code and add functionality to meet their needs. Rather than keep these changes close to their chests, a sense of community emerged wherein the source code with code adjustments was shared with others. The idea lies in the sharing of knowledge. As the number of users and the contributions increased, it became necessary to catalogue and coordinate these contributions, and repositories were created. These repositories allowed users to search for code that added new functionality or corrected a bug. The community would iteratively take the code and compile it on their systems. If they improved the code, they would upload these improvements to the repositories, benefiting others. Placing code in t...

  This utility will allow you to generate a password based on the symbol sets you specify and desired length. The password is copied to the clipboard for easy pasting. Property Details Password Length From 1 to 100 Use Numbers Generated password may include [0-9] Use lower letters Generated password may include [a-z] User upper letters Generated password may include [A-Z] Use special characters Generated password may include [`~!@#$%^&*()_-+={}[]|:;"'<>,.?/] Force 1st char as number / letter The first character of the password cannot be a symbol Avoid confusing characters The password will not include the following [lIO01] The Generate Password button is used to produce a new password. On Windows and Mac systems the generated passwords are automatically copied to the clipboard making the copy icon redundant. On Linux systems a  Not implemented error  could be thrown. The utility should work around this limitation. For information on how to install this functiona...

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 is  ETL  engine that converts data imported into Microsoft Excel to fixed or comma delimited text. ETL stands for extract, transform, load. It is the general procedure of copying data from one or more sources into a destination system which represents the data differently from the source(s) or in a different context than the source(s). It is often used in data warehousing.   Wikipedia page ETransL is an Excel VBA script that applies a template workbook to a transaction workbook to produce a text file that can be processed further on. The ETransL workbook is the computing engine of the solution. Through it one specifies: The Transaction Workbook & Worksheet The Template Workbook & Worksheet ETransL reads the Template file and applies the instructions in it on the Transaction File. The Transactions The Transaction Worksheet contains the data that will be transformed. The data can be any source that can be pulled into Excel. The name of the Transaction Workbo...

ETransL is  ETL  engine that converts data imported into Microsoft Excel to fixed or comma delimited text.   We would like to develop this tool further and can only do so with   YOUR   help. Read the tutorials and Beta test ETransL by applying it to your data transformation projects. Is there a function not catered by ETransL. If its not on the wish list suggest it. We will evaluate al requests. Want to join the development effort. We are looking for: Github gurus VBA developers Documentation authors Social media influencers ETransL specialists to create use cases. Want more information? Stuck? Reach out. Visit:  ETransL GitHub page