gmane.comp.finance.aqbanking.devel

Deleting List Today

Martin Preuss — 2010-06-18T10:41:52

Hi,

after a few months of warning and with a working alternative list in place 
this list will be deleted today. All remaining subscribers (still 167) will be 
unsubscribed.

Please subscribe to our new list at
"http://lists.aqbanking.de/cgi-bin/mailman/listinfo/aqbanking-user"


Regards
Martin

Libchipcard 4.99.6beta herausgegeben

2010-06-17T11:21:29

Automatische Nachricht vom Versions-Service auf www2.aquamaniac.de
=================================

   Diese Version enthaelt vor allem Verbesserungen fuer MacOSX.


=================================
Ende der automatischen Nachricht


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo

Last Call: Please change to aqbanking-user

Martin Preuss — 2010-06-07T21:33:52

Hi,

after a few months this is the final reminder now: This list will be closed 
this month, I'm mainly getting bounce and spam mails everyday since a few 
months. 

So everybody interested in the latests developments of the AqBanking family 
should subscribe to our not-so-new-anymore list at

"http://lists.aqbanking.de/cgi-bin/mailman/listinfo/aqbanking-user"


Regards
Martin


On Dienstag 19 Januar 2010, Martin Preuss wrote:

Libchipcard 4.99.4beta herausgegeben

2010-05-06T18:33:45

Automatische Nachricht vom Versions-Service auf www2.aquamaniac.de
=================================

   Diese Version gibt eine Fehlermeldung aus, wenn der PC/SC daemon nicht
   laeuft.

   Ausserdem wurde ein Bug behoben, so dass jetzt wieder die
   Lesertastatur zur Pin-Eingabe verwendet wird.

=================================
Ende der automatischen Nachricht


------------------------------------------------------------------------------

Libchipcard 4.99.2beta herausgegeben

2010-05-04T18:25:24

Automatische Nachricht vom Versions-Service auf www2.aquamaniac.de
=================================

   In dieser Version wurde einiges an unnoetigem Code entfernt.

   Da es jetzt nur noch den Client-Code gibt, wurden die Pfade fuer die
   Header vereinfacht. Ausserdem wurde das Pfad-Schema von Gwernhywfar
   uebernommen, d.h. die Header-Dateien werden nun in ein
   Unterverzeichnis von $PREFIX/include/libchipcard5 installiert.
   Die Bibliothek wurde ausserdem umbenannt von libchipcardc.so zu
   libchipcard.so (das c stand frueher fuer "client", aber dieser Anhang
   ist nun unnoetig).

   Verbessert wurde ausserdem der Code zum Warten auf das Einlegen einer
   Chipkarte.

=================================
Ende der automatischen Nachricht


------------------------------------------------------------------------------

Initial version of a q43 importer (was: Q43format)

Martin Preuss — 2010-05-03T12:07:17

Hi,

the subversion repository now contains a preliminary version of a Q43 
importer.

There still are some issues which need to be checked by Juan (or others), but 
I was able to import a given test file.


Regards
Martin

Re: Q43 format

Martin Preuss — 2010-05-03T10:17:57

Hi Juan,

On Sonntag 02 Mai 2010, Juan Pedro Paredes Caballero wrote:
[...]
[...]
[...]

I just started implementing an importer for that format. As promised, I have 
some more questions:

Does the field "11-F" have any effect on the signs of the amounts in the "22" 
records? Or is it just for informational purposes?


Regards
Martin

Re: Q43 format

Martin Preuss — 2010-05-02T17:59:20

Hi,

On Sonntag 02 Mai 2010, Juan Pedro Paredes Caballero wrote:
[...]
[...]

I guesst thisis the bank information of the payee?

A general question: Does the bank code plus office branch key uniquely identify 
a bank in your country? Like "Bankleitzahl" (routing number) in Germany?

In DE a bank account in uniquely identified by the routing number of the bank 
which manages the account plus the account number (and sometimes an additional 
identifier). Do you have the same kind of concept in Spain?

I don't see an account number for the payee in the the 22 record. Is there 
none? How do you map a transaction from the Q43 file to a payee (there is no 
payee name either)?

And in 22: What is "Common Concept" and "Bank own Concept" uses for?


Regards
Martin

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T17:49:46

Version 1.1 of aeb43 specifications
V1.1 Add 22H Common concepts and 33J currency iso codes. Add File examples

Regards.
Juampe


