Metadata Mapping for yuuvis® RAD extraction-service

yuuvis® RAD extraction-service provides the following mappings of default properties from e-mail files on joint yuuvis® RAD aliases:

yuuvis® RAD extraction-service provides the following mappings of EXIF data from audio, video, and image files, and XMP data from Office and PDF files on shared yuuvis® RAD tags:

yuuvis® RAD extraction-service can extract the data from e-invoices.

It uses a preconfigured mapping of XML paths to aliases.

This mapping can be viewed via the Swagger UI. Endpoint: GET /extraction/api/info/mapping

The aliases are shown with data type and assigned path.

Example: FERD:Document.IssueDateTime[Date] = {/CrossIndustryDocument/ExchangedDocument/DateTimeString}

Several paths for different e-invoice formats can be assigned to an alias.

The response can be saved.

If a path is found during the extraction of an e-invoice, the corresponding value is assigned to the alias.

The test file extraction shows the assignments.

Example: "FERD:Document.IssueDateTime": "2024-08-06T00:00:00+02:00"

Mapping configuration

The preconfigured mapping can be extended:

• Create the mappings directory in the data directory of yuuvis® RAD service-manager.

• Create a text file with the name invoicemapping.lst there.

• Enter the alias and path assignments there.
  The syntax must correspond to that of the response. You can freely choose the name for the alias. If no data type is specified, it is assumed that the data type is 'String'. Data types: String, Double, Integer, Sequence, Boolean, Date.
  The mapping of the invoicemapping.lst file has priority over the preconfigured mapping.
  

• Test the extraction.

The name of the text file used for the mapping can be changed via the <service-manager>\config\extraction-prod.yml configuration file:

extraction: 
  invoicemappings: 'c:/mappings/custom_invoicemapping.lst'

E-invoices with tables

Invoice data can have a row-by-row table structure. This data can be transferred line by line to a table in yuuvis® RAD. The aliases will be assigned to the columns.

This is preconfigured for aliases whose designation begins with FERD.LineItem.

Example: FERD:LineItem.Name[String] = {/Invoice/InvoiceLine[#]/Item/Name}

In the extracted data, these aliases are marked with the line number in square brackets.

The alias is specified in yuuvis® RAD designer without a data type: FERD:LineItem.Name