PC Law CSV Imports
- Karen McDonald
- Former user (Deleted)
- Gemma Heidemann
PC Law CSV Format
Wise Owl Legal can import current contacts, clients and matters from PC Law CSV files.
An optional mapping file can be present to translate from old PC Law type of law codes to Wise Owl matter types.
Only current / open matters can be imported at this time; closed and archived matters are not supported as yet. Clients, contacts and matters are imported from the same file.
In order to allow multiple file imports and associate the mapping file, you must zip all PC Law csv files and the mapping file into a zip file.
Important: do not open the PC Law files in Excel, make changes and then attempt to save them. Excel does not correctly support fields with line breaks in them.
Pre-requisites
Import your empty data base lists
Import fee earners
Check the matter types have imported
Steps
Export data from PC Law. It is important to ensure the following settings are correct for data to be imported correctly:
TODO: details / screenshots
Add column headings to the CSV in notepad or word pad. DO NOT Open in Excel or matters with the format of 16-1001 will turn into dates and not make sense in Wise Owl Legal.
Add optional mapping file
See Matter Type Mapping below for details
Zip all together
Upload into Wise Owl Legal
Field Mappings (Client)
The following fields are copied from a PC Law csv to Wise Owl Contact fields. Other fields, even if they contain data, are not copied.
As a Client can be listed against multiple Matters in a PC Law csv file, only the first is imported; subsequent matters referencing this client will not update the client details.
PC Law Field | Wise Owl Field | Required | Comments |
|---|---|---|---|
|
| Y | Must be unique in Wise Owl |
|
| Maybe | Either FIRST NAME and LASTNAME, or FIRM NAME must be present. If FIRST NAME and LAST NAME is present, the client is made an Individual in Wise Owl. |
|
| Maybe | Either FIRST NAME and LASTNAME, or FIRM NAME must be present. If FIRST NAME or LAST NAME is present, the client is made an Individual in Wise Owl. |
|
| Maybe | Either FIRST NAME and LASTNAME, or FIRM NAME must be present. If FIRM NAME is present, the client is made a Company in Wise Owl. |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N | |
|
| N |
Field Mappings (Matter)
The following fields are copied from a PC Law csv to Wise Owl Matter fields. Other fields, even if they contain data, are not copied.
All matters are assumed to be Open.
PC Law Field | Wise Owl Field | Required | Comments |
|---|---|---|---|
|
| Y | Must be unique in Wise Owl |
|
| Y | Picks up the client created above. Will cause the matter to fail if the client had an error. |
|
| Y | Must match a matter type code in Wise Owl or an item on the mapping spreadsheet. |
|
| Y | The name is the first line of the description. The first three lines of the description are used as re-lines. |
|
| Y | Should be formatted |
|
| Y | Can match based on username, initials or 'nobody'. Also is marked as conflict check. |
|
| N | Can match based on username, initials or 'nobody'. |
|
| N | Must match a referral source in Wise Owl. No mappings are supported as yet. |
Matter Type Mapping
As types of law and matter types may be different between your PC Law database and Wise Owl Legal, you can provide a mapping file (a simple table) which links old PC Law type-of-law codes to Wise Owl Legal matter types. This mapping file is optional.
If you do not include a mapping file, the import process assumes the current Wise Owl Legal Matter Type code field should correspond 1:1 with the PC Law TYPE_OF_LAW field (although upper and lower case does not matter, so COMM = comm = Comm). That is, if you configure your Matter Types to match PC Law before you import, you do not need a mapping file. However, because Wise Owl Legal is more flexible and allowed more characters in fields, this is not recommended.
If you do include a mapping file, every TYPE_OF_LAW value must be listed exactly once. Any which are not listed will fail to import associated matters. Any which are listed more than once will fail the entire import process. You can use the Excel Auto-Filter function or Remove Duplicates function to assist in building a unique list of TYPE_OF_LAW.
You can map several TYPE_OF_LAW values to the same Wise Owl Matter Type by listed the Matter Type multiple times (see MISC in the example below).
You must list the TYPE_OF_LAW and Wise Owl Matter Type even if the codes are identical.
There is no limit to the number of records in the mapping spreadsheet.
Layout
This must be an xlsx file called mappings.xlsx. A CSV file is not acceptable (as the importer assumes all CSV files are from PC Law).
Matter type mappings must be in a worksheet (tab) called MatterType
Two columns must be present in columns A and B with headings labelled exactly as the example below. Other columns are ignored.
The PC Law column must match the codes exported in the TYPE_OF_LAW field (although upper and lower case does not matter).
The Wise Owl column can match codes or full names of Matter Types (upper and lower case does not matter). Your import will fail if you mis-enter the Matter Type code or name.
PC Law Type Of Law | Wise Owl Matter Type |
|---|---|
Com | COMM |
civ | CIVL |
misc | MISC |
xyz | MISC |
we | W&E |
The spreadsheet looks like this, an example to download is below the picture.