# 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:

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FoQs4ce2R2DtpcSiVUzQE%2Ftool.png?alt=media&#x26;token=e1663d75-d1f8-4153-992d-0fabfb544fce" alt=""><figcaption></figcaption></figure>

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

{% hint style="info" %}
If you are running the CSV tool on a disk archive, then the source folder must be the root folder containing the disk archive.
{% endhint %}

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FruADVzF2jTc6EXgHSZdD%2FSltSource.png?alt=media&#x26;token=fee0393a-fdbb-4c63-817d-7f09d134a65d" alt=""><figcaption></figcaption></figure>

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:

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FMGL0SuZQ7y2l8lSGI6Nb%2FSltDest.png?alt=media&#x26;token=c25228ee-235d-49fc-bfdd-c6b48dfd6ec4" alt=""><figcaption></figcaption></figure>

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:

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FXNxWFaxB96MNnJqvXPRt%2Fdelim.png?alt=media&#x26;token=ff3830ed-d9e6-4ccf-a819-9ff84bc702c5" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FA6mEL9rbPL1iRo630YxO%2Frun.png?alt=media&#x26;token=2b153820-e3ad-4b28-b8f9-0c27fd34f9bf" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FJBbJ5hGuditUKP8n5MZa%2Fok.png?alt=media&#x26;token=4ffabf75-ecdb-4f14-a2b0-dba96e7fcb3d" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1039028294-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkmLDl5OXrWVfn2nv57%2Fuploads%2FbArjvFT8tDy8Nr1k0uSO%2FcsvFile.png?alt=media&#x26;token=7cd37132-406d-4f21-8b77-ca69f0282264" alt=""><figcaption></figcaption></figure>

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.

{% hint style="info" %}
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.
{% endhint %}

{% hint style="info" %}
If any issues are encountered during the data merge process an error message is displayed and the error is logged in the log file.
{% endhint %}

{% hint style="info" %}
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.
{% endhint %}