INDUSTRY
Media management
PROJECT TYPE
Enterprise
XML METS tool
App generating XML files of METS standard from Excel documents.

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:

  1. The tool processes received files and loads the read data into an XML file with a specific structure. 
  2. Further, the program reads metadata from image files that were specified in an Excel file and inserts them into an XML file. 
  3. 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.