Juan Pedro Paredes Caballero <juampe< at >iquis.com>
V1.1 Add 22H Common concepts and 33J currency iso codes. Add File examples
V1.0 Initial release

Q43 file format overview
The format can carry information about several accounts
1 record per line.
Lines with 80 characters maximum.
EBDIC enconding
AFAIK records are optional but with an stablished order.
Record types beginning with:
00: File HEADER (AFAIK optional)
11: Header Record
22: Bank transaction
23: Comment about the transaction
33: Final acount register
88: EOF (End Of File) register.

File scheme with 3 accounts:
11XX
22XX
23XX
...     This is only a visual iterator to repeat 22 and 23 registers
...
33XX
------- This is only a visual separator not used in file
11XX
22XX
23XX    This is only a visual iterator to repeat 22 and 23 registers
...
...
33XX
------- This is only a visual separator not used in file
11XX
22XX
23XX
...     This is only a visual iterator to repeat 22 and 23 registers
...
33XX
88XX


00 Record (File header)
00AAAABBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Bank code key (4 digits)
B YYMMDD        Account Date
C Free          Free
Example
000001040901

11 Record (Account header)
11AAAABBBBCCCCCCCCCCDDDDDDEEEEEEFGGGGGGGGGGGGGGHHHIJJJJJJJJJJJJJJJJJJJJJJJJJJKKK
A Numeric       Bank code key
B Numeric       Office branch code key
C Numeric       Account Number
D Numeric       Initial Range Date
E Numeric       Final Range Date
F Numeric       Sign of the bank account (1 debtor , 2 creditor)
G Numeric       Initial account balance with 2 decimals at end
H Numeric       Currency code (978=)
I Numeric       Report Mode code
J AlphaNum.     Name of the account owner
K Numeric       Customer code
Example
110001000200000000030409011004302000000000300009782JUAN PEDRO PAREDES CABALLE

22 Record (Main transaction record)
22AAAABBBBCCCCCCDDDDDDEEFFFGHHHHHHHHHHHHHHIIIIIIIIIIJJJJJJJJJJJJKKKKKKKKKKKKKKKK
A Numeric       Bank code key or NULL
B Numeric       Office branch code key
C Numeric       Transaction Date
D Numeric       Transaction Value Date
E Numeric       Common concept
F Numeric       Bank own concepts
G Numeric       Note type (1 deb note, 2 credit note)
H Numeric       Amount ot the note with 2 decimals at end
I Numeric       Document number
J Numeric       Reference 1
K AlphaNum.     Reference 2
Example
22    0242060101060101121761000000000049890000000000

23 Record (Transaction comment record)
23AABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Data code, each transaction record can carry several comment entries (01 for ther first, 02 the second and so on)
B AlphaNum.     First comment
C AlphaNum.     Second Comment
Example
2301COMPRA T.C. E.S.CALZADA DE O

33 Record (End of account record)
33AAAABBBBCCCCCCCCCCDDDDDEEEEEEEEEEEEEEFFFFFGGGGGGGGGGGGGGHIIIIIIIIIIIIIIJJJKKKK
A Numeric       Bank code key
B Numeric       Office branch code key
C Numeric       Account Number
D Numeric       Number of deb notes
E Numeric       Total amount of deb
F Numeric       Number of credit notes
G Numeric       Total amount of credit
H Numeric       Final balance code (1 deb, 2 credit)
I Numeric       Final balance
J Numeric       Currency Code (978=)
K Numeric       Free
Example
3300010002000000000300099000000000000990009900000000009991200000000000900978

88 Record (End of File record)
88AAAAAAAAAAAAAAAAAABBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Padding with 9
B Numeric       Number of records withouth self and 00
C Numeric       Free
Example
88999999999999999999004354

--------------------------------------------------------------------------------

