| Author |
Message
|
| matuwe |
 Posted: Wed Feb 10, 2016 11:05 pm Post subject: Modelling DFDL for OFS message |
 |
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Hi Please assist, I am using IIB10 trying to model an OFS message coming from my core banking system. Do we have any template for this, I tried to model this as fixed with which shows to be incorrect as the message changes.. How can i model the message based on OFS standards?
Thanks for assisting.. |
|
| Back to top |
|
 |
| maurito |
| Posted: Wed Feb 10, 2016 11:37 pm Post subject: Re: Modelling DFDL for OFS message |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| matuwe wrote: |
Hi Please assist, I am using IIB10 trying to model an OFS message coming from my core banking system. Do we have any template for this, I tried to model this as fixed with which shows to be incorrect as the message changes.. How can i model the message based on OFS standards?
Thanks for assisting.. |
Pardon my ignorance, but what does OFS stand for ?
Does it have any standards ?
Does it have a description of its record formats, maybe one of the ISO formats ? |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 2:15 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
Hi , Thanks for the quick response.. OFS is == OPEN FINANCIAL SERVICE
Messages that flows from / to core banking systems.
use the link bellow https://www.google.co.za/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjX4ITXle_KAhWJ1RoKHXD_ALcQFggnMAE&url=http%3A%2F%2Fmarkmail.org%2Fdownload.xqy%3Fid%3Dhgthhisf4quaanhi%26number%3D1&usg=AFQjCNHFgNb1Lyngr0RCg0MfAdyCCwHbWw&sig2=pHbDg1LvR2RoczibDfm-Lw
check page 42...
The message looks something like this
FT1111212P1J8C//1,TRANSACTION.TYPE=ACQR:1:1,DEBIT.ACCT.NO=999999999:1:1,CURRENCY.MKT.DR=1:1:1,DEBIT.CURRENCY=RSA:1:1,DEBIT.AMOUNT=1000.00:1:1,DEBIT.VALUE.DATE=20021109:1:1,CREDIT.ACCT.NO=5454545454:1:1,CURRENCY.MKT.CR=1:1:1,CREDIT.CURRENCY=RSA:1:1,CREDIT.VALUE.DATE=20101109:1:1,PROCESSING.DATE=20101109:1:1,CHARGES.ACCT.NO=999999999:1:1,CHARGE.COM.DISPLAY=NO:1:1,COMMISSION.CODE=DEBIT PLUS CHARGES:1:1,COMMISSION.TYPE=SSSBULK:1:1 |
|
| Back to top |
|
|
| maurito |
| Posted: Thu Feb 11, 2016 2:25 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| matuwe wrote: |
check page 42...
|
I think you mean page 32, as that document does not have 42.
According to that the message definition is:
| Code: |
OFS message example (enquiry)
ENQUIRY.SELECT,,INPUTT/123456,ACCOUNT-LIST,CUSTOMER.MNEMONIC:EQ=ALEXCOURT
Operator Globus account to be executed
ENQUIRY.SELECT
Options: Version of the application
N/A
User information: Globus sign on name & password
INPUTT/123456
Transaction ID: The enquiry to be executed
ACCOUNT LIST
Message Data – Enquiries: Data required to initiate an enquiry
Selection field: CUSTOMER
Operand: EQUAL TO
Field Value: ALEXCOURT
|
so, why are you using fixed length format ? that looks more like a CSV.
The message you posted is just ONE example and cannot be used for modelling.
You MUST use the format from the document, read it, understand it and then have a go.
Once you have done that, if you have any problems, then you can explain what you did and what problems you have, but you need to try it yourself first and don't ask at the first hurdle. |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 2:31 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
hi
I tried both csv and fixed.. My only delemma is how do i do comma with name value.. The comma is fine, that seems to get the data, but then how do i get the name value without writing long code ..? |
|
| Back to top |
|
|
| maurito |
| Posted: Thu Feb 11, 2016 2:36 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| matuwe wrote: |
hi
I tried both csv and fixed.. My only delemma is how do i do comma with name value.. The comma is fine, that seems to get the data, but then how do i get the name value without writing long code ..? |
As I said before, you need to understand the message definition first.
Then, you need to know about DFDL, do you know what an initiator is ?
In your case, you may have different initiators for the same field, in which case you will need a choice. But all that is for you to read and understand, then try it out. |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 2:47 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
okay thanks.. I will look into DFDL comma delimited with initiator..
will this be almost same as Fixed width with record Identifier>? Sorry havent used DFDL, I am used to Messageset terminology..
How do I suggest to IBM to build such template, same as what they have done for ISO message in IIB 9 and 10.. This is banking standard I am sure a lot of banks do need this. |
|
| Back to top |
|
|
| maurito |
| Posted: Thu Feb 11, 2016 2:53 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| matuwe wrote: |
| okay thanks.. I will look into DFDL |
Do that.
| matuwe wrote: |
will this be almost same as Fixed width with record Identifier>? Sorry havent used DFDL, I am used to Messageset terminology..
|
No
| matuwe wrote: |
How do I suggest to IBM to build such template, same as what they have done for ISO message in IIB 9 and 10.. This is banking standard I am sure a lot of banks do need this. |
Open an RFE |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 2:55 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
 thanks |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 3:20 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
|
| Back to top |
|
|
| maurito |
| Posted: Thu Feb 11, 2016 3:27 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
Yes, that presentation by timber is a good starting point, but you will need a lot more than that. As I said before, you need to understand the structure of your messages. |
|
| Back to top |
|
|
| matuwe |
| Posted: Thu Feb 11, 2016 3:40 am Post subject: |
|
|
Master
Joined: 05 Dec 2007
Posts: 296
|
|
| Back to top |
|
|
|
|
