FLAM Issue Tracker - FL5
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000907FL52.2 Subprogram FLUC (CONV)public2017-12-20 09:082018-03-08 18:41
ReporterFalk Reichbott 
Assigned ToFalk Reichbott 
PrioritynormalSeverityfeatureReproducibilityN/A
StatusresolvedResolutionfixed 
PlatformGeneralOSGeneralOS VersionGeneral
Product Version5.1.16 
Target Version5.1.17Fixed in Version5.1.17 
Summary0000907: Add XML format to table support
DescriptionBy 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))

Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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.