uCosminexus Service Platform, Basic Development Guide

[Contents][Glossary][Index][Back][Next]

6.12 Importing mapping definition using Excel

In Service Platform, you can import the file in which combination (mapping) of transformation source and transformation destination is defined in Excel, to the development environment.

When you want to perform similar mapping in multiple data transformation definitions, you can effectively use one mapping definition by using mapping definition created in Excel. Also, as you can check the mapping definition contents in Excel, you can reduce the mistakes at the time of definition in case of multiple transformation sources and transformation destinations and thus improve the development effectiveness.

To import mapping definition, export the contents mapped by defining in Excel, based on table format XML schema definition file. After that, import the data transformation definition file of development environment. In Data transformation definition screen, function or mapping line is generated according to the imported table format XML file.

Following figure shows the flow of importing the mapping definition.

Figure 6-50 FigureFlow of importing the mapping definition

[Figure]

You can directly create XML file according to table format XML schema definition file and import to the Data ran formation definition file.

In Service Platform, Excel of the following version is recommended.

Even when you create file by using any other tool, you can import if table format XML file is appropriate for table format XML schema definition file.

This section further describes procedure for creating table format XML file and for importing the mapping definition.

Organization of this section
6.12.1 Creating table format XML file
6.12.2 Setting up the mapping definition
6.12.3 Importing mapping definition
6.12.4 Points to be considered when using mapping definition using Excel