At the end of your organization's tenancy, you may request to extract all your data from LawVu. This article explains the format of the data, and how to access the resulting export.
FAQs - Answers to common questions when exporting client data.
What will be exported?
Matters
Contracts
Contract key dates
Files
Conversations
What file format is the export?
Download an example zip file which has the data structure and files. SampleExport.zip from the bottom of this page.
What format will the data be supplied in?
Data will be supplied in tab delimited text files. These can be opened using Excel. Actual files will be in a “Files” directory
What’s in the files?
Matters.txt - All matter data except fields.
MatterFields.txt - All matter field data.
MatterId column will reference the Id column in the Matters.txt file.Contracts.txt - All contract data except fields.
ContractFields.txt - all contract field data.
ContractId column will reference the Id column in the Contracts.txt file.
FileId is the Id in Files.txt of the actual contract file.KeyDates.txt - All key dates for contracts.
ContractId column will reference the Id column in the Contracts.txt file.Files.txt - All file data including file versions.
MatterId and ContractId columns will reference the Matters.txt and Contracts.txt files respectively.Files (directory) - All files.
Name of the files relate to the Code column in the Files.txt file.Conversations.txt - All matter and contract conversations.
MatterId and ContractId columns will reference the Matters.txt and Contracts.txt files respectively.
FileId is the Id in Files.txt of the email file.
Files.txt explained
Opening the Files.txt in Excel will display a Code column similar to below.
The value in the Code column is the name of the file in the “Files” directory.
Renaming a file in this directory (for example “A589899187“) with the value in the Name column will allow the opening of the file.
Why is there more data then what is listed in LawVu?
Your data file will include all soft deleted matters, contracts and files. Those records will have a value in the "DeletedDateUtc" column.
How to access the exported data
All data and files will be uploaded to an Azure Storage account in your region. You will need to install the Azure Storage Explorer - Azure Storage Explorer – cloud storage management | Microsoft Azure to access these files, along with a SAS token which will be sent directly to you.
Once you have installed the Azure Storage Explorer connect to a Blob Container using the SAS token provided.
Download an example zip file that has the data structure and file.
SampleExport.zip: