Fw: [pear-webmaster] SEPA Pain .008.001.02 XML script

Hello Ken, Christian,

I did not hear from you.
The email adres <[email protected]> provided a fault message.

Meanwhile I created a separate subclass for PaymentInformation.  It's
working on our site.
I learned from a Belgium site that there will be some differences in the XML
per bank for the grouping:

SINGLE, which means that you have one TransactionInformation block per
PaymentInformation Block.  There can be more than one PaymentInformation
Blocks in the XML message.

GROUPED, which means that there is only one PaymentInformation block in the
XML message, which contains all TransactionInformation blocks.

MIXED, which means that there are multiple PaymentInformation blocks with
each such block containing multiple TransactionInformation blocks.

With the separate subclass for PaymentInformation this can be implemented by
the user.

What do you think?

Best regards,
Marcel

----- Original Message -----
From: "Marcel Groot" <[email protected]>
To: "Ken Guest" <[email protected]>
Cc: "Christian Weiske" <[email protected]>; <[email protected]>
Sent: Saturday, June 16, 2012 1:03 PM
Subject: Re: [pear-webmaster] SEPA Pain .008.001.02 XML script


> Dear Ken,
>
> Firstly I made the program the "old school way" but now I have converted
it
> to two classes, which makes it usable for a wide public I believe.
> It works on my server at TransIP.
>
> attached I have two php scripts, two pdf's and one picture:
> - sepaclass.php, which contains two classes for generating the XML file
> according Pain format.
> - example_use_sepaclass.php, which provides a user an example how to use
the
> classes.
> If you load the two scripts, you can run example_use_sepaclass.php right
> away.  The XML file will open with any browser.
>
> - asset debits, nvvb rev2.2 Feb 2011 (incassos).pdf, this is the english
> text for the XML implementation guidelines issued by the dutch bank
> association
> - OverzichtBICNummersNederland.pdf, this is cross table to find a BIC code
> from the IBAN.   A user database usually has a table with the bank numbers
> of all its members and this need to be translated off course to IBAN
> numbers, for which services on the internet exists (www.ibanbicservice.nl)
> where you can upload your list with banknumbers and an hour later you have
> the IBAN's back.    However, in the new system you also need to have a BIC
> code.  I loaded this table in a database to extract the BIC code
> corresponding a member's IBAN.  I can imagine users would like to have
this
> table too.
>
> -member administration.jpg, shows you that our program can generate the
> "old" clieop files for which I use the scripts from Dave Mertens, and
lately
> also the SEPA file. It works with the real data.
>
> If you look to the files from Dave Mertens, I copied more or less a
similar
> structure.
>
> If you or others have any comments, please contact me and I am more than
> willing to adjust.  (One improvement might be to make a separte subclass
for
> paymentinformation as according the guideline a sepa file can have
> multiples, however I believe for normal use this is not needed)
>
> I did assemble quite some information from the internet about the
conversion
> process to IBAN and SEPA.
> We are in contact with our bank to get it arranged such that we can also
> upload SEPA files, however I noticed that they are not up to speed yet and
> play delay tactics. Will keep you informed.
>
> Best regards,
> Marcel
> ----- Original Message -----
> From: "Ken Guest" <[email protected]>
> To: "Marcel Groot" <[email protected]>
> Cc: "Christian Weiske" <[email protected]>;
<[email protected]>
> Sent: Monday, June 11, 2012 6:54 PM
> Subject: Re: [pear-webmaster] SEPA Pain .008.001.02 XML script
>
>
> Marcel,
> If your code is of use to more than just a small number of people I
> would prefer to see it on PEAR rather than just blindly pushed to
> github - especially as
> it's functionality will superseding an existing PEAR package that is
> to be obsoleted by industry/standards guidelines.
>
> I'm sure we can all suggest ways to make it less specific to your own
> database and for it to be more widely adoptable.
>
>
> Kind regards
>
> Ken
>
> On Mon, Jun 11, 2012 at 5:54 PM, Marcel Groot <[email protected]>
> wrote:
> >
> > Hello Christian,
> >
> > It is not a code just suitable for my database although it uses the
> database
> > to create the XML file, but this can come from anywhere. At this moment
> > everyone here in the Netherlands uses a Clieop file to upload incasso
> > batches to their bank.
> > In Feb 2014 the Clieop file format will become obsolete and needs to be
> > replaced by the XML Pain 008.001.02.
> >
> > In the past I used the scripts posted by Dave Mertens on your site about
> > Clieop files and this worked well.
> >
> > No problem, I'll post it on sourceforge or github to help others.
> >
> > best regards,
> > Marcel
> >
> > ***************************************************
> > It seems to me as if this is a tool specific for your database, so it
> > probably won't be that useful for other people. Do I see that right?
> >
> > Maybe you should just push the code to sourceforge or github.
> >
> >
> > --
> > Regards/Mit freundlichen Grüßen
> > Christian Weiske
> > ----- Original Message -----
> > From: "Christian Weiske" <[email protected]>
> > To: "Marcel Groot" <[email protected]>
> > Cc: <[email protected]>; "Marcel Groot"
> > <[email protected]>; <[email protected]>
> > Sent: Sunday, June 10, 2012 9:39 AM
> > Subject: Re: [pear-webmaster] SEPA Pain .008.001.02 XML script
> >
> >
> >
> >> To prepare for this I developed a simple php script which produces
> >> out of our member database such a XML file with the format according
> >> Pain.008.001.02. Currently I am in the process to get things arranged
> >> at our (Rabo)bank as well, but I noticed that I am the first one in
> >> their organisation who started about this. A first XML generated
> >> file is already in their posession for verification.
> >>
> >> I wonder if you would be interested to place this script on your pear
> >> site as it might help others as well.
> >
> > .
> >
> >
> > --
> > PEAR Webmaster Mailing List (http://pear.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
>
> --
> http://blogs.linux.ie/kenguest/
>