Servoy Forum

Discuss Servoy here!

Skip to content

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
Post a reply

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
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands
Top

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
Top

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
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands
Top

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
https://www.servoyforge.net
Velocity rules! If you don't use it, you don't know what you're missing!
User avatar
ptalbot
 
Posts: 1654
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC
Top

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
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands
Top

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
https://www.servoyforge.net
Velocity rules! If you don't use it, you don't know what you're missing!
User avatar
ptalbot
 
Posts: 1654
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC
Top

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
Top

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
Top
Post a reply

Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 6 guests

Learn more about Servoy