dynamicprocess 30/12/2008,23:44 24.93 Kb

Summary:

This use case illustrates how to generate dynamic combo box in Intalio process.
In this process user create xsl file which is used to retrieve records from the database for creating combo box dynamically. After  process execution combo box generated dynamically displaying the records i.e names of all the employee retrieve from the database. The user select the value i.e name of an employee  from the combo box and corresponding to this name designation is display in the text box.

Use case dependencies:

1.PIPA.xform
2.PIPA.xform.xsd
3.Result.xform
4.Result.xform.xsd
5.SelectValues.xform
6.SelectValues.xform.xsd
7.operation.sql.

Requirements:

1.Intalio BPMS Designer 5.2
2.Intalio BPMS Server 5.2
3.MySQL - 5.0 database.
4.mysql-connector-5.0.4.jar.
5.test .xsl

Preconditions:

1.Make sure Intalio|BPMS Server is up and running fine.
2.Make sure the Process Explorer pane does not contain any Intalio|BPMS Business Process Project with same name.

Process Download & Import:

1.Download ‘DynamicProcess.zip’.
2.Go to File > Import...
3.In Import wizard, select 'Existing Projects into Workspace', click on Next >
4.Select the "Select archive file" radio button.
5.Browse to select the downloaded archive file.
6.Click on Finish.
7.Update project builders by right click on project; go to BPMS Designer Tools > Update BPMS Builders.

Configurations:

MySQL:
1.All you need to have a table employee with two fields: name and designation in MySQL – 5.0.
2.mysql> create table employee(name varchar(20),designation varchar(30));

Designer:
1.To create connection profile refer to given link: http://bpms.intalio.com/tutorials-5.2/setting-up-a-connection-profile.html
2.To create dataabase connector refer to given link: http://bpms.intalio.com/tutorials-5.2/using-database-connectors.html

Server:
1.Paste mysql-connector-5.0.4. jar file under [intalio-bpms -server]5.2.0.050\repository\com\intalio\bpms\pxe\5.1.2\pxe-5.1.2.war\WEB-INF\lib
Note: You can obtain the jar file from [intalio-bpms-server]\repository\mysql\mysql-connector\5.0.4

Process Deployment & Execution:

1.Click on Deploy Project to Intalio|BPMS Server button in tool bar.
2.Make sure you select all runtime files while exporting to Intalio|BPMS Server.
3.Click on Finish button.
4.Open a web browser, provide url as: http://localhost:8080/ui-fw which takes to login screen for workflow UI.
5.Login with the following credentials:
username: 'examples\ewilliams' (without quotes).
password: 'password' (without quotes).
6.Under Processes tab you should see “DynamicProcess” link, click it to view form.
7.The form generated displays:
“Start Process.....”

8.Click on “DynamicProcess” link available under Tasks tab..
9.The form displays combo box generated dynamically displaying the names of all the employees. Select any one name from the combo box say John.
10.Click on “Complete” button to complete the process.
11.After then click on “DynamicProcess”  link available under Notifications tab.
12.The form displays the designation of the employee which is selected from the combo box. In this text box is displaying designation say Software Consultant.
13.Click on “Dismiss” button to dismiss the process. 

Notes:
This sample is an example to educate user on:
1.How to create dynamic combo box in Intalio process.
2.How to create xsl file for creating dynamic combo box in Intalio process.