The following instructions will help you create a table list from PCLaw.
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:
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
- $ROOT = "D:\ServerFolders\Company\PCLaw\DATA"
- $OutputFileName = "$ROOT\PCLAW.DB.txt"
- $Folders = @(
- "$ROOT\dyndata",
- "$ROOT\statdata"
- )
- $Files = $Folders `
- | Where-Object { [System.IO.Directory]::Exists($_) } `
- | Get-ChildItem -Filter *.dat `
- | Where-Object { $_.Name -inotlike "TTE*" } # Ignore temporary tables
- $Files
- $Lines = $Files `
- | ForEach-Object { [System.IO.Path]::GetFileNameWithoutExtension($_.FullName) + " " + $_.FullName }
- [System.IO.File]::WriteAllLines($OutputFileName, $Lines)