Laserfiche Solution Contributed By: The City of Roanoke, VA

The City of Roanoke, VA, integrated Laserfiche with its line of business applications. Here is how the integrations with IBM Lotus Notes and ESRI GIS are configured.

IBM Lotus Notes Integration

The contracts department uses IBM Lotus Notes to keep track of all of the City of Roanoke’s contracts and leases. The actual contract document is stored in Laserfiche, but all contracts are administered through IBM Lotus Notes. In IBM Lotus Notes, each contract or lease has a “View Imaged Document” button. Clicking this button opens all documents related to that contract or lease in Laserfiche WebLink.

roanoke1

When the button is clicked, a search is performed in Laserfiche WebLink based on the Lotus Notes ID number of the document.

roanoke2

Click image to view larger in new window.

Here is what the repository and document template look like. The DocID field corresponds to the Lotus Notes ID.

roanoke3

Click image to view larger in new window.

The code in Lotus Notes Designer behind the “View Imaged Document” button is shown below:

turl := "https://lf01/closedsearch/Search.aspx?dbid=0&searchcommand={[Document]:[DocID]=\"" + docID + "\"}";
@ URLOpen(turl)

  • Lf01 is the Laserfiche Server name.
  • Closedsearch uses the closed search functionality.
    • The search criteria for Closed Search is passed in using the docID from the Lotus Notes document: ={[Document]:[DocID]=\”” + docID + “\”}”;
  • Search.aspx?dbid=0&searchcommand = hits the database with an id of 0
    • The database id (dbid) is obtained from the Laserfiche WebLink Administrator’s Utility.
    • In this case, Dbid = 0 is the Contracts and Lease repository.
roanoke4

Click image to view larger in new window.

ESRI GIS Integration

Since property records, such as engineering maps, permits and deed cards, should, by law, be accessible to the public for free, the City of Roanoke has integrated its ESRI GIS system with Laserfiche. The main page of Roanoke’s website contains a GIS Maps and Real Estate link where citizens can view property parcels and all related documents.

roanoke5

Once the link is clicked, the user can search by address and pull up all of the related documents stored in Laserfiche, such as deed cards.

roanoke6

Click image to view larger in new window.

Here is how this integration works:

  • Each deed card is stored in the Laserfiche folder corresponding to the tax ID number.
    roanoke7

    Click image to view larger in new window.

  • The tax ID number is stored in the Tax Map field in the document template. In order to make sure it is always accurate, regular expressions are used to format the field.
    roanoke8

    Click image to view larger in new window.

  • The tax ID number is the link between the GIS system and Laserfiche.
    roanoke9

    Click image to view larger in new window.

  • When the deed cards link (highlighted in the above screenshot) is clicked, the tax ID number is passed into Laserfiche WebLink’s closed search and the deed card stored on the Laserfiche server is displayed on the web.
    roanoke10

    Click image to view larger in new window.

The integration relies on Laserfiche WebLink URLs. This is the URL passed into Laserfiche for search from GIS:

https://roanokeweb.roanokeva.gov/closedsearch/Search.aspx?dbid=4&searchcommand={[Deed%20Cards]:[Tax%20Map]=3090901}

  • The web server (roanokeweb.roanokeva.gov) database id (dbid) is 4.
  • The Laserfiche database id is obtained from the Laserfiche WebLink Administrator’s Utility. In this case the Laserfiche Server dbid is 3.
roanoke11

Click image to view larger in new window.

  • The actual search is encoded in the “searchcommand” parameter and, in this case, equals {[Deed%20Cards]:[Tax%20Map]=3090901
    • [Deed%20Cards] corresponds to the Laserfiche template name.
    • [Tax%20Map] corresponds to the field name in the template.
    • 3090901 corresponds to the actual tax ID number for which the search is performed.

 

Benefits of Laserfiche

Integrating Laserfiche with IBM Lotus Notes and ESRI GIS has led to the following benefits for the City of Roanoke:

  • The IBM Lotus Notes integration saves time by allowing employees to work within one system instead of toggling between two different programs.
  • The GIS integration allows citizen to quickly search for public property records, such as deed cards without having to call the city first. Citizens appreciate having self-service access to this information, and city employees are freed up to perform other duties.

Want to see how Laserfiche can integrate with your line-of-business applications? Schedule a demo today.
Demo

Related Posts