Skip to content
ISO 20022 camt.053 XML bank statement XSL transforms for FO, PDF and CSV
XSLT
Branch: master
Clone or download
Latest commit 4a12210 Nov 27, 2014
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
GPL-3.txt Initial import to Git Nov 27, 2014
README.txt Initial import to Git Nov 27, 2014
camt2csv.xsl Initial import to Git Nov 27, 2014
camt2pdf.xsl Initial import to Git Nov 27, 2014

README.txt

Introduction
------------

This project provides some XSL files for working with bank statements
published using the camt 053 XML file format.

 * camt2pdf.xsl converts the bank statement to a PDF for printing
 * camt2csv.xsl converts the bank statement to a CSV file for
   use with a spreadsheet

camt 053 defines the message named BankToCustomerStatementV04

How to use
----------

GNU/Linux users can install the xsltproc and fop utilities.
On Debian and Ubuntu, the package names are xsltproc and fop,

  $ sudo apt-get install xsltproc fop

The xsltproc utility transforms the bank statement into an XSL-FO XML file
describing the print layout.  The fop utility transforms the XSL-FO file
into PDF or another output format (see the man page for details).

Here is an example of how to generate a PDF:

  $ xsltproc camt2pdf.xsl statement.xml | fop - statement.pdf

and here is an example to convert camt 053 to CSV:

  $ xsltproc camt2csv.xsl statement.xml > statement.csv

Known issues
------------

Different banks may use slightly different versions of the camt 053
specification.  The exact version is specified in the xmlns attribute
in the XML file itself.

For example, Swiss Postfinance sends camt 053 XML files containing the
following:

  <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02"
   ...

while the sample document from the ISO 20022 web site contains this:

  <Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.053.001.04"
   ...

The exact same namespace string must be used in the xmlns:camt line
of the XSL files.  To use camt2pdf.xsl with an XML from Postfinance,
change the line near the top of camt2pdf.xsl to read:

  <xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:fo="http://www.w3.org/1999/XSL/Format"
    xmlns:camt="urn:iso:std:iso:20022:tech:xsd:camt.053.001.02">

If you see an error like this when converting to PDF:

Exception
org.apache.fop.apps.FOPException:
  org.apache.fop.fo.ValidationException:
   "fo:table-body" is missing child elements.
   Required content model: marker* (table-row+|table-cell+)
       (See position 5:747)

it may be that the bank statement XML is invalid, or the xmlns did not
match.

More details and related free software projects
-----------------------------------------------

 * http://www.iso20022.org/payments_messages.page
 * http://en.wikipedia.org/wiki/ISO_20022
 * http://project.i20022.com/
 * http://www.c24.biz/

Copyright and license information
---------------------------------

Copyright (C) 2012-2014, Daniel Pocock http://danielpocock.com

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.

You can’t perform that action at this time.