Parsing and validation utilites for the Spanish standard norm 43 by the 'Consejo Superior Bancario' (CSB) / 'Asociación Española de Banca' (AEB) for storing bank account transactions | [es] Herramientas para leer y validar datos almacenados siguiendo la norma 43 del Consejo Superior Bancario (CSB) / Asociación Española de Banca (CSB).
Project description
csb43
Tools for converting from the Spanish banks' format CSB norm 43 (CSB43).
csb2format
Convert a CSB/AEB norm 43 file to other file formats.
Supported formats:
- OFX v1.0.3 (SGML) & v2.1.2 (XML)
- HomeBank CSV
- JSON
- YAML
Additional formats are optionally provided by tablib
:
- HTML
- ODS: OpenDocument spreadsheet
- CSV, TSV: comma- or tab- separated values
- XLS: Microsoft Excel spreadsheet
- XLSX: OOXML spreadsheet
For an exhaustive list, see package tablib
.
Options:
usage: csb2format [-h] [-v] [-s] [--no-sepa] [-df] [-d DECIMAL] [-e ENCODING] [--use-float] [-V]
[-f {csv,dbf,homebank,html,jira,json,latex,ods,ofx,ofx1,rst,tsv,xls,xlsx,yaml}] [-E OUTPUT_ENCODING]
csb_file converted_file
Convert a CSB43 file to another format
options:
-h, --help show this help message and exit
-v, --version show program's version number and exit
csb43 arguments:
csb_file a csb43 file ('-' for stdin)
-s, --strict strict mode (default: False)
--no-sepa do not convert items to SEPA transfers or direct debits (default: True)
-df, --dayfirst use DDMMYY as date format while parsing the csb43 file instead of YYMMDD (default: True)
-d DECIMAL, --decimal DECIMAL
set the number of decimal places for the money amount type (default: 2)
-e ENCODING, --encoding ENCODING
set the input encoding ('cp850' for standard AEB file) (default: latin1)
--use-float export monetary amounts using binary floating point numbers as a fallback (default: str)
-V, --verbose show csb43 warnings (default: True)
output arguments:
converted_file destination file ('-' for stdout)
-f {csv,dbf,homebank,html,jira,json,latex,ods,ofx,ofx1,rst,tsv,xls,xlsx,yaml}, --format {csv,dbf,homebank,html,jira,json,latex,ods,ofx,ofx1,rst,tsv,xls,xlsx,yaml}
format of the output file (default: ofx)
-E OUTPUT_ENCODING, --output-encoding OUTPUT_ENCODING
set the output encoding (default: utf-8)
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
-
Using cp850 as the input encoding:
$ csb2format --encoding cp850 --format xlsx transactions.csb transactions.xlsx
Spreadsheets
ODS, XLS and XLSX 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.
Using Python
Parse a CSB43 file and print the equivalent OFX file
# OFX
from csb43.ofx import converter as ofx_converter
from csb43.aeb43 import read_batch
with open("movimientos.csb", "rb") as fd:
batch = read_batch(fd)
# print to stdout
print(ofx_converter.convert_from_aeb43(batch))
Parse a CSB43 file and print the equivalent in a tabular or dictionary-like file format
from csb43 import read_batch, formats
with open("movimientos.csb", "rb") as fd:
batch = read_batch(fd)
# print 'yaml' format to stdout
o = formats.convert_from_aeb43(batch, 'yaml')
print(o.yaml)
# write 'xlsx' format to file
o = formats.convert_from_aeb43(batch, 'xlsx')
with open("movimientos.xlsx", "wb") as f:
f.write(o.xlsx)
Build an AEB43 with a custom context:
import dataclasses
from csb43 import read_batch, get_current_context
# custom context
ctx = dataclasses.replace(get_current_context(), strict=True)
with open("movimientos.csb", "rb") as fd:
batch = read_batch(fd, context=context)
# scoped context
with get_current_context().scoped(strict=True):
with open("movimientos.csb", "rb") as fd:
batch = read_batch(fd)
Installing
Basic functionality (conversion to json, homebank and OFX)
$ pip install csb43
Conversion to YAML
$ pip install csb43[yaml]
Conversion to basic Tablib formats
$ pip install csb43[basic_formats]
Conversion to all Tablib formats
$ pip install csb43[formats]
Conversion to all supported formats
$ pip install csb43[all]
Changelog
0.10.0
- BREAKING CHANGES!
- Dropped support for python < 3.8. If you need support for old versions, please do not upgrade.
- New subpackage
csb43.aeb43
: CSB43 reimplemented using field descriptors:- the original binary record is kept as the internal representation
- consistent behaviour for field types (money, currency, int, string, etc...)
- validation failures will raise ValidationException o ValidationWarning depending of their gravity
- parsing of SEPA transfers and SEPA direct debits information stored in optional items in transactions.
- Subpackage
csb43.csb43
has been deprecated and it will be removed in a future version (and every package object that use it). - Classes and functions using camel case have been deprecated and they will be removed in a future version.
- Moved package settings from
setup.py
topyproject.toml
- Updated dependencies.
0.9.3
- Add support for Python 3.12 (thanks to Cédric Krier)
0.9.2
- Fixed setuptool's deprecation warning on python==3.10 (thanks to @mb)
- Fixed duplicated documentation of the same objects by sphinx (thanks to @mb)
0.9.1
- Added python_requires >= 3.6 (thanks to Cédric Krier)
0.9.0
- Dropped support for Python 2 (thanks to Sergi Almacellas)
- Added support for Python 3.8 and 3.9 (thanks to Sergi Almacellas)
- Added compatibility with tablib >= 1.0.0 (thanks to Sergi Almacellas)
- Type hinting
0.8.4
- Fixed tablib requirement (< 1.0.0)
- Fixed parsing of records with code 00 (thanks to Uttam Sharma)
0.8.2
- Do not fail with C locale (thanks to Cédric Krier)
0.8.1
- Fixed decimal values conversion in JSON and tabular formats (thanks to Harshad Modi).
- Fixed OFX validation (ORIGCURRENCY field).
- An error is raised when the currency code is not found.
0.8
- Text values are stored as string instead of bytes (thanks to Sergi Almacellas)
- Warnings are raised using the 'warnings' module.
- An encoding where control characters are different from ascii is not allowed. An exception will be raised.
- csb2format: added encoding as a new parameter.
0.7
- Defined installation targets:
yaml
andformats
(thanks to Sergi Almacellas & Cédric Krier). - Updated README file (thanks to Sergi Almacellas).
- Removed
simplejson
dependency. - Dates stored as
date
instead ofdatetime
(thanks to Sergi Almacellas). - Monetary amounts are represented as
Decimal
instead tofloat
in order to prevent representation and rounding issues. These fields are exported as a string by default, conversion to float is optional (thanks to Sergi Almacellas & Cédric Krier). - Added temprary dependency to
openpyxl < 2.5.0
to prevent issue while trying to export to xlsx.
0.6
- Fixed usage of pycountry >= 16.10.23rc1 objects (thanks to Alex Barcelo).
- Package refactored to simplify the structure.
0.5
- Fixed conversion to binary formats in python 2.
tablib
backend supported in python 3.- N43 warnings are silenced by default.
0.4
- OFX v 1.0.3 supported.
- OFX Tag inv401source renamed to inv401ksource.
- Unique transaction id when generating OFX file (thanks to Julien Moutte).
0.3.4
- Most Spanish N43 files will use LATIN-1 encoding not pure ASCII (thanks to Julien Moutte).
- Regular expression to check for account name is too limited (thanks to Julien Moutte).
- Reference1 can hold non numerical data in information mode 1 and 2 (thanks to Julien Moutte).
- Currency data as an inmutable list.
0.3.3
- Fixed deficiencies in OFX conversion (thanks to Andrea Santambrogio). Checked XML validation against OFX2_Protocol.xsd
0.3
- Compatible with Python 3 (except "tablib" dependencies)
0.2.3
- Fixed shebang header of csb2format
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file csb43-0.10.0.tar.gz
.
File metadata
- Download URL: csb43-0.10.0.tar.gz
- Upload date:
- Size: 552.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.0 CPython/3.10.11
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | f5c67bfbc96fc3dee9e9a8aade131e856c72f5f826f9a733ce684150f04303d2 |
|
MD5 | 29436084b7355c1e133085982a296f8d |
|
BLAKE2b-256 | 0b825fb992644406985cfdf0ce6019925fa5f619dc4840bb40d1082cee336a6f |
File details
Details for the file csb43-0.10.0-py3-none-any.whl
.
File metadata
- Download URL: csb43-0.10.0-py3-none-any.whl
- Upload date:
- Size: 150.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.0 CPython/3.10.11
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | c8f56507c5595cbcb502fce10595c1ef0ead03fef7b50a1313bbf33f19ac63f6 |
|
MD5 | 7879b09448503b13003d80fb53728c6a |
|
BLAKE2b-256 | 693b15a6588f513899ba73a7a1bb03b76ffd578c5c5348ccd068bd9dc8e2242e |