Spreadsheet to Preservica XML v2 (OPEX Compatible)

This is a new version of the CSV (Spreadsheet) converter, which can output OPEX format XML documents for the Preservica PUT tool version v6.6.1 and above.

If you are using a version of the PUT tool v6.6.0 and below export the XML as .metadata
If you are using a version of the PUT tool v6.6.1 and above export the XML as .opex

Upload Your CSV File

The Root Element Name

This is Root Element of the XML documents, e.g. oai_dc, dc, Metadata, Root etc

Default Namespace For The Root Element

This will become the default namespace of the XML documents, e.g. http://www.openarchives.org/OAI/2.0/oai_dc/ XML Namespaces are any valid URI or Uniform Resource Identifier.

CSV File

Make sure the Excel Spreadsheet has been saved as UTF-8 CSV

Information

This is a community site to provide support for Preservica users who want to create XML documents from CSV files. The site is not affiliated to Preservica or supported by Preservica Ltd.
Questions and issue can be posted to the github site.

XML Root Elements

The root element is the top level element within the XML document.
XML documents must contain one root element that is the parent of all other elements (spreasheet column names)

XML Namespaces

XML namespaces are used for providing uniquely named elements and attributes in an XML document.
The default namespace declaration has the following syntax. xmlns="URI"
Namespaces are used within Preservica to identify the XML document and allow users to assign custom viewers and editors.
You can re-use existing namespaces for standard schema's such as:

You can also create your own custom namespace. e.g. http://test.com/my-namespace.com