Server-wide custom functions

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Server-wide custom functions

    Hi,

    im trying to create some functions which i can use server-wide. To realize this, i used this explanation: knowledgebase.jedox.com/knowle…cro-engine-configuration/
    But this doesn't work so far :(

    My .php where i can define my functions looks like this:

    Source Code

    1. function TEST ()
    2. {
    3. return "2";
    4. }
    5. function RESOLVE ()
    6. {
    7. return "3";
    8. //$args = func_get_args();
    9. //return json_encode($args);
    10. }


    The function RESOLVE() was given by Jedox

    My macro_engine_config looks like this:

    XML Source Code

    1. <?xml version="1.0" encoding="utf-8"?>
    2. <php_macro_engine_config xmlns="http://www.jedox.com/jedox/wss" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    3. <php_extensions directory="php_extensions">
    4. <extensions>
    5. <extension extension_file="php_curl.dll" />
    6. <extension extension_file="phpchartdir540.dll" />
    7. <extension extension_file="phpchartdir540mt.dll" />
    8. <extension extension_file="php_xcache.dll" />
    9. <extension extension_file="php_jedox_palo.dll" />
    10. <extension extension_file="php_jedox_palo_x64.dll" />
    11. <extension extension_file="libphp_jedox_palo.so" />
    12. </extensions>
    13. </php_extensions>
    14. <php_files directory="../httpd/app" temp_directory="tmp">
    15. <include_paths>
    16. <include_path path="base" relative="true" />
    17. <include_path path="lib" relative="true" />
    18. </include_paths>
    19. </php_files>
    20. <ini_directives>
    21. memory_limit = 256M
    22. max_execution_time = 90
    23. max_input_time = 90
    24. date.timezone = ""
    25. open_basedir = "../httpd/app/base;../httpd/app/lib;tmp"
    26. xcache.cacher=1
    27. xcache.size=64M
    28. xcache.count=2
    29. xcache.ttl=0
    30. </ini_directives>
    31. <functions loglevel="error">
    32. <!-- misc -->
    33. <function spreadsheet_function="TEST" php_file="base/macro/fns/misc.php" php_function="TEST" always_recalc="false" />
    34. <function spreadsheet_function="RESOLVE" php_file="base/macro/fns/misc.php" php_function="RESOLVE" always_recalc="false" />
    35. </functions>
    36. <general_settings>
    37. <console_echo>false</console_echo>
    38. </general_settings>
    39. </php_macro_engine_config>
    Display All


    Source Code

    1. <function spreadsheet_function="RESOLVE" php_file="base/macro/fns/misc.php" php_function="RESOLVE" always_recalc="false" />
    was also given by Jedox.

    Now my Problem:
    If i type in one cell: =RESOLVE() the result in the cell is "3"
    If i type in one cell: =TEST() the result in the cell is "#NAME?"

    Do you know what the problem could be?

    Best regards
    Pascal