15.1.8 Opening the FNOL eForm in the eForms Designer Tool File | Open
The FNOL-AC-db2.itx eForm template is selected using File | Open menu of the eForms Designer as shown in Figure 15.64:
Figure 15.64: The FNOL-AC-db2.itx eForm template is selected using File | Open menu of the eForms Designer
As the form appears on your screen, select the cell Policy Number, then select Settings | Lookup from the menu as shown in Figure 15.65:
Figure 15.65: Select the cell “Policy Number”, then select Settings | Lookup from the menu
Select the Settings | Lookup menu as shown in Figure 15.66:
Figure 15.66: Select the Settings | Lookup menu
Click on Define Connection as shown in Figure 15.67:
Figure 15.67: Click on the Define Connection command button (highlighted)
Enter the JDBC connection parameters as shown in Figure 15.68:
Figure 15.68: Enter the JDBC connection parameters
Click OK (then, click OK from the main pop-up window). Repeat this process for the Home Phone and Last Name cells in the eForm template.
Note: You can zoom in to get a clearer view of each field using the zoom(magnifying glass icon) and use the following View opener, as shown in Figure 15.69, to get back the full screen view again..
NB
Figure 15.69: To get a clearer view of each field use the zoom (magnifying glass icon) and use the View opener
The Policy Details fields are shown in detail in Figure 15.70:
Figure 15.70: The Policy Details fields are shown in detail
Last name SQL code is as follows:
select FIRST_NAME,HOME_PHONE,STREET,CITY,STATE,ZIPCODE,CELL_PHONE,EMAIL,POLICY_ID,POLICY_START_DATE,POLICY_END_DATE,POLICY_NOTES,CONTACT_TIME,VEHICLE_MAKE,VEHICLE_MODEL,VEHICLE_YEAR,VEHICLE_LICENSE,DOB,LAST_NAME from AUTOCLAIM.CPOLICY where LAST_NAME like
‘
<>%
‘
<<1@AC_PolicyFirstName>>
<<2@AC_PolicyHomePhone>>
<<3@AC_PolicyStreet>>
<<4@AC_PolicyCity>>
<<5@AC_PolicyState>>
<<6@AC_PolicyZipCode>>
<<7@AC_PolicyCellPhone>>
<<8@AC_PolicyEmail>>
<<9@AC_PolicyNumber>>
<<10@AC_PolicyStartdate>>
<<11@AC_PolicyEndDate>>
<<12@AC_PolicyNotes>>
<<13@AC_PolicyTimeContact>>
<<14@AC_VehicleMake>>
<<15@AC_VehicleModel>>
<<16@AC_VehicleYear>>
<<17@AC_VehicleLicense>>
<<18@AC_PolicyDOB>>
<<19@AC_PolicyLastName>>
Finally use File | Save As, as shown in Figure 15.71:
Figure 15.71: Finally use File | SaveAs
And save as FNOL-AC db2updated.itx as shown in Figure 15.72:
Figure 15.72: Save the updated eForms template with the JDBC links as FNOL-AC db2updated.itx
Use the acce tool to import this as a new V2 Version document, using the IBM FileNet Check-out – Check-in (since the Version Series ID reference we entered earlier in the solution Case Details page, is always preserved the new ITX Form Template document will be loaded), as shown in Figure 15.73:
Figure 15.73: Use the acce tool to import FNOL-AC db2updated.itx as a new V2 Version, using the IBM FileNet Check-out – Check-in
The Exclusive Checkout menu option shows the original Content Element as illustrated in Figure 15.74:
Figure 15.74: The Exclusive Checkout menu option shows the original Content Element
We can now use the Checkin… function to update the FNOL – AC db2.itx file content with our new updated file, FNOL-AC db2updated.itx as shown in Figure 15.75:
Figure 15.75: Use the Checkin function to update the content with our new updated file, FNOL-AC db2updated.itx
Check in using the new updated file, FNOL-AC db2updated.itx as shown in Figure 15.76:
Figure 15.76: Use the Add command to check in using the new updated file, FNOL-AC db2updated.itx
Select the updated FNOL form template file as shown in Figure 15.77:
Figure 15.77: Select the updated FNOL form template file, FNOL-AC db2updated.itx
Use the Add Content button as shown in Figure 15.78 to load the updated file content:
Figure 15.78: Use the Add Content command button to load the updated file content
Check-In as a major version as shown in Figure 15.79:
Figure 15.79: Check-In as a major version
The document is checked in as version 2 as shown in Figure 15.80:
Figure 15.80: The document is checked in as version 2 as highlighted
Re-deploy the Auto Claims solution in Case Builder as shown in Figure 15.81:
Figure 15.81: Re-deploy the Auto Claims solution in Case Builder