[GNC] How to import MT940 and/or online banking missing in 5.5

Wed Mar 27 04:32:04 EDT 2024

Please copy the list on all replies.

The error suggest that you're trying to do a direct-bank download (FinTS, PayPal, or OFX DirectConnect) without having setup online banking. That's a bit odd on its own because GnuCash usually won't enable those menu selections (in Actions>Online Banking) without having run the AQBanking setup assistant in Tools>Online banking.

You don't need any of that to import an MT940 file. Use File>Import>Import using AQBanking and select Swift on the left and SWIFT-MT940 (unless you're an AMRO customer, in which case use AMRO-MT940) then click OK to select a file and proceed with the import.

The Windows equivalent of Unix's `export` is `set` in CMD, e.g. `set AQBANKING_LOGLEVEL=debug`. After doing that run GnuCash with `"C:\Program Files (x86)\gnucash\bin\gnucash.exe" --log aqbanking=debug`. Don't include the backticks (`), do include the double quotes (").

Regards,
John Ralls

> On Mar 27, 2024, at 08:32, An Ku <prooffes at gmail.com> wrote:
> 
> Hi John
> 
> Thanks, I have 5.5.1 and get the error message I posted above when I try to import.
> 
> Any thoughts? 
> 
> 
> On Wed, 27 Mar 2024, 08:22 john, <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> You don't need to install AQBanking separately. There was a linking problem with AQBanking in the original gnucash-5.5.setup.exe. You can install gnucash-5.5-1.setup.exe from the usual places or wait until next week and install GnuCash 5.6 that I'll release on Sunday.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Mar 24, 2024, at 15:11, An Ku <prooffes at gmail.com <mailto:prooffes at gmail.com>> wrote:
>> > 
>> > It seems there is some issue with AQBanking related to a missing config
>> > file? As mentioned, I did not understand how I can install AQBanking
>> > separately on Windows. I did a clean start of GnuCash and only tried to
>> > import. This is what the Gnucash tracefile shows:
>> > 
>> > * 14:57:04  WARN <gnc.core-utils> Could not locate file AUTHORS
>> > * 14:57:04  WARN <gnc.core-utils> Could not locate file DOCUMENTERS
>> > * 14:57:04  WARN <gnc.core-utils> Could not locate file LICENSE
>> > * 15:01:05 ERROR <aqbanking>
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings6/users] (-1)
>> > * 15:01:05 ERROR <aqbanking>
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 610: No AqBanking config folder found at
>> > [C:\Users\[username]/aqbanking/settings/users] (-1)
>> > * 15:01:05 ERROR <aqbanking>
>> > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_update.c:
>> > 411: There is no old settings folder, need initial setup
>> > * 15:01:12 ERROR <gwenhywfar>
>> > C:/gcdev64/gnucash/releases/src/gwenhywfar-5.10.2/src/os/windows/syncio_file.c:
>> > 220: Error opening
>> > file[C:\Users\[username]\[path_to_file]\MT940_140324.sta]: 3
>> > * 15:01:12  WARN <gnc.import.aqbanking> gnc_file_aqbanking_import: Error on
>> > import
>> > 
>> > If necessary, please let me know how I can increase the loglevel. I did not
>> > understand how to do it on Windows reading the following pages:
>> > https://wiki.gnucash.org/wiki/AqBanking#Debugging
>> > https://wiki.gnucash.org/wiki/Logging
>> > 
>> > Thanks all for the help!
>> > 
>> > On Wed, Mar 20, 2024 at 1:28 AM Frank H. Ellenberger <
>> > frank.h.ellenberger at gmail.com <mailto:frank.h.ellenberger at gmail.com>> wrote:
>> > 
>> >> 
>> >> 
>> >> Am 19.03.24 um 23:49 schrieb An Ku:
>> >>> Hi all
>> >>> Yes thank you, I was on 5.5 and those options were not available. I have
>> >>> read about AQbanking but neither did the setup option exist nor the
>> >> import
>> >>> option.
>> >>> 
>> >>> Installing 5.5.1 I do see those now. However, when I go to
>> >>> File>Import>Import using AQBanking and select swift>SWIFT-MT940 followed
>> >> by
>> >>> the file, nothing happens. The window closes and that's it. I have not
>> >> done
>> >>> any kind of AQBanking installation or similar or any Online Banking
>> >> setup.
>> >> 
>> >> Our packages (Windows, Macos, Flatpak) include AqBanking. Only Linux and
>> >> similar users mihgt have to install it separatly.
>> >> 
>> >>> Is there anything I should set up first before using the Import option?
>> >> 
>> >> No, the setup serves to configure bank connections, e.g. your paypal
>> >> account.
>> >> 
>> >>> If there's a howto I have not been able to find I would appreciate a
>> >> link.
>> >> 
>> >> There is only a small paragraph in the manual:
>> >> 
>> >> https://code.gnucash.org/docs/C/gnucash-manual/trans-import.html#trans-import-aqbanking
>> >> 
>> >> In your case the trace file
>> >> https://wiki.gnucash.org/wiki/Tracefile
>> >> could contain a clue.
>> >> 
>> >>> Thanks again for your help
>> >> 
>> >> HTH
>> >> Frank
>> >> 
>> >>> On Sat, Mar 16, 2024 at 5:00 PM Frank H. Ellenberger <
>> >>> frank.h.ellenberger at gmail.com <mailto:frank.h.ellenberger at gmail.com>> wrote:
>> >>> 
>> >>>> I suspect, André is aWindows user and needs to upgrade to 5.5-1:
>> >>>> 
>> >>>> 
>> >> https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/5.5/gnucash-5.5-1.setup.exe
>> >>>> 
>> >>>> Regards
>> >>>> Frank
>> >>>> 
>> >>>> Am 16.03.24 um 08:07 schrieb john:
>> >>>>> MT940 and CAMT.053 imports are done with File>Import>Import Using
>> >>>> AQBanking. Note that CAMT.053 is under XML, not CAMT in the import
>> >> selector.
>> >>>>> 
>> >>>>> Regards,
>> >>>>> John Ralls
>> >>>>> 
>> >>>>> 
>> >>>>>> On Mar 14, 2024, at 13:44, An Ku <prooffes at gmail.com <mailto:prooffes at gmail.com>> wrote:
>> >>>>>> 
>> >>>>>> Dear all
>> >>>>>> 
>> >>>>>> Unfortunately, my bank's CSV export is useless as it does not state
>> >>>>>> recipients or any useful information of transactions apart from the
>> >>>> amount
>> >>>>>> and date/time of execution. They do however provide the option to
>> >>>> download
>> >>>>>> MT940 as well as camt.053 (apart form PDFs). I understand there used
>> >> to
>> >>>> be
>> >>>>>> an option to import MT940 transactions through an online banking
>> >> module,
>> >>>>>> but I cannot find it anywhere in the UI (I'm using windows and am on
>> >>>> v5.5).
>> >>>>>> I found references to an external online banking package but no how to
>> >>>> make
>> >>>>>> it run on a windows machine.
>> >>>>>> 
>> >>>>>> I'd appreciate any help on:
>> >>>>>> 
>> >>>>>>   - Importing an MT940 file directly
>> >>>>>>   - Importing an camt.053 file directly
>> >>>>>>   - Converting either MT940 or camt.053 files to CSV
>> >>>>>> 
>> >>>>>> Thank you and kind regards,
>> >>>>>> André
>> >>>>>> _______________________________________________
>> >>>>>> gnucash-user mailing list
>> >>>>>> gnucash-user at gnucash.org <mailto:gnucash-user at 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.
>> >>>>> 
>> >>>>> _______________________________________________
>> >>>>> gnucash-user mailing list
>> >>>>> gnucash-user at gnucash.org <mailto:gnucash-user at 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.
>> >>>> 
>> >>> 
>> >> 
>> > _______________________________________________
>> > gnucash-user mailing list
>> > gnucash-user at gnucash.org <mailto:gnucash-user at 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.
>> 