The objective of this article is to export your data from PCLaw to be imported into MyCase. Please note that the success of your data migration into MyCase depends on the quality of your data set. This includes exporting your data in .csv or .xlsx format, ensuring headers are in the top row of the spreadsheet, and removing duplicate entries. If you are unsure as to how to format your data, please reach out to a Customer Support representative for assistance. If eligible for onboarding services, a Data Migration Specialist will assist you in the formatting and organizing of your data.
Contacts (Clients):
Click File > Contact Manager. Click Export
Pick Layout Name > All. Click Change
Select the Common tab and check all fields you want included in the export
Click the Other tab and check all fields you want included in the export
Click Ok. Under File Format select CSV
Under Output File select Browse and pick a destination for saving.
Click Export (click the checkboxes for Contact, Client, and Vendor before exporting)
Click Yes when asked to save changes
Repeat steps 7-8 but select Word for Windows as the File Format. This will provide you with the headers for the CSV file.
Matters (Cases):Open Matters:
Click File > Matter > Export . Pick Layout Name > OpenMatt
Click Change. Click Main Tab and check all the fields you want included in the export
Select Address Tab and check all the fields you want included in the export
Select Selections and check all the fields. Click OK
Under File Format select CSV
Under Output File select Browse and pick a destination for saving
Leave the Name field as OpenMatt.
Click Export
Click Yes when asked to save changes. Select Active Cases only.
Click OK to start Export
Repeat steps 8-10
Select Word for Windows as the File Format. This will provide you with the headers for the CSV file.
Closed Matters: To bring over please follow the steps above but apply the changes below:
On Step 4 change the Name field CloseMat
On Step 13 pick Inactive and/or Archived Cases only
Time Entries and Trust Balances:
Use reports functionality to review data sets then run a report and save to Excel.
Unbilled Time Entries:
Reports > Data Entry > Register. Select the Time
Check filters box and click filters. Select unbilled and click OK
Click the Excel button
Accounts Receivable (outstanding balances):
Reports > Accounts Receivable > Receivable by Client
On the Common tab select an end date. Check the box for Matter Totals if you want the balances to show by Matter
Filter by Attorney if necessary. Click OK and the report will display on screen
Export to Excel