FLAM Issue Tracker - FL5
View Issue Details
0000866FL52.2 Subprogram FLUC (CONV)public2017-03-22 09:142017-09-28 23:28
Falk Reichbott 
Falk Reichbott 
0000866: Add table support to convert based on colums between CSV files and FB datasets
Add a new component to split records (rows/line) in columns. This support requires binary blobs, strings, integer and float data types and the conversion between different representations.

The goal is to read a CSV file and present a COPYBOOK structure (FB) on the record interface, supporting all the COMP, BCD style datatypes of COBOL and vice versa in order to be able to convert files containing records with strings and binary numbers.
No tags attached.
related to 0000824resolved Falk Reichbott Extend table support for IMS/DB2 unload formats (more than one table format per file) 
related to 0000867resolved Falk Reichbott Add column encryption, tokenisation, anonymisation to table support 
related to 0000782resolved Falk Reichbott Support of conversion of tables, CSV files and FB datasets 
Issue History
2017-03-22 09:14Falk ReichbottNew Issue
2017-03-22 09:14Falk ReichbottStatusnew => assigned
2017-03-22 09:14Falk ReichbottAssigned To => Falk Reichbott
2017-03-22 09:14Falk ReichbottRelationship addedrelated to 0000824
2017-03-22 09:17Falk ReichbottRelationship addedrelated to 0000867
2017-03-24 09:23Ulrich SchwabDescription Updatedbug_revision_view_page.php?rev_id=357#r357
2017-05-10 13:44Falk ReichbottRelationship addedrelated to 0000782
2017-09-28 23:28Falk ReichbottNote Added: 0001128
2017-09-28 23:28Falk ReichbottStatusassigned => resolved
2017-09-28 23:28Falk ReichbottFixed in Version => 5.1.16
2017-09-28 23:28Falk ReichbottResolutionopen => fixed

Falk Reichbott   
2017-09-28 23:28   
* First version of table support (FB<->CSV<->VB)
 ** A record can now split in several columns
 ** Each column are parted with different methods (fix length, length field, binary delimiter or CSV entry)
 ** Each column are assigned with a certain data type (binary, string, integer, float)
 ** Each data type supports different kinds of external representations (character set, endianness, BCD, ...)
 ** You must describe the table at read and you can use auto formatting at write
 ** You can remove and or reorder or add columns at write based on logical names
 ** You can handle more than one table per file by different row specifications
 ** This version of table support contains an unlimited amount of pre-/post processing steps
 ** No processors available yet, but with the next revision column encryption is planed
 ** This version of table support is prepared for tables in hierarchical formats (TLV (e.g. ASN-1), TVD (e.g. SWIFT), XML (e.g. SEPA))
 *** Support of Tag-Value-Delimiter text files like swift is planed for the next revision
 *** Support of XML files like SEPA are planed for the after next revision
 ** You can activate an end of table handling to write the tables of one source to different files