Welcome, guest | Sign In | My Account | Store | Cart

Notice! PyPM is being replaced with the ActiveState Platform, which enhances PyPM’s build and deploy capabilities. Create your free Platform account to download ActivePython or customize Python with the packages you require and get automatic updates.

Download
ActivePython

csb43 0.2.2 (experimental)
Spanish banks' CSB norm 43 converter to OFX, Homebank, json, yaml, xls, xlsx, ods, csv, tsv

INSTALL>
pypm install csb43

How to install csb43

  1. Download and install ActivePython
  2. Open Command Prompt
  3. Type pypm install csb43
 Python 2.7Python 3.2Python 3.3
Windows (32-bit)
Windows (64-bit)
Mac OS X (10.5+)
Linux (32-bit)
Linux (64-bit)
0.2.2 Available View build log
 
Links
Author
License
LGPL
Dependencies
Lastest release
version 0.2.2 on Jan 9th, 2014

English

Tools for converting from the Spanish banks' format CSB norm 43 (CSB43).

csb2format

Convert a CSB norm 43 file to other file formats.

Supported formats:

  • OFX
  • HomeBank CSV
  • HTML
  • JSON
  • ODS: OpenDocument spreadsheet
  • CSV, TSV: comma- or tab- separated values
  • XLS: Microsoft Excel spreadsheet
  • XLSX: OOXML spreadsheet
  • YAML
Options:
usage: csb2format [-h] [-s] [-df] [-d DECIMAL]
                [-f {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}]
                [csbFile] [formatFile]

Convert a CSB43 file to another format

positional arguments:
csbFile               a csb43 file (stdin '-' by default)
formatFile            name for output file (stdout '-' by default)

optional arguments:
-h, --help            show this help message and exit
-s, --strict          strict mode
-df, --dayfirst       use DDMMYY as date format while parsing the csb43 file
                        instead of YYMMDD
-d DECIMAL, --decimal DECIMAL
                        set the number of decimal places for the currency type
                        (default: 2)
-f {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}, --format {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}
                        Format of the output file. Default: ofx
Examples

  • Converting to OFX format:

    $ csb2format transactions.csb transactions.ofx

$ csb2format --format ofx transactions.csb transactions.ofx

    or

    $ csb2format transactions.csb > transactions.ofx

    From another app to file

    $ get_my_CSB_transactions | csb2format > transactions.ofx

  • Converting to XLSX spreadsheet format:

    $ csb2format --format xlsx transactions.csb transactions.xlsx
Spreadsheets

ODS and XLS files are generated as books, with the first sheet containing the accounts information, and the subsequent sheets containing the transactions of each one of the accounts.

In XLSX files all the information is flattened in just one sheet.

Using Python

Parse a CSB43 file and print the equivalent OFX file

:::python

# OFX
from csb43 import csb_43, ofx

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# print to stdout
print ofx.convertFromCsb(csbFile)

Parse a CSB43 file and print the equivalent HomeBank CSV file

:::python

# OFX
from csb43 import csb_43, homebank

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# print to stdout
for line in homebank.convertFromCsb(csbFile):
    print line

Parse a CSB43 file and print the equivalent in a tabular or dictionary-like file format

:::python

# OFX
from csb43 import csb_43, formats

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# print 'yaml' format to stdout
o = format.convertFromCsb(csbFile, 'yaml')
print o.yaml

# write 'xlsx' format to file
o = format.convertFromCsb(csbFile, 'xlsx')
with open("movimientos.xlsx", "wb") as f:
    f.write(o.xlsx)

Español

Herramientas para convertir ficheros en formato usado por múltiples bancos españoles (norma 43 del Consejo Superior Bancario [CSB43]) a otros formatos.

csb2format

Convierte un fichero CSB norma 43 a otros formatos.

