Usage Of Workflow Table

 workflowtable 12/05/2008,03:28 31.90 Kb

Description:

This use case illustrates the use of a work flow table in which it gets dynamic values into input text fields from invoked database.

Use Case Dependencies:

1. start.xform
2. Start.xform.xsd
3. result.xform
4. result.xform.xsd
5. mysqldb.wsdl
6. mysqldb.xsd

Requirements:

1. Intalio|BPMS Server-5.1.1
2. Intalio|BPMS Designer-5.1.1
3. 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 “usageofworkflowtable.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.

Configuration:

MySQL Database:

1. All you need to have a table with four fields (empid,empname,designation,projectname) in MySQL-5.
2. mysql> create table employee (empid int ,empname varchar(20),designation varchar(20),projectname varchar(20));
3. mysql> insert into employee values (xxx"xxxx","xxxx","xxxx");. (please enter at least 1 rows)
4. Close and restart the server if it’s already started so that all the configurations done can be uploaded.

Designer:

1. To configure jdbc connection
2. Refer to reference guide > Intalio|BPMS Connector for JDBC
3. Create a Database Connection with the name as “mysqldb”.

Server:

1. 1.Go to [intalio-bpms-server]\var\config\jdbc-connector and create a folder with name as “mysqldb”
   Note: The folder names should always be similar to the name given for Database Connections in designer
2. create a “connection.properties” file and paste it inot “mysqldb” folder.
   Note: connection.properties file can be obtained form link give above.
3. Paste mysql-connector-5.0.4. jar file under [intalio-bpms-server]\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 “work flow table” link, click it to view form.
7. The form generated displays:
   Label “Start Process”.
8. Click on Start process button to proceed.
9. This will take you to the Tasks tab.
10. Click on “Refresh” and click on “work flow table” link available under Tasks Tab.
11. The form will display result in table format.
12. Click on 'Complete' button to complete the process.