22 Record E field common concepts in spanish language
01 TALONES - REINTEGROS
02 ABONARÉS - ENTREGAS - INGRESOS
02 PROMISSORY NOTE - DELIVERIES - REVENUE
03 DOMICILIADOS - RECIBOS - LETRAS - PAGOS POR SU CTA.
04 GIROS - TRANSFERENCIAS - TRASPASOS - CHEQUES
05 AMORTIZACIONES PRÉSTAMOS, CRÉDITOS, ETC.
06 REMESAS EFECTOS
07 SUSCRIPCIONES - DIV. PASIVOS - CANJES.
08 DIV. CUPONES - PRIMA JUNTA - AMORTIZACIONES
09 OPERACIONES DE BOLSA Y/O COMPRA /VENTA VALORES
10 CHEQUES GASOLINA
11 CAJERO AUTOMÁTICO
12 TARJETAS DE CRÉDITO - TARJETAS DÉBITO
13 OPERACIONES EXTRANJERO
14 DEVOLUCIONES E IMPAGADOS
15 NÓMINAS - SEGUROS SOCIALES
16 TIMBRES - CORRETAJE - PÓLIZA
17 INTERESES - COMISIONES  CUSTODIA - GASTOS E IMPUESTOS
98 ANULACIONES - CORRECCIONES ASIENTO
99 VARIOS

--------------------------------------------------------------------------------
File records ends  with CRLF line terminators

File q43 with 1 account

119999139931999138140511100511102000000000103469783R*****-V*****-JUAN FRANCIS   
22    8818051110051110040062000000000500000000000000000000002143TRF. JUAN FRANCI
2301TRF. JUAN FRANCISCO R***** V*****                                           
22    1302051110051110050371000000000422000000000000000000002144RCBO. PRESTAMO42
2301RCBO. PRESTAMO4268805159                                                    
3399991399319991381400001000000000422000000100000000050000200000000018146978    
88999999999999999999000012                                                      


File q43 with 2 accounts

11199213099999938140511100511102000000000103469783R*****-V*****-JUAN FRANCIS   
22    8818051110051110040062000000000500000000000000000000002143TRF. JUAN FRANCI
2301TRF. JUAN FRANCISCO R***** V*****                                           
22    1302051110051110050371000000000422000000000000000000002144RCBO. PRESTAMO42
2301RCBO. PRESTAMO4268805159                                                    
3319921309999991381400001000000000422000000100000000050000200000000018146978    
111992130999999055110511100511102000000000006009783R*****-V*****-JUAN FRANCIS   
22    1302051110051110020012000000000500000000000000000000000082TRASPASO CAIXA P
2301TRASPASO CAIXA POPULAR                                                      
22    8818051110051110040061000000000500000000000000000000000083SU ORDEN DE TRAS
2301SU ORDEN DE TRASPASO                                                        
3319921309999990551100001000000000500000000100000000050000200000000000600978    
88999999999999999999000012                                                      

--------------------------------------------------------------------------------

11 H and 33 J fields (Currency table an ISO codes) in spanish language
Dólar australiano 036
Dólar canadiense 124
Corona Danesa 208
Yen japonés 392
Dólar neozelandés 554
Corona noruega 578
Corona sueca 752
Franco suizo 756
Libra esterlina 826
Dólar USA 840
Euro 978
Divisas europeas
Pesetas ordinarias 230
Pesetas convertibles 100
Francos franceses 101
Marcos alemanes 105
Francos belgas convertibles 107
Francos belgas financieros 157
Florines 108
Escudos 109
Liras 113
Schillings austríacos 114
Marcos finlandeses 115
Libras irlandesas 117
Derechos especiales de giro DEG 180
Unidad Europea de Cuenta (ECU) 181
Franco C.F.A. 204
Dracmas griegos 206
Dirhams marruecos 205
Cruceiros 210
Soles peruanos 211
Bolívares 212
Austral argentino 213
Pesos uruguayos 214
Pesos mejicanos 218
Pesos colombianos 217
Dinares Libia 220
Ryales Arabia Saudita 221
Dirhams U.E.A. (Unión Emiratos Árabes) 222
Riales Irán 223
Dínares Kuwait 224
Renmimbi chino 250
Balboa panameño 251
Rand sudafricano 252
Peso chileno 254
Sucre 255
Peso boliviano 256
Colón costarricense 257
Peso cubano 258
Dinar argelino 259
Libra egipcia 260
Quetzal 261
Lempira 262
Gourde 263
Rupia india 264
Dinar iraquí 265
Dinar jordano 266
Naira 267
Córdoba 268
Libra siria 269
Rublo 270
Guaraní paraguayo 271
Ringgit 272
Rupia paquistaní 273
------------------------------------------------------------------------------
_______________________________________________
Aqbanking-devel mailing list
Aqbanking-devel< at >lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/aqbanking-devel

Re: Q43 format

Martin Preuss — 2010-05-02T15:40:03

Hi,

On Sonntag 02 Mai 2010, Juan Pedro Paredes Caballero wrote:
[...]
[...]


