FLAM Issue Tracker - FL5
View Issue Details
0000907FL52.2 Subprogram FLUC (CONV)public2017-12-20 09:082018-03-08 18:41
Falk Reichbott 
Falk Reichbott 
normalfeatureN/A
resolvedfixed 
GeneralGeneralGeneral
5.1.16 
5.1.175.1.17 
0000907: Add XML format to table support
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))

No tags attached.
Issue History
2017-12-20 09:08Falk ReichbottNew Issue
2017-12-20 09:08Falk ReichbottStatusnew => assigned
2017-12-20 09:08Falk ReichbottAssigned To => Falk Reichbott
2018-03-08 18:41Falk ReichbottNote Added: 0001149
2018-03-08 18:41Falk ReichbottStatusassigned => resolved
2018-03-08 18:41Falk ReichbottFixed in Version => 5.1.17
2018-03-08 18:41Falk ReichbottResolutionopen => fixed

Notes
(0001149)
Falk Reichbott   
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.