PCLaw Backups: Generating a Table List

PCLaw Backups: Generating a Table List

The following instructions will help you create a table list from PCLaw.

Locate the PC Law Data

To find out where the PC Law data exists, find a PC Law shortcut, right-click on it, and choose "Open File Location".



Repeat this process until you are in a location similar to the following.  Then double-click on the LOCALDATA folder.

 

Open the PCLaw.cf file:


And you will see the following relevant locations:

 

Navigate to that location.

If you need a comprehensive backup, create a ZIP file of everything in that location.

If you only need practice management data, go into the Data subfolder and create a ZIP of just the DynData and StatData files:

Create a Table List

PCLaw uses the FAIRCOM CTREE database format.

The following PowerShell script generates a table list which you can then use to connect to FAIRCOM ODBC.

When you configure FAIRCOM, you must set the following options:

Alignment: 1 Byte 

  1. $ROOT = "D:\ServerFolders\Company\PCLaw\DATA"
  2. $OutputFileName = "$ROOT\PCLAW.DB.txt"

  3. $Folders = @(
  4. "$ROOT\dyndata",
  5. "$ROOT\statdata"
  6. )


  7. $Files = $Folders `
  8. | Where-Object { [System.IO.Directory]::Exists($_) } `
  9. | Get-ChildItem -Filter *.dat `
  10. | Where-Object { $_.Name -inotlike "TTE*" } # Ignore temporary tables

  11. $Files


  12. $Lines = $Files `
  13. | ForEach-Object { [System.IO.Path]::GetFileNameWithoutExtension($_.FullName) + " " + $_.FullName }

  14. [System.IO.File]::WriteAllLines($OutputFileName, $Lines)

 


    • Related Articles

    • Tabs3 Backups: Creating a Table List

      When connecting to TABS3, there are a few different database servers that may be used. To determine the correct database system, open the TABS3 System Configuration Utility: Then click Help > About System Config. You will then see something like this ...
    • PCLaw Backups: Step by Step Procedure for CTREE Databases

      The following instructions will take you through each step required to create a Universal Database backup of PC Law data. Below are the high-level steps. You can click on a topic, or scroll through the entire article for step by step instructions. ...
    • PCLaw Migrations: Creating Database Backups

      Depending on a firm's version of PC Law, their PC Law database is running with either SQL Server or CTREE. You should identify the database type and use the appropriate measures to acquire a copy of their database and their STATDATA folder. For SQL ...
    • PCLaw Backups: Full Convert Options

      When using Full Convert to convert a PC Law database from a FairCom CTree data store to SQL, there are some additional options that must be configured. Summary Apply these Data Type Mappings tinyint=bigint smallint=bigint int=bigint Details After you ...
    • Worldox Backups: Backing Up Metadata

      This article will assist you in backing up and processing Worldox metadata for the purpose of restoring documents into another system. Because Worldox is not a SQL-based system, the steps are slightly different. In order to back up the data, you will ...