Hallo,

nach unserem Umstieg von PC auf Mac fehlt als letzter Migrationsschritt noch der Import von T-Online Banking Umsätzen in Pecunia.

Leider funktioniert das bei mir nicht.

Folgendes Format hat meine CSV Datei:

KontoNr;BLZ;Auszugsdatum;Saldo;Waehrung;Buchungsdatum;Wertstellungsdatum;Geschaeftsvorfall;Verwendungszweck;Empfaenger;Betrag;Waehrung;Kategorie
12345;9999999;29.04.2010;+47;EUR;19.03.2010;19.03.2010;BAR;19.03/11:23 UHR Muster ;GA NR4711 0;-1,00;EUR;Kategorie

Trotz diverser Versuche die Konfigurationsdatei anzupassen oder die Datei dem Layout der Original Profildatei, werden keine Datensätze importiert.

Desweiteren zeigt das Logfile, dass die Profile wohl auch im Verzeichnis /user/myuser/.aqbanking//imexporters/csv/profiles gesucht werden. Was hat es hiermit auf sich? Dieses Verzeichnis exisitiert bei mir standardmäßig nicht und auch das manuelle erstellen (bzw. dorthin kopieren) der angezeigten Verzeichnisse/Profile hilft hier nicht weiter.

Gibt es hier eine genaue Anleitung, wie der Import von T-Online CSV Daten funktionieren sollte?

Ich bin für jeden Hinweis dankbar!

Christina

P.S.:
1. Mittlerweile hat die Software das Verzeichnis /user/myuser/.aqbanking erstellt. Es befinden sich dort Nutzerspezifische Einstellungen. Das Unterverzeichnis imexporters gibt es aber weiterhin nicht.

