External Libraries in the Macro Engine

New libraries or scripts that should be globally available in the Jedox Macro Engine (ME) must be added to a folder that is readable for the Jedox Spreadsheet Server.

The entry open_basedir in the file macro_engine_config.xml defines the readable and writeable paths for the ME (see Macro Engine Configuration).

In Windows, the separator between the paths is a semicolon:

[crayon-5f2b51c252270058470404/]

In Linux, the separator between the paths is a colon:

[crayon-5f2b51c252276327068843/]

Example

In ../php_macros/lib/ inside the core directory, we create a new folder named “test”. Now we copy the script that we want to be globally available into that folder. For this example, we call the script test.php.

After running a macro with the statement

[crayon-5f2b51c252278159179455/]

the script test.php is globally available in the Macro Engine.

Macro example:

[crayon-5f2b51c25227a729888149/]