How to Extract All Data from a Meridian Vault and Export It to an Excel (.xlsx) Spreadsheet

To extract all data from a Meridian Vault and export it to an Excel (.xlsx) spreadsheet:

1. Download the "DataExtractor.7.1.6.zip" file in this link.

2. Extract the contents of the file in the following location:

   C:\Temp

3. Open a command window (CMD) and access the following location:

   C:\Temp\DataExtractor.7.1.6.

4. In this folder, type the following command:

   Copy

   M360.DataExtractor.exe -RepositoryName [RepositoryName] -FilePath [output file path].xlsx -RevisionsPerFile [number of revision records per file]

5. Press Enter.

6. To check if the process worked after the execution of the command, in CMD:

   1. Type “DIR”.

   2. Press Enter to show all files in the directory.

7. To open the reports, use Windows Explorer to access the following location:

   C:\Temp\DataExtractor.7.1.6.

   The process generates the following data output:

   • Intermediate files, in the following form:

     • [output file path]_Revision.json

     • [output file path]_References.json, containing all revisions and references in the vault.

   • Number of output files, in the following form:

     • [output file path]_[number].xlsx

   You must have Microsoft Office or a similar application to open .xlsx files.

Process interruption and restart

Once [output file path]_Revision.json and [output file path]_References.json are generated, you can interrupt the process after some [output file path][number].xlsx files are done.

To restart the process later from the point where it was interrupted, use the following syntax:

M360.DataExtractor.exe -RepositoryName [RepositoryName] -FilePath [output file path].xlsx -RevisionsPerFile [number of revision records per file] -RestoreRevisions true -NextFile [next file number]