File to XML

File to XML

The eiConsole Offers Easy Visual File to XML Editing with One-Click Import of Sample Data Formats and Data from the Selected Source System

You access the File to XML Editing component of the eiConsole, you simply click the “Edit” button (yellow area shown below) on the Transformation Module Configuration panel.

File-to-XML detail

This opens the File Specification Editor component (below) where you perform file to XML editing. File-to-XML Editing Panel

File-to-XML Editing Panel

For file to xml editing the user can choose between the Delimited and Fixed-Width File Transformation Module. The graphical interface utilizes color coding and tabs that allow the user to easily perform file to xml editing.

The File Specification Editor lets you import sample data formats and data from the Source System into the File Spec Editor where it can be visually edited. Tab Delimited, CSV, COBOL copybooks, HL7 v2.x and other files can be directly imported. You can also import individual record definitions from a spreadsheet.

Time saving features abound: you can modify the definition of the fields in the Structure Component Information section, the record structure tree or by simply sliding around the blue arrows in the Preview record structure window.

det_fin_tab-sliding

A Module Configuration tab allows you to add in Data Sources, Record Controls and Converters. The File Specification Editor works in two directions. It can take a non-XML file and convert it into an XML format as described by the record structure tree, or it can go in reverse and take an XML instance document (structured similarly to the record structure tree) and can convert that data into a fixed file form.

Under the covers, the information edited in the Record Structure tab is represented in an XML format in the Edit Spec XML tab. You can always go back and forth between the XML representation of the File Specification and the graphical rendering of the record structure.

det_fin_file-spec-graphical

By clicking “Save” the incoming data format is converted to a generic XML format – the first stage in the transformation process. The developer then returns to the main eiConsole window.

TAKE A TOUR

NEXT >> XML DATA MAPPING

NEXT >> XML SCHEMA MANAGEMENT

This is a unique website which will require a more modern browser to work! Please upgrade today!