Exporting Information from PCLaw to Create New Realti Files

Exporting Information from PCLaw to Create New Realti Files

The Realti PCLAW Integration allows you to transfer information from PCLAW to create new Realti files and to export accounting information from Realti to PCLaw.

Sending information to Realti from PCLaw

One time: Setup your new Realti layout.

Each export:
  1. Send the information from PCLaw to a spreadsheet
  2. Open the spreadsheet file and copy the information to a clipboard
  3. Import the copied information into Realti

One Time: Setup your New Realti Layout in PCLaw

In PCLaw, you will need to create a new Realti layout  as a one time process. Afterwards, you’ll be able to use it for all of your future information exports.
  1. To create the new layout, select File, then Matter, then Export.
  2. On the Export Matters screen, click the Add button.
On the Realti Layout Screen
  1. Enter the description as on the screen print
  2. Choose CSV as the initial File Format
  3. Browse to choose a path where the export file will be sent, including a name for the file that Realti will import
On the Main tab of the layout, check off the  Matter, Resp. Lawyer, and Other Staff fields.  These PCLaw fields will import into the following Realti fields:
 
In PCLaw
In Realti
Matter

File Number

Resp. Lawyer

Lawyer (/Notary in BC)

Other Staff

Conveyancer/Paralegal/Firm Contact.

AlertNote: that the Other Staff field in PCLaw must be set up as a user under Options/Administrator/Security if you wish to use this field. 

On the Address tab, check off the boxes for the following information fields under the  Billing section, then click OK; this creates and saves the Realti layout:
  1. First Name, Middle, and Last/Firm Name
  2. Bus, Home, Cell, and Fax
  3. Email 1 and Email 2
The following PCLaw fields will import into the corresponding Realti fields:
 
PCLaw field

Realti fields

Matter

File Number

First Name
First Name
Middle
Middle Name
Last/Firm Name
Last Name or Company Name
Business Number
Business Number
Home Number
Home Number
Cell Number
Cell Number
Fax Number
Fax Number
Email 1
Email 1
Email 2
Email 2

Each Export from PCLaw

Step 1: Send information from PCLaw to a spreadsheet

  1. To export the real estate files from this layout screen to the path and file name required, click the Export button. If you have exported a file previously, you will get a message asking you if you want to overwrite the file. If you have already imported the previous export, you can continue with overwriting the file when prompted.
  2. The Select Matters screen allows you to select matters according to the Type of Law and Opening Date criteria. You may want to pick Only Real Estate Files (based on the Type of Law the files have been opened in in PCLaw) and/or only a range of files based on their file open dates to be included in the Export File. Once you select OK you will get a message that the export is complete. 

Step 2: Open the spreadsheet file and copy the information to the clipboard

  1. The next step is to load the export file that you exported from PCLaw. Open Microsoft Excel, find the file you exported from PCLaw, and bring it up into Microsoft Excel (this will be the path and file name specified in the output File Information on the Export Matters screen). 
  2. Highlight the data in the sheet that you want to copy over. 

Step 3: Import the copied information into Realti

  1. Login to the Realti program, and on the File Menu, point to PCLaw File Import. 
  2. The following screen is displayed for you to paste your spreadseet contents into Realti. It will look like the following screen after you paste your information. 
  3. Click the Load and Preview button. The information is shown in a table underneath under the appropriate headings.
  4. Click Create Files. All files will be created in Realti. If a file with the same file number exists, you will be asked if you wish to still create it. If you do, there will be more than one file with that file number on your Main file list.
    AlertNote: In your PCLaw data, the lawyer initials should match a lawyer in your Realti database and the staff name should match a name in your Realti contact database.

    If the lawyer initials don’t match a firm lawyer in Realti, no name or initials are brought into Realti. If the staff name doesn’t exist in Realti, the staff name will be brought in but not associated with any previously existing Realti information.

    If you wish to make use of the lawyer and staff import, make sure to add the relevant lawyers and staff into Realti so that it matches your PCLaw information.
  5. In Realti, you will be able to tell which files on your Main files list have been imported from PCLaw, as they will not have a letter in the PSM column. You will need to indicate whether it is a Purchase, a Sale, or a Mortgage, and then the import information will populate.

    Still can't find what you're looking for?

      Related Categories
      Billing, Accounting Integrations, Admin Functions & Reports

      File Creation, Document Creation, and other general topics

      Province-specific information for AB clients

      Province-specific information for BC clients

      Province-specific information for MB clients

      Province-specific information for ON clients

      Province-specific information for NS clients

      Province-specific information for SK clients

        • Related Articles

        • Using Realti's PCLaw Integration

          Step 1: Create a New Matter in PCLaw Create a new matter in PCLaw® to obtain the matter number for Realti. To do this, use New Matter and enter the matter based on the last matter number. Enter the Type of Law. For Real Estate, choose REM-Real Estate ...

        • Setup for Realti/PCLaw Integration

          If you're planning to use the PCLaw integration in Realti, you'll need to follow the below steps to setup your computer. Check to see if there is a folder on your computer called Realti on the local C:\ drive. If you don't have access to this drive, ...

        • How to Create a File

          To create a file, login to RealtiWeb. At the top of the File List click + File. Under the File Creation list there are 3 options: New File New File From Template PCLaw Import File Creation Screen Clicking on New File in the File Creation list will ...

        • Using Realti's CosmoLex® Integration

          Step 1 – Create a New Matter in CosmoLex® Create a new matter in CosmoLex® to obtain the matter number for use with Realti. To do this, select Matters from the menu bar and click Add at the top toolbar. The matter is based on the last matter number. ...

        • Adding Support Staff in RealtiWeb

          You can add clerks and other staff to your account any time from within a RealtiWeb file. These are referred to as firm contacts. Open a file and find Firm Contact on the Basic screen. Click on the selection icon beside the field to open a window. ...