Re: [GNC] How to import MT940 and/or online banking missing in 5.5
André, There aren't any errors there, just progress messages. It's complaining that you don't have the setup files, but it doesn't need them for a plain file import. It's quite possible that your bank's MT940 format doesn't match either of the profiles. Different banks interpret MT940 spec differently resulting in incompatibilities, hence Martin's suggestion to use CAMT 0.53 instead. Regards, John Ralls > On Mar 27, 2024, at 15:17, An Ku wrote: > > Hi John, all > > I just ran it again with the debug enabled as per John's instructions. Again: > I have not done any kind of setup of online banking or anything like that, > I'm only going to File-Import-AQBanking-Swift on the left-Swift-MT940 on the > right side and click OK. Nothing happens after that. > I also tried the same with a camt53 file (choosing the related option in the > dialog) with the same result. > > I also noticed that I have a folder created on the 19. (probably that first > time I ran/installed 5.5.1) in my user folder called "aqbanking". It contain > 2 folders: > settings > This one is empty > settings6 > aqbanking > config.conf only contains one line: "int lastVersion="100992000"" > backends > aqebics.conf > aqhbci.conf > aqnone.conf > aqofxconnect.conf > aqpaypal.conf > > Here's the debug output: > * 22:48:47 ERROR > 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) > * 22:48:47 ERROR > 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) > * 22:48:47 ERROR > 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 > * 22:48:47 DEBUG started > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: >65: AqBanking v6.5.4.0stable: initialising > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 185: Registering bankinfo plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 217: Registering provider plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: > 249: Registering imexporters plugin manager > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" > contains profile "AMRO-MT940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" > contains profile "AMRO-MT942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" > contains profile "fints940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" > contains profile "fints942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt535.conf" > contains profile "SWIFT-MT535" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt940.conf" > contains profile "SWIFT-MT940" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt942.conf" > contains profile "SWIFT-MT942" > * 22:48:47 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 666: Path "C:\Users\[username]\aqbanking\imexporters\swift\profiles" is not > available > * 22:48:55 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" > contains profile "AMRO-MT940" > * 22:48:55 INFO > C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: > 720: File "C:\Program Files > (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" > contains profile "AMRO-MT942" > * 22:48:55 INFO > C:/gcdev64/gnucash/releases/src/aq
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Hi John, all I just ran it again with the debug enabled as per John's instructions. Again: I have not done any kind of setup of online banking or anything like that, I'm only going to File-Import-AQBanking-Swift on the left-Swift-MT940 on the right side and click OK. Nothing happens after that. I also tried the same with a camt53 file (choosing the related option in the dialog) with the same result. I also noticed that I have a folder created on the 19. (probably that first time I ran/installed 5.5.1) in my user folder called "aqbanking". It contain 2 folders: - settings - This one is empty - settings6 - aqbanking - config.conf only contains one line: "int lastVersion="100992000"" - backends - aqebics.conf - aqhbci.conf - aqnone.conf - aqofxconnect.conf - aqpaypal.conf Here's the debug output: * 22:48:47 ERROR 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) * 22:48:47 ERROR 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) * 22:48:47 ERROR 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 * 22:48:47 DEBUG started * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 65: AqBanking v6.5.4.0stable: initialising * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 185: Registering bankinfo plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 217: Registering provider plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_init.c: 249: Registering imexporters plugin manager * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" contains profile "AMRO-MT940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" contains profile "AMRO-MT942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" contains profile "fints940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" contains profile "fints942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt535.conf" contains profile "SWIFT-MT535" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt940.conf" contains profile "SWIFT-MT940" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt942.conf" contains profile "SWIFT-MT942" * 22:48:47 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 666: Path "C:\Users\[username]\aqbanking\imexporters\swift\profiles" is not available * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro940.conf" contains profile "AMRO-MT940" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\amro942.conf" contains profile "AMRO-MT942" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints940.conf" contains profile "fints940" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\fints942.conf" contains profile "fints942" * 22:48:55 INFO C:/gcdev64/gnucash/releases/src/aqbanking-6.5.4/src/libs/aqbanking/banking_imex.c: 720: File "C:\Program Files (x86)\gnucash\share\aqbanking\imexporters\swift\profiles\swiftmt535.con
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Hi John
I follow the import process exactly as you describe it and not the Online
Banking. See my earlier email.
I'll do the debug and let you know.
Thanks and best regards.
André
On Wed, 27 Mar 2024, 09:32 john, wrote:
> 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 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, 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 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 Could not locate file AUTHORS
>> > * 14:57:04 WARN Could not locate file DOCUMENTERS
>> > * 14:57:04 WARN Could not locate file LICENSE
>> > * 15:01:05 ERROR
>> >
>> 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
>> >
>> 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
>> >
>> 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
>> >
>> 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_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.ellenber...@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.ellenber...@gmail.com> wrote:
>> >>>
>> >
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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 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, > 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 > > > 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 Could not locate file AUTHORS
>> > * 14:57:04 WARN Could not locate file DOCUMENTERS
>> > * 14:57:04 WARN Could not locate file LICENSE
>> > * 15:01:05 ERROR
>> > 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
>> > 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
>> > 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
>> > 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_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.ellenber...@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.ellenber...@gmail.com >
>> >>> wrote:
>> >>>
>> I suspect, André is aWindows user and needs to upgrade to 5.5-1:
>>
>>
>> >> https://so
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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 Could not locate file AUTHORS * 14:57:04 WARN Could not locate file DOCUMENTERS * 14:57:04 WARN Could not locate file LICENSE * 15:01:05 ERROR 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 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 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 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_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.ellenber...@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.ellenber...@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 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@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@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. > >>>
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Hi, Am 19.03.24 um 23:49 schrieb An Ku: [...] 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. Is there anything I should set up first before using the Import option? If there's a howto I have not been able to find I would appreciate a link. [...] BTW: I always prefer camt over swift, because camt is a well documented and well understood file format. Swift mt940 OTOH is a pain in the neck, with all those extensions and specialties. It took us about 20 years to get the swift parser work well enough for all those different document types we encountered so far in Germany. It might not work that well with MT940 docs from other countries :-/ I imagine your banks have their own ideas about what to put in the MT940 fields... Regards Martin -- "Things are only impossible until they're not." ___ 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.
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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. Is there anything I should set up first before using the Import option? If there's a howto I have not been able to find I would appreciate a link. Thanks again for your help On Sat, Mar 16, 2024 at 5:00 PM Frank H. Ellenberger < frank.h.ellenber...@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 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@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@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@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.
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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.ellenber...@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 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@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@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@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.
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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 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@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@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@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.
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
Just a reminder that "File>Import>Import Using AQBanking" is not an option on the menu for Windows Build ID: 5.5+(2023-12-16) Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of john Sent: Saturday, March 16, 2024 3:07 AM To: An Ku Cc: gnucash-user@gnucash.org Subject: Re: [GNC] How to import MT940 and/or online banking missing in 5.5 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 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@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@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@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.
Re: [GNC] How to import MT940 and/or online banking missing in 5.5
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 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@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@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.
