XML METS tool

App generating XML files of METS standard from Excel documents.

INDUSTRY
Media management

PROJECT TYPE
Enterprise

TECHNOLOGIES

java

An enterprise application for generating XML files of METS standard from Excel documents for the subsequent exchange of documentary information and metadata on digitized archival documents.

Task

The purpose of the project is development of a tool using which the customer can generate XML documents from Excel spreadsheets. Our challenge was to build XML and to fill it with data and metadata, received from images, as well as from Excel-documents.

TECHNOLOGIES

java

Solution

The input of the program is an Excel-file or a folder. It works by the following algorithm:

The tool processes received files and loads the read data into an XML file with a specific structure.
Further, the program reads metadata from image files that were specified in an Excel file and inserts them into an XML file.
After that, this XML file is validated by XML schemes (XSD), and the output is a finished XML file.

Technologies used:

Java 8
Spring
JPA/Hibernate
Oracle/MSSQL

Explore more projects.

Briefing Module

OMN plugin for creating catalog page layouts.

Media management

Enterprise

MetaData Translation

OMN Flash plugin for translating product descriptions.

Media management

Enterprise

Article Briefing

OMN plugin for simplifying the process of associating assets with products.

Media management

Enterprise

OMN

Large software product for solving various tasks in Media production management.

Media management

Enterprise