2. Hier das Logfile. Das Programm scheint also irgendwie die Datei schon zu lesen, aber es wird nichts importiert.
<10:19:31.202> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/amex.conf" contains profile "amex"
<10:19:31.204> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/aqmoney1.conf" contains profile "AqMoney1"
<10:19:31.217> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/aqmoney2.conf" contains profile "AqMoney2"
<10:19:31.234> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/bankaustria.conf" contains profile "BankAustria"
<10:19:31.251> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/cli-transfers.conf" contains profile "cli-transfers"
<10:19:31.268> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/comdirect.conf" contains profile "comdirect"
<10:19:31.284> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/consors-tagesgeld.conf" contains profile "Consors"
<10:19:31.302> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/default.conf" contains profile "default"
<10:19:31.318> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/diba.conf" contains profile "diba"
<10:19:31.336> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/full.conf" contains profile "full"
<10:19:31.353> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/hypovereinsbank.conf" contains profile "HypoVereinsbank"
<10:19:31.369> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/lbbberlin.conf" contains profile "LandesBankBerlin"
<10:19:31.386> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/mijnpostbank.conf" contains profile "mijnpostbank"
<10:19:31.404> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/oko.conf" contains profile "oko"
<10:19:31.420> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/postbankffm.conf" contains profile "PostbankFFM"
<10:19:31.437> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/psk.conf" contains profile "PSK"
<10:19:31.454> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/sns.conf" contains profile "sns"
<10:19:31.471> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/sparda.conf" contains profile "sparda"
<10:19:31.488> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/spk-aachen.conf" contains profile "SPK-AACHEN"
<10:19:31.505> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/spk-steiermark.conf" contains profile "spk-steiermark"
<10:19:31.521> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/tonline-banking.conf" contains profile "T-ONLINE"
<10:19:31.539> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/vrnetworld.conf" contains profile "vrnetworld"
<10:19:31.556> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/csv/profiles): No such file or directory
<10:19:31.572> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/csv/profiles" is not available
<10:19:31.590> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/ctxfile/profiles/default.conf" contains profile "default"
<10:19:31.607> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/ctxfile/profiles): No such file or directory
<10:19:31.623> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/ctxfile/profiles" is not available
<10:19:31.641> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/dtaus/profiles/debitnote.conf" contains profile "debitnote"
<10:19:31.658> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/dtaus/profiles/default.conf" contains profile "default"
<10:19:31.683> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/dtaus/profiles/transfer.conf" contains profile "transfer"
<10:19:31.704> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/dtaus/profiles): No such file or directory
<10:19:31.737> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/dtaus/profiles" is not available
<10:19:31.770> directory.c: 77: opendir(/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/eri2/profiles): No such file or directory
<10:19:31.802> banking_imex.c: 317: Path "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/eri2/profiles" is not available
<10:19:31.836> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/eri2/profiles): No such file or directory
<10:19:31.870> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/eri2/profiles" is not available
<10:19:31.903> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/ofx/profiles/default.conf" contains profile "default"
<10:19:31.936> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/ofx/profiles): No such file or directory
<10:19:31.970> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/ofx/profiles" is not available
<10:19:32.003> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/openhbci1/profiles/default.conf" contains profile "default"
<10:19:32.036> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/openhbci1/profiles): No such file or directory
<10:19:32.069> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/openhbci1/profiles" is not available
<10:19:32.085> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/q43/profiles/default.conf" contains profile "default"
<10:19:32.101> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/q43/profiles): No such file or directory
<10:19:32.120> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/q43/profiles" is not available
<10:19:32.153> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/sepa/profiles/ccm.conf" contains profile "ccm"
<10:19:32.169> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/sepa/profiles/default.conf" contains profile "default"
<10:19:32.185> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/sepa/profiles): No such file or directory
<10:19:32.201> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/sepa/profiles" is not available
<10:19:32.219> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/swift/profiles/amro940.conf" contains profile "AMRO-MT940"
<10:19:32.235> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/swift/profiles/amro942.conf" contains profile "AMRO-MT942"
<10:19:32.251> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/swift/profiles/swiftmt940.conf" contains profile "SWIFT-MT940"
<10:19:32.269> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/swift/profiles/swiftmt942.conf" contains profile "SWIFT-MT942"
<10:19:32.285> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/swift/profiles): No such file or directory
<10:19:32.301> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/swift/profiles" is not available
<10:19:32.320> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/xmldb/profiles/default.conf" contains profile "default"
<10:19:32.353> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/xmldb/profiles): No such file or directory
<10:19:32.386> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/xmldb/profiles" is not available
<10:19:32.402> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/yellownet/profiles/default.conf" contains profile "default"
<10:19:32.419> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/yellownet/profiles): No such file or directory
<10:19:32.435> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/yellownet/profiles" is not available
<10:19:55.804> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/amex.conf" contains profile "amex"
<10:19:55.820> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/aqmoney1.conf" contains profile "AqMoney1"
<10:19:55.852> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/aqmoney2.conf" contains profile "AqMoney2"
<10:19:55.869> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/bankaustria.conf" contains profile "BankAustria"
<10:19:55.890> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/cli-transfers.conf" contains profile "cli-transfers"
<10:19:55.923> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/comdirect.conf" contains profile "comdirect"
<10:19:55.956> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/consors-tagesgeld.conf" contains profile "Consors"
<10:19:55.972> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/default.conf" contains profile "default"
<10:19:56.003> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/diba.conf" contains profile "diba"
<10:19:56.019> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/full.conf" contains profile "full"
<10:19:56.040> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/hypovereinsbank.conf" contains profile "HypoVereinsbank"
<10:19:56.073> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/lbbberlin.conf" contains profile "LandesBankBerlin"
<10:19:56.106> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/mijnpostbank.conf" contains profile "mijnpostbank"
<10:19:56.139> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/oko.conf" contains profile "oko"
<10:19:56.156> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/postbankffm.conf" contains profile "PostbankFFM"
<10:19:56.186> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/psk.conf" contains profile "PSK"
<10:19:56.207> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/sns.conf" contains profile "sns"
<10:19:56.223> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/sparda.conf" contains profile "sparda"
<10:19:56.257> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/spk-aachen.conf" contains profile "SPK-AACHEN"
<10:19:56.290> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/spk-steiermark.conf" contains profile "spk-steiermark"
<10:19:56.324> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/tonline-banking.conf" contains profile "T-ONLINE"
<10:19:56.357> banking_imex.c: 371: File "/Applications/Pecunia.app/Contents/Frameworks/AqBanking/share/aqbanking/imexporters/csv/profiles/vrnetworld.conf" contains profile "vrnetworld"
<10:19:56.390> directory.c: 77: opendir(/Users/myuser/.aqbanking/imexporters/csv/profiles): No such file or directory
<10:19:56.424> banking_imex.c: 317: Path "/Users/myuser/.aqbanking/imexporters/csv/profiles" is not available
<10:19:56.475> csv.c: 300: Found a possible transaction
<10:19:56.492> csv.c: 441: Adding transaction
<10:19:56.519> csv.c: 300: Found a possible transaction
<10:19:56.540> csv.c: 441: Adding transaction
...

Dieses Verzeichnis wird auch nicht standardmaessig angelegt. Es erlaubt dem Benutzer aber, dort eigene Profile abzulegen, falls er von den systemweiten installationen abweichen moechte.

