Exporting Information from PCLaw to Create New RealtiWeb Files

Exporting Information from PCLaw to Create New RealtiWeb Files

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

Sending information to RealtiWeb from PCLaw

One time: Setup your new RealtiWeb 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 RealtiWeb

One Time: Setup your New RealtiWeb Layout in PCLaw

In PCLaw, you will need to create a new RealtiWeb 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 RealtiWeb 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 RealtiWeb 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 RealtiWeb fields:
 
In PCLaw
In RealtiWeb
Matter

File Number

Resp. Lawyer

Lawyer (/Notary in BC)

Other Staff

Conveyancer/Paralegal/Firm Contact.

Note: 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 RealtiWeb 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 RealtiWeb fields:
 
PCLaw field

RealtiWeb 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 RealtiWeb

  1. Login to the RealtiWeb 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 RealtiWeb. 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 RealtiWeb. 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.
    Note: In your PCLaw data, the lawyer initials should match a lawyer in your RealtiWeb database and the staff name should match a name in your RealtiWeb contact database.

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

    If you wish to make use of the lawyer and staff import, make sure to add the relevant lawyers and staff into RealtiWeb so that it matches your PCLaw information.
  5. In RealtiWeb, 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 RealtiWeb's PCLaw Integration

          Step 1: Create a New Matter in PCLaw Create a new matter in PCLaw® to obtain the matter number for RealtiWeb. 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 ...

        • Setup for RealtiWeb/PCLaw Integration

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

        • 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 ...

        • 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 Information tab. Click on the selection icon beside the field to open a ...

        • Using RealtiWeb Ontario for a New Home Sales Transaction

          Activating the New Home Sales Bundle Even though it was originally designed for the residential resale market, you can use RealtiWeb for new home or condominium sales files. If you are acting on behalf of a developer with larger-scale projects, ...