1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
Converter
==========
Convert a **CSB/AEB norm 43** file to other file formats.
Supported formats:
- OFX v1.0.3 (SGML) & v2.1.1 (XML)
- `HomeBank CSV <http://homebank.free.fr/help/06csvformat.html>`_
- *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] [-e ENCODING] [--use-float]
[-V]
[-f {csv,dbf,df,homebank,html,json,latex,ods,ofx,ofx1,tsv,xls,xlsx,yaml}]
[-v]
csbFile convertedFile
Convert a CSB43 file to another format
optional arguments:
-h, --help show this help message and exit
-v, --version show program's version number and exit
csb43 arguments:
csbFile a csb43 file ('-' for stdin)
-s, --strict strict mode (default: False)
-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 currency 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: False)
-V, --verbose show csb43 warnings
output arguments:
convertedFile destination file ('-' for stdout)
-f {csv,dbf,df,homebank,html,json,latex,ods,ofx,ofx1,tsv,xls,xlsx,yaml}, --format {csv,dbf,df,homebank,html,json,latex,ods,ofx,ofx1,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
- 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.
|
