Op 07-12-2024 om 21:01 schreef Koos Pol:
The CSV importer *almost* works. The statements from my bank has:
- one column for the amount. The amount is always positive.
- one column have the entries "Debet" or "Credit" to indicate the
direction of the tx.
Here are a few sample rows:
"01-01-2024","38,10","Debet",...
"11-01-2024","241,58","Credit",...
"23-01-2024","43,35","Debet",...
"11-02-2024","241,58","Credit",...
"06-03-2024","384,95","Debet",...
Is there any way to have the importer grok this? The "Action" column
didn't work.
Thanks for all the suggestions. But honestly I don't like the manual
preprocessing.
To overcome this I've cobbled together an AQBanking profile for my
particular CSV statements, starting from the standard available
profiles. AQBanking supports a separate column for Credit/Debet. GnuCash
picks it up automatically. And it works like a charm :-)
This means I can now run File > Import AQBanking > CSV > triodos
My profile is located at
/home/koos/.aqbanking/imexporters/csv/profiles/triodos.conf
I've attached the profile for those interested.
Cheers,
Koos
char name="triodos"
char version="1"
char shortDescr="Triodo Bank"
int import="1"
int export="1"
int usePosNegField="1"
char posNegFieldName="posNeg"
char positiveValues="Bij", "C", "Credit"
char negativeValues="Af", "D", "Debet"
char subject="transactions"
char dateFormat="DD-MM-YYYY"
char valueFormat="rational"
params {
int ignoreLines="0"
char delimiter=","
int title="0"
int quote="1"
columns {
char 1="date"
char 2="localIban"
char 3="value%2Fvalue"
char 4="posNeg"
char 5="remoteName%5B0%5D"
char 6="remoteAccountNumber"
char 7="transactionCode"
char 8="purpose%5B0%5D"
} #columns
} #params
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