Aktuelle Versionen von AqBanking enthalten beispielsweise einen CSV-Profil-Editor-Dialog, der geaenderte und neue Profile eben dort ablegt, und dort werden sie dann fuer den Import/Export auch gefunden.

Wichtig ist bei von Hand erstellten Profilen aber, dass diese einen eindeutigen Namen enthalten (als Beispiel siehe die Vorinstallierten Profile oder aber das AqBanking-Handbuch).


Gruss
Martin

Hallo,

Danke erst mal für die Antwort auf die Frage zu dem .aqbanking Verzeichnis.

Haben Sie auch noch einen Tipp, wie ich nun weiterkomme?

Was bedeutet es, dass die Importfunktion meine Transaktionen zu lesen scheint, aber diese nicht importiert?
..
<10:19:56.475> csv.c: 300: Found a possible transaction
<10:19:56.492> csv.c: 441: Adding transaction
<10:19:56.519> csv.c: 300: Found a possible transaction
<10:19:56.540> csv.c: 441: Adding transaction
...

Mit freundlichen Grüßen,

Christina Berg

Hallo,
im Pecunia-Wiki gibt es eine Beschreibung zum Import:

http://debugmode.de/trac/pecunia/wiki/PecuniaWiki

außerdem sollte man diese Vorabversion von Pecunia installieren, da gab es nämlich noch einen Fehler:
http://www.pecuniabanking.de/d…upport.dmg

Super, Danke!


Den Wiki-Beitrag hatte ich schon gesehen und die Profildatei entsprechend angepasst.

Mit dem Patch hat es nun auch funktioniert.

Jetzt muss ich nur noch herausfinden, ob/wie ich Umsätze für ein Konto importieren kann, dass nicht mehr existiert.

Mit freundlichen Grüßen,,

Christina

Hallo,
ich versuche derzeit ebenfalls meine Umsätze zu importieren, scheitere aber schon an der Profildatei. Diese liegt hier:
/Users/xxxx/.aqbanking/imexporters/csv/profiles/jamaica.conf
Wenn ich nun in Pecunia über importieren/csv anwähle, erwarte ich diese Datei im Auswahlmenü "profil", was aber leider nicht eintrifft. Mache ich noch was falsch?
Wenn ich eine conf Datei aus dem Programmverzeichnis in das oben angeführte Verzeichnis hineinkopiere, wird diese ebenfalls nicht angezeigt.
Im log-file wird nicht nur das Nichteinlesen der CSV-Datei bemängelt, auch das Einlesen des "Contents" Ordners wird als nicht möglich angezeigt.
Gruß hoarst

Hallo Hoarst,

ich hatte dieses Problem auch kurzzeitig. Bei mir war der Grund ein Syntaxfehler in der Feldbeschreibung.

Vielleicht kannst Du ja Deine .conf Datei mal hochladen.

Gruß,

Christina

Hallo,
hier der Inhalt der conf-Datei:



wäre schön wenn ich die buchungen noch importieren könnte.

Hallo Hoarst,

du solltest das Profil unter dem Namen "test" bei den CSV-Profilen sehen. Außerdem solltest du prüfen, ob tatsächlich die ersten 8 Zeilen ignoriert werden sollen.

Gruß, Frank

Hallo Frank,

nein, die test.conf ist beim Import-Dialog "csv" nicht zu sehen. Die Datei liegt hier:
/Users/xxxx/.aqbanking/imexporters/csv/profiles/test.conf

das log-file gibt beim Aufrufen des Import-Befehles die Fehlermeldung:

<15:40:07.774> banking_imex.c: 356: Could not read file "/Users/xxxx/.aqbanking/imexporters/csv/profiles/Test.conf"

was meinst du mit den ersten 8 Zeilen die ignoriert werden? Nach meinem kümmerlichen Programmierwissen werden Zeilen ignoriert werden, die mit einem # beginnen. In der ersten 8 Zeilen kommt das Gatter aber nur einmal vor.

Gruß hoarst

Hallo,

ich habe kurz mal rumprobiert.

Es scheint, dass Du nach der allerletzten Zeile ein "Return" vergessen hast.

Bei mir ist danach zumindest das Profil sichtbar.

Gruß,

Christina

Der Name der Datei ist soweit ich weiss egal. Wichtig ist was unter

char name="test" steht.

Unter dem Namen wird das Profil dann angezeigt.
Soweit ich weiss interpretiert der Importer das #-Zeichen nicht, sondern man muss unter

int ignoreLines="8"

die Anzahl der zu ignorierenden Zeilen in der Datendatei angeben.