Fix errors when executing scripts with VBScript or Python variables

Problem

You write VBscrip or Python code using label variables. When your Loftware solution runs the script, you get an error message about missing variables or values not being set.

The error occurs because of optimization and performance reasons. Only initialized variables load when you run Loftware applications. All other variables have no values so in some cases, scripts can't execute. In Automation, your script often uses variables from triggers' data which are also not initialized.

Solution

By default, Loftware variable values load conditionally and variables are not used/called until later in runtime. Designer PowerForms initializes label variables and script variables but not the variables used in forms. Automation initializes only script variables.

With these solutions, you initialize all your variables at the beginning of script executions.

Solution 1

Edit product.config XML file:

1. Navigate to the Loftware System folder.

   %PROGRAMDATA%\Loftware\Loftware

2. Create a backup copy of product.config file.

3. Open product.config file in a text editor. The file has an XML structure.

4. Add the element IntegrationService/UseAllVariablesForScripting with value True.

   The file should have the following contents:

   <?xml version="1.0" encoding="utf-8"?>
   <configuration>
       ...
       <IntegrationService>
           <UseAllVariablesForScripting>True</UseAllVariablesForScripting>
           ... 
       </IntegrationService>
       ...
   </configuration>

5. Save and close product.config file.

Solution 2

• For VBScript:

  Add the comment at the beginning of your script:

  'NL-LoadAllVariables

• For Python:

  Add the comment at the beginning of your script:

  #NL-LoadAllVariables

  Example

  Code that causes an error:

  list_invert.Value = ",".join(str(x) for x in [y for y in [z for z in range(1, int(last_row.Value) + 1)] if y not in [int(element) for element in selected_rows.Value.split(",")]])

  Variables last_row and selected_rows do not have values until later in execution.

  Code that works:

  #NL-LoadAllVariables

  #Keep comment above to pre-load all Loftware variables

  list_invert.Value = ",".join(str(x) for x in [y for y in [z for z in range(1, int(last_row.Value) + 1)] if y not in [int(element) for element in selected_rows.Value.split(",")]])

Solution 3

Manually initialize your variables.

Variable123.Value = Variable123.Value

or

v123 = int(Variable123.Value)