[GNC] SOLVED: Re: CSV importer Debet/Credit issue

[Koos Pol]

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
-------------- next part --------------
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