0000907: Add XML format to table support

FLAM® Issue Tracker

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000907

FL5

2.2 Subprogram FLUC (CONV)

public

2017-12-20 09:08

2018-03-08 18:41

Reporter

Falk Reichbott

Assigned To

Falk Reichbott

Priority

normal

Severity

feature

Reproducibility

N/A

Status

resolved

Resolution

fixed

Platform

General

OS Version

General

Product Version

5.1.16

Target Version

5.1.17

Fixed in Version

5.1.17

Summary

0000907: Add XML format to table support

Description

By defining a path to the elements of an row, the table support can handle structured and unstrucktured XML data formats like SEPA.

Example:

<?xml version='1.0'?>
<root>
  <table>
    <row>
       <name>Falk</name>
       <value>1234</value>
    </row>
    <row>
       <name>Rolf</name>
       <value>2345</value>
    </row>
  </table>
</root>

this XML document can be converted to this CSV file

"name","value"
"Falk","1234"
"Rolf","2345"

with the command below

read.char(file='%s' table(format=XML xmlpath='root'
row(name=namevale xmlpath='table.row' col(name=name) col(name=value))
write.text(file='%s' table(format=CSV))

Tags

No tags attached.

Attached Files

Relationships

Notes
(0001149) Falk Reichbott (administrator) 2018-03-08 18:41	A full scope XML support containing (header, arrays, optional fields, ...) to convert each kind of XML in flat tables and back to a any kind of XML structure are implemented. Addtional the CONV function of the byte and record interface was extented to support memory to memory conversion of such complex data to support the instant payment stuff of the central banks. The data format conversion of FLAM can now be used for file processing (ESB for persistant data) but also for transaction (ESB for online data). Additional a small enhancement to add columns to a table at write was implemented, for example to a xmlns attributes to the root tag.

Issue History
Date Modified	Username	Field	Change
2017-12-20 09:08	Falk Reichbott	New Issue
2017-12-20 09:08	Falk Reichbott	Status	new => assigned
2017-12-20 09:08	Falk Reichbott	Assigned To	=> Falk Reichbott
2018-03-08 18:41	Falk Reichbott	Note Added: 0001149
2018-03-08 18:41	Falk Reichbott	Status	assigned => resolved
2018-03-08 18:41	Falk Reichbott	Fixed in Version	=> 5.1.17
2018-03-08 18:41	Falk Reichbott	Resolution	open => fixed