Working with python

Download and install python from https://www.python.org/downloads

To avoid issues install it for all users

Our software automatically detects the version of python installed, and loads relevant DLL.
32-bit version of our software uses the 32-bit version of python and
64-bit version of our software uses the 64-bit version of python

Here is a very basic example where we are converting a string into the upper case using python

Using scripts is the slowest way to transform the data and it should be avoided.
If you do not know how to transform the data ask the question here and we will help you.

The script checks a number of the day and shows an appropriate message

The execution result is determined by Result.Value, Result.Value=1 means success and Result.Value=0 means failure

“etltools” package provides a way of communication between python and our software.
It is only available when python is run from our software.

etltools.GetVariable('<VariableName>')
etltools.SetVariable('<VariableName>','Important Value')
etltools.WriteToLog('Important Message')
etltools.ExecuteObject(ObjectID)

Use ExecuteObject to execute object from the script inside the package

It returns the result of the package/transformation execution that was called.

• 0 = success
• 1 = failure

• Extracting text from PDF file
• Extracting data from PDF tables
• Extracting Information from MSG Files

Advanced ETL Processor Professional and Enterprise Documentation
Visual Importer ETL Professional and Enterprise Documentation