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.
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.