Thank you very much, this is very usefull!!

How are lines seaprated? Is there a LF or CR/LF at the end (e.g. DOS or Linux 
line termination)?


Regards
Martin

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T15:33:17

El 02/05/2010 15:12, Martin Preuss escribió:


As I promised i have made a report to show how q43 or CSB43 file format 
works
Please use fixed with font to read this.
I have to collect some private codes (22 F field), for example for my bank.
But this is a general overview of the q43.
My english is oriented to computer engineering, sorry for some 
accounting terminology that I use.

Q43 file format Overview
The format can carry information about several accounts
Originally cames from IBM Z/OS - OS/360 Records
1 record per line.
Lines with 80 characters maximum.
EBDIC enconding
AFAIK records are optional but with an stablished order.
Record types beginning with:
00: File HEADER (AFAIK optional or not necessary)
11: Header Record
22: Bank transaction
23: Comment about the transaction
33: Final acount register
88: EOF (End Of File) register.

File scheme with 3 accounts:
00XX
11XX
22XX
23XX
...     This is only a visual iterator to repeat 22 and 23 registers
...
33XX
------- This is only a visual separator not used in file
11XX
22XX
23XX    This is only a visual iterator to repeat 22 and 23 registers
...
...
33XX
------- This is only a visual separator not used in file
11XX
22XX
23XX
...     This is only a visual iterator to repeat 22 and 23 registers
...
33XX
88XX


00 Record (File header)
00AAAABBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Bank code key (4 digits)
B YYMMDD        Account Date
C Free          Free
Example
000001040901

11 Record (Account header)
11AAAABBBBCCCCCCCCCCDDDDDDEEEEEEFGGGGGGGGGGGGGGHHHIJJJJJJJJJJJJJJJJJJJJJJJJJJKKK
A Numeric       Bank code key
B Numeric       Office branch code key
C Numeric       Account Number
D Numeric       Initial Range Date
E Numeric       Final Range Date
F Numeric       Sign of the bank account (1 debtor , 2 creditor)
G Numeric       Initial account balance with 2 decimals at end
H Numeric       Currency code (978=€)
I Numeric       Report Mode code
J AlphaNum.     Name of the account owner
K Numeric       Customer code
Example
110001000200000000030409011004302000000000300009782JUAN PEDRO PAREDES 
CABALLE

22 Record (Main transaction record)
22AAAABBBBCCCCCCDDDDDDEEFFFGHHHHHHHHHHHHHHIIIIIIIIIIJJJJJJJJJJJJKKKKKKKKKKKKKKKK
A Numeric       Bank code key or NULL
B Numeric       Office branch code key
C Numeric       Transaction Date
D Numeric       Transaction Value Date
E Numeric       Common concept
F Numeric       Bank own concepts
G Numeric       Note type (1 deb note, 2 credit note)
H Numeric       Amount ot the note with 2 decimals at end
I Numeric       Document number
J Numeric       Reference 1
K AlphaNum.     Reference 2
Example
22    0242060101060101121761000000000049890000000000

23 Record (Transaction comment record)
23AABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Data code, each transaction record can carry several 
comment entries (01 for ther first, 02 the second and so on)
B AlphaNum.     First comment
C AlphaNum.     Second Comment
Example
2301COMPRA T.C. E.S.CALZADA DE O

33 Record (End of account record)
33AAAABBBBCCCCCCCCCCDDDDDEEEEEEEEEEEEEEFFFFFGGGGGGGGGGGGGGHIIIIIIIIIIIIIIJJJKKKK
A Numeric       Bank code key
B Numeric       Office branch code key
C Numeric       Account Number
D Numeric       Number of deb notes
E Numeric       Total amount of deb
F Numeric       Number of credit notes
G Numeric       Total amount of credit
H Numeric       Final balance code (1 deb, 2 credit)
I Numeric       Final balance
J Numeric       Currency Code (978=€)
K Numeric       Free
Example
3300010002000000000300099000000000000990009900000000009991200000000000900978

88 Record (End of File record)
88AAAAAAAAAAAAAAAAAABBBBBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
A Numeric       Padding with 9
B Numeric       Number of records withouth self and 00
C Numeric       Free
Example
88999999999999999999004354


------------------------------------------------------------------------------

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T12:46:20

El 02/05/2010 14:18, Juan Pedro Paredes Caballero escribió:

