Installation Instructions

Spreadsheet-based Business Process Tester

INSTALLATION INSTRUCTIONS

A. Google Sheet Plugin
1. Follow this instructions to create a Google API console project service account. The information is under the title: "Create the service account and its credentials".
2. Upload to Google Drive the spreadsheet template located in DIRECTORY_BPE/conf/resources/Template.xlsx
3. Open the template as a Google Sheet (right click over the document -> open with -> Google Sheet
4. Click on Tools -> Script editor...
5. Copy and paste the content of DIRECTORY_TOOL/conf/resources/DoEmulation.gs into new script.

B. Tool Database
1.Download MySQL community server from here
2.Install MySQL and run the server
3.Run the following command: mysql -u username -ppassword -h localhost databasename <event_log.sql for applying the database schema located in DIRECTORY_TOOL/conf/resources/log/

D. Tool Configuration
In DIRECTORY_TOOL/conf/application.conf file change the values of
1. db.default.url, db.default.user, db.default.password according to the URL, username and password of the database set up in the step B.3.
2. server.host.url, server.host.port according to the URL and port of the server in which the tool will run.
3. gdrive.spreadsheettemplate.id according to the ID of the spreadsheet template. The ID is the set of characters located after 'key=' in the URL of the spreadsheet template.
4. gdrive.accountemail according to the email address obtained from the step A.1.

D. Tool Execution
1.Download the Play! framework from here and unzip it into a directory.
2. From DIRECTORY_TOOL execute the command PLAY_FRAMEWORK_DIRECTORY/play run

F. Signavio Plugin
1. Execute the command svn checkout http://signavio-core-components.googlecode.com/svn/trunk/ signavio
2. Follow the instructions here to install Signavio Process Modeler
3. In the line 80 of DIRECTORY_TOOL/conf/resources/signavio_plugin/emulator.js set the server URL and port (must be same set in D.2)
4. Copy the file DIRECTORY_TOOL/conf/resources/signavio_plugin/emulator.js to SIGNAVIO_DIR/editor/src/scripts/Plugins/
5. Copy the file DIRECTORY_TOOL/conf/resources/signavio_plugin/BPMNHandler.java to SIGNAVIO_DIR/platform/src/com/signavio/warehouse/model/handler/
6. In SIGNAVIO_DIRECTORY execute the command patch -p0 -i BPE_DIRECTORY/conf/resources/signavio_plugin/bpe_plugin.diff
7. Copy the file BPE_DIRECTORY/conf/resources/signavio_plugin/ajax-loader.gif to SIGNAVIO_DIR/editor/src/images/
8. In SIGNAVIO_DIRECTORY execute the command ant build-and-deploy-all-in-one-war-to-tomcat
9. When the previous command finished you can access signavio at http://SERVER_URL:TOMCAT_PORT/signavio