loanprocess_using_forms 06/02/2008,06:13 24.61 Kb

Description:

In this use case sample user enters name and salary 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 displays in the form with the result according to salary.

If salary is 10000 then it displays the result as:

Cust_result: congratulations we are able to give the loan to you.
Startsalary: 10000
Endsalary: 20000
Loanamount: upto 100000
Duration: 1 year
Rate: 10 %

Use case dependencies:

1. connection.wsdl
2. connection.xsd
3. PALoan.xform
4. PALoan.xform.xsd
5. PIPALoan.xform
6. PIPALoan.xform.xsd
7. query.sql
8. query.prm

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 LoanProcess.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 the name Loan and with six fields (custresult, startsalary, endsalary, loanamount, duration, rate) in MySQL-5.

Note: we must create a table with four rows as shown below.

mysql> create table Loan (custresult varchar (70),startsalary varchar (10),endsalary varchar(10),loanamount varchar(20),duration varchar(10),rate varchar(10);

mysql> insert into Loan values('Unable to give the loan if salary is below 10000','0','9999','0','0','0');

mysql> insert into Loan values('Congratulations we are able to give the loan to you,10000','19999','up to 100000','1 year','10%');

mysql> insert into Loan values('Congratulations we are able to give the loan to you,20000','49999','up to 500000','2 years','7%');

mysql> insert into Loan values('Congratulations we are able to give the loan to you','50000','100000','up to 1000000','5 years','5%');

Designer

To configure jdbc connection:

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

Server

1. Go to [intalio-bpms-server]\var\config\jdbc-connector and create folder with name as connection.
   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 connection folder.
   Note The file can be obtained form the 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. Also verify and check Deploy processes & Deploy forms choice before click on Finish button.
4. Open a web browser, provide url as: http://localhost:8080/ui-fw which takes to login screen or workflow.
5. Login with the following credentials:
   username: examples\ewilliams (without quotes).
   password: password (without quotes).
6. Go to Processes tab and click on PIPALoan-init process LoanProcess/LoanProcess with form PIPALoan.xform.
7. This should generate a form with two input fields to map input data.
8. Type Name in Name field and Salary (eg:11000) in salary field then click on Start Process button.
9. This will take you to the Tasks tab.
10. Click on Refresh button and click on Ready link available under Tasks Tab.
11. The form will display the result as:
    Cust_result: Congratulations we are able to give the loan to you
    Start_Salary: 10000
    End_Salary: 19999
    LoanAmount: Up to 100000
    Duration: 1 year
    Rate: 10%
12. Click on Complete button to complete the process.