Mispelling, Sure i can.

I can try to answer the questions that would be necessary,as a user and
as a programmer.


Regards
Juampe

------------------------------------------------------------------------------

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T12:18:24

El 02/05/2010 12:53, Martin Preuss escribió:

Sorry for the duplicates, my mail server does someting strange.

Thanks for response.
I can translate the specifications to something readable by humans ;)
I can provide example files, and privately some files from my bank to test.
I cant try to answer the questions that would be necessary,as a user and 
as a programmer.

First I will do, is to recopilate all the informattion  about q43 and 
make a report in english.
Whith this report, we can discuse some deep issues about the format.


Regards.
Juampe.

------------------------------------------------------------------------------

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T12:00:12

------------------------------------------------------------------------------
_______________________________________________
Aqbanking-devel mailing list
Aqbanking-devel< at >lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/aqbanking-devel

Re: Q43 format

Martin Preuss — 2010-05-02T10:53:49

Hi,

On Sonntag 02 Mai 2010, Juan Pedro Paredes Caballero wrote:
[...]
[...]


This question appears every once in a while... I believe it was last year that 
someone wanted to translate the file format and that someone partially did.

However, when I asked some questions about that translation (mostly about the 
meaning of some of the file fields) he never got back to me.

So given that experience over the last few years I won't even consider working 
on that matter unless:
- I have a translation to a language I understand (German, English, 
unfortunately I don't understand Spanish)
- I have one or two explanatory example files
- Someone is willing to answer question I might have about the data fields


Regards
Martin

Re: Q43 format

Juan Pedro Paredes Caballero — 2010-05-02T10:13:07

------------------------------------------------------------------------------
_______________________________________________
Aqbanking-devel mailing list
Aqbanking-devel< at >lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/aqbanking-devel

Libchipcard 4.99.1beta herausgegeben

2010-05-01T14:02:31

Automatische Nachricht vom Versions-Service auf www2.aquamaniac.de
=================================

   Diese Version wurde an die neueste Ausgabe von Gwenhywfar angepasst.

   Da die Client-Konfigurationsdatei inzwischen obsolet geworden ist wird
   sie auch nicht mehr geladen.

=================================
Ende der automatischen Nachricht


------------------------------------------------------------------------------

Libchipcard 4.99.0beta herausgegeben

2010-04-16T21:32:09

Automatische Nachricht vom Versions-Service auf www2.aquamaniac.de
=================================

   Dies ist die erste Beta-Version fuer Libchipcard5.

   Ab Libchipcard5 wird der eigene Ressourcen-Manager nicht mehr
   verwendet. Stattdessen setzt Libchipcard5 auf PC/SC.

   Dadurch funktioniert Libchipcard nun auch mit Lesern, die vorher
   entweder gar nicht oder nur unzureichend unterstuetzt wurden.

=================================
Ende der automatischen Nachricht


------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

Re: [iMac/aqbanking] "Could not lock user ...(-109)"

Jannick Asmus — 2010-04-10T10:23:01

Hier zusätzliche Infos:
- GnuCash 2.2.9
- AQBanking 4.1.4
- Leider habe ich alle Bank-Konten in der Übersicht (nicht die 
zugeordneten GnuCash-Konten) manuell gelöscht
- Bei Abruf von Systemerkennung ercheint das Fenster "Starte exklusiven 
Zugriff" für 60 Sekunden, dann Abbruch mit der Fehlermeldung "Could not 
lock user xxx (-109)"




------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

[iMac/aqbanking] "Could not lock user ... (-109)"

Jannick Asmus — 2010-04-10T10:02:15

Hallo NG,

ich habe das Problem, dass für HBCI keine Informationen (Systemkennung, 
Kontenliste) mehr von der Bank (BLZ 550 905 00) abgerufen werden können. 
Abbruchmeldung siehe Betreffzeile. Ich kann den Benutzer auch nicht mehr 
in der User-Liste löschen.

Allerdings funktioniert alles problemlos auf einem anderen Rechner 
(WinVista).

Bitte meldet Euch, wenn Ihr weitere Infos benötigt.

Vielen Dank für Hilfe.

Schöne Grüße
J. 



------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

Re: [Aqbanking-user] Konten aktualisieren schlägt fehl

Marcel Naziri — 2010-03-16T20:28:23

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Aqbanking-devel mailing list
Aqbanking-devel< at >lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/aqbanking-devel