Convert_1.3
Attempt creating a universal Homebank(4.3) csv import converter (c)Ton 8-10-2011
=============================================================================================================
[Manual]    Program usage

Before you can use this script, you have to create a definition-file (see short manual below)
Format import-csv-file-record homebank  = ['date','paymode','info','payee','description','amount','category']
Format import-csv-file-record bank      = [any number of fields & field-position in record]
                                          Record field seperation-token can be comma or semicolon [,;]

Run in terminal, on command-line type     ./Convert_x.x.x.py [import.csv] [output.csv] [import.def]
*
[Leganda]        [import.csv] = ("bank".csv)        file exported from bank
                 [output.csv] = ("homebank".csv)    file to be created
                 [import.def] = ("bank".def)        definition-file "bank" <> "Homebank"
*
Input-files:     [import.csv], [import.def]
Output-files:    [output.csv], log.txt (= logging conversion process)
=============================================================================================================
[Manual]    Definition-file:
*
Homebank definition file contains multiple lines/records:
*
First line is needed to be able to SKIP Header-line(s) at the top of the ["bank".csv] file,
*                                           Line contains 3 fields/columns (left to right):
*
[1] = (H) Homebank field                !! field # = [H]                >>> do NOT change <<<
[2] =     Homebank name                 !! function                     >>> do NOT change <<<
[3] = (B) Skipped Bankfile header-lines !! [0..N]                       (skipped from the top)
*
Rest of lines informs program position of field-data stored in ["bank".csv] file,
*                                           Line contains 5 fields/columns (left to right):
*
[1] = (H) Homebank field pos.           !! field # = [0..8]             >>> do NOT change <<<
[2] =     Homebank field name           !! as in Homebank               >>> do NOT change <<<
[3] = (B) Bankfile field pos.           !! field # = [0..N,-1,-M]       (M = headerlength)
[4] =     Bankfile field name           !! as in Bank-file
[5] =     Bankfile field details        !! line #,pos #                 (NO semicolons allowed)
-------------------------------------------------------------------------------------------------------------
Column[3] <Bankfile-field-number> [0..N]  : existing field      (possitiv number)
*                                 [-1]    : "not-in-use"        (negative number)
*                                 Bank-file contains header with data to be extracted
*                                 [-2..-N]: LAST-line of header (negative number) i.e. headerlength
*                                 
NOTE:   Multi definitions-lines(rows) per field are possible but cannot contain [-1] !!!!!!!!!!
NOTE:   header containing data MUST be >= 2 lines !!!!!!!! 
-------------------------------------------------------------------------------------------------------------
[Without header]
Column[5] <Bankfile-field-details> must contain information crucial for converting import field-data.
*                                  These 3 fields are Homebank-date, -amount, -paymode.
*                                
-Date    (any  order):  4*[Y]ear,2*[M]onth,2*[D]ay -> seperation[-#%&*/]  -> [YYYY/MM/DD] [YYYY-MM-DD] [DD%MM%YYYY]
*
-Amount (comes first):  Amount without sign needs extra Amount_sign info,
*                       Amount-format can have grouping-token[,.]
*                                           and decimal-token[.,]
*         limitations:  integers[N*= any number], fraction[None .. 2= max]
*
-Amount_sign (second):  [aA-zZ],[aA-zZ]            -> order [+,-]         -> [D,C] [Debet,Credit] [af,bij] [Neg,Pos]
*
-Paymode (any lenght):  N*(Booking-code)          , N*(Homebank-code)
*                       [aA-zZ,0-9],..,[aA-zZ,0-9], [0-10],...,[0-10]     -> [ga,gb,cb,..,tg,kh,db,3,3,4,..,8,9,10]
*                       (any no. of char. per code)
*
NOTE:   NO semicolons allowed in Bank-file-field-details !!!!!!!!!!
--------------------------------------------------------------------------------------------------------------
[With header]
Column[5] <Bankfile-field-details> must contain information crucial for converting import header-data.
*                                  These fields are Homebank-account,-balance
*                                  Consists of row/line-number[1-N] and column/line-item-number[0-N].
*  
*              Header:  (line N of header)        , (item N of line)         Example
*                        [2-N]                     , [0-N]                 -> [6,1]
                        
=============================================================================================================
Example-definition-file 1 (without header):
---------------------------------------------------------------------------------------------------------
H  <Homebank>    B    <"Bank">        <Bank-file>
#___<field>___________<field>_______<field-details>______________________________________________________
0;date          ;2 ;Curr.date      ;YYYYMMDD
1;paymode       ;8 ;Booking-Code   ;ga,gb,cb,sb,tb,ba,ck,eb,ei,ma,nb,bg,ac,id,3,3,4,4,5,6,6,7,7,7,7,8,8,8
2;info          ;5 ;Offset-account ;
3;payee         ;6 ;Payee          ;
4;description   ;10;Description.1  ;
4;description   ;11;Description.2  ;
4;description   ;12;Description.3  ;
4;description   ;13;Description.4  ;
4;description   ;14;Description.5  ;
4;description   ;15;Description.6  ;
5;amount        ;4 ;Amount         ;
5;amount_sign   ;3 ;Debet/Credit   ;D,C
6;category      ;-1;               ;
7;*account      ;0 ;Account        ;
8;*balance      ;-1;               ;
=========================================================================================================
Example-definition-file 2 (with header 1 line to be skipped):
---------------------------------------------------------------------------------------------------------
H  <Homebank>    B    <"Bank">        <Bank-file>
#___<field>___________<field>_______<field-details>______________________________________________________
H;header        ;1
0;date          ;2 ;Curr.date      ;YYYYMMDD
1;paymode       ;8 ;Booking-Code   ;ga,gb,cb,sb,tb,ba,ck,eb,ei,ma,nb,bg,ac,id,3,3,4,4,5,6,6,7,7,7,7,8,8,8
2;info          ;5 ;Offset-account ;
3;payee         ;6 ;Payee          ;
4;description   ;10;Description.1  ;
4;description   ;11;Description.2  ;
4;description   ;12;Description.3  ;
4;description   ;13;Description.4  ;
4;description   ;14;Description.5  ;
4;description   ;15;Description.6  ;
5;amount        ;4 ;Amount         ;
5;amount_sign   ;3 ;Debet/Credit   ;D,C
6;category      ;-1;               ;
7;*account      ;0 ;Account        ;
8;*balance      ;-1;               ;
=========================================================================================================
Example-definition-file 3 (with header containing data):
--------------------------------------------------------------------------------------------
H  <Homebank>    B    <"Bank">        <Bank-file>
#___<field>___________<field>_______<field-details>_________________________________________
0;date          ;2 ;Curr.date      ;YYYYMMDD
1;paymode       ;8 ;Booking-Code   ;ga,gb,cb,sb,tb,ba,ck,eb,ei,ma,nb,bg,ac,id,3,3,4,4,5,6,6,7,7,7,7,8,8,8
2;info          ;5 ;Offset-account ;
3;payee         ;6 ;Payee          ;
4;description   ;10;Description.1  ;
4;description   ;11;Description.2  ;
4;description   ;12;Description.3  ;
4;description   ;13;Description.4  ;
4;description   ;14;Description.5  ;
4;description   ;15;Description.6  ;
5;amount        ;4 ;Amount         ;
5;amount_sign   ;3 ;Debet/Credit   ;D,C
6;category      ;-1;               ;
7;*account      ;-7;Account        ;2,1
8;*balance      ;-7;Balance        ;6,1