Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

2024-01-25 Thread John Haiducek
Thanks Alan, that did the trick. I had previously tried "dnf reinstall" and
that didn't fix it, but per your suggestion I uninstalled gnucash and then
reinstalled using dnf and now it's working again.

On Thu, Jan 25, 2024 at 5:36 PM Alan Hopkins  wrote:

> I am using GnuCash on Fed38 too. I seem to remember when I installed it
> via the Software Centre it didn't install properly (ie some dependencies
> were missing) so I uninstalled, updated all and reinstalled via CLI and it
> runs like a dream. Maybe do what I did? Hope that is of some help
> Cheers
> Hop
>
> On Fri, 26 Jan 2024, 4:49 am John Haiducek,  wrote:
>
>> I upgraded a bunch of packages using the PackageKit GUI and offline
>> update,
>> and gnucash was one of them. Software Center indicated that the system was
>> fully updated afterward.
>>
>> On Thu, Jan 25, 2024 at 11:46 AM Derek Atkins  wrote:
>>
>> > Correct, it would say something like that.
>> > Now, it could be that there is a sub-library missing.  I.e. this library
>> > looks for libfoo.so (which it finds), but libfoo.so depends on
>> libbar.so,
>> > and THAT is missing.  ldd would not show that.
>> >
>> > So, question for you:  did you do a full system update, or did you JUST
>> > update the gnucash packages?  I only ask because I am running F38 and I
>> > have GnuCash 5.5 running just fine.
>> >
>> > -derek
>> >
>> > On Thu, January 25, 2024 11:33 am, John Haiducek wrote:
>> > > Here's the output from ldd. IIRC, missing dependencies would show up
>> here
>> > > as something like "=> Not found". It looks like everything here
>> points to
>> > > a
>> > > specific file.
>> > >
>> > > $ ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
>> > > linux-vdso.so.1 (0x7ffe3cf5a000)
>> > > libgnc-expressions.so => /usr/lib64/gnucash/libgnc-expressions.so
>> > > (0x7ff5df86a000)
>> > > libguile-3.0.so.1 => /lib64/libguile-3.0.so.1 (0x7ff5df6e3000)
>> > > libgnc-engine.so => /usr/lib64/gnucash/libgnc-engine.so
>> > > (0x7ff5df20)
>> > > libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x7ff5df59a000)
>> > > libc.so.6 => /lib64/libc.so.6 (0x7ff5df022000)
>> > > libgnucash-guile.so => /usr/lib64/gnucash/libgnucash-guile.so
>> > > (0x7ff5def0a000)
>> > > libgnc-app-utils.so => /usr/lib64/gnucash/libgnc-app-utils.so
>> > > (0x7ff5df504000)
>> > > libgobject-2.0.so.0 => /lib64/libgobject-2.0.so.0 (0x7ff5deeaa000)
>> > > libgnc-core-utils.so => /usr/lib64/gnucash/libgnc-core-utils.so
>> > > (0x7ff5dee6e000)
>> > > libgc.so.1 => /lib64/libgc.so.1 (0x7ff5ded2c000)
>> > > libffi.so.8 => /lib64/libffi.so.8 (0x7ff5df4f8000)
>> > > libunistring.so.2 => /lib64/libunistring.so.2 (0x7ff5deb7e000)
>> > > libgmp.so.10 => /lib64/libgmp.so.10 (0x7ff5dead9000)
>> > > libcrypt.so.2 => /lib64/libcrypt.so.2 (0x7ff5deaa)
>> > > libm.so.6 => /lib64/libm.so.6 (0x7ff5de9bf000)
>> > > /lib64/ld-linux-x86-64.so.2 (0x7ff5df88a000)
>> > > libicui18n.so.72 => /lib64/libicui18n.so.72 (0x7ff5de60)
>> > > libicuuc.so.72 => /lib64/libicuuc.so.72 (0x7ff5de20)
>> > > libgmodule-2.0.so.0 => /lib64/libgmodule-2.0.so.0 (0x7ff5df4ed000)
>> > > libstdc++.so.6 => /lib64/libstdc++.so.6 (0x7ff5dde0)
>> > > libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x7ff5de99b000)
>> > > libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7ff5de566000)
>> > > libgio-2.0.so.0 => /lib64/libgio-2.0.so.0 (0x7ff5ddc2d000)
>> > > libboost_filesystem.so.1.78.0 => /lib64/libboost_filesystem.so.1.78.0
>> > > (0x7ff5de979000)
>> > > libboost_locale.so.1.78.0 => /lib64/libboost_locale.so.1.78.0
>> > > (0x7ff5de4c4000)
>> > > libicudata.so.72 => /lib64/libicudata.so.72 (0x7ff5dbe0)
>> > > libz.so.1 => /lib64/libz.so.1 (0x7ff5de95f000)
>> > > libmount.so.1 => /lib64/libmount.so.1 (0x7ff5de47e000)
>> > > libselinux.so.1 => /lib64/libselinux.so.1 (0x7ff5de451000)
>> > > libboost_atomic.so.1.78.0 => /lib64/libboost_atomic.so.1.78.0
>> > > (0x7ff5de955000)
>> > > libboost_system.so.1.78.0 => /lib64/libboost_system.so.1.78.0
>> > > (0x7ff5de95)
>> > > libboost_thre

Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

