![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Task A Review the Import FileOpen the renewal.xls spreadsheet located in the samples directory where you installed TIBCO Business Studio and take a minute to look at it. The first row of cells corresponds to the parameter names:
• Case Number - a unique number to identify the case. This will be ignored when we import the data into TIBCO Business Studio.
• Activity Name - the Activity being performed. Note the Activity Names do not have to match exactly the names of the Activities in the Process; the Import wizard allows you to map Activities between the spreadsheet and the Process.
• Duration - the amount of time it takes to perform the Activity. The time unit is specified in the Import wizard.
• Existing Customer? - this Parameter affects how long it takes to get the customer details.
• Number of Drivers - the number of drivers to be insured.Task B Create the Parameter
1.
2. Click Next to accept the displayed Project, Package and Process.
3.
5. Click Add Value. This adds a value called New Value. Double-click the value and rename it to Yes. Repeat this to create a No value. The result should look like this:Task C Import the Data
1.
2. Select Historical Case Data (Activity Duration).
4.
5. The Select Parameters dialog is displayed. This allows you to specify which columns in the spreadsheet represent the Activity name and duration:
− In the Select from imported columns: section, select the Activity Name Column and the Duration Column. Select Minutes as the Duration Unit.
− In the Map Activity Names: section, map the Activities in the spreadsheet to those in the Process.Click Next.
6. The next dialog allows you to map any parameters not already used in the previous dialog onto Activities in the Process. In this example, there are three parameters left over, Case No, Existing Customer and Number of Drivers. In this example, we will ignore the Case No and Number of Drivers Parameters. The Existing Customer parameter is interesting to us because it affects what information is required for the Take Customer Details Activity. Map the parameters as follows:Click Next.Click Finish.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |