ARIS SCRIPTS - execution registration, conversion SAX to JAVA

Сергей, по поводу отслеживания запуска скриптов - ИМХО, проще на арисовском сервере сделать расшареную папку и вести лог (txt, excel), а в скрипты, которые Вы используете добавить стандартный код (это конечно не решит проблему отслеживания запуска предустановленных скриптов).

По поводу конвертера - он криворукий, поэтому можно перенести только максимально примитивные скрипты. Мы сталкивались с проблемой - конвертация кирилицы (в комментах, диалогах, формах и т.д.), многие методы не переносятся и т.п. Что-либо сложное нам пришлось переносить руками.

Hi Sergei, to track scripts you can just simply add to the end of each script piece of code to log each execution: 

var sLogFile = "Aris_" +Context.getScriptInfo(Constants.SCRIPT_VERSION)+ "_script_activity_log.log";
    var oFileToWrite = new java.io.File(Context.getTempPath(),sLogFile);
    var oWriter = new java.io.FileWriter(oFileToWrite, true);
    var sLogMessage = new String(nowStart.getFullYear() + ((nowStart.getMonth()+1) < 10 ? "0"+(nowStart.getMonth()+1):(nowStart.getMonth()+1)) + (nowStart.getDate() < 10 ? "0"+nowStart.getDate():nowStart.getDate()));
    sLogMessage += new String("|" + Context.getScriptInfo(Constants.SCRIPT_NAME));
    sLogMessage += new String("|" + Context.getSelectedPath()+Context.getSelectedFile());
    sLogMessage += new String("|" + ArisData.getActiveDatabase().ActiveUser().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().ActiveFilter().Name(g_nLoc));
    sLogMessage += new String("|" + ArisData.getActiveDatabase().getDbLanguage().Name(g_nLoc));
    sLogMessage += new String("|" + sStart + "|" + sEnd);
    sLogMessage += new String("|" + sDuration);
    sLogMessage += new String("\n");
    oWriter.write(sLogMessage);
    oWriter.close();

Milan

Hi, Milan.

This code is good however it could be exception (file lock) when several users will run the same script simultaneously.

We have hunderds of licenses to run simultaneously and therefore are looking for the registraion of the script execution in SQL database.

Registration in LOG file will require further sych with SQL database and therefore is not the best option so far.

The script log and script execution results will be used to tune up user support and educational courses for ARIS users.

Thanks for the code, pretty usable in case when we will have SQL code for registration.

Hi Sergei,

only two hints (please see ARIS installation&administrarion-guide by IDS for details)

1) if you have configured your Business Server to create an accounting log you will find it in:

    %arishome71%\server\accounting\arisaccountlog.xml

I found that for each execution of a VB script on Business Server a <session> with <clienttype>WIN is logged with time stamps. These sessions stick out if only ABDesigner or Architect Client access the server.

2) for each execution of JavaScripts on a Business Server there will be records of selected options per user in:

%arishome71%\server\templates\scriptservice\internal\ReportRegistry.cfg

Hope it helps, Martin

Hi, Martin.

Thanks for the tips - we will try it.

What we are after - registration of the script, user, model and some statistics of the script execution (if script produces any). The statistical data is needed for the purpose to track common errors/issues and tune training towards this issues elimination.

Script registration in the SQL database would be ideal.

Thanks againfor your information.

Sergei