Save Notes metadata in CSV format

The CSV tool is used to merge the XML or JSON metadata generated by Seascape into a single or multiple CSV files.

To use the tool, download the zip package provided to you by SWING Software, unzip the package, and open the CSVTool.exe file:

Once the tool is open, select the folder (the database archive) that contains the exported metadata, as source folder:

If you are running the CSV tool on a disk archive, then the source folder must be the root folder containing the disk archive.

Next, select the destination folder where you would like the CSV file will be saved, or leave it as it and the CSV file will be saved in the source folder:

Finally select the CSV delimiter character you would like to use in the CSV file (typically a comma or a semi-colon) and select the Create CSV option, then click on Next button:

To start the conversion process, select the database archive (could be multiple in source folder) and click on Run.

Once the process is completed you will receive a confirmation message. Clicking on the "OK" button will end the current process.

The generated CSV file is now saved in the selected destination folder:

Options:

• Create CSV for each form: By selecting this option, a CSV file will be created for each form.

• Create CSV for each individual view: By selecting this option, a CSV file will be created for each individual view.

• Create CSV with all file paths: Selecting this option will create a CSV file capturing the relative and full path to all documents and metadata files contained in the archive.

• Create CSV for embedded views: Selecting this option will create a CSV file capturing the relative and full path for embedded views.

• Create CSV for attachments: Selecting this option will create a CSV file capturing the relative and full path for attachments.

in case you need to use either of these two options (create CSV for each form/for each individual view) then the source folder should point to a specific database archive, not root folder.

If any issues are encountered during the data merge process an error message is displayed and the error is logged in the log file.

If there are multiple databases in the archive and you would like to get the metadata only for one specific database, then you would need to select the root folder of that database (not the root folder of the archive) as the source folder.