AnsweredAssumed Answered

CAMT.053 format as flat file

Question asked by cristi936523 on Feb 8, 2018

I have the task of creating a flat file profile that will match the CAMT.053 document structure. The document looks like this(2 different examples):

 

File containing individual transfers:


UHL1
1 1501 000000 0300
2 100010 010118
19-19 123 5001 1234567890 03000558 9999 AV:message first part|second (...)
19-19 123-123 10002 1234567890 03000558 8888 AV:hello|hi
19 123456 25003 0123456789 03000558 7777 AV:see you|kind regards
19 654321 60004 0123456789 03000138 6666 NN:sending 600,04 czk
3+
5+


File containing mass orders – both payment and direct debits:


UHL11010179INSTRUCTING PARTY 200222780978658999123456654321
1 1501 000000 0300
2 19-19 000000000100010 20180101
123 5001 01234567890 03000558 9999 AV:message first part|second (...)
123-123 10002 01234567890 03000558 8888 AV:hello|hi
123456 25003 0123456789 03000558 7777 AV:see you|kind regards
654321 60004 0123456789 03000138 6666 AV:sending 600,04 czk
3 +
5 +
1 1502 999999 0300
2 0001230000000123 0000000000100010 111117
123 5001 1234567890 03000558 9999 AV:message first part|second (...)
1230000000123 10002 1234567890 03000558 8888 AV:hello|hi
19-19 25003 0123456789 03000558 7777 AV:see you|kind regards
000019-19 60004 0123456789 0003000138 6666 ZZZdebiting 600,04 czk |||thx
3 +
5 +

 

Group of orders is closed by charactes:
3 +

Accounting file is closed by characters:
5 +

First line is the header.

 

The file will be picked up from a SFTP, and I need to parse it inside boomi, and convert it to an XML format. I tried playing around with the settings of the flat file profile, but to no avail. I think I can build some functions inside a map to parse the input file and split it up, but I am looking for a simple solution.

 

Kind regards,

Cristian

Outcomes