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:


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



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


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

Macro example: