[GNC] Quotes issue

[Steve]

I'm getting this error:

steve@stevesdesktop:~$ gnc-fq-check
Json3.c: loadable library and perl binaries are mismatched (got handshake key 
0xce00080, needed 0xed00080)

But...
steve@stevesdesktop:~$ sudo find /usr -name "libperl.so*" -exec ls -lah {} \; 
2>/dev/null
-rw-r--r-- 1 root root 3.6M Sep 24  2021 
/usr/lib/x86_64-linux-gnu/libperl.so.5.32.1
lrwxrwxrwx 1 root root 17 Sep 24  2021 
/usr/lib/x86_64-linux-gnu/libperl.so.5.32 -> libperl.so.5.32.1

steve@stevesdesktop:~$ perl --version

This is perl 5, version 32, subversion 1 (v5.32.1) built for 
x86_64-linux-gnu-thread-multi
(with 47 registered patches, see perl -V for more detail)

So why does gnc-fq-check think there is a mismatch? 

Thanks,
Steve
___
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] Quotes issue

[Steve]

On Sun, 17 Apr 2022 12:54:56 -0700
John Ralls  wrote:

> > On Apr 17, 2022, at 9:24 AM, john  wrote:
> > 
> > 
> >   
> >> On Apr 17, 2022, at 8:07 AM, Steve  wrote:
> >> 
> >> On Sat, 16 Apr 2022 19:48:52 -0700
> >> john  wrote:
> >>   
> >>>> On Apr 16, 2022, at 9:47 AM, Steve  wrote:
> >>>> 
> >>>> I'm getting this error:
> >>>> 
> >>>> steve@stevesdesktop:~$ gnc-fq-check
> >>>> Json3.c: loadable library and perl binaries are mismatched (got
> >>>> handshake key 0xce00080, needed 0xed00080)
> >>>> 
> >>>> But...
> >>>> steve@stevesdesktop:~$ sudo find /usr -name "libperl.so*" -exec
> >>>> ls -lah {} \; 2>/dev/null -rw-r--r-- 1 root root 3.6M Sep 24
> >>>> 2021 /usr/lib/x86_64-linux-gnu/libperl.so.5.32.1 lrwxrwxrwx 1
> >>>> root root 17 Sep 24  2021
> >>>> /usr/lib/x86_64-linux-gnu/libperl.so.5.32 -> libperl.so.5.32.1
> >>>> 
> >>>> steve@stevesdesktop:~$ perl --version
> >>>> 
> >>>> This is perl 5, version 32, subversion 1 (v5.32.1) built for
> >>>> x86_64-linux-gnu-thread-multi (with 47 registered patches, see
> >>>> perl -V for more detail)
> >>>> 
> >>>> So why does gnc-fq-check think there is a mismatch? 
> >>> 
> >>> As a first guess your perl json module is linked to a different
> >>> version of libjson than the one you have. If you used
> >>> gnc-fq-update to set up Finance::Quote then running it again
> >>> should fix the problem. If you installed F::Q from your distro's
> >>> package manager and there aren't any updates then the packager
> >>> for that module is running a bit behind, a common problem for
> >>> most distros since they rely on volunteers.
> >>>   
> >> 
> >> steve@stevesdesktop:~/Downloads$ sudo gnc-fq-update
> >> Reading '/root/.cpan/Metadata'
> >> Database was generated on Sun, 17 Apr 2022 00:17:02 GMT
> >> Date::Manip is up to date (6.86).
> >> Finance::Quote is up to date (1.51).
> >> 
> >> (update done here)
> >> 
> >> steve@stevesdesktop:~/Downloads$ sudo apt-get upgrade
> >> Reading package lists... Done
> >> Building dependency tree... Done
> >> Reading state information... Done
> >> Calculating upgrade... Done
> >> The following packages have been kept back:
> >> qdbus
> >> 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
> >> 
> >> steve@stevesdesktop:~/Downloads$ dpkg -l | egrep -i
> >> 'perl.*json|json.*perl' ii  libjson-parse-perl
> >> 0.61-1 amd64module to read
> >> JSON into a Perl variable ii  libjson-perl
> >>   4.03000-1  all  module for
> >> manipulating JSON-formatted data ii  libjson-xs-perl
> >>  4.030-1+b1 amd64
> >> module for manipulating JSON-formatted data (C/XS-accelerated)
> >> 
> >> So am I right in thinking that the 4.030 versions are the problem?
> >> If so, I'll have to contact the maintainers.  
> > 
> > Please remember to copy the list on all replies.
> > 
> > libjson-xs-perl is probably the mismatched library.  briefly
> > explains the nature of the problem. Before you can blame the Debian
> > packager (the libjson-xs-perl maintainer is innocent) for upgrading
> > perl without upgrading all of the packages you need to be sure that
> > that's the only instance of libjson-xs-perl on your system. If
> > there's another one earlier in perl's include path it might be the
> > mismatched library. Have you ever run gnc-fq-update or used cpan
> > directly  on this machine?  
> 
> 
> I forgot to paste in the URI that explains the problem. It's
> https://foursixnine.io/blog/2019/01/21/perl-binaries-are-mismatched.html
> 
Looks like you are correct:

steve@stevesdesktop:~/Downloads$ sudo find / -name "libjson-xs-perl*" 
2>/dev/null
[sudo] password for steve: 
/var/lib/dpkg/info/libjson-xs-perl.md5sums
/var/lib/dpkg/info/libjson-xs-perl.list
/var/cache/apt/archives/libjson-xs-perl_3.030-1_amd64.deb
/var/cache/apt/archives/libjson-xs-perl_4.030-1+b1_amd64.deb
/var/cache/apt/archives/libjson-xs-perl_3.040-1+b1_amd64.deb
/usr/share/doc/libjson-xs-perl

This is starting to come back to me now. IIFC, the version of perl that
came with my distribution did not have a Finance module and I ended up
with a separate version of Perl that did have Finance. I've done several
dist-upgrades since then so I'm going to delete the separate perl
version and attempt to install the Finance module from the distribution
perl.

Thanks,
Steve
___
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.

[GNC] Quotes issue

[Steve]

When I do Tools->Price Database->Get Quotes I get:

ERROR: ALPHAVANTAGE_API_KEY must be set for currency and quotes.
See
https://wiki.gnucash.org/wiki/Online_Quotes/#Source_Alphavantage.-2C_US

and yet:

steve@stevesdesktop:~/Downloads$ env|grep ALPHAVANTAGE
ALPHAVANTAGE_API_KEY=D5IXXX

steve@stevesdesktop:~/Downloads$ gnc-fq-dump currency GBP USD
1 GBP = 1.2630887 USD

steve@stevesdesktop:~/Downloads$ gnc-fq-dump yahoo_json GOOGL
Finance::Quote fields Gnucash uses:
symbol: GOOGL<=== required
  date: 05/27/2022   <=== recommended
  currency: USD  <=== required
  last: 2246.33  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional
steve@stevesdesktop:~/Downloads$ 

I have all my quotes set up to use yahoo_json so what am I missing?

Steve
___
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] Quotes issue

[Steve]

On Sat, 28 May 2022 17:26:47 -0700
John Ralls  wrote:

> You're missing that the environment in your shell isn't necessarily
> the one that GnuCash sees unless you launch GnuCash from that shell.
> Enter your API key in Preferences>Online Quotes to cover that case.
> 
> Regards,
> John Ralls
> 

That was it!
Thanks,
Steve

> 
> > On May 28, 2022, at 4:42 PM, Steve  wrote:
> > 
> > When I do Tools->Price Database->Get Quotes I get:
> > 
> > ERROR: ALPHAVANTAGE_API_KEY must be set for currency and quotes.
> > See
> > https://wiki.gnucash.org/wiki/Online_Quotes/#Source_Alphavantage.-2C_US
> > 
> > and yet:
> > 
> > steve@stevesdesktop:~/Downloads$ env|grep ALPHAVANTAGE
> > ALPHAVANTAGE_API_KEY=D5IXXXXXXX
> > 
> > steve@stevesdesktop:~/Downloads$ gnc-fq-dump currency GBP USD
> > 1 GBP = 1.2630887 USD
> > 
> > steve@stevesdesktop:~/Downloads$ gnc-fq-dump yahoo_json GOOGL
> > Finance::Quote fields Gnucash uses:
> >   symbol: GOOGL<=== required
> > date: 05/27/2022   <=== recommended
> > currency: USD  <=== required
> > last: 2246.33  <=\   
> >  nav:  <=== one of these
> >price:  <=/
> > timezone:  <=== optional
> > steve@stevesdesktop:~/Downloads$ 
> > 
> > I have all my quotes set up to use yahoo_json so what am I missing?
> > 
> > Steve
> > ___
> > 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.

[GNC] Stock price retrieval (again, sorry!)

[Steve]

Every since Yahoo shut down their service, I have not been able to get
any stock quotes. I had been running a very old version 2.6.15, I
think, so I did not try to resolve the issue but now I have updated to
3.4 and I still have the same problem.

I have checked that I have the necessary version of Perl and
gnc-fq-dump installed and I changed all my securities to retrieve
quotes using yahoo_jason. From the command line I ban get a quote:

$ gnc-fq-dump yahoo_json googl
Finance::Quote fields Gnucash uses:
symbol: googl<=== required
  date: 05/17/2019   <=== recommended
  currency: USD  <=== required
  last: 1168.78  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

but when I try from inside GNC I get the "Unknown Error" popup. Are
there any debug logs I can look at to see what is going on? Perhaps I
have too many securities? Is there a way to request just one from
inside GNC?

Thanks,
Steve
___
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.

[GNC] Stock quotes

[Steve]

Ever since Yahoo shut down their service, I have not been able to get
any stock quotes. I had been running a very old version, 2.6.15, I
think, so I didn't try to resolve the issue but now I have updated to
3.4 and I still have the same problem.

I have checked that I have the necessary version of Perl and
gnc-fq-dump installed and I changed all my securities to retrieve
quotes using yahoo_jason. From the command line I can get a quote:

$ gnc-fq-dump yahoo_json googl
Finance::Quote fields Gnucash uses:
symbol: googl<=== required
  date: 05/17/2019   <=== recommended
  currency: USD  <=== required
  last: 1168.78  <=\   
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

but when I try from inside GNC I get the "Unknown Error" popup. Are
there any debug logs I can look at to see what is going on? Perhaps I
have too many securities? Is there a way to request just one from
inside GNC?

Thanks,
Steve
___
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] Stock quotes

[Steve]

That was it. I still had one set up as Alphavantage. "Unknown error"
is not the most helpful error message.

Thanks,
Steve

On Fri, 24 May 2019 08:00:35 -0400
"Derek Atkins"  wrote:

> Are you sure that ALL your securities are set to yahoo_json?
> If only ONE is set elsewhere, it wont work and you'll get this error.
> 
> -derek
> 
> On Fri, May 24, 2019 7:24 am, Steve wrote:
> > Ever since Yahoo shut down their service, I have not been able to
> > get any stock quotes. I had been running a very old version,
> > 2.6.15, I think, so I didn't try to resolve the issue but now I
> > have updated to 3.4 and I still have the same problem.
> >
> > I have checked that I have the necessary version of Perl and
> > gnc-fq-dump installed and I changed all my securities to retrieve
> > quotes using yahoo_jason. From the command line I can get a quote:
> >
> > $ gnc-fq-dump yahoo_json googl
> > Finance::Quote fields Gnucash uses:
> > symbol: googl<=== required
> >   date: 05/17/2019   <=== recommended
> >   currency: USD  <=== required
> >   last: 1168.78  <=\
> >nav:  <=== one of these
> >  price:  <=/
> >   timezone:  <=== optional
> >
> > but when I try from inside GNC I get the "Unknown Error" popup. Are
> > there any debug logs I can look at to see what is going on? Perhaps
> > I have too many securities? Is there a way to request just one from
> > inside GNC?
> >
> > Thanks,
> > Steve
> > ___
> > 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.

GnuCash mobile

[Steve]

Before I get flamed, I throw myself on the mercy of the gawds and acknowledge
that I've posted on this subject before...

Not talking about the ("un-official") GnuCash app that allows you to record
transactions and upload them to "real" GnuCash...
.
The drum beat to get a "real" mobile application really is a screamer, and
increases each and every day.  As with others, I spend less and less time on
my laptop, more and more time on my phone, not having access to my GnuCash
account is becoming increasingly inconvenient.  As much as I "luv" GnuCash,
having to go back to my laptop to update it, is increasingly a pain.

Just venting.  And yes, I know all the usual reasons why it doesn't exist,
and why it's not likely to exist for the foreseeable future, and I totally
get that those valuable souls who have spent their time and energies on this
program, only have so much to give...  Just sayin', the drum beat makes me
want to look for a solution even though I'm totally happy with GnuCash...

I can't be the only one feeling the increasing need to get this void
filled...I really need a mobile app that represents the present, not
contingent on being manually updated to reflect it...

I now officially crawl back into my crevice...



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/GnuCash-mobile-tp4691888.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: GnuCash mobile

[Steve]

Personally, I'd be willing to pay $100+ per year for the app.  I don't expect
it to be free, I'm thrilled that for the past number of years since leaving
Quicken, that I have a program that "works".  To have that information
available to me wherever I am?  Hard to put a price on it.  Hard for me to
imagine that if one is able to translate the current program to a mobile
app, that it would not get wide adoption with whatever reasonable monthly
charge.

I'm just saying that with each passing day, having a program that is
anchored to a desktop or laptop computer, makes increasingly less sense. 
Perhaps progress is being made behind the scenes, I sure hope so.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/GnuCash-mobile-tp4691888p4691891.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Scheduled Transaction Help :(

[Steve]

I'm running Windows 10, GnuCash Version 2.6.17.

After using GnuCash for a number of years, I finally am getting around to
using the Scheduled Transaction feature.  Previously I would simply add the
upcoming anticipated transactions to the account registry, and then when the
date in question hit for payment, I would manually add another transaction
for the same item for the next due date.  At least I could have a snapshot
of upcoming transactions.

Anyway, so I went and added all of my scheduled transactions with no issue,
I did this around July 27th or so, some were to hit on the 1st or 2nd. 
After making my initial entries, I used the "since last run", and it worked
perfect, eg all of the scheduled entries I made, appeared in the various
accounts for the next payment date.  So all is good.

So 8/1 comes and goes, 8/2 comes and go.  Although I have the settings on
each transaction to create automatically AND to create in advance (31 days),
I of course expected to see new transactions to appear on 9/1 and 9/2 in the
relevant accounts.  But no transactions appear.  When I exit and re-start
GnuCash, they still don't appear, when I click "since last run" they also
don't appear.  When I bring up the relevant transactions in Scheduled
Transactions I do note it says "Last occurrence: 9-1-2017", but there's no
new entry for 9/1.

Below is a screenshot of one of the transactions in Scheduled Transactions. 
Can anyone give me a clue as to what I'm obviously doing wrong?  Thanks!  :)

 



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-Transaction-Help-tp4693019.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled Transaction Help :(

[Steve]

I double checked the settings, and mine look correct.

As I indicated, although the scheduled transaction SAYS in my screenshot the
last occurrence was on 9/1/17, in fact no transaction for it was created on
9/1/17. I did try changing the time to 60 days as you suggested, and ran it,
and a transaction was indeed created for 10/1 (but none for 9/1, as I assume
it thinks it already did that).

So I guess my next question is, is it possible to "reset" the dates that
gnucash is keeping track of, for scheduled transactions.  Or do I need to
DELETE my scheduled transaction and re-enter it to get a clean slate?  That
really has nothing to do with solving my problem, but it would help in
testing to try and figure out what is going on.

My other transactions on 8/1 also are showing that the last created
occurrences was on 9/1, but again, NO transactions were in fact created.  So
clearly this isn't just related to an isolated transaction of mine, it's
impacting all of my scheduled transactions.

I'll fool with it a bit more; worst case I'll just go back to manually doing
it.  Figured I'd throw it out there in case someone noticed I was doing
something wrong...



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-Transaction-Help-tp4693019p4693021.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled Transaction Help :(

[Steve]

Sure...

 



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-Transaction-Help-tp4693019p4693030.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled Transaction Help :(

[Steve]

Figured I'd put an end to this thread.  Bottom line, I eventually got it to
work, although I can't offer much of an explanation as to why.  I DELETED
all of the scheduled entries I made, and started over.  Used the same
entries.  It's working now.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-Transaction-Help-tp4693019p4693127.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Announcement: GnuCash 2.6.18 Release 2017-09-24

[Steve]

Ok, it's late and I'm probably not awake enuf to see, but, uh, what happen to
the option to go online and download transactions or the balance?  Isn't
that option missing or has the long day caught up with me?  I just
downloaded and installed the new update with no problem.

Thinking I should wait to post this in the morning as I'll likely have pie
on my face, but seriously, I'm not seeing it!





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Announcement: GnuCash 2.6.18 Release 2017-09-24

[Steve]

Ok, after waking up this morning, I still find the usual option to go online
and download transactions or the balance, absent.  If I'm wrong, would some
kind person point me to where the heck it is (and I will then crawl back
into my embarrassed cave). 

Was it "left on the kitchen table" during construction of the update, or do
I need to see an ophthalmogist first thing this am?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Announcement: GnuCash 2.6.18 Release 2017-09-24

[Steve]

Thank you, my sanity and eyesight apparently are intact.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Announcement: GnuCash 2.6.18 Release 2017-09-24

[Steve]

Thanks for the revised download for Windows. I downloaded and tried it, all
is good.

My sanity thanks you.

My eyesight thanks you.

I thank you.  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Scheduled transactions

[Steve]

I feel like I've "paid my dues" with the scheduled transaction feature;
finally got it to work the way I want it, but it definitely contributed to
my hair loss in the process of doing so, but at last, I'm there...

I have monthly payments calendared 60 days in advance (so there are always 2
monthly pmts that appear in the register, for next month and the following
month).  If I want to pay the current one earlier than on the date on which
its scheduled and appears (which I often do), I just change the date of the
transaction as it appears in the register, I stay "the hell away" from the
scheduled transaction editor.

Simple, straightforward, uncomplicated.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: budget with ytd difference option and ?improved? readability

[Steve]

Color me clueless, well, almost... 

Using Windows 10, latest release of GnuCash. 

So the two scm files, I installed them in the standard-reports sub-directory
as indicated in the above posts. I got them there, by opening up each one,
copying the contents, then pasting the contents to a new file I created with
Notepad, and saving it with the original name with the scm extension, eg 

budget-plus.scm 
stylesheet-budget-plus.scm 

In the .gnucash directory, I created a config.user file using Notepad, then
copied the 2 lines calling the scm files into that file. 

But then when I try and start up GnuCash, it won't start, eg program won't
run.  When I remove the above files from the referenced directories, it runs
fine.  So obviously I'm doing something wrong (not the first time). 

Hints... ? Be gentle... :)



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: budget with ytd difference option and ?improved? readability

[Steve]

Color me clueless, well, almost...

Using Windows 10, latest release of GnuCash.

So the two scm files, I installed them in the standard-reports sub-directory
as indicated in the above posts. I got them there, by opening up each one,
copying the contents, then pasting the contents to a new file I created with
Notepad, and saving it with the original name with the scm extension, eg

budget-plus.scm
stylesheet-budget-plus.scm

In the .gnucash directory, I created a config.user file using Notepad, then
copied the 2 lines calling the scm files into that file.

But then when I try and start up GnuCash, it won't start, eg program won't
run.  When I remove the above files from the referenced directories, it runs
fine.  So obviously I'm doing something wrong (not the first time).

Hints... ? Be gentle... :)



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: budget with ytd difference option and ?improved? readability

[Steve]

Fred Bone wrote
> Perhaps it's objecting to the MS-DOS-style line endings, that Notepad 
> will have helpfully put there for you?
> 
> If you put a file there with one line containing just a semicolon and it 
> still won't run, then that's the problem.

Thanks, Fred. The file that's causing the problem is the
"stylesheet-budget-plus.scm" file. When it's in the target directory,
GnuCash will not run; when I remove it, it will. I've played with removing
the ";;" lines in that file, with no success. Have tried re-creating the
file a couple of times, to make sure I didn't make an error in the copy,
etc. But appreciate the help.




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Finance-Quote 1.42 released!

[Steve]

Michael Fross wrote
> If anyone is having issues getting it working on Windows with
> Activatestate
> Perl, I'd be happy to post about it, but it was really just installing F:Q
> 1.42 and then  changing all of my securities to update via Alphavantage. 
*
>  I
> also had to add the API key to an environment variable.
*
> 

So for someone running *Windows 10*, could you expand on "*I also had to add
the API key to an environment variable.*"




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Finance-Quote 1.42 released!

[Steve]

Thank you. After reviewing those threads you referenced, think I'll do
nothing for the moment, will wait for the dust to settle... appreciate your
reply, however. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Finance-Quote 1.47 released!

[Steve]

Alan... no ever accused GnuCash of being user friendly. Unfortunate.

The environment file you opened may look like simply a bunch of
instructions, but if you look closely, it's actually a combination of
comments and the commands themselves.  The comments explain each line that
follows, etc.  You don't need to concern yourself with those.

Simply go to the END of the file and on a new line, paste the necessary line
from the instructions, containing your Alphaadvantage code.  Then simply
save the file (I ended up having to change the permissions on the file to be
able to save it, btw) under the same name.

That's it.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Saved Report Configurations (Color on Tabs)

[Steve]

Is there any way to add color to tabs for Saved Report Configurations?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Password screw-up "magic fix"?

[Steve]

I've used GnuCash for a long time, have the current stable version, Windows
10.

Question:  Since Adam & Eve first danced, whenever I *accidently* hit
"remember PIN" (something I would never do intentionally, but seem to do
from time to time) when downloading transactions on a particular account,
I'm always screwed.  "Screwed" meaning, after that it will never
successfully download transactions for that account.  I've posted about this
from time to time over the years (when I had more hair), and I've never
gotten a satisfactory explanation and honestly, at this point, I really
don't care.  However... when that does happen, there is no way to reverse
that designation (it seems to have no connection with the option in
"preferences" to remember the pin, eg if you accidently hit "remember pin",
and then go to look at the setting in preferences, the "remember pin" option
is not checked).  So what I end up doing is going to online banking setup,
REMOVING the setup for that account, and then redoing it...

I know, I know, you want to know what my question is...

I keep a careful backup of my files, including the supplementary files.  Can
someone specifically tell me, if I want to RESTORE an older online setup,
what folders and files do I need to restore, to just address the online
banking config setups???

Obviously (?) like an idiot I managed to hit that "remember pin" box earlier
today when dreaming about turkey, and had to go in and delete and re-create
my account settings.  Thus what prompted this question on turkey day.

Thanks...



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Password screw-up "magic fix"?

[Steve]

and merely restoring the file folder "aqbanking" does NOT do it, btw



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Password screw-up "magic fix"?

[Steve]

Thanks, John, but guess you didn't have a chance to read my entire post.  I
can't uncheck the box for "remember the pin in memory" when it is *NOT*
checked to begin with!

Bottom line, tell me what folders and/or files I need to backup (and restore
as needed) that reflect my settings for aqbanking (and it's clearly not
merely the aqbanking folder).



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Password screw-up "magic fix"?

[Steve]

Ok, thanks for taking a look. Unfortunately, many times I've tried restoring
my backup copy of the entire aqbanking folder which includes the file you
referenced, and it "doesn't seem to do the job", so I end up having to
delete the bank account in question, and re-creating it which does take care
of the problem.

The problem is when I'm retrieving transactions for a particular account and
type in an incorrect PIN and accidently hit "remember pin", I am then
"officially" screwed, as there's no way to escape from my "decision
(without, apparently, deleting the account and re-creating it).  Doesn't
happen often, but my fingers manage to do it about once ever month or so... 

Thanks anyway.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Password screw-up "magic fix"?

[Steve]

Thanks for the suggestion. Unfortunately, no, restarting GnuCash does not
rectify the issue for me. So far the only way I've found to "fix" it, is
deleting the account in question in aqbanking, and then adding it back. 
I've gotten pretty darn good at doing that :)  Fortunately, it's the Charles
Schwab Bank account, which is pretty easy to add.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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 Portable

[Steve]

I used it briefly a few years ago. Just noticed, unless I'm mistaken, it was
updated in October of this year (2017).

Curious to hear how others are using the portable version (eg, why and under
what circumstances), and how you're handling the backup and/or transfer of
the data files from the memory stick to your desktop, cloud, etc.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Gnucash Portable

[Steve]

AC wrote
> No, he's talking about GnuCash Portable which is a copy of GnuCash
> modified and packaged with all the necessary libraries to be able to run
> directly from a memory stick or other portable storage device without
> having to install the libraries.  It's packaged by PortableApps.com.

*AC is correct. I'm referring to GnuCash Portable, NOT the android app.*




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Schwab shows no tranactions

[Steve]

I've only used Gnucash and aqbanking module for Schwab Bank downloads which
has always worked great.

For some reason I've long since forgotten, I thought it didn't work with the
brokerage side.  Guess I'm wrong?  I did start to fool with it, but is
https://ofx.schwab.com/cgi_dev/ofx_server correct?  Thought I read in the
documentation somewhere that someone said that was a phishing link???



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Schwab shows no tranactions

[Steve]

Steve wrote
> I've only used Gnucash and aqbanking module for Schwab Bank downloads
> which
> has always worked great.
> 
> For some reason I've long since forgotten, I thought it didn't work with
> the
> brokerage side.  Guess I'm wrong?  I did start to fool with it, but is
> https://ofx.schwab.com/cgi_dev/ofx_server correct?  Thought I read in the
> documentation somewhere that someone said that was a phishing link???

I misread the documentation; it's another link, one character off, that
someone identified as a phishing link. Nevertheless, I have been
unsuccessful in getting Schwab brokerage transactions to download; I did
note one person's comment that he changed the FID to  from 5104 but
makes no difference, eg no transactions download.

Can anyone conclusively say they have downloads of Schwab brokerage (not
bank) working? If the consensus is that it's not available, will not invest
further time fooling with it... thanks 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

Strange cookie appears when accessing this site...

[Steve]

I've been meaning to ask this for well over a year (if not longer), keep
forgetting about it; I did a search just now, but didn't get any hits...

Every single time I start the GnuCash User forum site (using Windows 10 Pro,
btw, Google Chrome), and this *only occurs* when I access the GnuCash User
forum site, I've noticed that a new *cookie* appears (if I delete it, it
reappears the next time I access the GnuCash User forum site)...

*http://www.super-resume.com/*

Any explanation??

 




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

[GNC] Quotes setup

[Steve]

I decided that it was time to update my quotes post-Yahoo.

I found this: https://wiki.gnucash.org/wiki/Online_Quotes which seems
to be up-to-date.

My system is a Debian based distro so I already have Perl installed and
F::Q. gnc-fq-check show that I have v1.47 installed.

gnc-fq-update is not installed on my system so I when to get it from
github but the link in the Wiki
(https://raw.githubusercontent.com/Gnucash/gnucash/master/src/quotes/gnc-fq-update.in)
gives me a 404 error.

Next a tried the external update method
$ gnucash --add-price-quotes ~/Documents/gnucash/us_accounts.gnucash
Found Finance::Quote version 1.47
$

but nothing happened. I guessing that means there are no quotes
enabled. Each security has the "Get online quotes" checkbox checked but
the radio button is still set to Yahoo.

Is there any more detailed and current documentation that would help me?

Thanks,
Steve
___
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.

[GNC] Frequent imports always requiring intervention

[Steve Freeman]

When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. 

Is there some way to teach GnuCash to accept these?

Thank you for any help.

Steve 

-
Steven F. Freeman *  http://sffreeman.com
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com&c=E,1,QzXD
SswwaM6wgd_K3ufbl_p4CzgW5tok_SF9gyv43RXjI187brQr55aVaxuOq77r5sAQbnXln_Iy0nw6
R3MH5T79wQeOovtPvBGnB6wg&typo=1>  * Google/ Gab/ Mewe/ Facebook/ Linked-In/
Twitter/ Skype: sffreeman * Best email: s...@alum.mit.edu
<mailto:s...@alum.mit.edu>  * +1 (215) 802 4680 * Hub: ARMs for the Rest of
Us: A Systems Approach to Applied Research Methods
http://sffreeman.com/ARMs/
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com%2fblog%2f&;
c=E,1,xTKv_9nFPSu-Shnbuwgq7rSxhHIfbj3rUkLyot4MA5TnWCx12pfx6VzS9ZUf9TBpsDeXNM
UvdyHe_rq2Vhw18qdzVFcK5wwTOL4V_H7H6L1rrmoNk-XApDD9PmOm&typo=1> 
 
Recent Articles: Knowledge + Leadership
<https://medium.com/knowledge-leadership>  (Rigorous, relevant research and
concise insight on leadership)
*   Psychological Containment: A Critical Leadership Success Factor
<https://medium.com/knowledge-leadership/psychological-containment-284b3a7f0
875>   (with Marc Maltz)
*   The Astonishing Power of Shared Opportunity and Moral Purpose:
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
->  The Secret to Sandler O'Neill's Resurrection from the Ashes of 9/11
Devastation
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
-> 
*   A Crisis is a Terrible Thing to Waste: Recovering Agency in
Coronavirus Times
<https://medium.com/@sffreeman/a-crisis-is-a-terrible-thing-to-waste-recover
ing-agency-in-coronavirus-times-86e87472a96e>  
Election Integrity <https://medium.com/election-integrity>  (Paper Ballots /
Process Transparency / Election Day Voting / Democracy-Building / Education)

*   How to Restore Trust and Peace in America
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> : Why Election Transparency is critically important
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> 
*   Elections We Can All Believe In
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> : The
*Other* Reason America Needs Election Integrity
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> 
*   America Needs Elections We Can All Believe In
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
--->  An impartial perspective on US elections
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
---> 


 
___
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] frequent imports always requiring intervention

[Steve Freeman]

When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. is there some way to teach GnuCash to accept
these?

Thank you for any help.

Steve 

-
Steven F. Freeman *  http://sffreeman.com
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com&c=E,1,QzXD
SswwaM6wgd_K3ufbl_p4CzgW5tok_SF9gyv43RXjI187brQr55aVaxuOq77r5sAQbnXln_Iy0nw6
R3MH5T79wQeOovtPvBGnB6wg&typo=1>  * Google/ Gab/ Mewe/ Facebook/ Linked-In/
Twitter/ Skype: sffreeman * Best email: s...@alum.mit.edu
<mailto:s...@alum.mit.edu>  * +1 (215) 802 4680 * Hub: ARMs for the Rest of
Us: A Systems Approach to Applied Research Methods
http://sffreeman.com/ARMs/
<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fsffreeman.com%2fblog%2f&;
c=E,1,xTKv_9nFPSu-Shnbuwgq7rSxhHIfbj3rUkLyot4MA5TnWCx12pfx6VzS9ZUf9TBpsDeXNM
UvdyHe_rq2Vhw18qdzVFcK5wwTOL4V_H7H6L1rrmoNk-XApDD9PmOm&typo=1> 
 
Recent Articles: Knowledge + Leadership
<https://medium.com/knowledge-leadership>  (Rigorous, relevant research and
concise insight on leadership)
*   Psychological Containment: A Critical Leadership Success Factor
<https://medium.com/knowledge-leadership/psychological-containment-284b3a7f0
875>   (with Marc Maltz)
*   The Astonishing Power of Shared Opportunity and Moral Purpose:
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
->  The Secret to Sandler O'Neill's Resurrection from the Ashes of 9/11
Devastation
<https://medium.com/@sffreeman/the-astonishing-power-of-shared-opportunity-a
nd-moral-purpose-aa9d8315e946?source=your_stories_page--
-> 
*   A Crisis is a Terrible Thing to Waste: Recovering Agency in
Coronavirus Times
<https://medium.com/@sffreeman/a-crisis-is-a-terrible-thing-to-waste-recover
ing-agency-in-coronavirus-times-86e87472a96e>  
Election Integrity <https://medium.com/election-integrity>  (Paper Ballots /
Process Transparency / Election Day Voting / Democracy-Building / Education)

*   How to Restore Trust and Peace in America
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> : Why Election Transparency is critically important
<https://medium.com/election-integrity/how-to-restore-trust-and-peace-in-ame
rica-180bd8e3c5f8?source=your_stories_page--
---> 
*   Elections We Can All Believe In
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> : The
*Other* Reason America Needs Election Integrity
<https://medium.com/election-integrity/elections-we-can-all-believe-in-a2546
02fc8f7?source=your_stories_page-> 
*   America Needs Elections We Can All Believe In
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
--->  An impartial perspective on US elections
<https://medium.com/election-integrity/america-needs-elections-we-can-all-be
lieve-in-159f3fc37089?source=your_stories_page--
---> 


 
___
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] Sorry, first post: frequent imports always requiring intervention

[Steve Freeman]

Sorry, it was my first post in the listserv. I didn't know how exactly how
it worked. Will not use default signature again and will use a fresh email
to start a new thread.

-original 
When I import transactions (using csv) about 10% do not import, i.e. show up
in red as requiring intervention. Some of these are repeated transactions,
e.g. Apple.Com/Bill $5.32. 

Is there some way to teach GnuCash to accept these?

Thank you for any help.

Steve 


___
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] I need basic help

[Steve Butler]

On Wed, Oct 18, 2023, 23:04 Edwin Booth  wrote:

> Steve,
>
> Thanks for getting back to me!
>
> It seems that I need to first delete my newly downloaded file from GnuCash
> and re-import it but first assign all the
>

Yes, remove those transitions or restore to a pre-import backup.

transactions to various accounts. I have

This is done during the import process just after you open the file.  You
should see a list of the transactions that will be loaded.  Pick each one
and be sure it has the correct destination account.  That's how the import
process is taught.

 gone through the process (I think) of creating a hierarchy of accounts
(though I will surely want to add more expense accounts later).

>
> Okay, I have deleted the AMEX credit card OFX account that I imported into
> GnuCash and have gone back to my Mac Downloads file. How do I now assign
> all those transactions to their proper accounts without first importing
> this OFX file into GnuCash? Doesn’t it have to be in GnuCash before it can
> even know what accounts are available?
>
> It’s late now, so I’ll wait for an answer to this first question before
> going on.
>
> But for some reason I saw this email in my Yahoo mail app rather than
> in my Gmail app. Please respond to this by sending out my Gmail account.
> elybee...@gnail.com.
>
> Thanks,
>
> Edwin
>
>
> Sent from Yahoo Mail for iPhone
>
> On Wednesday, October 18, 2023, 2:05 PM, Stephen M. Butler 
> wrote:
>
> Edwin,
>
> I routinely download my CC transactions using OFX.  I think you missed a
> very important step.
>
> It sounds like you did tie this OFX file to your CC Liability Account.
> That will be remembered for all future imports from this CC.
>
> It also sounds like you may not have set up all the various expense
> accounts (Groceries, Fuel, Hardware, etc).  Those need to be setup as
> accounts under the Expense top-level account.
>
> Then, during the import process, after you pick the file but before
> doing the actual import step you will see a list of all the
> transactions.  During this first import none of them will show the
> corresponding expense account.  You will need to click on each line and
> indicate to which account that expense should be assigned.  In some
> cases you will have a payment so up.  For the first time you will need
> to assign this to your Asset/Checking account.
>
> This process of assigning accounts to each transaction will teach the
> import process how to automatically assign them in the future. As the
> importer learns each transaction (based on the description), it will
> begin to automatically assign the proper accounts. Occasionally you may
> need to correct the account assignment or it may see a new description
> and not know leaving it assigned to the Invalid Account.  This is your
> clue to click on that line (perhaps double click) and make the
> appropriate assignment.
>
> Hopefully this helps you on future imports.
>
> --Steve
>
> Stephen M Butler
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> On 10/18/23 11:09, Edwin Booth wrote:
> > Hi. New to this. I just downloaded an OFX file for a credit card I have.
> I
> > imported it into my “Unsaved Book.” That worked. It is now on the
> Accounts
> > Page with an amount under the “Total” column. But there is also a line
> that
> > says “Imbalance-USD” with the same same amount under Total. I understand
> (I
> > think) that that Imbalance is due to the fact that I have no other
> account
> > in there and so there is nothing to balance my CC account with.
> >
> > So, I obviously need to enter some new accounts. I haven’t paid off all
> of
> > that CC account, but I have paid some of it. The unpaid portion would be
> > under “Liability” I assume, and the paid part under “Expense.”
> >
> > Not sure what to do next. I’m running GnuCash on a MacBook Pro, which I’m
> > also pretty new at.
> >
> > Thanks,
> >
> > Edwin
> > ___
> > 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/

Re: [GNC] Transaction not showing as reconciled when it should be.

[Steve Butler]

I suspect you have a transaction for the  £107.29 that has already been
reconciled when it shouldn't have been.  Probably for a different date.  Go
get a transaction report for this account and sort by reconcile date.  Look
at transactions reconciled after the last good reconciliation date.

I once found a dupe that was entered for a year prior to the other.  Now as
I reconcile I check the transaction date to be sure I'm not reconciling
something with a very old date unless it was a true error that I went back
and fixed.

On Mon, Nov 20, 2023, 12:41 David Kirkby 
wrote:

> On Mon, 20 Nov 2023 at 19:57, David Carlson 
> wrote:
>
> > That image does not appear to be from the reconciliation tool.  If it is
> > from the reconciliation report, it probably cannot actually reconcile a
> > transaction, but I have never used that report and I dont know how it
> works.
> >
>
> That's correct, but here's a view from the reconciliation tool. I picked a
> date that had just one extra transaction compared to the previous
> reconciled amount. So selecting the £98 deposit the account will reconcile.
> But to get to that point, the must have already been reconciled,
> but I'm still shown the option to select it.
> [image: image.png]
>
>
>
> >
> >
> >
> > On Mon, Nov 20, 2023, 1:28 PM David Kirkby <
> drkir...@kirkbymicrowave.co.uk>
> > wrote:
> >
> >> I've reconciled my accounts. To do that I would have needed to include a
> >> particular transaction of £107.29 to Digikey, but not the one of £176.20
> >> to
> >> Digikey on the same day. However, the £107.29 is not marked as
> reconciled.
> >> If I try to reconcile to any later date, I'm always presented with the
> >> option to reconcile that transaction. But the accounts will not
> reconcile
> >> unless I ignore that one.
> >>
> >> It seems the "n" in the reconciliation status needs to be changed to a
> >> "y",
> >> but why this is happening I don't have a clue.
> >>
> >>
> >> [image: image.png]
> >>
> >>
> >> --
> >> Dr David Kirkby Ph.D
> >> Kirkby Microwave Ltd
> >> Email: drkir...@kirkbymicrowave.co.uk
> >> Web: https://www.kirkbymicrowave.co.uk/
> >> Telephone 07910 441670 (UK) or +44 7910 441670 (international)
> >> Registered in England and Wales, company number 08914892.
> >> Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Essex, CM3
> 6DT
> >> ___
> >> 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.

[GNC] gnu-cash users to meet in person?

[Steve Freeman]

Do any gnu-cash user groups meet in person? I'd like to meet and perhaps
occasionally work with other gnu-cash users. 

If no groups exist, but any of you might care to meet with another user,
please direct reply. 

I live in central Connecticut and would be happy to host a group. 

I travel occasionally to New York (especially Westchester), New Jersey,
Philadelphia, Vermont and Boston and would be happy to meet with any users
in any of these areas.

Thanks, Steve 

___
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] Feature request: Import assistant, room for big improvements

[Steve Butler]

I do it every OFX import.  Works well.  Ubuntu 23.10.  GnC 5.4-117.

Need anything else?  BTW, works fine, the right click.


On Mon, Jan 15, 2024, 21:12 Christopher Lam 
wrote:

> Has anyone tried right click the relevant transaction(s) in the ofx or csv
> import assistant?
>
> On Tue, 16 Jan 2024, 12:49 pm David Carlson, 
> wrote:
>
> > Which import assistant is being discussed here?  The Generic assistant
> > behind the OFX and QIF imports is quite limited in placing new
> transactions
> > into the desired account or in matching incoming transactions to correct
> > pre-existing transactions, but the new CSV transaction importer is
> better,
> > if harder to configure optimally.  Also, I think they all have changed in
> > recent GnuCash releases, so tell us which release you are currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless it is
> > completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> > wrote:
> >
> > > 👍
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > >> On January 15, 2024 23:06:07 Phyllis Bruce 
> > wrote:
> > > >>
> > > >> Thanks, David.  I think I am being unclear.  My research provides
> what
> > > you
> > > >> call the transfer account for unmatched items.  That's all good.  It
> > is
> > > the
> > > >> memo field which I use to remind me of what I did that is not
> > available
> > > in
> > > >> the reconciliation screen.  For instance I want to remember that I
> > paid
> > > >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > > groceries
> > > >> at Christmas*.  Would you call that the "action"?
> > > >>
> > > >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> > davidcousen...@gmail.com
> > > >
> > > >> wrote:
> > > >>
> > > >>> Ulrich,
> > > >>>
> > > >>> There is nothing to stop you supplying the transfer account
> > > information in
> > > >>> an
> > > >>> import record if it is available. There is a header which can be
> > > assigned
> > > >>> to the
> > > >>> appropriate column of your input file for the transfer account.
> > > >>>
> > > >>> The first time you import with a given account name in he record
> you
> > > will
> > > >>> be
> > > >>> asked to specify the internal GnuCash account to which it
> > corresponds.
> > > >>> After
> > > >>> that it will be matched to that account.
> > > >>>
> > > >>> The Bayesian process only assigns a probable account in cases where
> > the
> > > >>> import
> > > >>> record does not specify the  transfer account.
> > > >>>
> > > >>> David Cousens
> > > >>>
> > >  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > >  Hello fellow GnuCash users,
> > > 
> > >  I wonder if there are plans on improving the import filter, for
> > > importing
> > >  bank transfers.
> > >  The situation now is, that some hidden engine tries to learn from
> > > doing.
> > >  But the truth is, that even after one year of importing bank
> > > transfers, I
> > >  have to check every single transaction, since errors keep
> occurring.
> > > If I
> > >  miss an error, this transaction is put in the wrong ledger
> account.
> > > 
> > >  E-boekhouden.nl uses an import assistant where you can specify a
> > > ledger
> > >  account number, other keywords and/or amounts of money. The import
> > >  assistant puts the transactions into the right ledger account,
> with
> > > far
> > >  less errors than with GnuCash. In fact, only where a specific
> > keyword,
> > >  leger number or amount is missing, or where no import rule is made
> > > for a
> > >  specific payment, the transaction has to be placed into the right
> > > general
> > >  ledger by hand.
> > > 
> > >  Have a nice day!
> > > 
> > >  --
> > >  नमस्ते (Namasté),
> > >  Ulrich
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > > 
> > >  " Can't talk to you without talking to me; we're guilty of the
> same
> > > old
> > >  thing.
> > >    Thinking a lot about less and less, and forgetting the Love we
> > >  bring "
> > > [Grateful Dead, in: 'Althea']
> > > 
> > > 
> > > >>>
> > >
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> > >  ¤º°`°º¤ø
> > >   Mijn blog: ✡ theskepticaltheist.eu ✡
> > >  ___
> > >  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.
> > >  Y

Re: [GNC] Automatic account match doesn't work when import transactions

[Steve Butler]

Which import?  CSV?

On Sun, Feb 4, 2024, 13:04 Jediator  wrote:

> I couldn't get the automatic account match to work when importing
> bank/credit card transactions to GC.  Is there anyway to manually create
> the matching rules?  Thanks!  -- JC
> ___
> 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] GnuCash with Interactive Brokers

[Steve Butler]

That is true for the first time.  After that it will learn the matches you
make and only ask for new ones.

On Tue, Feb 6, 2024, 16:35 km22 via gnucash-user 
wrote:

> Thanks.
>
>
> Upon importing the OFX I am prompted to match the different bonds in the
> statement with the relevant asset in GnuCash:
>
> This is quite a manual process having to match these manually
> one-by-one.  Do you know whether there is a way for me to define the
> assets in GnuCash so this mapping is more automated? (Or at least where
> GnuCash is able to select the best match for me to review?)
>
>
> Since it reads "Please note that the exchange code of the commodity you
> select will be overwritten" does this mean that if I set the ISIN/CUSIP
> correctly in GnuCash the mapping would be more seamless?
>
>
>
>
>
>
> On 2024-02-05 22:17, Kalpesh Patel wrote:
> >
> > Ken, as Gyle mentioned, they are sibling to each other. In terms of
> > technical specs, QFX is modified OFX format which contains additional
> > Intuit’s non-XML header but GNC treats them both equal as it simply
> > ignores that header. From the transaction wise they both will contain
> > identical data.
> >
> > *From:*Gyle McCollam 
> > *Sent:* Monday, February 05, 2024 8:59 AM
> > *To:* Kalpesh Patel ; km22 
> > *Cc:* gnucash-user@gnucash.org
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > It doesn't "prefer" either, in fact the import is OFX/QFX.
> >
> > Thank You,
> >
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > gmccol...@live.com email
> >
> > 
> >
> > *From:*gnucash-user
> >  on behalf of km22
> > via gnucash-user 
> > *Sent:* Monday, February 5, 2024 4:54 AM
> > *To:* Kalpesh Patel 
> > *Cc:* gnucash-user@gnucash.org 
> > *Subject:* Re: [GNC] GnuCash with Interactive Brokers
> >
> > Hi Kalpesh,
> >
> > Thanks for your reply. IBKR offers these "Third-party Downloads":
> >
> > 1. Quicken Web Connect -> which generate a QFX file
> >
> > 2. GainsKeeper
> >
> > 3. TradeLog
> >
> > 4. MS Money -> which generates a OFX file
> >
> >
> > Do you know whether GnuCash prefers OFX or QFX?
> >
> > I have downloaded both and will experiment with them.
> >
> > Thanks,
> >
> > Ken
> >
> >
> >
> > On 2024-02-05 10:27, Kalpesh Patel wrote:
> > > While I am NOT with Interactive Broker, your best bet is to see if
> > you can download transactions in OFX (Open Financial Exchange) or QFX
> > (Quicken Financial Exchange) format. That would be the best format and
> > I believe most broker-dealers support that format as a download method
> > from their web portal.
> > >
> > > -Original Message-
> > > From: km22
> > > Sent: Sunday, February 04, 2024 4:57 AM
> > > To:gnucash-user@gnucash.org
> > > Subject: [GNC] GnuCash with Interactive Brokers
> > >
> > > Hi Gnucash Users,
> > >
> > > Does anyone on this mailing list have a method for importing
> > transactions from Interactive Brokers (IBKR) to GnuCash? (Especially
> > multi-currency users.)
> > >
> > > I currently enter all transactions manually but would like to
> > explore ways of importing transactions.
> > >
> > > Please share your approach if so.
> > >
> > > Thanks,
> > >
> > > Ken
> > >
> > >
> > >
> > >
> > ___
> > 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] Can't open old GnuCash file

[Steve Butler]

Can you install version 4.x on your box and try again.  Maybe even a 3.x.

On Thu, Feb 15, 2024, 17:01 MegaBrutal  wrote:

> Hello,
>
> I've been using GnuCash between 2015 to 2017 to help to straighten out
> my personal finances. Due to changes in my life, my transaction count
> increased significantly which required more and more time to enter,
> while I got less free time to do the accounting. Meanwhile, my
> financial problems basically got resolved and my motivation to keep on
> updating my GnuCash file dropped significantly.
>
> Now I got a situation that I'm looking for certain transactions from
> around that time and I remembered that I should check my old GnuCash
> file, untouched since 2017-09-21. To my shock, the modern GnuCash
> version that comes with my distro (Ubuntu 23.10) crashes when I try to
> open my old file. Here is my GnuCash version and the backtrace I get:
>
> ---
>
> GnuCash 5.3
> Build ID: 5.3+(2023-06-26)
>
> Backtrace:
> In ice-9/boot-9.scm:
>   1752:10  5 (with-exception-handler _ _ #:unwind? _ #:unwind-for-type _)
> In unknown file:
>4 (apply-smob/0 #)
> In ice-9/boot-9.scm:
>2836:4  3 (save-module-excursion # ice-9/eval-string.scm:66:9 ()>)
> In ice-9/eval-string.scm:
>  38:6  2 (read-and-eval # #:lang _)
> In ice-9/eval.scm:
> 619:8  1 (_ #(#
> # *
> 563d43f24190>))
> In unknown file:
>0 (GncOption-set-value # (absolute
> 1496181600 . 0))
>
> ERROR: In procedure GncOption-set-value:
> Wrong type (expecting exact integer): (1496181600 . 0)
>
> Some deprecated features have been used.  Set the environment
> variable GUILE_WARN_DEPRECATED to "detailed" and rerun the
> program to get more information.  Set it to "no" to suppress
> this message.
>
> ---
>
> Maybe I was wrong that I expected some backward compatibility that
> modern versions are capable of performing incremental updates to old
> files to update it to the current file format... What to do now? Any
> suggestions?
>
>
> Best regards,
> MegaBrutal
> ___
> 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] What account name do you use to record the apartment/house expenses related to the building?

[Steve Butler]

On Tue, Apr 16, 2024, 10:49 john  wrote:

>
>
> > On Apr 14, 2024, at 17:45, Oleander via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Hello,
> > is "Housing" a proper account name if I want to include only my
> apartment expenses like Rent/Mortgage and Repairs&Maintenance? I'd like to
> record my Utilities expenses separately within another account so that my
> "Housing" account adds up only the expenses related to the building.
> >
> > If not, what would you use?
>
> Rent is an expense but if you're renting then maintenance should generally
> be the landlord's responsibility.



If you are the owner and renting out the property, then rent is income.


A mortgage means you own the place and the payment gets split up into one
> or more expenses (at least interest; maybe insurance, fees, and others
> depending on the terms of the loan) and principal payment that reduces the
> loan amount. Property owners also need to distinguish between maintenance
> and improvements: The latter increase the value of the property, the former
> are an expense.
>
> Regards,
> John Ralls
>
> ___
> 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] Merge amounts in report

[Steve Butler]

The only way I know is to select both (all such) in a transaction report.
Then produce the grand total.

You would have to setup the options to get the specifics how you want them.

On Fri, Apr 19, 2024, 20:00 Bruno Sampaio Alves 
wrote:

> I have some expenses accounts that hold the same name (for example, "eating
> out") but one is related to my personal expenses and the other either is
> related to the mutual expenses I have with my fianceé or to a trip expense,
> for example.
> I would like to know if there is a way that when I'm looking at an expense
> report, for example, I could see the total amount of these accounts sumed
> up rather than the each amount separately.
>
> I'd appreciate thoughts on the topic.
>
> Bruno Alves
> ___
> 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] Problem with Online Quotes/Price Database

[Steve Barru]

I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep track of
personal finances. I am retired and my income consists of Social Security
and distributions from investments in funds and occasionally, stocks. I
live outside of the US and am tracking dual-currencies with GnuCash. When I
started running GnuCash in Jan 2023, I set up the Online Price Retrieval
module for equities and forex quotations. I have been using the Price
Database tool to fetch quotes on a more or less monthly basis and this has
worked seamlessly until May 2024 when I got an error message telling me
there was a problem with the database or something to that effect. Beyond
periodic Windows updates, no changes to my system that I know of.

Since then I have uninstalled and then reinstalled the Strawberry Perl app
that runs the online quote service; the version installed is 5.32.1001.
After the installation, I ran the Price Database tool and the Get Quotes
button on the right of the screen was grayed out. I got a new Alpha Vantage
API key hoping that might solve the problem. It did not; the Get Quotes
button is still grayed out.

Looking for suggestions how to troubleshoot this, hopefully that are not
exceptionally technical. Thanks for any help with this.

Best,
Steve

-- 
steve barru photographs <http://stevebarru.com>
Mobile: +84 393 022 059
Hoi An, Vietnam
___
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] Problem with Online Quotes/Price Database

[Steve Barru]

Mission accomplished! Thanks for all of the advice/help.

I have a clean install of v5.6 with my financial data imported and a new
install of Strawberry Perl. A new installation of Finance::Quote has
cleared up whatever corrupted the price database and the online quote
fetching process. Everything seems to work now. Thanks again for the
assistance.

Best,
Steve

On Sat, Jun 15, 2024 at 9:06 AM Kalpesh Patel  wrote:

> There is more than one way to install it, thankfully.
>
> With the procedure I provided, it least keeps screen output intact to
> denote or capture the error when it fails...
>
> -Original Message-
> From: David H 
> Sent: Friday, June 14, 2024 9:11 PM
> To: david amaral 
> Cc: gnucash-user@gnucash.org; Kalpesh Patel ;
> sba...@gmail.com; cho...@gmail.com
> Subject: Re: [GNC] Problem with Online Quotes/Price Database
>
> I use the simple way on Windows.  Go To the Start Menu and the Gnucash
> folder under "G" within it - click on "Install Online Price Retrieval for
> Gnucash", let it do it's thing.  I use this whenever a new Finance Quote
> module has been installed and it works every time, also installs Strawberry
> Perl if required.
>
> Cheers David H.
>
> On Sat, 15 Jun 2024 at 04:11, david amaral via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> >  dont know why this happened but.shoud be cd Program Files
> > (x86)\gnucash\bin perl gnc-fq-check (should get some info) if not
> > install/reinstall finance quote cpanm Finance::Quote perl
> > gnc-fq-update close all apps and reboot should fix your problem
> >
> >
> >
> > On Friday, June 14, 2024 at 11:05:26 AM MST, david amaral via
> gnucash-user  wrote:
> >
> >   Had same problem and this resolved it open CMD windowcd Program
> > Files (x86)\gnucash\binperl gnc-fq-check (should get some info)if not
> > install/reinstall finance quotecpanm Finance::Quote perl gnc-fq-update
> > close all apps and reboot should fix your problem
> >
> > On Friday, June 14, 2024 at 10:33:05 AM MST, Kalpesh Patel <
> kalpesh.pa...@usa.net> wrote:
> >
> >  It is very likely that when you uninstalled Strawberry Perl, it also
> > uninstalled Finance::Quote library which is needed to download quotes.
> >
> > At a Windows' CMD (Command line) console, you should be able to
> installed it.
> > Instructions are as follows:
> >
> > 1) At the command prompt execute following to bring up CPAN shell:
> > perl -MCPAN -e shell
> >
> > 2) In CPAN shell type in following command (this might trigger
> > initialization question for CPAN module since it will be seen as being
> run for first time.
> > accepting all defaults setting is fine so answer 'Y' when prompted):
> > install Finance::Quote
> >
> > Get your favorite drink and enjoy it while all dependencies are
> > downloaded and installed. If all goes well then you should see
> > following (or similar) message at completion of step 2:
> > Finance::Quote is up to date (1.62).
> >
> > Once finished, I recommend you reboot and then launch GNUCash. If
> > everything works as it suppose to, the button will be no longer greyed
> out.
> >
> > Hope that helps.
> >
> >
> > > On Jun 13, 2024, at 1:25 AM, Steve Barru  wrote:
> > >
> > > I am using GnuCash v4.12 on a 64-bit Windows 11 laptop to keep
> > > track of personal finances. I am retired and my income consists of
> > > Social Security and distributions from investments in funds and
> > > occasionally, stocks. I live outside of the US and am tracking
> > > dual-currencies with GnuCash. When I started running GnuCash in Jan
> > > 2023, I set up the Online Price Retrieval module for equities and
> > > forex quotations. I have been using the Price Database tool to fetch
> > > quotes on a more or less monthly basis and this has worked
> > > seamlessly until May 2024 when I got an error message telling me
> > > there was a problem with the database or something to that effect.
> Beyond periodic Windows updates, no changes to my system that I know of.
> > >
> > > Since then I have uninstalled and then reinstalled the Strawberry
> > > Perl app that runs the online quote service; the version installed is
> 5.32.1001.
> > > After the installation, I ran the Price Database tool and the Get
> > > Quotes button on the right of the screen was grayed out. I got a new
> > > Alpha Vantage API key hoping that might solve the problem. It did
> > > not; the Get Quotes button is still grayed out.
> > >
> 

Re: [GNC] Consolidated billing of two credit cards

[Steve Butler]

I presume the two CC accounts are in the Liabilities section.  My approach
depends on if I can download the transactions separately.  If so, I would
create a parent placeholder Liability account for that bank and move both
CC accounts under it.

At payment time write it against your checking account (asset) with the
total amount on that line of the transaction with the other side split
between the two CC liability accounts.



On Sun, Jul 7, 2024, 09:30 Mark at Lorimark 
wrote:

> (not an accountant)
>
> I think you can make your one (1) payment to the bank, and then split
> the portions of that payment for each card;
>
> account  DrCr
> Bank   $1000
>CC1 $400
>CC2 $600
>
> So you're writing out one check and paying it towards the two credit
> cards... does that resolve your issue?
>
> ~mark petryk
> ~c:469-556-5075
> ~w:http://www.lorimarksolutions.com
>
> On 7/7/24 10:54, rsbrux via gnucash-user wrote:
> > I have two credit cards from the same bank, which were previously
> > handled completely separately and are therefor represented by separate
> > accounts in GnuCash.
> >
> > Now the bank has consolidated the statements, but not completely.  There
> > is now a sinlge statement, but the charges and balance due are listed
> > and summed up separateky for each card.
> >
> > However, the total due for both cards is now applied as a single charge
> > to my bank account. Because of the separate totals on the statement, it
> > is still convenient to reconcile the two credit card accounts separately.
> >
> > However, this results in two separate charges to the GnuCash bank
> > account, which I then have to mentally add together to reconcile the
> > bank account.
> >
> > This has led me to consider merging the two credit card accounts in
> > GnuCash.  How easy is this?  Will this really make things easier, or am
> > I better off sticking with the status quo?
> >
> > Thanks in advance for any tips!
> >
> > ___
> > 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] Check & Repair

[Steve Butler]

In the past there was a progress bar in the lower right of the window.  It
was vastly sped up in the 4 series.  The last time I did a Check and
Repair, I repeated it a few times in order to catch it.  It may be so fast
now that the progress bar is meaningless.

On Sun, Jul 21, 2024, 19:57 Art Chimes  wrote:

> I don't know whether the observed behavior (no feedback to user) is a bug
> or that the Check and Repair function is supposed to operate silently. I am
> hoping someone can clarify that. If I'm supposed to be getting some kind of
> report but I didn't get feedback, then it would seem to be a bug that I
> could report. In my opinion — and I am not a coder or designer of user
> experience — if the interface leaves the user scratching their head, it
> could be improved. But I understand if that is not a high-priority item on
> what I'm sure is a very long to-do list. Thank you.
>
> -Art-
>
> On Sun, Jul 21, 2024 at 8:39 PM flywire  wrote:
>
> > Report a bug eg https://bugs.gnucash.org/show_bug.cgi?id=797711
> >
>
>
> --
> Art Chimes  |  Arlington, Virginia  |  703·407·2306  |  Google Voice
> 202·643·9638‬
> ___
> 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] Watch me mess this up. Deposited money

[Steve Butler]

When entering numbers ignore the thousand separator.  Also drop the
fraction separator and double zero when it is zero.

So, try this value:  2

On Thu, Aug 8, 2024, 09:33 James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> To all.I tried to deposit like 20.000.00. It won't take.
> ThanksJames Baxter
>
> Yahoo Mail: Search, Organize, Conquer
> ___
> 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] Move working files

[Steve Butler]

The location of saved config values, saved reports, and other such items is
O/S specific.  Those need to be moved separate from the main file(s) that
holds/hold you accounting book(s).

I don't know the wiki location that references the various O/S locations.

On Tue, Aug 13, 2024, 03:12 Mahon Finbar via gnucash-user <
gnucash-user@gnucash.org> wrote:

> If nobody minds, could I butt in?
>
> This thread is sort of about the same problem I have but I have received
> no reply to my recent post about it.
>
> Am I to assume from the messages here that there is no easy way to
> transfer working files to another location, or, as in my case, to
> another PC, following an upgrade?
>
> Sorry again, I am not unaware of computing, but my knowledge is 'old'
> and, from my experience of GNU support it would seem I am not nerdy
> enough.
>
> Finbar
>
> On 11/08/2024 11:03, sunfish62--- via gnucash-user wrote:
> > David,
> >
> > I agree. Additionally, there are many different ways to remedy the
> situation-- as noted by others in the thread (omitting log files for
> backup, for example).
> >
> > Moreover, it doesn't take a huge effort to work out your own solution.
> I, for example, took a half hour and threw together the following
> powershell script that will move all such items in the current directory
> into a folder named "backup":
> >
> > $backupfolder = "./backup/"
> > $filelist = Get-ChildItem |Where-Object {$_.basename -match
> 'gnucash.[0-9_]'}
> > move-item -path $filelist -destination $backupfolder
> >
> > This can be placed in a powershell file (e.g., "movelog.ps1") and run
> from your gnucash folder. Note that I didn't put any error checks in; it
> simply moves any file that has "gnucash.###" in its name to that backup
> location. My tests showed it worked for me. It would not be hugely
> difficult to add tests and configurations to allow broader use, but I'm not
> that interested in the issue.
> >
> > A similar approach could be taken on Linux and MacOs. The user can then
> either run this as they remember, or set it to run at a regular time.
> >
> > ⁣David T. ​
> >
> > On Aug 11, 2024, 6:29 AM, at 6:29 AM, David Cousens<
> davidcousen...@gmail.com>  wrote:
> >> Richard I would suspect the main reason that this feature request has
> >> never been implemented is that it lies at the interface of GnuCash with
> >> the Windows/Linux/MacOSX operating systems and has to work seamlessly
> >> on all of them. That requires a level of both code and multiple OS
> >> familiarity that few of us posess and those that do generally have more
> >> pressing problems to address.
> >> On Sat, 2024-08-10 at 11:45 -0500, R Losey wrote:
> >>> I haven't done a lot of customization with my GnuCash system.
> >>>
> >>> My data file - MyData.gnucash is in the same directory as what I call
> >>> the
> >>> "working" files -- the MyData.gnucash..gnucash and the
> >>> MyData.gnucash..log files.
> >>>
> >>> Is there some way that these working files can be created in a
> >>> separate
> >>> directory?
> >>>
> >>> I am backing up the GnuCash data directory, but in reality, all I
> >>> really
> >>> need to backup is my GnuCash file - all of these working files are
> >>> just
> >>> taking up space on the backup media.
> >>>
> >>> Note: I have GnuCash set to trim the files after a certain number of
> >>> days,
> >>> but the files are (naturally) not deleted from the backup material,
> >>> so it
> >>> has files back to when I started the backup.
> >>>
> >>> Thanks!
> >>>
> >> ___
> >> 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] Beginner use case: Checking, Savings, Credit Card = how do I correlate a transaction in Checking Withdrawal to Savings Deposit or Credit Card payment?

[Steve Butler]

As Michael stated, you don't truly understand double entry bookkeeping.

During the import process, you specified the main checking/savings/cc
account.  But it appears you failed to identify the other account for
each transaction.  If you had done that, there is a fairly good chance that:
1.  The importer would learn how to assign those other accounts
automatically for you.
2.  The savings and cc import may have found the transaction from the
checking import and updated it (if necessary) and would not have loaded it
again.

To fix you can either start over brand new and load each one
month-by-month.  Do checking, then savings, then cc for January.  Then the
same for February and repeat for all the other months.

This way the importer will learn much faster and make the later months
much easier.  Also it will ensure the transaction matching in the savings
and cc loads are finding the transaction from the checking load.

Take smaller bytes and chew thoroughly.

On Tue, Aug 13, 2024, 08:56 Bruce Griffis  wrote:

> I'm trying to figure out the very basics of managing a checking account,
> savings account and credit card in GnuCash. I downloaded a csv of all
> checking transactions for a year and imported them. They look good and
> match up with my check register. Then I downloaded my savings for a year
> into a savings account in GnuCash. Finally, I downloaded a csv of credit
> card transactions for a year and imported into a liabilities/credit card
> account.
>
> So, in my checking account, I see a transfer to savings. This is marked
> imbalanced.
>
> In my savings account, I see a deposit maybe the same day and the same
> amount. This is marked imbalanced.
>
> If I open my checking account register and changed the destination
> account from imbalanced to savings, then I see that transaction pop up
> in my savings register. I now have two transactions of the same amount
> and possibly the same day in my savings register. Would I delete the
> duplicate entry I got when I downloaded the csv? Or what do I do to show
> that my checking transfer out transaction is the same as my savings
> increase transaction?
>
> And the same with my credit account. I see a payment out of checking to
> SuperBigBank Mastercard. In the credit card, I see a payment. Both are
> imbalanced. If I change the checking transaction to show it goes to my
> credit card, I now see two transactions in my credit card register.
> Would I simply delete the duplicate entry? Or how do I show that they
> are the same transaction?
> ___
> 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] Credit Card Rewards Refund

[Steve Butler]

I also record as misc. non-taxed income.  Thinking of titling a new income
account as "Rebates".

On Thu, Oct 14, 2021, 05:34 rsbrux via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I have a credit card which, like a few others, accrues a small
> percentage (1-2%) of the amounts spent as a rebate.  The rebate isn't
> subtracted from each charge, but accumulates in the card account as
> "Reward Points" until I cash them in.  The amount is then credited to
> the card account as a payment.  Should such payments be recorded as
> income or as a negative expense?
>
> ___
> 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.

[GNC] Incorrect QFX Import

[Steve Cohen]

I downloaded all of 2021's transactions from my bank in QFX format and
tried to import the file.

As I was doing so, I noticed an anomaly.  I receive monthly direct deposits
from a pension, all arrive on or shortly after the first of each month, the
same amount every month. But on the QFX import screen, only 5 of the months
showed the deposit,
for January, May, August, September and December.  The other seven months
were not on the import screen. I tried sorting by date, by amount, by
description - they aren't there.

In an attempt to learn what was going on, I first checked my bank
statements.  Was the pension not being deposited?  No, that wasn't it, the
deposits came in every month as they were supposed to. I then opened the
QFX file in a text editor to see if the deposits were listed in the QFX.
They all were.  So I am trying to understand if there's a bug in the import
function that would throw these transactions away.

Here are the QFX entries from December and November. Perhaps someone
looking at them can tell me why the first one was accepted and the second
not? I see no important difference.


CREDIT
2021120112[0:GMT]
1772.79
202112010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



CREDIT
2021110112[0:GMT]
1772.79
202111010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021

___
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] Incorrect QFX Import

[Steve Cohen]

Additionally, I tried exiting GnuCash and trying the import again.  This
made no difference.

On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:

> I downloaded all of 2021's transactions from my bank in QFX format and
> tried to import the file.
>
> As I was doing so, I noticed an anomaly.  I receive monthly direct
> deposits from a pension, all arrive on or shortly after the first of each
> month, the same amount every month. But on the QFX import screen, only 5 of
> the months showed the deposit,
> for January, May, August, September and December.  The other seven months
> were not on the import screen. I tried sorting by date, by amount, by
> description - they aren't there.
>
> In an attempt to learn what was going on, I first checked my bank
> statements.  Was the pension not being deposited?  No, that wasn't it, the
> deposits came in every month as they were supposed to. I then opened the
> QFX file in a text editor to see if the deposits were listed in the QFX.
> They all were.  So I am trying to understand if there's a bug in the import
> function that would throw these transactions away.
>
> Here are the QFX entries from December and November. Perhaps someone
> looking at them can tell me why the first one was accepted and the second
> not? I see no important difference.
>
> 
> CREDIT
> 2021120112[0:GMT]
> 1772.79
> 202112010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
> 
> CREDIT
> 2021110112[0:GMT]
> 1772.79
> 202111010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
___
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] Incorrect QFX Import

[Steve Cohen]

There do not appear to be any duplicate FITIDs here.

I ran the command

grep FITID downloaded.QFX | sort > fitid.txt

and could easily see that there were no duplicates in the 136 entries in
the file. The bank (Chase) appears to assign FITIDs of the form mmDD#
where # is a consecutive number from 0-9.  What it would do if there were
more than 10 entries isn't clear to me but that eventuality did not occur
in this file which has only 136 entries over a year.



On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche  wrote:

> GC will not import an ofx transaction it thinks it already has imported.
> To determine whether a transaction has been imported GC looks at the
> FITID. So if two transactions in your OFX file have the same FITID, the
> second one won't be imported.
>
> Can you check that the transactions that are missing don't have the same
> FITID as some of the transactions that were imported?
> Some banks are not good at assigning unique FITID to transactions, and
> that can cause a problem for GC.
> Jean
>
> On 12/29/21 2:13 PM, Steve Cohen wrote:
> > Additionally, I tried exiting GnuCash and trying the import again.  This
> > made no difference.
> >
> > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:
> >
> >> I downloaded all of 2021's transactions from my bank in QFX format and
> >> tried to import the file.
> >>
> >> As I was doing so, I noticed an anomaly.  I receive monthly direct
> >> deposits from a pension, all arrive on or shortly after the first of
> each
> >> month, the same amount every month. But on the QFX import screen, only
> 5 of
> >> the months showed the deposit,
> >> for January, May, August, September and December.  The other seven
> months
> >> were not on the import screen. I tried sorting by date, by amount, by
> >> description - they aren't there.
> >>
> >> In an attempt to learn what was going on, I first checked my bank
> >> statements.  Was the pension not being deposited?  No, that wasn't it,
> the
> >> deposits came in every month as they were supposed to. I then opened the
> >> QFX file in a text editor to see if the deposits were listed in the QFX.
> >> They all were.  So I am trying to understand if there's a bug in the
> import
> >> function that would throw these transactions away.
> >>
> >> Here are the QFX entries from December and November. Perhaps someone
> >> looking at them can tell me why the first one was accepted and the
> second
> >> not? I see no important difference.
> >>
> >> 
> >> CREDIT
> >> 2021120112[0:GMT]
> >> 1772.79
> >> 202112010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> >> 
> >> CREDIT
> >> 2021110112[0:GMT]
> >> 1772.79
> >> 202111010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> > ___
> > 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.
>
___
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.

[GNC] GNUCash 4.9

[Steve Mortimer]

I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are not 
removed from the desktop and I have to go and delete the manually.  If I 
do not delete them manually after each time I close the program the 
program just keeps adding more of the same files to the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

I have closed the program either way and there is no difference.
Thanks for the prompt response.
Steve


Derek Atkins <mailto:de...@ihtfp.com>
Monday, January 3, 2022 12:12 PM
Hi,

On Mon, January 3, 2022 12:50 pm, Steve Mortimer wrote:

I have been running Gnucash on this computer, Win10, for sometime now
and have been having the same problem all along.  I have upgraded to
version 4.9.  When I close the program there are two files that are not
removed from the desktop and I have to go and delete the manually.  If I
do not delete them manually after each time I close the program the
program just keeps adding more of the same files to the desktop.

The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program
is closed?

How are you closing the program?  Are you just clicking on the [X]?  Or
are you using File -> Quit?


Regards,
Steve Mortimer
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek

Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

How do I get the main program to save other than to the desktop?
Steve


Dan Black <mailto:dblack2...@outlook.com>
Monday, January 3, 2022 12:21 PM
You seem to be saving your main file on the desktop, which is not a 
good practice. The program will save a backup and a log file in the 
folder where the main file is located. In your email, you show the log 
file and lock file. The lock file should be deleted when you close the 
program.


Dan


On January 3, 2022 12:51:15 PM Steve Mortimer  
wrote:



Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

Using the File Explorer and moving the files to a GNUcash folder did the 
trick.

Thanks for every ones help.

Steve

Glenn Fowler <mailto:gfowl...@outlook.com>
Monday, January 3, 2022 1:12 PM
Just use File Explorer and move it to the folder you prefer and then 
open from new location with File > Open in GnuCash


Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 12:59 PM
How do I get the main program to save other than to the desktop?
Steve


Dan Black <mailto:dblack2...@outlook.com>
Monday, January 3, 2022 12:21 PM
You seem to be saving your main file on the desktop, which is not a 
good practice. The program will save a backup and a log file in the 
folder where the main file is located. In your email, you show the log 
file and lock file. The lock file should be deleted when you close the 
program.


Dan


On January 3, 2022 12:51:15 PM Steve Mortimer  
wrote:



Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 11:50 AM
I have been running Gnucash on this computer, Win10, for sometime now 
and have been having the same problem all along.  I have upgraded to 
version 4.9.  When I close the program there are two files that are 
not removed from the desktop and I have to go and delete the 
manually.  If I do not delete them manually after each time I close 
the program the program just keeps adding more of the same files to 
the desktop.


The files are:
1223GNUCASH.gnucash.20...0103063517.gnucash.LCK
1223GNUCASH.gnucash.201...cash.20220103114501.log

What do I need to do so these files are deleted every time the program 
is closed?


Regards,
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the 
man of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

David,

Thanks for the information.
Steve


David Carlson <mailto:david.carlson@gmail.com>
Monday, January 3, 2022 1:32 PM
Steve,
In Windows you have a folder called Documents or similar.  Using your 
file explorer create a sub folder in Documents called "MyGnucsahData" 
or whatever you like.  Then, as the others here have said, move your  
data file there either with your file explorer or by using File > Save 
As from inside GnuCash.  Then set your GnuCash preferences using Edit 
> Preferences > Retain Log/Backup files to save them for 30 days or 7 
days, but forever would, IMHO, be too long.




--
David Carlson


--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

Thanks.  Looking into this.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 4:12 PM
Steve,

I'll add that it appears you are opening backup files, not the main 
GnuCash file. The very long file names indicate this. So it seems you 
have backups of backups. If you find the main file, it might not have 
all the same transactions as whatever you are currently working in.


Regards,
Adrien



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



--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

Adrien,

Here is what I have found out.  Each time the program is closed it adds 
that date and time to the name of the file.  How can this be stopped?


I can change the name of the file so that there is only one date for the 
file name and bring it up with all of the transactions in the file.  I 
close the program and the file now has two dates showing on it.


Guess there is no original file on the computer.
Steve


Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 5:40 PM
Thanks.  Looking into this.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 4:12 PM
Steve,

I'll add that it appears you are opening backup files, not the main 
GnuCash file. The very long file names indicate this. So it seems you 
have backups of backups. If you find the main file, it might not have 
all the same transactions as whatever you are currently working in.


Regards,
Adrien



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



--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

___
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] GNUCash 4.9

[Steve Mortimer]

What I did to correct my problem was to take the last backup file and 
remove all of the dates in the file name and made that my main 
(orginial) transaction file.  I opened that file as the data file and 
used it.  This corrected the issue with I was having.


Thanks everyone for your responses.
Steve


Adrien Monteleone <mailto:adrien.montele...@lusfiber.net>
Monday, January 3, 2022 8:30 PM
Your original file never changes names, unless you do a File > Save 
As, or change it via your OS file manager.


If you ever see a file with a date stamp, it is a backup. Do not try 
to open it in order to work in your main file. If you do, you are 
instead working in a backup copy and the main file never gets changed.


This new backup then becomes your current 'working copy'.

If those truncated file names contain several (not just two) time 
stamps, this means you've done this repeatedly and have now seriously 
branched your file.


If you know for certain you never worked in any previous original or 
backup file after opening a later one, just do a File > Save As on the 
currently open file with a simpler name. Then only open that file to 
start GnuCash in the future. Or better yet, if you are only using a 
single file, just open GnuCash itself. It always defaults to the last 
open file.


If you want a desktop shortcut, make it to the GnuCash app itself, not 
your file. Store that in your Documents as already suggested. 
(backups, logs, and lck files will be stored with it)


Regards,
Adrien



___
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.
Steve Mortimer <mailto:noahsark0...@att.net>
Monday, January 3, 2022 6:27 PM
Adrien,

Here is what I have found out.  Each time the program is closed it 
adds that date and time to the name of the file.  How can this be 
stopped?


I can change the name of the file so that there is only one date for 
the file name and bring it up with all of the transactions in the 
file.  I close the program and the file now has two dates showing on it.


Guess there is no original file on the computer.
Steve




--
Steve Mortimer

2 Timothy 3:16-17 (ESV)
All Scripture is breathed out by God and profitable for teaching, for 
reproof, for correction, and for training in righteousness that the man 
of God may be complete, equipped for every good work

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

[GNC] How to get debug to work (saying "uncle")

[Steve Conley]

I have been trying for 5 days now to chunk Quicken and start using gnucash.
ANY CLUES will be sincerely appreciated.

The immediate problem I am trying to solve:
Quicken export to qif of accounts/categories "seems" to complete - but
nothing visible in gnucash.
Quicken export to qif of tranactions seems to work also.  (large).

*But gnucash import of even a limited qif data to 2001, gets to the final
import stage and gnucash dies with no error.  Sometime in late QIF import -
before matching step.*

Naturally I try to get a debug log but the ONLY way I was able to make
anything happen was

(I pulled the startup command from the .desktop entry):
/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash
--file-forwarding org.gnucash.GnuCash --debug
(and added --debug)

This does not put a trace/debug file anywhere I can find. Definitely not in
/tmp.

I next tried specifying the logto option with /tmp/gnucash.trace or
~/gnucash.trace
The trace goes neither place.

Running this:
/usr/bin/flatpak run --command=gnucash --file-forwarding
org.gnucash.GnuCash --debug gcashdata_3.gnucash

(I had to remove the branch and arch options that are in the desktop entry
(which I copied from above) to even get his outputof warnings)

and then doing the qif import, results in about 40 lines of:
(gnucash:2): Gtk-WARNING **: timestamp: Negative content width -2147483648
 while allocating gadget (node progress, owner GtkProgressBar)
and
(gnucash:2): Gtk-WARNING **: timestamp: Drawing a gadget with negative
dimensions. did you forget to allocate a size? (node progress, owner
GtkProgressBar)

Whether this results in the actual crash, I have no idea.

OTHER BACKGROUND ON WAY TO HERE ...

Whenever gnucash is started, I get the Gtk messages as follows:
Gtk-Message: timestamp" Failed to load module "appmenu-gtk-module"
Gtk-Message: timestamp" Failed to load module "canberra-gtk-module"
Gtk-Message: timestamp" Failed to load module "canberra-gtk-module"

I tried all manner of suggestions of loading appmenu-gtk/2/3 and
libcanberra-gtk/2/3 etcand reinstalling each. all said they were installed
and all re-installs also completed without error.
But did not get rid of the messge.

The machine is a core-i3 with 4GB of RAM and a large drive - so space
should not be an issue.
But it is an Inspiron 13 - set at 1080p resoultion.

Why GNCash ...
I like what I see and have read the pdfs of documentation and played around
with examples.
(BTW, I am a 49 year - before retiring veteran of computer science with a
PhD in Comp Sci and Electronics.  I have 6 Xubuntu Linux machines at  home
in addition to a couple of hated Win10 achines.)

So I have 23 years of history in my Quicken data.
I have run the Quicken Repair options, and they say all is well.

Quicken (latest) export to qxf crashes.So I can't try gnucash import of
qxf.

First I am running for this machine Pop!_OS versus Xubuntu as it will be my
wife's and she is better with GUI.
AND I have ordered a System76 Pop!_OS laptop to replace my failing (screen)
Dell Inspiron 15.
___
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] How to get debug to work (saying "uncle")

[Steve Conley]

A BIG Thanks to all who responded with clues or solutions ...
r
Geert, QUITE RIGHT about the broken -lotto.  I now have it working. "Who
would have that the only place it did not work was where the doc said it
should be ...).

I finally successfully loaded up to "about" where it died.  I am proceeding
to check the Quicken QIF and work my way slowly "over" the bug - either in
Quicken output or gnucash input.

The import seemed to do, on the surface, the 3 years I imported mostly the
correct things ... will verify and report, if anyone is interested, the
things that failed.

CURRENTLY: I still have these messages to the CONSOLE if run in a command
window.
These "seem" to be harmless bugs "so far", but someone might like to know
about them:

Gtk-Message: 11:47:04.747: Failed to load module "appmenu-gtk-module"
Gtk-Message: 11:47:05.351: Failed to load module "canberra-gtk-module"
Gtk-Message: 11:47:05.418: Failed to load module "canberra-gtk-module"
Found Finance::Quote version 1.49.

LOTS OF THESE:
(gnucash:2): Gtk-WARNING **: 11:50:59.099: Negative content width
-2147483648 (allocation -2147483648, extents 0x0) while allocating gadget
(node progress, owner GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.099: Drawing a gadget with negative
dimensions. Did you forget to allocate a size? (node progress owner
GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.164: Negative content width
-2147483648 (allocation -2147483648, extents 0x0) while allocating gadget
(node progress, owner GtkProgressBar)

(gnucash:2): Gtk-WARNING **: 11:50:59.165: Drawing a gadget with negative
dimensions. Did you forget to allocate a size? (node progress owner
GtkProgressBar)

Anyway, THANKS AGAIN.
Steve Conley




On Tue, Jan 18, 2022 at 2:58 AM Geert Janssens 
wrote:

> In addition to David's suggestions, here's one to get debug logs.
>
> In flatpak the log file is not generated by default (due to some internal
> conflicts in the sandbox wrt where gnucash wants to write the log file).
>
> So if you want to generate the logs add
>
> --logto=
>
> to you flatpak command.
>
> The filename can be either 'stdout' to print directly to your console
> window or any file path that's not in /tmp, for example
> "$HOME/gnucash.trace"
>
> Regards,
>
> Geert
>
> Op maandag 17 januari 2022 22:12:31 CET schreef Steve Conley:
>
> > I have been trying for 5 days now to chunk Quicken and start using
> gnucash.
>
> > ANY CLUES will be sincerely appreciated.
>
> >
>
> > The immediate problem I am trying to solve:
>
> > Quicken export to qif of accounts/categories "seems" to complete - but
>
> > nothing visible in gnucash.
>
> > Quicken export to qif of tranactions seems to work also.  (large).
>
> >
>
> > *But gnucash import of even a limited qif data to 2001, gets to the final
>
> > import stage and gnucash dies with no error.  Sometime in late QIF
> import -
>
> > before matching step.*
>
> >
>
> > Naturally I try to get a debug log but the ONLY way I was able to make
>
> > anything happen was
>
> >
>
> > (I pulled the startup command from the .desktop entry):
>
> > /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash
>
> > --file-forwarding org.gnucash.GnuCash --debug
>
> > (and added --debug)
>
> >
>
> > This does not put a trace/debug file anywhere I can find. Definitely not
> in
>
> > /tmp.
>
> >
>
> > I next tried specifying the logto option with /tmp/gnucash.trace or
>
> > ~/gnucash.trace
>
> > The trace goes neither place.
>
> >
>
> > Running this:
>
> > /usr/bin/flatpak run --command=gnucash --file-forwarding
>
> > org.gnucash.GnuCash --debug gcashdata_3.gnucash
>
> >
>
> > (I had to remove the branch and arch options that are in the desktop
> entry
>
> > (which I copied from above) to even get his outputof warnings)
>
> >
>
> > and then doing the qif import, results in about 40 lines of:
>
> > (gnucash:2): Gtk-WARNING **: timestamp: Negative content width
> -2147483648
>
> >  while allocating gadget (node progress, owner GtkProgressBar)
>
> > and
>
> > (gnucash:2): Gtk-WARNING **: timestamp: Drawing a gadget with negative
>
> > dimensions. did you forget to allocate a size? (node progress, owner
>
> > GtkProgressBar)
>
> >
>
> > Whether this results in the actual crash, I have no idea.
>
> >
>
> > OTHER BACKGROUND ON WAY TO HERE ...
>
> >
>
> > Whenever gnucash is started, I get the Gtk messages as

[GNC] Bug 798423 - IMPORT QIF crashes on a Quicken transaction Reminder (NOT a scheduled reminder)

[Steve Conley]

I submitted this bug, which was my only "stopper" so far.

Taking import a bit at a time, but it seems to be working well.

I discovered a couple of minor issues with my entries in 26 years pf
quicken and am correcting this and restarting.

Just wanted to thank everyone again, and if I did anything wrong with the
bug submission, please let me know.

I did search Google and the bug list and did not find this bug.

Steve Conley
___
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] (no subject)

[Steve Butler]

Please plan a compressive backup strategy for your entire system.  Include
email, Libre Office documents, other misc files and not just GnuCash.

That way it won't matter where files are "hidden" as you will have a
complete backup strategy that isn't specific to any particular application.

On Tue, Feb 22, 2022, 09:51 Mario Nigrovic  wrote:

> Many years ago, I had used gnucash, and was pretty happy with it. I was
> very careful to make regular backups of my data, and so, when my disk
> inevitably crashed, I was not too worried. However, I was mortified to
> discover that, although all my transaction data had been saved, all my
> custom reports were lost, as they had been stored separately in a secret
> undisclosed location, I later discovered to be elsewhere in my home
> directory.
>
> Recently, I have decided to try again to use gnucash, but I would like very
> much to ensure ALL my data is backed up. So I hit upon the idea of running
> the tool under a custom value of $HOME, but I was then shocked to discover
> that even with this method, gnucash was able to remember previous locations
> of my database file, which suggests that the tool is also using some kind
> of other mechanism to save historical data, and that makes me very nervous
> about actually being able to do proper backups of everything related to the
> tool.
> Doing some sleuthing using strace, I was able to find the previous database
> location delivered through some socket connection, and that really scares
> me, since it is now possible critical data is stored via some other Linux
> service and I will have no way to trace out where this may be to avoid
> future nasty surprises.
> I have not seen any documentation about backup strategies other than the
> aromatic saving of previous data files, yet I do see that there was data
> being stored at least in ~/.local, so I'm hoping someone on this list may
> be able to point me to some more thorough discussion of ALL the places user
> data from gnucash may be stored.
> Thanks for your help!
>
> -- Mario
>
> -- Mario
> ___
> 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.

Re: [GNC] Report unreliable (invalid totals)

[Steve Butler]

Look for future dated transactions.  I entered some for last December and
they ended up for next December.  Happens when entering backdated entries
in January!

On Sun, Feb 27, 2022, 15:15 David H  wrote:

> Bruce,
>
> Have you double-checked the report options to ensure all accounts are
> selected.  Also maybe try increasing the "Levels of Subaccounts" ?
>
> Cheers David H.
>
>
> On Mon, 28 Feb 2022 at 07:22, Bruce Irving  wrote:
>
> > I'm using Version: 4.9, Build ID: Flathub 4.9-2 on Peppermint 10 (Ubuntu
> > 20.04 based).
> > Looking at the liabilities section of my Balance Sheet
> > (Liabilities_2022-02-27.png); it showed 1 AP account of -90.68 totaling
> to
> > -80.68!
> > I tried running the report limiting it to only liabilities.  The rest of
> > the options, except show zero values, were the same for both reports.
> > (Liabilities_2022-27.html)  Now it shows both payees but the total is
> stil
> > $10.00!  and the Total liabilities is -43.18 for both reports.
> > Bruce
> > ___
> > 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.
>
___
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] Automatic sales tax

[Steve Butler]

As soon as you dream up something that can't occur, the legislative
assistants will incorporate that scenario into new law.

On Mon, Feb 28, 2022, 09:48 Fred Bone  wrote:

> On 28 February 2022 at 10:28, William Prescott said:
>
> > Sebastian,
> >
> > Just to clarify, where the "item changed hands" may not be the seller's
> > location. I use to live just outside the border of a city that charged a
> > sales tax. When purchasing an item from a store within the city, I would
> > pay sales tax if I went into the store, purchased it, and took it home.
> > However, if I went into the store and purchased something that they then
> > delivered to my house, e.g. lumber, there was no sales tax. So the tax
> was
> > based on the delivery address not the seller's location.
>
> Out of idle curiosity ... Is it possible to dream up some complication
> that does *not* occur, somewhere?
>
> ___
> 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.

Re: [GNC] IRA/401K income detection

[Steve Butler]

I made a subaccount under the asset in which to record the distributions.
That subaccount is cleaned out each year by an adjusting transaction that
moves that to the main account.  That way the balance sheet year end report
shows the yearly distribution amount.  Makes it easy to pick off and send
to the CPA.

On Thu, Mar 10, 2022, 11:11 David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> When I move money from an IRA or 401K account to my bank account and the
> tax man, that is all a taxable distribution, but GNUCash mostly sees a
> transfer.  How do I capture the income?
> ___
> 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.

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu - solved

[Steve Butler]

Jeff,

Per chance are you on a Unix/Linux derevitive?  I have seen Windows line
endings cause problems for different shells trying to process the script.
Changing to Unix style line endings fixed the problem.  To the text editor
I was using the files appeared to be the same.

--Steve

On Mon, Apr 4, 2022, 07:16 Jeff  wrote:

>
> Geert, don't ask me how I did it because I do not know but the new icon
> now works.
>
> Just for kicks and grins I created a desktop file for LibreOffice Writer
> and it worked right the first time.  So then I edited my desktop icon
> for GNC and compared it to yours and couldn't see any differences except
> the path and data file name.  Renamed my file and copied yours into a
> text editor, changed the path and filename accordingly.  Saved it and
> right clicked the allow launching and it worked.
>
> Working version (copied and edited from your post):
>
> [Desktop Entry]
> Type=Application
> Terminal=false
> Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/'Mac
> Drive'/Ledgers/Dad/Dad.gnucash
> Name=GnuCash 4.9 FLATPAK Dad
> Comment=Manage home and small business accounts
>
> Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
>
> ==
> Non-working version:
>
> [Desktop Entry]
> Type=Application
> Terminal=false
> Exec=flatpak run org.gnucash.GnuCash /media/jeffrey/**'Mac
> Drive'/Ledgers/Dad/Dad.gnucash
> Name=GnuCash 4.9 FLATPAK Dad
> Comment=Manage home and small business accounts
> Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/share/gnucash/pixmaps/gnucash-icon.ico
>
>
>
>
> To the naked eye they look identical but one works and the other does
> not.  Both are right clicked to allow launching.  The only difference I
> can see, now that I copied and pasted into this e-mail, is that the text
> width is different. I don't know if that has something to do with it or
> not (hidden high bit character that doesn't show up in Text Editor
> perhaps?).
>
> I then created an icon for another set of books (which works) and
> checked the permissions for both.  They are not the same.  The copy of
> yours shows a check mark in the 'Allow executing file as program', the
> second one has a '-' .  My original had a check mark too.
>
> Thank you!
>
> --
> --JEffrey Black M.B.A.
>
> On 4/2/22 11:28 AM, Geert Janssens wrote:
> > [Desktop Entry]
> > Type=Application
> > Terminal=false
> > Exec=flatpak run org.gnucash.GnuCash /home/janssege/testfile.gnucash
> > Name=GnuCash 4.9 FLATPAK Dad
> > Comment=Manage home and small business accounts
> > Icon=/var/lib/flatpak/app/org.gnucash.GnuCash/x86_64/stable/active/files/
> > share/gnucash/pixmaps/gnucash-icon.ico
>
>
> ___
> 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.

[GNC] Reinstall GnuCash after Ubuntu upgrade to 22.04

[Steve Cohen]

I just upgraded my system to Ubuntu 22.04 (from 21.10). As a non-official
application, GNUcash seems to have been removed from the system or rendered
non-functional though a launch icon remains and does nothing.  Prior to
install, I was running GNC 4.9.

Can someone please point me in the right direction for building or
installing the best version of GNUcash on my new system?

Thanks.
___
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] Mass Reconcile

[Steve Butler]

Do they all have the same parent?  If so, reconcile the parent and check
the box to include all sub-accounts.

On Sat, May 21, 2022, 22:17 Fred Tydeman  wrote:

> I added over 300 dummy #yymmdd accounts and am using them as tags in splits
> in transactions (to simulate Quicken classes).  I now realized that those
> splits are not reconciled.  It is a slow process to  reconcile them one by
> one.  Is there an easy way to pick many of those #yymmdd accounts and have
> them all be reconciled at once?
> ___
> 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.

[GNC] Description list

[Steve Elstad]

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.

 

In the Transfer field there is a pull down list of accounts.  

 

Thanks,

 

Steve

___
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] Description list

[Steve Elstad]

Thanks for that.  Is there a way to produce a list of all those descriptions 
that I have used before?  Autocomplete is great if I am close to spelling the 
description I want.  Otherwise I am just guessing and would like to reuse a 
previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad 
Cc: GnuCash users group 
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as 
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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.

Re: [GNC] Description list

[Steve Elstad]

Thanks, that is interesting.  I migrated from Quicken end of last year and
it is one of the things I got used to with Quicken and can't find an analog
with GnuCash.  Overall GnuCash has been wonderful, and my workflow is more
efficient for my needs.  

 

Steve

 

From: Gyle McCollam 
Sent: Wednesday, June 29, 2022 5:15 PM
To: Steve Elstad ; 'Glenn Fowler' 
Cc: 'GnuCash users group' 
Subject: Re: [GNC] Description list

 

Steve,

You could use Edit/Find.  Then select Description-Contains-(type in part of
the description, can be just one letter) and if you check Match Case it will
find any descriptions that match.  It will show the same description
multiple times however.  Obviously, if it is a seldom used description it
won't show up that often.

 

Thank You,   

Gyle McCollam

Gyle McCollam

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail....@gnucash.org> > on behalf of
Steve Elstad mailto:st...@ngc7331.com> >
Sent: Wednesday, June 29, 2022 8:05 PM
To: 'Glenn Fowler' mailto:gfowl...@outlook.com> >
Cc: 'GnuCash users group' mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list 

 

Thanks for that.  Is there a way to produce a list of all those descriptions
that I have used before?  Autocomplete is great if I am close to spelling
the description I want.  Otherwise I am just guessing and would like to
reuse a previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad mailto:st...@ngc7331.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto: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 <mailto: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.

Re: [GNC] Description list

[Steve Elstad]

Thanks for that, as a workaround I have done a search and iterated on that
to get a pseudo list.  Was clunky and didn't end up with what I wanted.  

Steve

-Original Message-
From: gnucash-user On Behalf Of Jeff
Sent: Wednesday, June 29, 2022 5:16 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

Hi Steve,

That's a great idea, and one that I wish was there, as it's always those
seldom used ones that you can't remember what you typed it as.

It may not be possible to generate the list from within GnuCash, but you
could always export the register to Excel and remove the duplicate entries
to create your own list.

Regards,
Jeff.

On 30/6/22 10:05, Steve Elstad wrote:
> Thanks for that.  Is there a way to produce a list of all those
descriptions that I have used before?  Autocomplete is great if I am close
to spelling the description I want.  Otherwise I am just guessing and would
like to reuse a previously used description.
>
>   
>
> Steve
>
>   
>
> From: Glenn Fowler
> Sent: Wednesday, June 29, 2022 4:38 PM
> To: Steve Elstad 
> Cc: GnuCash users group 
> Subject: Re: [GNC] Description list
>
>   
>
> Hi Steve,
>
>   
>
> Your register *is* your list. Auto-complete just matches previous entries
as type.
>
>   
>
> On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:
>
> Hi, is there a way to create a list of all the items I have used in 
> the Description field?  The autocompletion works if I remember the 
> description correctly.  Would like to see a list for those rarely used
ones.
>
>
>
> In the Transfer field there is a pull down list of accounts.
>
>
>
> Thanks,
>
>
>
> Steve
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto: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.
>

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

Re: [GNC] Description list

[Steve Elstad]

Roger on that.

 

Steve

 

From: Gyle McCollam 
Sent: Wednesday, June 29, 2022 5:21 PM
To: Steve Elstad ; gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

 

Steve, I should have mentioned that if you are in a particular register, it
will only look in that register.  If you are in the accounts (CoA) it will
find it in any register.

 

Thank You,   

Gyle McCollam

Gyle McCollam

 <mailto:gmccol...@gyleshomes.com> gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
Steve Elstad mailto:st...@ngc7331.com> >
Sent: Wednesday, June 29, 2022 8:05 PM
To: 'Glenn Fowler' mailto:gfowl...@outlook.com> >
Cc: 'GnuCash users group' mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list 

 

Thanks for that.  Is there a way to produce a list of all those descriptions
that I have used before?  Autocomplete is great if I am close to spelling
the description I want.  Otherwise I am just guessing and would like to
reuse a previously used description. 

 

Steve

 

From: Glenn Fowler 
Sent: Wednesday, June 29, 2022 4:38 PM
To: Steve Elstad mailto:st...@ngc7331.com> >
Cc: GnuCash users group mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Description list

 

Hi Steve,

 

Your register *is* your list. Auto-complete just matches previous entries as
type.

 

On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:

Hi, is there a way to create a list of all the items I have used in the
Description field?  The autocompletion works if I remember the description
correctly.  Would like to see a list for those rarely used ones.



In the Transfer field there is a pull down list of accounts.  



Thanks,



Steve

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto: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 <mailto: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.

Re: [GNC] Description list

[Steve Elstad]

In my simple mind, to do autocomplete you are looking up the entered values
in a list for a closest match.  Seems you could export that list?

Steve

-Original Message-
From: gnucash-user On Behalf Of Jeff
Sent: Wednesday, June 29, 2022 5:16 PM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Description list

Hi Steve,

That's a great idea, and one that I wish was there, as it's always those
seldom used ones that you can't remember what you typed it as.

It may not be possible to generate the list from within GnuCash, but you
could always export the register to Excel and remove the duplicate entries
to create your own list.

Regards,
Jeff.

On 30/6/22 10:05, Steve Elstad wrote:
> Thanks for that.  Is there a way to produce a list of all those
descriptions that I have used before?  Autocomplete is great if I am close
to spelling the description I want.  Otherwise I am just guessing and would
like to reuse a previously used description.
>
>   
>
> Steve
>
>   
>
> From: Glenn Fowler
> Sent: Wednesday, June 29, 2022 4:38 PM
> To: Steve Elstad 
> Cc: GnuCash users group 
> Subject: Re: [GNC] Description list
>
>   
>
> Hi Steve,
>
>   
>
> Your register *is* your list. Auto-complete just matches previous entries
as type.
>
>   
>
> On Wed, Jun 29, 2022 at 7:21 PM Steve Elstad mailto:st...@ngc7331.com> > wrote:
>
> Hi, is there a way to create a list of all the items I have used in 
> the Description field?  The autocompletion works if I remember the 
> description correctly.  Would like to see a list for those rarely used
ones.
>
>
>
> In the Transfer field there is a pull down list of accounts.
>
>
>
> Thanks,
>
>
>
> Steve
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org <mailto: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.
>

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

[GNC] American Express now forces you to use Quicken to download QFX

[Steve Cohen]

I've gone back recently to using my GnuCash and I need to download 
transactions from American Express.  Their website now wants to force me 
to go through Quicken to deactivate my account and reactivate it in 
order to get QFX data.


It's my data, not Quicken's.  That was the whole reason I started using 
GNUCash to avoid quicken.  How can I get my data now from American Express?

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

[GNC] Amex won't let me access QFX data without a Quicken Account

[Steve Cohen]

I've recently picked up Gnucash after letting it slide for about a year.  I
want to download data from my American Express Card account in QFX format,
and they won't let me do it without "deactivating and reactivating" my
Quicken account.  Quicken doesn't own my data, I own it.  I don't even have
Quicken available to use to deactivate.  Amex technical support is
useless.  What are my options?
___
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] What does OFX Direct Connect do?

[Steve Cohen]

"steadily dwindling list" - doesn't sound good.  I never got direct
connection to work, but I was happy enough downloading my Amex card
transactions via QFX.  Now I can't even do that. :-(  Hmm.  What options
besides .QFX does GnuCash support?  As I recall, QFX was best.

On Mon, Jan 4, 2021 at 3:28 PM John Ralls  wrote:

> Please remember to copy the list on all replies.
>
> GnuCash does not have such a list, but the website http://ofxhome.com
> maintains a directory of US financial institutions that do or did support
> OFX Direct Connect. Be sure to check the bottom of the institution's page
> to see when the ofxhome test script last ran successfully.
>
> If your existing FI decides to support only Quicken then your options are
> to switch to somewhere that still supports OFX Direct Connect (a steadily
> dwindling list), switch to manually downloading your transactions in one of
> the formats GnuCash supports, or getting Quicken.
>
> Regards,
> John Ralls
>
>
> > On Jan 4, 2021, at 1:19 PM, Steve Cohen  wrote:
> >
> > and if your financial institution, like American Express, forces you to
> maintain an account with Quicken in order to download QFX files, what,
> short of closing your account with them, are your options?  Does GNUCash
> maintain a list of institutions that do or don't support import of data?
> >
> > I quit Quicken several years ago because I was tired of being forced to
> upgrade every 2 or 3 years to get a bunch of features I had no need of, yet
> bug fixes I did have need of were never made.
> >
> > On Mon, May 18, 2020 at 10:09 PM John Ralls  wrote:
> > No, OFX is a file format. Many financial/bank websites offer OFX or QFX
> downloads of your transaction data; more in fact than offer OFX Direct
> Connect. Since OFX (and it's slightly altered evil twin QFX, for Quicken
> Financial eXchange) are formats expressly designed for transferring
> consumer transaction information it's a more efficient and less error prone
> way to import transactions into programs like GnuCash.
> >
> > If your bank offers OFX Direct Connect then GnuCash can connect to your
> bank and get that OFX download. If not but allows downloading OFX-formatted
> files then you go to the bank website, log in, and get the download, then
> use File>Import>Import OFX/QFX to import it.
> >
> > Regards,
> > John Ralls
> >
> > > On May 18, 2020, at 2:20 PM, Fran_3  wrote:
> > >
> > > Woops! No ill intent. I've seen the same response on other SIG's when
> someone started a new thread that a groups member or admin thought should
> have been included in a recent thread on that some related topic. Oh well.
> > >
> > > Back to the topic... so OFX just saves you the steps of downloading
> the transactions as CSV and then having to do a bit of formatting before
> you import them into GC... right?
> > >
> > >
> > >
> > > On Monday, May 18, 2020, 1:48:19 PM EDT, John Ralls <
> jra...@ceridwen.us> wrote:
> > >
> > >
> > > Don't hijack threads, it's rude. Start a new one when you have a new
> question.
> > >
> > > OFX Direct Connect is just like importing an OFX or QFX file
> downloaded from your bank's website except that it will connect to the bank
> and get the OFX file for you.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > > > On May 18, 2020, at 10:27 AM, Fran_3  wrote:
> > > >
> > > > If I can jump in here I would like to learn more about OFX Direct
> Connect with GnuCash.
> > > >
> > > > Does such automatically determine what transactions occur at the
> bank that are not in GC...
> > > > And then automatically update GnuCash?
> > > >
> > > > Or what?
> > > >
> > > > Thanks.
> > > >
> > > >
> > > > On Monday, May 18, 2020, 12:35:10 PM EDT, John Ralls <
> jra...@ceridwen.us> wrote:
> > > >
> > > >
> > > >
> > > >
> > > > > On May 17, 2020, at 12:06 PM, Hershey 
> wrote:
> > > > >
> > > > > I'm new to Gnu and am having issues setting up online downloads.
> > > > > My first attempt is Wells Fargo and I get a 2000 error message.
> > > > > The Tutorial show Wells Fargo in its example but I've also seen
> this
> > > > > statement on the web: Wells Fargo has switched to OFX Web Connect.
> GnuCash
> > > > > doesn't support this authentication.
> 

[GNC] Fwd: Amex won't let me access QFX data without a Quicken Account

[Steve Cohen]

-- Forwarded message -
From: Steve Cohen 
Date: Mon, Jan 4, 2021 at 7:40 PM
Subject: Re: [GNC] Amex won't let me access QFX data without a Quicken
Account
To: Dean Gibson 


Good that you can.  I can’t.  When I try exactly what you describe (which
used to work for me,too), I get a message that demands I deactivate and
reactivate my Quicken account.  And the only way they describe to do that
is with Quicken, which I don’t have on my system anymore.  I also do this
with Chase.

On Mon, Jan 4, 2021 at 6:30 PM Dean Gibson 
wrote:

> You can still do it;  I just did seconds ago. You just have to login to
> the AmEx web site, browse to downloads, & select the Quicken option.
>
> You then have to import the file into GnuCash.  It's not as neat as just
> doing it directly, but it does give you a backup file.
>
> Chase bank did this about a year ago, & I use the above technique with
> them as well.
>
> Since I download the PDF statement at the same time as I download the
> .QFX file, its not a big deal for me.
>
> Much more of a problem is Schwab, which has adopted the same security
> change as the above two firms, but (last I checked a month ago) has NOT
> provided a download option within the website.
>
>
>
> On 2021-01-04 12:56, Steve Cohen wrote:
> > ...  Amex technical support is useless.  What are my options?
> > ___
> >
> ___
> 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.

Re: [GNC] Adding new income category or new expenses category

[Steve Butler]

Barry,

This comes down to building your chart of accounts (COA).  You would be
adding Income and/or expense accounts.  Easy to do when sitting on the
accounts tab.  The top menu bar will have entries to ADD, DELETE, or EDIT.

The user guide will also walk you through the exercise.  Give it a good
read and follow along using a test file.

On Thu, Jul 15, 2021, 11:34 Barry G. Hall  wrote:

> I am a new GnuCash user.  I successfully set up an account and imported my
> business bank account statement.
>
> In the list of transactions I was able to assign an income or expense
> category to each transaction, however there is no expense category for
> “advertising”, “consulting”, “internet” or equipment purchase. For my
> internet expenses I just used Subscriptions.
>
> Similarly, there is no income category for “sales”, so I used “Bonus”.
>
> It it possible to add new categories?  If so, how might I accomplish that?
>
> Thanks for your help.
>
> Barry G. Hall
> Director, Bellingham Research Institute
> ba...@bellinghamresearch.com
> http://www.bellinghamresearch.com 
>
>
>
>
> ___
> 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.

[GNC] Cash Accounting Method

[Steve Morrow]

I spent much of today evaluating GnuCash for use with my U.S. based small
business. I found it to be robust in its functions.

 

Unfortunately, it only supports the accrual accounting method (income and
expense recognized when invoiced or billed).  My business uses cash
accounting method (income and expense recognized at time of receipt or
payment).

 

I highly recommend an enhancement to add an accounting method option for
accrual or cash method. 

 

This makes a big difference in reporting!

 

Steve Morrow

 

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

[GNC] Calculating interest rates

[Steve Hill]

Despite much Googling I haven't been able to find anything explaining 
how to calculate this...


I know:
 - The balance of a savings account at the start of the year;
 - The amounts and dates of payments into the account; and
 - The amount of interest paid at the end of the year.

I want to calculate the percent of interest received, assuming that the 
account compounds daily.


If there were no payments into the account it would be easy 
(interest_amount/start_balance=interest_percent), but I can't figure out 
how to take account of irregular payments into the account throughout 
the year.


Thanks.

--
- Steve
___
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] Scheduled Transaction Posting Order

[Steve Butler]

Other approach is to have the payroll happen the day before (think day of
week) the allowance.

On Fri, Oct 1, 2021, 14:32 Stan Brown  wrote:

>
> On 2021-10-01 14:01, Robin Chattopadhyay wrote:
> > Is there a way to control the posting order of scheduled transactions?
> >
> > For example, I have scheduled transaction A that runs every two weeks
> > (payroll) and scheduled transaction B (kids' allowance) that runs every
> > week.
> >
> > For the bank account side of the transaction, it would be nice if the
> > deposit (from transaction A) would appear in the register before the
> > withdrawal (from transaction B).
>
> You can put something in the Num field in the Scheduled Transaction
> Editor. For instance, you could number the deposit as 1 and the
> withdrawal as 2.
>
> That's not terribly satisfactory, since every other week you will have a
> 2 but not a 1, but it's the best I know how to do.
>
> (I'm using GC 2.6.19, but I don't imagine the Scheduled Transaction
> Editor has dropped the Num field in later versions.)
>
> Another possibility is simply to let the transactions appear, and then
> assign numbers to the new posted transactions. GC will display
> transactions in Num order.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
> ___
> 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.

[GNC] Fixing bad Bayesian data

[Steve Cohen]

Q: How do I get the most benefit from the Bayesian learning algorithm while 
importing?

A: First of all you should always assign transactions to the right accounts in the import dialog - accounts names containing Imbalance are definitely wrong. 
Next, start with a small subset of transactions (like one month) and assign the right accounts in the import dialog. The next time you import transactions, it will recognize this kind of transaction.



Ok, I've been a bad boy.  Didn't read the docs carefully enough. 
Imported without setting categories correctly.  Lots of "Imbalanced". 
I've been correcting these manually after import. Been using GnuCash 
about a year and a half.


Now I'd like to straighten up and fly right.

Is there any way to overwrite the old Bayesian data or is it possible on 
subsequent imports to enter the right accounts and have it just work now?


___
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] Fixing bad Bayesian data

[Steve Cohen]

Thanks.

Seems like none of these solutions will work if your data is stored as a 
.gnucash file, they only work with .xml files.


Is there a way to convert this?

Is the Bayesian matching applied to entries that are corrected in the 
account editor, or is it only applied to entries made in the importer?


I am somewhat comfortable with the bleeding edge, but, when is the 
release of version 4 expected?



On 12/18/18 5:17 PM, David Cousens wrote:

Steve

These may help.
https://wiki.gnucash.org/wiki/Bayes
https://lists.gnucash.org/pipermail/gnucash-user/2016-July/066299.html
http://gnucash.1415818.n4.nabble.com/Fixing-confused-bayesian-matching-data-td4685819.html
http://blog.jdlh.com/en/2016/07/29/resetting-gnucashs-import-transaction-matching/

Make a backup of your data file and only work on a copy until you are sure
it is working after changing it if you attempt any of the solutions
mentioned in the above posts.

The importer stores the map data and probabilities during the final step of
the import process. If you let transactions go through to Imbalance then it
obviously gets no data to work with. If you assign all transactions to a
specific transfer account before import and continue to do that, it will
eventually correct itself. There are a few situations in which the bayesian
matcher does not work. I find where there is a transaction unique number
which changes with each periodic transaction the matcher seems to run into
problems. An number identifying the payer/payee and not the transaction
itself is OK. Some of mine have both.

There will be a feature to be added in GnuCash V4 which allows multiple
selection of transactions and assignment of a single transfer account in the
import matcher which speeds up the transaction matching process
significantly. It can be incorporated in V3.x as a patch if you build
GnuCash from source, but the risk is that future bug fixes in the importer
which change the two affected files could result in a non-working GnuCash.
It incorporated in the master barnch of the GitHub repository and can be
built from that if you are comfortable working with the bleeding edge.

David Cousens




-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Fixing bad Bayesian data

[Steve Cohen]

OK, I figured out that .gnucash does not describe the file format which 
is either compressed or non-compressed XML depending on the compression 
setting you choose.


So I switched to non-compressed and look at the bayesian elements and 
it's not what I would have expected.  The expressions that are mapped 
from are not phrases but "words."  Something like




import-map-bayes/INDEPENDENCE/f5cb4b5b31decc01c394dd7170078254
  1



import-map-bayes/INDIA/af48360c2fb9b039b4707ad7d7517950
  1



import-map-bayes/INGTON/94ec6c9aae683c9125fb0dd2b1bb8846
  1



import-map-bayes/INN/c6447afebc9564fded7d1bafbe1e026e
  1



import-map-bayes/INTEREST/b572baae5a56a30ce384ab58ff12ed7d
  1



import-map-bayes/INTUIT/9c204d33baf137f4f0b078f9b61531d1
  1



import-map-bayes/INVESTM/5920c9dbe1d24308893a5eeb32d01e09
  3



import-map-bayes/IS/c6447afebc9564fded7d1bafbe1e026e
  4


So I am trying to understand how these are applied.  I get that the long 
hex numbers are GUIDs representing accounts and that the expressions 
before this are bits of the transaction description.  But what if the 
transaction description is multiple words, each mapping to a different 
account?  Obviously "INVESTM" and "IS" are going to be pulled in many 
different directions.  How does "INGTON" get in there?  Why isn't it 
"WAASHINGTON"? So I'm trying to understand how this works at all.


I know that it does, but I can't imagine how.

The long hex numbers are GUIDs corresponding to accounts.
On 12/18/18 5:59 PM, Stephen M. Butler wrote:

On 12/18/18 3:31 PM, Steve Cohen wrote:

Thanks.

Seems like none of these solutions will work if your data is stored as 
a .gnucash file, they only work with .xml files.


Is there a way to convert this?

Is the Bayesian matching applied to entries that are corrected in the 
account editor, or is it only applied to entries made in the importer?


I am somewhat comfortable with the bleeding edge, but, when is the 
release of version 4 expected?



On 12/18/18 5:17 PM, David Cousens wrote:

Steve

These may help.
https://wiki.gnucash.org/wiki/Bayes
https://lists.gnucash.org/pipermail/gnucash-user/2016-July/066299.html
http://gnucash.1415818.n4.nabble.com/Fixing-confused-bayesian-matching-data-td4685819.html 

http://blog.jdlh.com/en/2016/07/29/resetting-gnucashs-import-transaction-matching/ 



Make a backup of your data file and only work on a copy until you are 
sure

it is working after changing it if you attempt any of the solutions
mentioned in the above posts.

The importer stores the map data and probabilities during the final 
step of
the import process. If you let transactions go through to Imbalance 
then it

obviously gets no data to work with. If you assign all transactions to a
specific transfer account before import and continue to do that, it will
eventually correct itself. There are a few situations in which the 
bayesian

matcher does not work. I find where there is a transaction unique number
which changes with each periodic transaction the matcher seems to run 
into

problems. An number identifying the payer/payee and not the transaction
itself is OK. Some of mine have both.

There will be a feature to be added in GnuCash V4 which allows multiple
selection of transactions and assignment of a single transfer account 
in the

import matcher which speeds up the transaction matching process
significantly. It can be incorporated in V3.x as a patch if you build
GnuCash from source, but the risk is that future bug fixes in the 
importer
which change the two affected files could result in a non-working 
GnuCash.

It incorporated in the master barnch of the GitHub repository and can be
built from that if you are comfortable working with the bleeding edge.

David Cousens




-
David Cousens
--



Steve,

In GnC, click on the Tools menu and then on the Import Map Editor.  Once 
on the new screen you can see all the mappings that have been generated.


In my case, I did some restructuring of my accounts and found that the 
existing mappings no longer worked.  I highlighted the top levels and 
clicked on the DELETE key.  That reset everything for me and I'm in the 
process of building the new set of mappings.


The high level is based on the imports you do.  I had three: Checking 
account, Credit Card, and Savings account.  The last one is used so 
little that it isn't worth the hassle of downloading the 1-2 entries 
each month so I now enter them by hand.  That will leave me with just 
two imports -- which I plan to do multiple times each month to keep the 
number of transactions low.


Anyway, if you decide to clear everything out, the above is a nice and 
easy way to do that.


--Steve



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences o

Re: [GNC] Fixing bad Bayesian data

[Steve Cohen]

Thanks, Geert, I hadn't realized that until yesterday when another 
poster pointed me there, but even then I hadn't realized that this was 
intended as a replacement for messing with data files/perl scripts, etc.


On 12/19/18 4:09 AM, Geert Janssens wrote:

GnuCash 3.x also has a new tool that allows you to erase bad bayesian data.
There's no need to dive directly into the data files to make changes. This was
contributed by Robert Fewell.

This tools is called "Import Map Editor" and can be found under the "Tools"
menu.

Regards,

Geert


___
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] Fixing bad Bayesian data

[Steve Cohen]

A nice-to-have would be an option to automatically filter all state 
abbreviations and days of the week.  I see lots of these polluting my map.


On 12/19/18 12:52 PM, Steve Cohen wrote:
Thanks, Geert, I hadn't realized that until yesterday when another 
poster pointed me there, but even then I hadn't realized that this was 
intended as a replacement for messing with data files/perl scripts, etc.


On 12/19/18 4:09 AM, Geert Janssens wrote:
GnuCash 3.x also has a new tool that allows you to erase bad bayesian 
data.
There's no need to dive directly into the data files to make changes. 
This was

contributed by Robert Fewell.

This tools is called "Import Map Editor" and can be found under the 
"Tools"

menu.

Regards,

Geert




___
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] Data entry problem

[Steve Butler]

That was a bug on certain releases that has been fixed.  You didn't
indicate what version of GnC you are using nor did you say which O/S or
hardware.  Without that info it is impossible to determine whether your
issue has been fixed or if it raised its ugly head again.

On Thu, Dec 20, 2018, 07:52 avigr...@juno.com  When I type something by mistake, my delete and backspace key do not work
> to allow me to correct the error.  How do you correct a typo in GnuCash?
> ___
> 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.

Re: [GNC] New User-Chase Bank Problems

[Steve Cohen]

I am also trying to set this up with Chase, where I have both bank and 
credit card accounts. I've tried and failed since first using GNUCash 
last year.  Trying to understand what needs to be done.


I see in the Wizard "UserId is assigned to you by the bank after 
applying for OFX DirectConnect"


I don't recall having ever done this much less possess any documents 
from the bank.  Yet on the Chase website, it says,




Desktop apps
You've set up your Chase accounts so desktop versions of apps like Quicken® or 
Intuit QuickBooks® can access them directly. To remove this access, contact help 
& support at 1-877-CHASEPC (1-877-242-7372). Keep in mind: this only applies to 
apps you've installed on your desktop. If you'd like to link your accounts to a 
mobile or website app, please go to the linked apps and websites page.


This access must have been granted back in the days when I used Quicken.

but I have no idea how to find my User Id.

Where do I go from here?


 On 12/17/18 7:41 PM, Michael Mantei wrote:


That's what I've done. No luck. I'm not getting any messages on the 
Chase site so I don't know if they are seeing anything or not. I just 
keep seeing the same thing over and over. I'm on my 27 user attempt and 
nothing has changed. I was hoping it was the fact that I hadn't removed 
the hyphens from the CLUID, but even removing them doesn't fix it.



SciFiGeek


On 12/15/2018 6:14 PM, Fross, Michael wrote:

Hello,

I remember spending a lot of time to get it to work with my Chase 
Freedom card.  There were 2 things that needed be done.  #1, create a 
UUID and #2, go onto the website after you try it and give access.


Summary:
1. Generated a Version 4 UUID here:
a. https://www.uuidgenerator.net/version4
2. Entered it in my user settings ClientUID field in the aqbanking 
wizard - without the dashes

3. Changed the Header version to 103 (was 102)
4. Connect and instant success!  Transactions and balance downloaded 
with no error messages in log.

Go to your Chase Secure message box and allow the connection

Thanks to Dave Reiser for figuring it out...I basically followed his 
instructions.  If you'd like me to paste the entire email let me 
know.  I saved it along with my summary above.


Michael

On Sat, Dec 15, 2018 at 7:32 PM David Reiser via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:



    > On Dec 15, 2018, at 8:10 PM, Michael Mantei mailto:mante...@gmail.com>> wrote:
    >
    > I was a user of Quicken for as long as I can remember. I'm now
    trying to get serious about my finances and recently installed
    GNUCash on my Windows 10 system. I simply installed the software,
    and built my entire account structure manually, to match exactly
    what I wanted it to be. Now I need to connect to my bank (Chase)
    and can't do it.
    >
    > I'm using the AQBanking Wizard and have setup a user account and
    it won't connect.  I started reading lots of messages here then
    created a new user.  This one has the User Name and User Id set to
    the same name I used with Quicken. I used an online app to
    generate a Client UID. I've selected JPMorqan Chase Bank as my
    bank and took the defaults on the Bank Settings page. For the
    Application Settings, I have an Application ID of "QWIN". The
    application version is set to 2700 and the header version is set
    to 103. When I try to retrieve the account list, this is what I get:
    >
    >
    > 14:06:57 Retrieving SSL certificate
    > 14:06:57 Connecting to server...
    > 14:06:57 Using GnuTLS default ciphers.
    > 14:06:57 TLS: SSL-Ciphers negotiated:
    TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
    > 14:06:57 Signer not found
    > 14:06:57 Certificate is not trusted
    > 14:06:57 Connected.
    > 14:06:57 Disconnected.
    > 14:06:57 Connection ok, certificate probably received
    > 14:06:57 Operation finished, you can now close this window.
    >
    > The OFX.log file shows this:
    >
    > Sending:
    > -
    > OFXHEADER:100
    > DATA:OFXSGML
    > VERSION:103
    > SECURITY:NONE
    > ENCODING:USASCII
    > CHARSET:1252
    > COMPRESSION:NONE
    > OLDFILEUID:NONE
    > NEWFILEUID:20181214144405.000
    >
    >
    20181214144405.000#NAME
    REMOVED#
    > #PASSWORD REMOVED#
    > ENGChase

Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 


    >
    > -
    >
    > Anyone have any ideas what I am doing wrong? Your help would be
    greatly appreciated.
    >
    > SciFiGeek
    >

    The ofx log says you set the APPVER to 2200 instead of 2700. That
    probably matters.

    Another thing is that you’re likely to have to do is log into the
    Chase web site, and check your secure messages for one that asks
    you if you were the one trying to sign in with a previously
    unknown app (as identified by the new unique CLIENTUID). Once
    you’ve followed the steps in the Chase message, you’ll be in
    better shape. If you have no m

Re: [GNC] new to gnucash

[Steve Butler]

Sounds right to me.

Remember that Asset and Expense accounts are Debit accounts.  So Debit
increases and Credit decreases the balances in the accounts.

Liability, Income, and Equity/Capital accounts are Credit accounts.  So
Debit decreases and Credit increases the balance.

On Sat, Jan 5, 2019, 08:44 Mike Kerstetter  Hello all. I'm brand new to gnucash. I want it to do just the basics of
> keeping a register and reconciliation of a couple bank and credit card
> accounts. I had Money Sunset Deluxe and currently have Quicken (which is
> now charging a yearly subscription). I'm muddling through setting up my
> accounts and I am baffled at the seemingly backward credit and debit
> columns in the register. A deposit to my Checking (or payment to my
> credit card account) shows up under "DEBIT" and a charge to my accounts
> shows up under "CREDIT".  The balance is correct. Am I doing something
> wrong in my set-up?
>
> Thanks,
>
> Mike Kerstetter
> ___
> 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.

[GNC] Trouble entering Fund sale transaction

[Steve Kelem]

I have an account that is set up as a Mutual Fund, using Commodity Value.

I transferred some $ into the account when the price was $10.00, and converted 
it to the proper number of shares.

I then tried to sell some shares. I entered -1943.2136 shares at a price of $10.02, with 
a transaction amount of $19,471.00. I hit enter and it says "The values entered for 
this transaction are inconsistent. Which value would you like to have recalculated? 
Shares, Price, or Value." The $ amount is accurate as is the # of shares. I don't 
care if the price is off by a few decimals, so I opt for Price.

It then changes the price to 1.00, and the number of shares to -19,471! 
This is 1/10 the Price and 10x the number of shares!

I looked up the price in the database and it shows a price of $10.02 on the 
date of the transaction.

Why can't I represent the transaction correctly?

Thanks for any help you can give,
Steve Kelem

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