How it works
Case Management System Integration
Partner for Windows
Further Information / Consultancy
Perfect Portal provide an advanced online Conveyancing Sales and Management system.
Integrating your existing database system with Perfect Portal involves periodically downloading Case, Contact, Key-Stage and User information held within the Perfect Portal system. There is also scope for uploading Key Stage information and other details as you may require.
The initial base utility is designed for Perfect Portal Version 4, Lean software will release new versions of this integration tool in line with Perfect Portal subsequent new releases.
The utility can be used as the basis for example for integration with a Case Management system such as Partner for Windows.
How it works
This module is a command line utility, designed be scheduled to run from your server, and to download and populate SQL Server tables in an unattended fashion.
In addition Json text files are also created on the server, should you have use to read these files directly into another non-SQL system.
Version 4.2 1st February 2017
[Major version number inline with Perfect Portal Version number]
The configuration file PerfectPortalSQL-V4.INI holds details of your SQL Server and your Perfect Portal User ID and Password :
This initial release supports the following command line functions:
Additionally there is a non-quiet mode that will display the downloaded Json should you wish to see the remote server responses. The Json is saved to text files for you by default.
This method simply tests the SQL Server and Perfect Portal connections specified within the INI file.
This method downloads all of the KeyStages defined in your Perfect Portal system.
Details are downloaded into the SQL table PerfectPortal_KeyStages
This method downloads all of the users defined in your Perfect Portal system.
Details are downloaded into the SQL table PerfectPortal_Users
This method downloads (potentially) all of the case information held within your Perfect Portal system.
There is an SQL function you can modify should you wish to selectively download case information - for example to exclude completed matters.
The function is called fn_PerfectPortalDownloadCase, simply modify the SQL within this function to return 0(zero) if the case information is not to be downloaded.
By default all cases will be downloaded and the following tables will be populated or refreshed (if already downloaded).
SQL table PerfectPortal_Cases
SQL table PerfectPortal_Clients
SQL table PerfectPortal_Agents
SQL table PerfectPortal_Brokers
SQL table PerfectPortal_OtherSide
SQL table PerfectPortal_Disbursements
SQL table PerfectPortal_LegalFees
SQL table PerfectPortal_Diary
This method uploads the local case key stages for live matters to the Perfect Portal system.
CASE MANAGEMENT SYSTEM INTEGRATION
Local Link fields are inbuilt that can be populated to link to local database records.
Depending on your Case Management system, stored procedures and triggers can be deployed to link the data to existing records, or to use the Perfect Portal data to create new records.
We have achieved this already for multiple clients with the case management system Partner for Windows provided by Tikit PLC.
Partner for Windows - specifically
With P4W integration - Prospective Clients records are automatically created :
All Perfect Portal details are used to populate the Prospective Client, in addition the Notes field is populated with some options - to create the matter Yes/No and a suggested Matter Description :
After clicking 'Create Live Entity' the matter is also automatically created
Property address details, agent and broker details can also be integrated into into the new matter, as you need, this will require bespoke work tailored to your existing Partner conveyancing property details and financial information screens.
Lean Software Ltd can help you achieve this on a consultancy basis.
The base module command line utility software is currently licenced on an annual basis @£750+vat per year.
In return for your licence fee Lean Software are committed to keeping the module release versions in line with Perfect Portal system and distributing to Partner for windows clients.
Fee includes :
· Development and prompt delivery / notification / installation (if required) of all new versions as will be required when Perfect Portal release new versions of their service.
· Direct support with Lean Software, promptly resolving any issues or queries with the software
Richard Briggs of Lean Software Ltd is a highly experienced Microsoft Certified software developer and Partner for Windows Tikit software specialist.
Richard's consultancy / software development is provided @560+vat per 8hr day.
Typically a standard installation will require one day remote consultancy/installation, then up to four days of bespoke work to integrate with your Partner screens and import Matter contacts, for example.
Consultancy can include specialist integration and other system work you require.
Please contact us (email@example.com) or PerfectPortal.co.uk for more information.
Contact Richard directly Richard.Briggs@LeanSoftware.net