Analyse File for Structure
You can open the following dialogue via the source structure menu or the destination structure menu.
Depending on the type of file, a specific dialogue will be opened in which further settings can be made. The uploaded file is then analysed and an appropriate source or destination structure is automatically generated.
The following files can be analysed. These are the data files themselves, only XSD/DTD is a schema file. If you do not find your file format here, there are further possibilities in area Importing Structures in area General Data. See also section Working with Templates in general.
JSON (Hinweis: If the file contains arrays with several different data types, the analysis works only partially and must be adjusted manually.)
CSV
Excel
XML
X12
EDIFACT
IDoc
Swagger (JSON)
RESTful API ML (RAML)
In the following, we only deal with dialogues that have no self-explanatory settings or are not already linked to other sections.
(1) The row within the file that is to be used as an example for the structure to be created.
(2) The field delimiter.
(3) The Excel sheet to be used.
(4) The row within the file that is to be used as an example for the structure to be created.
(5) These settings are identical with the ones in section XML Schemas - XSD/DTD Files.
(6) The option No complex fields should always be activated if no repetition of the same field within a node can occur. Any XML element that has no sub-elements or attributes is then represented as a simple field in the Lobster_data structure. Otherwise, every simple field would be represented as a node containing a value field <nodename>_val. See also section Representation of XML Attributes in Source and Destination Structure.
(7) Here you have to specify the RAML resource type ("start" node) that you want to represent in your structure. Details about RAML can be found at www.raml.org.