mt940 parser

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

mt940 parser

Postby Harjo » Wed Apr 10, 2013 8:35 pm

Did anyone build already an mt940 parser? (format for dutch bank-account data)

We have build already a small method, for one bank, but the format differs from bank to bank.
Maybe someone interested in setting up an opensource project?
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4289
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: mt940 parser

Postby jw teunisse » Thu Apr 11, 2013 9:48 am

about 13 years ago I build a sort of MT940 parser on the Windows platform. With regards to the coming SEPA/IBAN payments I should also consider the format CAMT.053. Its format has more fields. This means that in MT940 a lot of information is placed in the fieldtag 86 (a free description field) and each bank approches that differently.
jw teunisse
 
Posts: 27
Joined: Tue Jan 23, 2007 9:54 pm
Location: Amersfoort, NL

Re: mt940 parser

Postby Harjo » Thu Apr 11, 2013 9:53 am

Hi Jw,

yes I know, this is also called: MT940 structured! ;-)
I have already searched a lot for 'javascript mt940' but could'nt find any javascript parser.
There are a few (and good ones) written in PHP & Ruby... (searched on gitHub)
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4289
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: mt940 parser

Postby ptalbot » Thu Apr 11, 2013 5:07 pm

There is a Java Mt940Parser which is part of the Open Source jGnash finance application: http://sourceforge.net/projects/jgnash/
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
http://www.servoy-stuff.net
https://www.servoyforge.net
--------------------------------------------
Servoy 5.2.16 / 6.0.9 / 6.1.6 / 7.3.1
All OSes / Java 5 & 6 & 7
User avatar
ptalbot
 
Posts: 1612
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: mt940 parser

Postby Harjo » Thu Apr 11, 2013 5:17 pm

yeah I saw that one too, but from what I hear & read, it has a very basic (poor) mt940 parser...
And I'm not a Java programmer ;-)
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4289
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: mt940 parser

Postby ptalbot » Thu Apr 11, 2013 5:55 pm

I haven't seen it, was just pointing you to it.
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
http://www.servoy-stuff.net
https://www.servoyforge.net
--------------------------------------------
Servoy 5.2.16 / 6.0.9 / 6.1.6 / 7.3.1
All OSes / Java 5 & 6 & 7
User avatar
ptalbot
 
Posts: 1612
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: mt940 parser

Postby jw teunisse » Fri Apr 19, 2013 10:33 am

Harjo, do you have a specification of the method to parse a MT940 file available? At the moment I'm investigating the possibility to write a groovy script to convert a MT940 file to for instance a CSV file or XML.
A second step could be the development of a plugin to parse a MT940 file.
jw teunisse
 
Posts: 27
Joined: Tue Jan 23, 2007 9:54 pm
Location: Amersfoort, NL

Re: mt940 parser

Postby lucky.3526 » Mon Mar 21, 2016 4:20 pm

Hi JW,

I am looking for groovy script which will convert MT940 to csv.
If you can help, that will really great help of you.

Thanks,
Lucky
lucky.3526
 
Posts: 1
Joined: Mon Mar 21, 2016 4:20 pm


Return to Programming with Servoy

Who is online

Users browsing this forum: Bing [Bot] and 4 guests

cron