Creating Scripts

Last updated on 2025-06-24

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.

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
  • Additional information: if necessary, a description of 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)