foreach 05/02/2008,03:03 22.67 Kb

Description:

In this use case sample user enter name and designation of a particular person through a form. As the process flows a database call has been made in order to fetch all the values from database and has been sent into for-each loop. The process starts looping from “1” and continues to execute till the total no. of rows available in the database.
As the process continues looping a check is being done to validate if a user with name entered exists in the database or not.
If user exists the loop terminates and a new form opens that displays result as:
Name User is Valid
If user does not exist then result is displayed as:
Name User is Invalid

Use case dependencies:

1. MySQLdb.wsdl
2. MySQLdb.xsd
3. paform.xform
4. paform.xform.xsd
5. pipaform.xform
6. pipaform.xform.xsd
7. query.sql

Requirements:

1. Intalio|BPMS Server-5.1.1
2. Intalio|BPMS Designer-5.1.1
3. MySQL-5 database.
4. mysql-connector-5.0.4.jar

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 ‘Foreach.zip’.
2. Go to File > Import...
3. Select 'Existing Projects into Workspace', in the wizard, click on Next >
4. Browse to select the downloaded archive file.
5. Click to Finish.
6. Update project builders by right click on project; go to BPMS Designer Tools > Update BPMS Builders.

Defining Configurations:

MySQL Database:

All you need to have a table with two fields (Name & Designation) in MySQL-5.
mysql> create table employee (Name varchar (20), Designation varchar (12));
mysql> insert into employee values (‘xxxxx’ ‘xxxxx’);

Designer:

1. To configure jdbc connection:
   Refer to the reference guides>Intalio|BPMS Connector for JDBC
2. Create Database Connection with the name as MySQLdb.

Server:

1. Go to [intalio-bpms-server]\var\config\jdbc-connector and create folder with name as MySQLdb
   Note: The folder name should always be similar to the name given for Database Connections in designer
2. Create a ‘connection.properties’ file and paste it into this folder.
   Note The file can be obtained form reference guides>Intalio|BPMS Connector for JDBC  
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.
5. Login with the following credentials:
   username: ‘examples\ewilliams’ (without quotes).
   password: ‘password’ (without quotes).
6. Go to Processes tab and click on “pipaform-init process Foreach/foreachprocess with form pipaform.xform”.
7. This should generate a form with an input field to map input data.
8. Type Name in Name field and Designation in Designation field then click on Start Process button.
9. This will take you to the Tasks tab.
10. Click on Refresh button and click on “Response” link available under Tasks Tab.
11. The form will display the result as:
    Name User is Valid [If user name entered is available in database].
    Name User is Invalid [If user name entered is unavailable in database].
12. Click on “Complete” button to complete the process.