[GNC] AqBanking help for Citi CC

[Jim Maki]

> Accquiring lock: Started.

> Accquiring lock: 2812 of 60000

> <......>

> Accquiring lock: 59984 of 60000

> Accquiring lock: 59999 of 60000

> Accquiring lock: Finished.

> 3:2018/10/28

> 11-04-37:gwen(39044):C:/gcdev64/gnucash/releases/src/gwenhywfar-4.20.0/plugins/configmgr/dir/c

> fgdir.c:  469: Could not lock group [shared/certs]: 2

> 3:2018/10/28

> 11-04-37:aqbanking(39044):C:/gcdev64/gnucash/releases/src/aqbanking-5.7.8/src/libs/aqbanking/b

> anking_cfg.c:  303: Could not lock shared group [certs] (-109)

> 4:2018/10/28

> 11-04-37:aqbanking(39044):C:/gcdev64/gnucash/releases/src/aqbanking-5.7.8/src/libs/aqbanking/g

> ui/abgui.c:  147: Could not lock certs db, asking user (-109)

This is a file locking issue and you just have to delete the ".lck" files. For a description of file locking see:

     https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html#basics-backuplock2

For the AqBanking directory on Windows containing the lock files, see table 2.4 in:

     https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-migrate-settings.html

If you want real detail, I believe the actual locking code is fslock.c:

     https://github.com/cstim/gwenhywfar/blob/master/src/os/windows/fslock.c

You'll see to lock a directory "D" they create a lock file "D/.dir.lck" and to lock a file "F" they lock "F.lck". These are the files you should delete.

Those tidbits make me want to skim through the whole GnuCash Tutorial and Concepts Guide:

     https://www.gnucash.org/docs/v3/C/gnucash-guide/

> So it seems the account never gets configured into AQBanking...that's a hint I think. AQBanking does not record the account.

Given Chase works for you but Citi only lacks the account setup, you're almost there. All you have to do is manually create the account part (given that you've created the user part).

Start the AqBanking wizard: Tools ==> Online Banking Setup ... ==> Next ==> Start AqBanking Wizard.

Edit the user you already created to verify it's correct, but don't use "Retrieve Account List". Once you're satisfied it's right, close the user and then click on Accounts ==> Create Account and fill it in (see below).

Once you close the "AqBanking Setup" window just make sure it's mapped to the right GnuCash account and you should be good to go.

For convenience, here's the configuration I posted before (updated to version 2900):

    AqBanking Setup

    ==>  User Settings

    ====>  User Name - "YOURUSERID"

    ====>  User Id - "YOURUSERID " (trailing space)

    ====>  Client UID - not specified

    ==>  Bank Settings

    ====>  Bank Name - "Citi Credit Card"

    ====>  Broker Id - "Citigroup"

    ====>  FID - "24909"

    ====>  ORG - "Citigroup"

    ====>  Server URL -

"https://www.accountonline.com/cards/svc/CitiOfxManager.do"

    ==>  Application Settings

    ====>  Application ID - "QWIN"

    ====>  Application Version - "2900"

    ====>  Header Version - "103"

    ====>  No Special Settings

    ==>  Account Info

    ====>  Account Number - "YOUR CC NUMBER"

    ====>  Account Name - "Citigroup"

    ====>  IBAN - not specified

    ====>  Owner Name - not specified

    ====>  Currency - "US Dollar (USD)"

    ====>  Account Type - "Credit Card Account"

    ==>  Bank Info

    ====>  Country - "United States of America (US)"

    ====>  Bank Code - "www.accountonline.com"

    ====>  Bank Name - "www.accountonline.com"

    ====>  SWIFT BIC - not specified

    ====>  Selected User - the user you defined above

Hope that helps.

   Jim