2024-01-25 Thread John Haiducek
I upgraded a bunch of packages using the PackageKit GUI and offline update,
and gnucash was one of them. Software Center indicated that the system was
fully updated afterward.

On Thu, Jan 25, 2024 at 11:46 AM Derek Atkins  wrote:

> Correct, it would say something like that.
> Now, it could be that there is a sub-library missing.  I.e. this library
> looks for libfoo.so (which it finds), but libfoo.so depends on libbar.so,
> and THAT is missing.  ldd would not show that.
>
> So, question for you:  did you do a full system update, or did you JUST
> update the gnucash packages?  I only ask because I am running F38 and I
> have GnuCash 5.5 running just fine.
>
> -derek
>
> On Thu, January 25, 2024 11:33 am, John Haiducek wrote:
> > Here's the output from ldd. IIRC, missing dependencies would show up here
> > as something like "=> Not found". It looks like everything here points to
> > a
> > specific file.
> >
> > $ ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
> > linux-vdso.so.1 (0x7ffe3cf5a000)
> > libgnc-expressions.so => /usr/lib64/gnucash/libgnc-expressions.so
> > (0x7ff5df86a000)
> > libguile-3.0.so.1 => /lib64/libguile-3.0.so.1 (0x7ff5df6e3000)
> > libgnc-engine.so => /usr/lib64/gnucash/libgnc-engine.so
> > (0x7ff5df20)
> > libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x7ff5df59a000)
> > libc.so.6 => /lib64/libc.so.6 (0x7ff5df022000)
> > libgnucash-guile.so => /usr/lib64/gnucash/libgnucash-guile.so
> > (0x7ff5def0a000)
> > libgnc-app-utils.so => /usr/lib64/gnucash/libgnc-app-utils.so
> > (0x7ff5df504000)
> > libgobject-2.0.so.0 => /lib64/libgobject-2.0.so.0 (0x7ff5deeaa000)
> > libgnc-core-utils.so => /usr/lib64/gnucash/libgnc-core-utils.so
> > (0x7ff5dee6e000)
> > libgc.so.1 => /lib64/libgc.so.1 (0x7ff5ded2c000)
> > libffi.so.8 => /lib64/libffi.so.8 (0x7ff5df4f8000)
> > libunistring.so.2 => /lib64/libunistring.so.2 (0x7ff5deb7e000)
> > libgmp.so.10 => /lib64/libgmp.so.10 (0x7ff5dead9000)
> > libcrypt.so.2 => /lib64/libcrypt.so.2 (0x7ff5deaa)
> > libm.so.6 => /lib64/libm.so.6 (0x7ff5de9bf000)
> > /lib64/ld-linux-x86-64.so.2 (0x7ff5df88a000)
> > libicui18n.so.72 => /lib64/libicui18n.so.72 (0x7ff5de60)
> > libicuuc.so.72 => /lib64/libicuuc.so.72 (0x7ff5de20)
> > libgmodule-2.0.so.0 => /lib64/libgmodule-2.0.so.0 (0x7ff5df4ed000)
> > libstdc++.so.6 => /lib64/libstdc++.so.6 (0x7ff5dde0)
> > libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x7ff5de99b000)
> > libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7ff5de566000)
> > libgio-2.0.so.0 => /lib64/libgio-2.0.so.0 (0x7ff5ddc2d000)
> > libboost_filesystem.so.1.78.0 => /lib64/libboost_filesystem.so.1.78.0
> > (0x7ff5de979000)
> > libboost_locale.so.1.78.0 => /lib64/libboost_locale.so.1.78.0
> > (0x7ff5de4c4000)
> > libicudata.so.72 => /lib64/libicudata.so.72 (0x7ff5dbe0)
> > libz.so.1 => /lib64/libz.so.1 (0x7ff5de95f000)
> > libmount.so.1 => /lib64/libmount.so.1 (0x7ff5de47e000)
> > libselinux.so.1 => /lib64/libselinux.so.1 (0x7ff5de451000)
> > libboost_atomic.so.1.78.0 => /lib64/libboost_atomic.so.1.78.0
> > (0x7ff5de955000)
> > libboost_system.so.1.78.0 => /lib64/libboost_system.so.1.78.0
> > (0x7ff5de95)
> > libboost_thread.so.1.78.0 => /lib64/libboost_thread.so.1.78.0
> > (0x00007ff5de431000)
> > libboost_chrono.so.1.78.0 => /lib64/libboost_chrono.so.1.78.0
> > (0x7ff5de945000)
> > libblkid.so.1 => /lib64/libblkid.so.1 (0x7ff5de1c8000)
> >
> > On Thu, Jan 25, 2024 at 11:15 AM Derek Atkins  wrote:
> >
> >> Run:
> >>   ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
> >>
> >> And see if perhaps it is missing a dependency?
> >>
> >> -derek
> >>
> >> On Thu, January 25, 2024 11:07 am, John Haiducek wrote:
> >> > The file and its parent directory are both world-readable
> >> >
> >> > On Thu, Jan 25, 2024 at 10:46 AM R Losey  wrote:
> >> >
> >> >> This is probably a silly question, but does the .so file have
> >> >> permissions
> >> >> that let it be read by your account? And/or what about the
> >> >> containing directory?
> >> >>
> >> >>
> >> >> On Thu, Jan 25, 2024 at 9:19 AM John Haiducek 
> >> >> wrote:
> >> >>
> >> >>> After upgrading to gnucash 5.5 on Fed

Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

2024-01-25 Thread John Haiducek
Here's the output from ldd. IIRC, missing dependencies would show up here
as something like "=> Not found". It looks like everything here points to a
specific file.

$ ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
linux-vdso.so.1 (0x7ffe3cf5a000)
libgnc-expressions.so => /usr/lib64/gnucash/libgnc-expressions.so
(0x7ff5df86a000)
libguile-3.0.so.1 => /lib64/libguile-3.0.so.1 (0x7ff5df6e3000)
libgnc-engine.so => /usr/lib64/gnucash/libgnc-engine.so (0x7ff5df20)
libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x7ff5df59a000)
libc.so.6 => /lib64/libc.so.6 (0x7ff5df022000)
libgnucash-guile.so => /usr/lib64/gnucash/libgnucash-guile.so
(0x7ff5def0a000)
libgnc-app-utils.so => /usr/lib64/gnucash/libgnc-app-utils.so
(0x7ff5df504000)
libgobject-2.0.so.0 => /lib64/libgobject-2.0.so.0 (0x7ff5deeaa000)
libgnc-core-utils.so => /usr/lib64/gnucash/libgnc-core-utils.so
(0x7ff5dee6e000)
libgc.so.1 => /lib64/libgc.so.1 (0x7ff5ded2c000)
libffi.so.8 => /lib64/libffi.so.8 (0x7ff5df4f8000)
libunistring.so.2 => /lib64/libunistring.so.2 (0x7ff5deb7e000)
libgmp.so.10 => /lib64/libgmp.so.10 (0x7ff5dead9000)
libcrypt.so.2 => /lib64/libcrypt.so.2 (0x7ff5deaa)
libm.so.6 => /lib64/libm.so.6 (0x7ff5de9bf000)
/lib64/ld-linux-x86-64.so.2 (0x7ff5df88a000)
libicui18n.so.72 => /lib64/libicui18n.so.72 (0x7ff5de60)
libicuuc.so.72 => /lib64/libicuuc.so.72 (0x7ff5de20)
libgmodule-2.0.so.0 => /lib64/libgmodule-2.0.so.0 (0x7ff5df4ed000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x7ff5dde0)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x7ff5de99b000)
libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7ff5de566000)
libgio-2.0.so.0 => /lib64/libgio-2.0.so.0 (0x7ff5ddc2d000)
libboost_filesystem.so.1.78.0 => /lib64/libboost_filesystem.so.1.78.0
(0x7ff5de979000)
libboost_locale.so.1.78.0 => /lib64/libboost_locale.so.1.78.0
(0x7ff5de4c4000)
libicudata.so.72 => /lib64/libicudata.so.72 (0x7ff5dbe0)
libz.so.1 => /lib64/libz.so.1 (0x7ff5de95f000)
libmount.so.1 => /lib64/libmount.so.1 (0x7ff5de47e000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x7ff5de451000)
libboost_atomic.so.1.78.0 => /lib64/libboost_atomic.so.1.78.0
(0x7ff5de955000)
libboost_system.so.1.78.0 => /lib64/libboost_system.so.1.78.0
(0x7ff5de95)
libboost_thread.so.1.78.0 => /lib64/libboost_thread.so.1.78.0
(0x7ff5de431000)
libboost_chrono.so.1.78.0 => /lib64/libboost_chrono.so.1.78.0
(0x7ff5de945000)
libblkid.so.1 => /lib64/libblkid.so.1 (0x7ff5de1c8000)

On Thu, Jan 25, 2024 at 11:15 AM Derek Atkins  wrote:

> Run:
>   ldd /usr/lib64/gnucash/libgnc-expressions-guile.so
>
> And see if perhaps it is missing a dependency?
>
> -derek
>
> On Thu, January 25, 2024 11:07 am, John Haiducek wrote:
> > The file and its parent directory are both world-readable
> >
> > On Thu, Jan 25, 2024 at 10:46 AM R Losey  wrote:
> >
> >> This is probably a silly question, but does the .so file have
> >> permissions
> >> that let it be read by your account? And/or what about the
> >> containing directory?
> >>
> >>
> >> On Thu, Jan 25, 2024 at 9:19 AM John Haiducek 
> >> wrote:
> >>
> >>> After upgrading to gnucash 5.5 on Fedora 38 (using the rpm package for
> >>> gnucash from the Fedora repos), I get the following error trying to
> >>> start
> >>> gnucash:
> >>>
> >>> $ gnucash
> >>> Backtrace:
> >>> In ice-9/boot-9.scm:
> >>>   3536:20 19 (_)
> >>>2835:4 18 (save-module-excursion #)
> >>>   3556:26 17 (_)
> >>> In unknown file:
> >>>   16 (primitive-load-path "gnucash/report/html-utilities" #<…>)
> >>> In html-utilities.scm:
> >>>  32:0 15 (_)
> >>> In ice-9/boot-9.scm:
> >>>   3927:20 14 (process-use-modules _)
> >>>222:17 13 (map1 (((gnucash report report-core
> >>>   3928:31 12 (_ ((gnucash report report-core)))
> >>>   3326:17 11 (resolve-interface (gnucash report report-core) #:select
> >>> …)
> >>> In ice-9/threads.scm:
> >>> 390:8 10 (_ _)
> >>> In ice-9/boot-9.scm:
> >>>   3252:13  9 (_)
> >>> In ice-9/threads.scm:
> >>> 390:8  8 (_ _)
> >>> In ice-9/boot-9.scm:
> >>>   3536:20  7 (_)
> >>>2835:4  6 (save-module-excursion #)
> >>>   3556:26  5 (_)
> >>> In unknown file:
> >>>4 (primitive-load-path "gnucash/report/report-core" #)
> >>> In report-

Re: [GNC] No such file or directory error finding libgnc-expressions-guile.so

2024-01-25 Thread John Haiducek
The file and its parent directory are both world-readable

On Thu, Jan 25, 2024 at 10:46 AM R Losey  wrote:

> This is probably a silly question, but does the .so file have permissions
> that let it be read by your account? And/or what about the
> containing directory?
>
>
> On Thu, Jan 25, 2024 at 9:19 AM John Haiducek  wrote:
>
>> After upgrading to gnucash 5.5 on Fedora 38 (using the rpm package for
>> gnucash from the Fedora repos), I get the following error trying to start
>> gnucash:
>>
>> $ gnucash
>> Backtrace:
>> In ice-9/boot-9.scm:
>>   3536:20 19 (_)
>>2835:4 18 (save-module-excursion #)
>>   3556:26 17 (_)
>> In unknown file:
>>   16 (primitive-load-path "gnucash/report/html-utilities" #<…>)
>> In html-utilities.scm:
>>  32:0 15 (_)
>> In ice-9/boot-9.scm:
>>   3927:20 14 (process-use-modules _)
>>222:17 13 (map1 (((gnucash report report-core
>>   3928:31 12 (_ ((gnucash report report-core)))
>>   3326:17 11 (resolve-interface (gnucash report report-core) #:select …)
>> In ice-9/threads.scm:
>> 390:8 10 (_ _)
>> In ice-9/boot-9.scm:
>>   3252:13  9 (_)
>> In ice-9/threads.scm:
>> 390:8  8 (_ _)
>> In ice-9/boot-9.scm:
>>   3536:20  7 (_)
>>2835:4  6 (save-module-excursion #)
>>   3556:26  5 (_)
>> In unknown file:
>>4 (primitive-load-path "gnucash/report/report-core" #)
>> In report-core.scm:
>>  26:2  3 (_)
>> In unknown file:
>>2 (load-extension "libgnc-expressions-guile" "scm_init_sw…")
>> In system/foreign-library.scm:
>>190:25  1 (load-foreign-library _ #:extensions _ # _ #:search-path …)
>> In unknown file:
>>0 (dlopen "libgnc-expressions-guile.so" 1)
>>
>> ERROR: In procedure dlopen:
>> In procedure dlopen: file "libgnc-expressions-guile.so", message
>> "libgnc-expressions-guile.so: cannot open shared object file: No such file
>> or directory"
>>
>> I can confirm that /usr/lib64/gnucash/libgnc-expressions-guile.so exists.
>> Obviously this looks like a bug, but I'm not sure if it's a gnucash bug or
>> a packaging problem on the Fedora side. Can anyone help me figure out
>> which
>> it is? Any possible workarounds to try?
>> ___
>> 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.
>>
>
>
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
>
___
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.


[GNC] No such file or directory error finding libgnc-expressions-guile.so

2024-01-25 Thread John Haiducek
After upgrading to gnucash 5.5 on Fedora 38 (using the rpm package for
gnucash from the Fedora repos), I get the following error trying to start
gnucash:

$ gnucash
Backtrace:
In ice-9/boot-9.scm:
  3536:20 19 (_)
   2835:4 18 (save-module-excursion #)
  3556:26 17 (_)
In unknown file:
  16 (primitive-load-path "gnucash/report/html-utilities" #<…>)
In html-utilities.scm:
 32:0 15 (_)
In ice-9/boot-9.scm:
  3927:20 14 (process-use-modules _)
   222:17 13 (map1 (((gnucash report report-core
  3928:31 12 (_ ((gnucash report report-core)))
  3326:17 11 (resolve-interface (gnucash report report-core) #:select …)
In ice-9/threads.scm:
390:8 10 (_ _)
In ice-9/boot-9.scm:
  3252:13  9 (_)
In ice-9/threads.scm:
390:8  8 (_ _)
In ice-9/boot-9.scm:
  3536:20  7 (_)
   2835:4  6 (save-module-excursion #)
  3556:26  5 (_)
In unknown file:
   4 (primitive-load-path "gnucash/report/report-core" #)
In report-core.scm:
 26:2  3 (_)
In unknown file:
   2 (load-extension "libgnc-expressions-guile" "scm_init_sw…")
In system/foreign-library.scm:
   190:25  1 (load-foreign-library _ #:extensions _ # _ #:search-path …)
In unknown file:
   0 (dlopen "libgnc-expressions-guile.so" 1)

ERROR: In procedure dlopen:
In procedure dlopen: file "libgnc-expressions-guile.so", message
"libgnc-expressions-guile.so: cannot open shared object file: No such file
or directory"

I can confirm that /usr/lib64/gnucash/libgnc-expressions-guile.so exists.
Obviously this looks like a bug, but I'm not sure if it's a gnucash bug or
a packaging problem on the Fedora side. Can anyone help me figure out which
it is? Any possible workarounds to try?
___
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] List of fields checked by importer when matching transactions

2024-01-15 Thread John Haiducek
Thanks, Etienne. Thankfully, my CSV only has one row per transaction.

On Sat, Jan 13, 2024 at 5:04 AM GNUCash  wrote:

> John,
> Yes the description had to match the tranfer memo. To clarify.
> In my transaction CSV I had 3 rows belonging to 1 transaction.
> Description on all 3 rows: “Order 1234”
> Receivables and deposit rows where identical in all fields (memo, transfer
> memo, description).
> But the third row contained the transaction fee.
> So I had in the transfer memo: “Order 1234; payment cost”. Then the
> importer failed to match it to the first 2 rows.
>
> Etienne
> On 12 Jan 2024 at 12:43 +0100, GNUCash via gnucash-user <
> gnucash-user@gnucash.org>, wrote:
>
> Perhaps related to your question.
> I did notice as I was closing last quarter that in the GNU Cash latest
> version something seems to have changed with the importer matching.
> I create my own CSV files in Python based on the export from
> suppliers/payments.
> I had to change the Transfer memo field I believe, to match either the
> Memo field or the description field. Else transactions no longer matched.
> Before, I could have different texts there.
>
> Etienne
> On 11 Jan 2024 at 18:01 +0100, John Haiducek , wrote:
>
> Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
> those it says "Match missing!", even for cases where every imported field
> is identical to an existing transaction.
>
> On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam  wrote:
>
> I've been having the same issue with qfx/ofx files, but I find when I
> click on the clear check box it finds the matching transaction. You might
> want to try that.
>
>
>
> Sent from Samsung Galaxy smartphone.
>
>
>
>  Original message 
> From: John Haiducek 
> Date: 1/11/24 10:43 AM (GMT-05:00)
> To: GNU Cash User 
> Subject: [GNC] List of fields checked by importer when matching
> transactions
>
> Hi,
>
> Is there a list somewhere of what fields are checked by the importer when
> matching transactions? I'm trying to import a CSV file that contains
> already-existing transactions and the importer is failing to detect them
> (there are hundreds so I don't want to manually de-select them all).
>
> John
> ___
> 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.
>
>
___
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] List of fields checked by importer when matching transactions

2024-01-11 Thread John Haiducek
Checking "Clear" (or "Update+Clear") doesn't work in my case. When I check
those it says "Match missing!", even for cases where every imported field
is identical to an existing transaction.

On Thu, Jan 11, 2024 at 11:44 AM Gyle McCollam  wrote:

> I've been having the same issue with qfx/ofx files,  but I find when I
> click on the clear check box it finds the matching transaction. You might
> want to try that.
>
>
>
> Sent from Samsung Galaxy smartphone.
>
>
>
>  Original message 
> From: John Haiducek 
> Date: 1/11/24 10:43 AM (GMT-05:00)
> To: GNU Cash User 
> Subject: [GNC] List of fields checked by importer when matching
> transactions
>
> Hi,
>
> Is there a list somewhere of what fields are checked by the importer when
> matching transactions? I'm trying to import a CSV file that contains
> already-existing transactions and the importer is failing to detect them
> (there are hundreds so I don't want to manually de-select them all).
>
> John
> ___
> 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.


[GNC] List of fields checked by importer when matching transactions

2024-01-11 Thread John Haiducek
Hi,

Is there a list somewhere of what fields are checked by the importer when
matching transactions? I'm trying to import a CSV file that contains
already-existing transactions and the importer is failing to detect them
(there are hundreds so I don't want to manually de-select them all).

John
___
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.


[GNC] USAA OFX Direct Connect stopped working

2023-12-14 Thread John Haiducek
Downloading transactions from USAA accounts stopped working for me today.
In the past I've been able to restore access by following the instructions
at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA and
getting an accessid from http://usaa.com/accessid or
https://df3cx-services.1fsapi.com/casm/usaa/enroll. However, now both of
those websites redirect to a page that returns the following in JSON:

{
"error": "invalid_request",
"error_description": "Validation error"
}

Does anyone know a workaround for this? Is there an updated URL I can use?
___
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] [GNC-dev] USAA FSB requires newer QWIN support

2021-02-17 Thread John Haiducek
Thanks for the clarification. I updated aqbanking to 6.2.6 and I can see
the HTTP User Agent field now.

On Tue, Feb 16, 2021 at 11:25 AM John Ralls  wrote:

> Sorry, it's AQBanking 6.2.6. I've fixed the wiki page and added links for
> macOS and flathub users to the exact version of GnuCash they need.
>
> There's no 4.4.1: We changed to a two-digit versioning system 4 years ago.
> However the all-in-one bundles on macOS and Windows can have suffixes as do
> flathub packages. I didn't do a rebundle of the 4.4 release on Windows as
> we have nightly builds for that and users are accustomed to using them. The
> flathub version you need is 4.4-4 and the macOS one is 4.4-2. For the
> latter use the new link on the wiki page; I don't intend to change the link
> on the website nor to add the 4.4-2 dmg to the Github release because this
> affects only a few users.
>
> Regards,
> John Ralls
>
>
> > On Feb 16, 2021, at 6:07 AM, John Haiducek  wrote:
> >
> > The instructions on the wiki say that GnuCash 4.4 and aqbanking 6.1.6
> are required to connect, but some of the comments on this thread refer to
> GnuCash 4.4.1. I tried with GnuCash 4.4 and aqbanking 6.2.5 and found that
> the aqbanking UI is slightly different than described in the wiki and there
> is no field to set the HTTP User Agent. Is GnuCash 4.4.1 and/or aqbanking
> 6.2.6 required to make this work?
> >
> > John
> >
> > On Sun, Feb 14, 2021 at 7:54 PM John Ralls  wrote:
> > I tried again with a second visit to accessid so I'd get a fresh UUID.
> It worked to get the accounts but failed when I tried to retrieve
> transactions.
> >
> > I've summarized the setup process in
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA,
> though for my experience the Client UID instructions, which reflect getting
> them from the URL, are not correct.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Feb 14, 2021, at 3:59 PM, John Ralls  wrote:
> > >
> > > I tried it both ways, capitalized and not.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >> On Feb 14, 2021, at 11:31 AM, Randy Johnson 
> wrote:
> > >>
> > >> I ended up with two during my experimentation - I ended up requesting
> access twice, I got the same access is and password both times but
> different client uuids. Both client uuids I got as well as the published
> one worked for me.
> > >> Quick check, did you capitalize the letters in the uuid? Someone
> mentioned it earlier and I just confirmed with my own, lower case uuids
> will return an error.
> > >> -Randy
> > >>
> > >> On Sun, Feb 14, 2021, 2:12 PM John Ralls  wrote:
> > >> Well, there's a UUID in that URL, but I just tried using it for the
> ClientUUID and got "The user cannot signon because he or she entered an
> invalid user ID or password." Using the one scraped from Quicken for MacOS
> and reported in
> https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html
> works.
> > >>
> > >> That leads me to believe that USAA is using the ClientUUID as an API
> key. Quicken may have registered one or many. I think the only way to find
> that out is for more users to set up MITMs with different versions of
> Quicken and retrieve the ClientUUIDs for comparison.
> > >>
> > >> This makes me a bit leery of publishing it on the wiki, because if
> Quicken or USAA catch on that it's been compromised they might change it
> and lock us out again.
> > >>
> > >> Regards,
> > >> John Ralls
> > >>
> > >>
> > >>> On Feb 13, 2021, at 9:06 PM, Randy Johnson 
> wrote:
> > >>>
> > >>> The CLIENTUID is also part of the URL that you get sent to after
> completing
> > >>> https://df3cx-services.1fsapi.com/casm/usaa/enroll (or
> usaa.com/accessid ,
> > >>> not sure which is preferred), hopefully avoiding the need to install
> > >>> Quicken.
> > >>>
> > >>> -Randy
> > >>>
> > >>> On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel <
> > >>> gnucash-de...@gnucash.org> wrote:
> > >>>
> > >>>> I got new USAA OFX download working with GNC 4.4.1.
> > >>>>
> > >>>> It's mainly a configuration task.
> > >>>>
> > >>>> -- User config --
> > >>>> int uniqueId=""
> > >>>> char backendName="aqofxconnect"

Re: [GNC] [GNC-dev] USAA FSB requires newer QWIN support

2021-02-16 Thread John Haiducek
The instructions on the wiki say that GnuCash 4.4 and aqbanking 6.1.6 are
required to connect, but some of the comments on this thread refer to
GnuCash 4.4.1. I tried with GnuCash 4.4 and aqbanking 6.2.5 and found that
the aqbanking UI is slightly different than described in the wiki and there
is no field to set the HTTP User Agent. Is GnuCash 4.4.1 and/or aqbanking
6.2.6 required to make this work?

John

On Sun, Feb 14, 2021 at 7:54 PM John Ralls  wrote:

> I tried again with a second visit to accessid so I'd get a fresh UUID. It
> worked to get the accounts but failed when I tried to retrieve transactions.
>
> I've summarized the setup process in
> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA,
> though for my experience the Client UID instructions, which reflect getting
> them from the URL, are not correct.
>
> Regards,
> John Ralls
>
>
> > On Feb 14, 2021, at 3:59 PM, John Ralls  wrote:
> >
> > I tried it both ways, capitalized and not.
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Feb 14, 2021, at 11:31 AM, Randy Johnson 
> wrote:
> >>
> >> I ended up with two during my experimentation - I ended up requesting
> access twice, I got the same access is and password both times but
> different client uuids. Both client uuids I got as well as the published
> one worked for me.
> >> Quick check, did you capitalize the letters in the uuid? Someone
> mentioned it earlier and I just confirmed with my own, lower case uuids
> will return an error.
> >> -Randy
> >>
> >> On Sun, Feb 14, 2021, 2:12 PM John Ralls  wrote:
> >> Well, there's a UUID in that URL, but I just tried using it for the
> ClientUUID and got "The user cannot signon because he or she entered an
> invalid user ID or password." Using the one scraped from Quicken for MacOS
> and reported in
> https://lists.gnucash.org/pipermail/gnucash-devel/2021-February/045690.html
> works.
> >>
> >> That leads me to believe that USAA is using the ClientUUID as an API
> key. Quicken may have registered one or many. I think the only way to find
> that out is for more users to set up MITMs with different versions of
> Quicken and retrieve the ClientUUIDs for comparison.
> >>
> >> This makes me a bit leery of publishing it on the wiki, because if
> Quicken or USAA catch on that it's been compromised they might change it
> and lock us out again.
> >>
> >> Regards,
> >> John Ralls
> >>
> >>
> >>> On Feb 13, 2021, at 9:06 PM, Randy Johnson 
> wrote:
> >>>
> >>> The CLIENTUID is also part of the URL that you get sent to after
> completing
> >>> https://df3cx-services.1fsapi.com/casm/usaa/enroll (or
> usaa.com/accessid ,
> >>> not sure which is preferred), hopefully avoiding the need to install
> >>> Quicken.
> >>>
> >>> -Randy
> >>>
> >>> On Fri, Feb 12, 2021, 5:29 PM Bob White via gnucash-devel <
> >>> gnucash-de...@gnucash.org> wrote:
> >>>
>  I got new USAA OFX download working with GNC 4.4.1.
> 
>  It's mainly a configuration task.
> 
>  -- User config --
>  int uniqueId=""
>  char backendName="aqofxconnect"
>  char userName=""
>  char userId=""
>  char customerId=""
>  char country="us"
>  char bankCode="314074269"
>  int lastSessionId="0"
> 
>  data {
>  backend {
>    char bankName="USAA Federal Savings Bank"
>    char org="USAA Federal Savings Bank"
>    char fid="67811"
>    char serverAddr="https%3A%2F%2Fdf3cx-services.1fsapi.com
>  %2Fcasm%2Fusaa%2Faccess.ofx"
>    char appId="QMOFX"
>    char appVer="2300"
>    char headerVer="103"
>    char clientUid=""
>    int httpVMajor="0"
>    int httpVMinor="0"
>    char httpUserAgent="InetClntApp%2F3.0"
>  } #backend
>  } #data
>  -
> 
>  Notes:
>  -- 'httpUserAgent' is currently not configurable through GNC v4.4.1,
> but
>  it works when included in the file.  It has been added in newer
> AqBanking,
>  look for support in next GNC release.
>  -- 'CLIENTUID' can be found in OFXLog.txt generated by Quicken.
> Signup
>  for trial and cancel within 30 days no charge.
>  -- 'your new USAA access id' can be found at
>  https://www.usaa.com/accessid
> 
>  You will need to disconnect accounts from within the AqBanking Wizard,
>  download accounts with new user configuration, then reconnect
> accounts.  In
>  my case, the new credit card account numbers in the accounts list are
> not a
>  100% match to the number found on your credit card.  There were enough
>  common digits to know which was which, just be aware.  I was able to
>  successfully download and update 2 checking accounts, a savings
> account,
>  and a credit card account.
> 
>  I hope this helps.
> 
>  Regards,
> 
>  Bob
> 
>  PS.  I did clone the AqBanking repo and build and install the latest
>  libraries on the same machine I am running GNC.  I am not sure if the
>  GNC used 

[GNC] Error retrieving price quotes

2020-07-01 Thread John Haiducek
When I try to fetch prices I get the error "There was a system error while
retrieving the price quotes". No error message is printed to the console.

gnc-fq-dump is able to fetch quotes successfully.

I'm running gnucash 3.10 with Finance::Quote 1.47 on Fedora 32.

John
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)

2020-05-13 Thread John Haiducek
Didn't work for me. I installed the updated aqbanking package and still get
the error. Anthony, did you have to go into aqbanking and recreate the
accounts in order for download transactions to work?

On Sun, May 10, 2020 at 5:03 PM Anthony Joseph Messina <
amess...@messinet.com> wrote:

> On Monday, May 4, 2020 4:10:45 PM CDT John Ralls wrote:
> > > On May 4, 2020, at 1:07 PM, Daffy Duck 
> wrote:
> > >
> > > Hello,
> > >
> > > I'd been using online banking forever, but since upgrading to Fedora 32
> > > last week, I now get this error when I try to fetch transactions:
> > >
> > > error on executing job. status: enqueued (1)
> > >
> > > It shows in a popup.
> > >
> > > If I go into online banking setup and try to retrieve accounts, it just
> > > crashes.
> > >
> > > gnucash-3.10-1.fc32.x86_64
> > >
> > > aqbanking-6.0.1-2.fc32.x86_64
> > >
> > > gwenhywfar-5.1.2-2.fc32.x86_64
> > >
> > > Any ideas?
> >
> > Yes, AQBanking between 5.99.0 and 6.1.4 doesn't work with OFX
> DirectConnect.
> > https://bugzilla.redhat.com/show_bug.cgi?id=1830609
> >
> > Regards,
> > John Ralls
>
> I can confirm the update in bodhi resolves the issue:
> https://bodhi.fedoraproject.org/updates/FEDORA-2020-24e4addb7e
>
> Thank you.  -A
>
> --
> Anthony - https://messinet.com
> F9B6 560E 68EA 037D 8C3D  D1C9 FF31 3BDB D9D8 99B6
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.