Creating and Executing Scripts

Last updated on 2025-09-03

Overview

In the Scripts workspace, scripts can be created, edited, and executed.

Scripts can be used to read out, change, augment, and import data from different systems. Each script contains all instructions required to execute a specific task (e. g. import data into Lucanet.Financial Warehouse).

The Application function is also available in the Scripts workspace. This function can be used to load Lucanet.Script Execution Application (SEA for short) into the workspace. 

The scripts used to import data into Lucanet.Financial Warehouse are usually created by Lucanet.Consulting. If necessary, get in touch with your Lucanet contact.

Creating a Script

To create a script:

  1. In the overview, click the Import and Journals workspace.
  2. In the tree view of the workspace, right-click Scripts or a folder and select the following from the context menu: Create | Script:
    Create a new script
  3. Choose one of the following options to load the script into the Scripts workspace in the subsequent dialog:
    • Drag and drop the desired script into the dialog.
    • Click browse and navigate to the desired script.
  4. The script is created.
  5. In the detail view of the script, click Edit to configure the script (see following section).
Options for Scripts

The following options are available for scripts:

Option

Description

Execute

Execute the script (see following chapter)

If necessary, values required for execution of the script must be specified on the Configuration tab.

Edit

Open edit mode for the script: 

  • Name: name of the script
  • Configuration: values required to execute the script

There is usually a separate documentation for scripts, which describes the configuration of the script.

The Uses tab shows which Lucanet objects (e.g. data sources) access this script.

SEA used to import data into Lucanet.Financial Warehouse

Lucanet Script Execution Application (SEA for short) is a Lucanet application that you need if you operate ERP/financial source systems on-premises and want to import data from these systems into the LucaNet CFO Solution Platform using an ETL script.

 

If you want to import data from ERP source systems and these source systems are operated on premises, you must perform the following steps before importing via script:

  1. Create SEA certificate (see Generating and Downloading SEA Certificates).
  2. Install SEA (see Installing and Using Lucanet.Script Execution Application).
  3. Create SEA in the Scripts workspace as an application (see Installing and Using Lucanet.Script Execution Application).
  4. Assign SEA as an application in the data source (see Defining a Data Source)
Executing a Script

Scripts can be executed manually in the Scripts workspace.

Proceed as follows:

In the Scripts workspace, select the script you would like to execute. The detail view is displayed as follows, for example:

shows the detail view of a script. Highlighted are the sections to configure the execution location and to execute the srcipt.
Executing a script

If applicable, choose the Execution location of the script. To do so, open the edit mode and choose if you want to execute the script on the server or on any configured Script Execution Application (SEA).
(For more information on SEA, see the previous chapter and Installing and Updating Lucanet Script Execution Application.)

Click Execute.

If applicable, specify the configuration values in the Execute - script name dialog.

Click Start to start the execution.

Contact Us