Skip to Content
avatar image
Former Member

Sender File content conversion

Hi Experts,

My scenario is file to proxy. I need help in file content conversion.attached sample input file and message type  . My requirement is need to read all lines and send to proxy.

Header starts with H H;fieldname1;fieldname2;;;fieldnamen;

Details starts with D  D;fieldname1;fieldname2;;;fieldnamen;

Control block starts with CH CH;Number of header;Total amount of currency;

CH; Unique currency name;total amount of that currency

Pls guide me for content conversion parameters

Thanks in advance

Jeevitha N

Sample.jpg (98.7 kB)
MT.jpg (168.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 28, 2015 at 06:09 AM

    Hi ,

    Below is  structure, File content conversion parameters and sample file.

    Please check and correct me..

    Please correct me , if wrong anywhere

    Thanks

    Jeevitha N


    structure.jpg (114.8 kB)
    FCC1.jpg (122.7 kB)
    input1.jpg (21.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 12:15 PM

    Hi Jeevitha,

    If understand you right you will have a key field to know in which part the file is. Check this Shabarish blog Content Conversion ( The Key Field Problem )

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 01:15 PM

    Hello Jeevitha,

    Try this

    Header.fieldSeparator - ;

    Header.fieldNames - LineIndicator,Suppliercode,InvoiceDate,Curreny,Amount

    Header.keyFieldValue - H

    Detail.fieldSeparator - ;

    Body.fieldNames - LineIndicator,Linetype,Companycode,Costelement

    Body.keyFieldValue - D

    Controlblock.fieldSeparator - ;

    Trailer.fieldNames - controlIndicator,Totalline,Total,Currency

    Trailer.keyFieldValue - CH

    ignoreRecordsetName - true

    File Content Conversion - Process Integration - SCN Wiki

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 11:01 AM

    Hi,

    I am getting below error.

    Below is the file content conversion parameters,. Please correct me if I am wrong anywhere.

    Input file :


    error.jpg (53.1 kB)
    three.jpg (85.0 kB)
    two.jpg (49.6 kB)
    One.jpg (61.5 kB)
    input.jpg (16.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 03:37 AM

    Hi Jeevitha

    If you require the lines with X, CH and CD, then standard FCC conversion will not work because it is a deeply nested structure (due to repeating H followed by D).

    There are various alternatives to handle this, below are two solutions that I have come up with to handle deep structures.

    XSLT approach to enable FCC for deep structures (Part 2 - Flat File to Deep XML)

    DeepFCCBean - The better FCC at meeting your deep (structure) needs! (Part 2 - Flat File to Deep XML)

    Rgds

    Eng Swee

    Add comment
    10|10000 characters needed characters exceeded