Formatos soportados:

  • OFX
  • HomeBank CSV
  • HTML
  • JSON
  • ODS: hoja de cálculo OpenDocument
  • CSV, TSV: valores separados por coma o tabulador
  • XLS: hoja de cálculo de Microsoft Excel
  • XLSX: hoja de cálculo OOXML
  • YAML
Opciones:
usage: csb2format [-h] [-s] [-df] [-d DECIMAL]
                [-f {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}]
                [csbFile] [formatFile]

Convierte un fichero CSB43 a otro formato

positional arguments:
csbFile               fichero csb43 (entrada estándar '-' por defecto)
formatFile            nombre del fichero de salida (salida estándar '-' por
                        defecto)

optional arguments:
-h, --help            show this help message and exit
-s, --strict          modo estricto (para en el primer error)
-df, --dayfirst       usa DDMMYY (día, mes, año) como formato de fecha al
                        interpretar los datos del fichero csb43 en lugar de
                        YYMMDD (año, mes, día)
-d DECIMAL, --decimal DECIMAL
                        establece el número de dígitos decimales a considerar
                        en el tipo de divisa (por defecto: 2)
-f {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}, --format {csv,homebank,html,json,ods,ofx,tsv,xls,xlsx,yaml}
                        Formato del fichero de salida. Por defecto: ofx
Ejemplos

  • Convertir a formato OFX:

    $ csb2format transactions.csb transactions.ofx

$ csb2format --format ofx transactions.csb transactions.ofx

    o bien

    $ csb2format transactions.csb > transactions.ofx

    Desde una aplicación de recuperación de datos a otro fichero

    $ get_my_CSB_transactions | csb2format > transactions.ofx

  • Convertir a hoja de cálculo XLSX (Excel):

    $ csb2format --format xlsx transactions.csb transactions.xlsx
Hojas de cálculo

Los ficheros en ODS y XLS se generan a modo de libro, conteniendo la primera hoja la información relativa a las cuentas, y las hojas siguientes conteniendo cada una los movimientos de cada cuenta.

En los ficheros XLSX toda la información está aplanada en una sola hoja.

En Python

Lee un archivo CSB43 e imprime el contenido equivalente en OFX

:::python

# OFX
from csb43 import csb_43, ofx

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# imprime a stdout
print ofx.convertFromCsb(csbFile)

Lee un archivo CSB e imprime el contenido equivalente a CSV de Homebank

:::python

# OFX
from csb43 import csb_43, homebank

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# imprime a stdout
for line in homebank.convertFromCsb(csbFile):
    print line

Lee un archivo CSB e imprime el equivalente en un archivo de formato tabular o de diccionario

:::python

# OFX
from csb43 import csb_43, formats

csbFile = csb_43.File(open("movimientos.csb"), strict=False)

# imprime formato 'yaml' a stdout
o = format.convertFromCsb(csbFile, 'yaml')
print o.yaml

# escribe a archivo en formato 'xlsx'
o = format.convertFromCsb(csbFile, 'xlsx')
with open("movimientos.xlsx", "wb") as f:
    f.write(o.xlsx)

Installing

Using pip

$ pip install csb43

Using easy_install

$ easy_install csb43

If you are using Windows, you can download an executable file from the repository

Changelog

0.2.2
  • csb2format adapted to pyinstaller
  • Executable file for Windows
0.2.1
  • Trivial changes
0.2
  • Several bugfixes
  • Bidirectional use of objects (file -> object, object -> file)
  • Added conversion to spreadsheets, dict and tabular formats (thanks to tablib)
  • Localization to Spanish
  • Sphinx documentation
0.1
  • Initial release

Subscribe to package updates

Last updated Jan 9th, 2014

What does the lock icon mean?

Builds marked with a lock icon are only available via PyPM to users with a current ActivePython Business Edition subscription.

Need custom builds or support?

ActivePython Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds.

Plan on re-distributing ActivePython?

Get re-distribution rights and eliminate legal risks with ActivePython OEM Edition.