Re: [GNC] About auto-completion

[Adrien Monteleone]

Stan, the old method of typing separators still exists.

Regards,
Adrien

On 8/14/23 6:26 PM, Stan Brown (using GC 4.14) wrote:

On 2023-08-14 16:19, David Carlson wrote:

I wish to support the 'search throughout' method.  I admit that it took
me several seconds to get used to it but it reduces the size of the
short list of partial matches very quickly until I can pick the winner
very easily.  Since I am now expecting it I don't have to type several
introductory characters before typing the real meaty characters of my
search.


Thanks for posting, David. I was blinkered by what I was used to, but I
think you're right, it's just a matter of training myself to type
something unique from the interior when starting at the beginning would
come up with the account I didn't want.

All my accounts payable begin with "AP ", and all my accounts receivable
with "AR ". Maybe I should move those to the end of the account names.
I'll think on that for a while.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to search for transactions with new line character in description?

[Adrien Monteleone]

Use the Regex option.

Regards,
Adrien

On 8/14/23 11:42 AM, Lipp F. wrote:

When doing paste into a transaction description field, special characters
are stored "as is". I need to find a way to delete all these special
characters.

Can you guys recommend a proper way? 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.

Re: [GNC] Today's search....for .lck

[Adrien Monteleone]

Barry, we don't need your actual files. That's not going to help much 
anyway. The only thing requested was a screenshot of your file manager 
window showing the list of files, including their names, creation dates, 
and modified dates. But if that list is several scrolling windows long, 
then the better option is to export the list into a txt file and send 
that (or copy/paste it into a reply). The command to do so was provided 
several replies back.


Regards,
Adrien

On 8/13/23 1:41 PM, Mahon Finbar via gnucash-user wrote:
Apropos, the whole issue ofthehistory of the GNU files, I have been 
having a lot of problems trying to get the into a fo that can be senton 
here here. There are so many files with very small differences it seems 
to "confuse" cutting and pasting.


Could I suggest I try saving individually GNU files from the period 
before 30.7.2023, which is when the issue of not being able to save the 
files started, as .txt files and sent them over?


___
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] Chase ofx support?

[Kalpesh Patel]

Chase does supports download in CSV, QFX, QIF and QBO formats for Credit
Card and Bank accounts. 

QFX format seems to be the best and then importing it as a OFX/QFX has
worked well ...

-Original Message-
From: John Ralls  
Sent: Monday, August 14, 2023 4:43 PM
To: D Ducky 
Cc: Jon Schewe ; Gnucash Users 
Subject: Re: [GNC] Chase ofx support?



> On Aug 14, 2023, at 1:33 PM, D Ducky  wrote:
> 
> Hello,
> 
> It seems Chase does not support OFX anymore.
> 
>
https://www.banktivity.com/support/articles/banktivity-7/ofx-direct-connect-
will-no-longer-be-supported-by-chase-as-of-october-6th-2022/
> 
> 
> Is it possible to use some other method in gnucash to download
transactions from gnucash?
> 

No, there is no other method in GnuCash to download transactions from US
banks. You may be able to download files from Chase's website that you can
import into GnuCash using File>Import. Likely formats are OFX, QFX, QIF, and
CSV.

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.

Re: [GNC] About auto-completion

[Sherman Yoder]

   I love the "search throughout" feature. i am the treasurer of a foreign
   mission, and we track expenses by missionary family. All I have to do
   is to type in "david" and up come David's housing, transportation, and
   support accounts. That's so much nicer than typing
   Expenses:Housing:David, and so on.

   I hope this feature doesn't go away.

   Sherman

   On 8/14/2023 7:26 PM, Stan Brown (using GC 4.14) wrote:

On 2023-08-14 16:19, David Carlson wrote:

I wish to support the 'search throughout' method.  I admit that it took
me several seconds to get used to it but it reduces the size of the
short list of partial matches very quickly until I can pick the winner
very easily.  Since I am now expecting it I don't have to type several
introductory characters before typing the real meaty characters of my
search.

Thanks for posting, David. I was blinkered by what I was used to, but I
think you're right, it's just a matter of training myself to type
something unique from the interior when starting at the beginning would
come up with the account I didn't want.

All my accounts payable begin with "AP ", and all my accounts receivable
with "AR ". Maybe I should move those to the end of the account names.
I'll think on that for a while.

Stan Brown
Tehachapi, CA, USA
[1]https://BrownMath.com
___
gnucash-user mailing list
[2]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[3]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.

References

   1. https://BrownMath.com/
   2. mailto:gnucash-user@gnucash.org
   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
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] Strange prices update issue (possibly with TSP)

[John Ralls]

Kalpesh,

Bruce posted at 
https://github.com/finance-quote/finance-quote/issues/335#issuecomment-1676443182:
"While the fix did not make it into v1.58, you can download and install 
BPSCHUCK/Finance-Quote-1.58_01.tar.gz from CPAN for testing/verification. It 
also has what I hope is a fix for TSP. It was not returning the hash if the GET 
failed or if the body of the response produced a CSV file."

That's the BSEIndia issue; 
https://github.com/finance-quote/finance-quote/issues/338 is the TSP one.

If you find more problems with TSP (or anything else in F::Q) and want to help 
debug it the best way to communicate with Bruce and stay up to date would be to 
open an issue at https://github.com/finance-quote/finance-quote/issues/. You 
can post here too if you want, but a Github issue is a better place to put 
debugging results.

Regards,
John Ralls


> On Aug 14, 2023, at 1:54 PM, Kalpesh Patel  wrote:
> 
> Some good find in debugging ... Strawberry Perl cannot resolve the FQDN name 
> one out of three times for www.tsp.gov on my system (this might be 
> obfuscating the client behavior in response to real backend issue). It might 
> be that I am reaching servers that are in error state (rc = 500 which is 
> Internal Server Error; my observation on F::Q could be cause of concern on 
> amount of data being returned).  Below is the output from the failed run:
> 
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>set DEBUG=1
> 
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>test2.pl
> 
> ### [Mon Aug 14 16:26:56 2023] YIND_URL_HEAD : 
> 'https://query1.finance.yahoo.com/v8/finance/chart/'
> ### [Mon Aug 14 16:26:56 2023] YIND_URL_TAIL : 
> '?interval=1d=1691440016=1692044816'
> 
> ### AlphaVantage->new args : {}
> 
> ### COUNT_URL: 'http://www.panix.com/~hd-fxsts/finance-quote.html?tsp'
> ### Code: '200'
> 
> ### [Mon Aug 14 16:26:56 2023] url  : 
> 'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1'
> ### [Mon Aug 14 16:26:56 2023] reply: bless( {
> ###_content => 'Can\'t connect to 
> www.tsp.gov:443 (nodename nor servname provided, or not known)
> 
> nodename nor servname provided, or not known at 
> C:/Strawberry/perl/site/lib/LWP/Protocol/http.pm line 50.
> ',
> ###_headers => bless( {
> ### 
> '::std_case' => {
> ###   
> 'client-date' => 'Client-Date',
> ###   
> 'client-warning' => 'Client-Warning'
> ###   
>   },
> ### 
> 'client-date' => 'Mon, 14 Aug 2023 20:26:56 GMT',
> ### 
> 'client-warning' => 'Internal response',
> ### 
> 'content-type' => 'text/plain'
> ###   }, 
> 'HTTP::Headers' ),
> ###_msg => 'Can\'t connect to 
> www.tsp.gov:443 (nodename nor servname provided, or not known)',
> ###_rc => 500,
> ###_request => bless( {
> ### _content 
> => '',
> ### _headers 
> => bless( {
> ###   
>'user-agent' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) 
> AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36'
> ###   
>  }, 'HTTP::Headers' ),
> ### _method 
> => 'GET',
> ### _uri => 
> bless( do{\(my $o = 
> 'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1')},
>  'URI::https' )
> ###   }, 
> 'HTTP::Request' )
> ###  }, 'HTTP::Response' )
> 
> C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>
> 
> My test file (test2.pl) is as follows:
> 
> #test2.pl - start
> 
>use Finance::Quote;
>use Data::Dumper;
> 
>$q = Finance::Quote->new;
> 
>%info = $q->fetch('tsp', "L2030");
> 
>print Dumper(%info);
> 
> # test2.pl - end
> 
> 
> Interesting side notes for GNC (I am on Windows 11 with GNC v4.14 and now 
> F::Q v1.58 so might have some subtle from it):
> 
> I was able to put the module in debug mode (set DEBUG=1 in cmd.exe; of 

Re: [GNC] Chase ofx support?

[Gyle McCollam]

I don't use direct connect at all anymore.  However, I do import OFX/QFX files 
from many sources, Chase credit card being one.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of John Ralls 
Sent: Monday, August 14, 2023 4:42 PM
To: D Ducky 
Cc: Gnucash Users 
Subject: Re: [GNC] Chase ofx support?



> On Aug 14, 2023, at 1:33 PM, D Ducky  wrote:
>
> Hello,
>
> It seems Chase does not support OFX anymore.
>
> https://www.banktivity.com/support/articles/banktivity-7/ofx-direct-connect-will-no-longer-be-supported-by-chase-as-of-october-6th-2022/
>
>
> Is it possible to use some other method in gnucash to download transactions 
> from gnucash?
>

No, there is no other method in GnuCash to download transactions from US banks. 
You may be able to download files from Chase's website that you can import into 
GnuCash using File>Import. Likely formats are OFX, QFX, QIF, and CSV.

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] About auto-completion

[Stan Brown (using GC 4.14)]

On 2023-08-14 16:19, David Carlson wrote:
> I wish to support the 'search throughout' method.  I admit that it took
> me several seconds to get used to it but it reduces the size of the
> short list of partial matches very quickly until I can pick the winner
> very easily.  Since I am now expecting it I don't have to type several
> introductory characters before typing the real meaty characters of my
> search.

Thanks for posting, David. I was blinkered by what I was used to, but I
think you're right, it's just a matter of training myself to type
something unique from the interior when starting at the beginning would
come up with the account I didn't want.

All my accounts payable begin with "AP ", and all my accounts receivable
with "AR ". Maybe I should move those to the end of the account names.
I'll think on that for a while.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] About auto-completion

[David Carlson]

I wish to support the 'search throughout' method.  I admit that it took me
several seconds to get used to it but it reduces the size of the short list
of partial matches very quickly until I can pick the winner very easily.
Since I am now expecting it I don't have to type several introductory
characters before typing the real meaty characters of my search.

On Mon, Aug 14, 2023 at 2:53 PM Stan Brown (using GC 4.14) <
stan...@fastmail.fm> wrote:

> I know there's been a lot of controversy about auto-completion in GC
> 5.x. I'm waiting for 5.4 to finish my upgrade, but have been using 4.14
> for a week or so now. One thing I just noticed is that, on the accounts
> tab, when I type the first few letters of an account name it now matches
> the first account name that _contains_ those letters, not necessarily at
> the beginning as in GC 2.x.
>
> Personally, I prefer matches to be done only at the start of account
> names, not in the middle. But I'm sure here are others who prefer them
> in the middle (which re4ally means matching anywhere).
>
> I wonder if it could make sense to have an option for matching account
> names at the beginning or anywhere, and a similar option the same for
> matching to descriptions when auto-filling transactions. That would
> please the maximum number of people, if it's not too difficult to
> implement.
>
> --
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
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] Consolidation of family member accounts

[Fred Tydeman]

Based upon my usage of keeping three separate "trusts" in the same one
file/book,
If multiple family members own the same stock,
then the Trading transactions will be a pain to keep correct.
I gave up and went with three separate files/books.

On Mon, Aug 14, 2023 at 12:00 PM James Thomas  wrote:

> I’m not sure why you’re maintaining separate books for each family member
> but it occurs to me that, rather than keeping them separate and having
> trouble combining when you want, you might try keeping all the accounts
> together but giving each a different name (perhaps just add each  family
> member’s initials before each account name). Then you could produce
> statements which included only those accounts pertaining to one entity at a
> time.
>
> You could even make each entity account subsidiary to its master account
> which (the master accounts) would then be the sum of all combined and could
> be displayed exclusively in the combined entity statements.
>
> Without trying it myself I’m not sure how many challenges might arise out
> of this but it might be worth giving a shot.
>
>
___
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] Strange prices update issue (possibly with TSP)

[Kalpesh Patel]

Some good find in debugging ... Strawberry Perl cannot resolve the FQDN name 
one out of three times for www.tsp.gov on my system (this might be obfuscating 
the client behavior in response to real backend issue). It might be that I am 
reaching servers that are in error state (rc = 500 which is Internal Server 
Error; my observation on F::Q could be cause of concern on amount of data being 
returned).  Below is the output from the failed run:

C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>set DEBUG=1

C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>test2.pl

### [Mon Aug 14 16:26:56 2023] YIND_URL_HEAD : 
'https://query1.finance.yahoo.com/v8/finance/chart/'
### [Mon Aug 14 16:26:56 2023] YIND_URL_TAIL : 
'?interval=1d=1691440016=1692044816'

### AlphaVantage->new args : {}

### COUNT_URL: 'http://www.panix.com/~hd-fxsts/finance-quote.html?tsp'
### Code: '200'

### [Mon Aug 14 16:26:56 2023] url  : 
'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1'
### [Mon Aug 14 16:26:56 2023] reply: bless( {
###_content => 'Can\'t connect to 
www.tsp.gov:443 (nodename nor servname provided, or not known)

nodename nor servname provided, or not known at 
C:/Strawberry/perl/site/lib/LWP/Protocol/http.pm line 50.
',
###_headers => bless( {
### 
'::std_case' => {
### 
  'client-date' => 'Client-Date',
### 
  'client-warning' => 'Client-Warning'
### 
},
### 
'client-date' => 'Mon, 14 Aug 2023 20:26:56 GMT',
### 
'client-warning' => 'Internal response',
### 
'content-type' => 'text/plain'
###   }, 
'HTTP::Headers' ),
###_msg => 'Can\'t connect to 
www.tsp.gov:443 (nodename nor servname provided, or not known)',
###_rc => 500,
###_request => bless( {
### _content => 
'',
### _headers => 
bless( {
### 
 'user-agent' => 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) 
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.61 Safari/537.36'
### 
   }, 'HTTP::Headers' ),
### _method => 
'GET',
### _uri => 
bless( do{\(my $o = 
'https://www.tsp.gov/data/fund-price-history.csv?startdate=2023-08-07=2023-08-14=1=1=1')},
 'URI::https' )
###   }, 
'HTTP::Request' )
###  }, 'HTTP::Response' )

C:\Users\kalpesh\OneDrive\QuickenStuff\HELPERS>

My test file (test2.pl) is as follows:

#test2.pl - start

use Finance::Quote;
use Data::Dumper;

$q = Finance::Quote->new;

%info = $q->fetch('tsp', "L2030");

print Dumper(%info);

# test2.pl - end


Interesting side notes for GNC (I am on Windows 11 with GNC v4.14 and now F::Q 
v1.58 so might have some subtle from it):

I was able to put the module in debug mode (set DEBUG=1 in cmd.exe; of course 
install the Smart::Comment Perl module first) and have them write out the smart 
comment messages to cmd console as you can see from above when I run a small 
test file that I've created. However, when I lunch gnc in  normal fashion from 
the same console where debugging is enabled, the screen does not display 
anything, not even the smart comment; it is almost like it is ignoring all env 
settings or not being passed to sub-shell. Windows is notorious for this so 
there may not be a "clean" way of doing so. There is a new window that pops up 
and then disappears at the start up (this process seems to be part normal start 
up - check if F::Q is there or not) and does not display anything also. I 
attempted to start gnc with debug (with --log=gnc.scm=debug option) as well but 
that also does not emit anything either. On the note of specifying a file name 
for logging (--logto= parameter), it does not create nor write a
 ny file anywhere on the file system when only a fixed file name is given. I 
took away that option and it was happy to write a file to %LOCALAPPDATA% path 

Re: [GNC] Chase ofx support?

[John Ralls]

> On Aug 14, 2023, at 1:33 PM, D Ducky  wrote:
> 
> Hello,
> 
> It seems Chase does not support OFX anymore.
> 
> https://www.banktivity.com/support/articles/banktivity-7/ofx-direct-connect-will-no-longer-be-supported-by-chase-as-of-october-6th-2022/
> 
> 
> Is it possible to use some other method in gnucash to download transactions 
> from gnucash?
> 

No, there is no other method in GnuCash to download transactions from US banks. 
You may be able to download files from Chase's website that you can import into 
GnuCash using File>Import. Likely formats are OFX, QFX, QIF, and CSV.

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.

[GNC] About auto-completion

[Stan Brown (using GC 4.14)]

I know there's been a lot of controversy about auto-completion in GC
5.x. I'm waiting for 5.4 to finish my upgrade, but have been using 4.14
for a week or so now. One thing I just noticed is that, on the accounts
tab, when I type the first few letters of an account name it now matches
the first account name that _contains_ those letters, not necessarily at
the beginning as in GC 2.x.

Personally, I prefer matches to be done only at the start of account
names, not in the middle. But I'm sure here are others who prefer them
in the middle (which re4ally means matching anywhere).

I wonder if it could make sense to have an option for matching account
names at the beginning or anywhere, and a similar option the same for
matching to descriptions when auto-filling transactions. That would
please the maximum number of people, if it's not too difficult to implement.

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Convert Money Market stock acnt to Bank acnt

[R Losey]

On Sat, Aug 12, 2023 at 2:09 PM Fred Tydeman  wrote:

> Is there an easy way to convert a money market stock account
> to a bank account?
>
> Since the price is always $1, and each transaction has Trading splits, the
> money market accounts are adding extra data to the book file and the price
> history file.
>

While the price is attempted to be kept at $1, it is not guaranteed to be
so. I'd advise against it and if you're concerned about price history,
you can get rid of old entries, can you not?



_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Consolidation of family member accounts

[Michael or Penny Novack]

On 8/14/2023 12:11 PM, Paras Desai wrote:
Thanks for a sharing fundamental understanding of accounting, that too 
coming from a person who seems to have actually done booking keeping 
with pen and paper is a real treat. 



LOL --- it wasn't THAT long ago.

In the 1950's (I was a teen in the late 50's) only a few of the largest 
corporations had computers. Almost everybody was still using pens and 
accounting ruled paper. It would still have been true in the 70's and 
early 80's that the majority of bookkeeping was done on paper.


Mind, because I did learn in the late 50's, I do have a better 
understanding of the process and exactly what gnucash is automating. The 
BIG deal is that it is "autoposting" (finding and correcting errors made 
while posting from the journal to the ledger were the bane of our 
existence). The shortcut allowing entry directly into the ledger for 
transactions with just two accounts mimics "cashbook accounting" which 
we had in those pen and ink on paper days just for a small subset of the 
"most popular" accounts (accounting paper only so wide) and gnucash 
extends that to the entire ledger. Another biggie is automatic 
generation of the reports.


Michael D Novack


___
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] Copying report formats to new PC

[Stan Brown (using GC 4.14)]

On 2023-08-14 09:43, Richard Stanton wrote:
> I'm moving GNUCash to a new PC. I've moved the data files, but
> I've also got a bunch of customised graphs that open by default
> when I open that file. When I open the file on the new PC,
> those are missing. I've googled, and as a result have tried
> copying the files located at
> users\username\appdata\roaming\gnucash,

BTW, it's shorter to type %APPDATA%\GnuCash on the location bar near the
top of File Explorer, and shorter to type in an email too. :-)

> but that hasn't helped.
> Obviously there's some extra data/preferences stored elsewhere,
> but I can't seem to find the info?
> 
> I'm on GNUCash 5.3 on both PCs, and windows 11 on both.

You say "the files located at" %APPDATA%\GnuCash (the short version of
the location you gave). Did you also copy the subfolders? The "books"
subfolder contains one file per previously opened book, and in that file
are the configuration of the Accounts panel (e.g. columns, sorting) and,
the tabs that should be opened when the book is opened. I'm pretty sure
your choices on File » Preferences are stored there too.

Make sure GC is closed when you copy %APPDATA%\GnuCash from your old PC.
Since you've already opened GC on your new PC, there will be a file in
"books" for it. It's safe to overwrite that file with the one from the
old PC, because it does not contain any of your accounting data. So your
simplest procedure is:

1. Delete the entire %APPDATA%\GnuCash folder (including subfolders) on
the new PC.
2. Copy the entire %APPDATA%\GnuCash folder (including subfolders) from
your old PC to your new one.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Copying report formats to new PC

[Rich Stanton]

Thanks for that, while checking your suggestions I realised that the GCM file 
hadn't been copied over properly. Copying that fixed the issue, Thanks!

Rich



On 14/08/2023 18:14:04, Murugan Muruganandam  wrote:
Richard

Can you check the file named saved-reports-2.x   has your custom changes.
Check the userconfig directory in the new machine, you can see th same from 
Help -> About



Saludos Cordiales

Murugan

From: gnucash-user 
 on behalf of 
Richard Stanton 
Sent: Monday, August 14, 2023 12:43 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Copying report formats to new PC
 
Hi,

I'm moving GNUCash to a new PC. I've moved the data files, but I've also got a 
bunch of customised graphs that open by default when I open that file. When I 
open the file on the new PC, those are missing. I've googled, and as a result 
have tried copying the files located at users\username\appdata\roaming\gnucash, 
but that hasn't helped. Obviously there's some extra data/preferences stored 
elsewhere, but I can't seem to find the info?

I'm on GNUCash 5.3 on both PCs, and windows 11 on both.

Thanks,

Rich
[d14fcb23-8f58-4585-a6d1-d6c95a1dea1d]
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
[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.

[93f03d10-f696-4776-a326-a343b78b819e]
___
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] Copying report formats to new PC

[Murugan Muruganandam]

Richard

Can you check the file named saved-reports-2.x   has your custom changes.
Check the userconfig directory in the new machine, you can see th same from 
Help -> About




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Richard Stanton 
Sent: Monday, August 14, 2023 12:43 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Copying report formats to new PC

Hi,

I'm moving GNUCash to a new PC. I've moved the data files, but I've also got a 
bunch of customised graphs that open by default when I open that file. When I 
open the file on the new PC, those are missing. I've googled, and as a result 
have tried copying the files located at users\username\appdata\roaming\gnucash, 
but that hasn't helped. Obviously there's some extra data/preferences stored 
elsewhere, but I can't seem to find the info?

I'm on GNUCash 5.3 on both PCs, and windows 11 on both.

Thanks,

Rich
[d14fcb23-8f58-4585-a6d1-d6c95a1dea1d]
___
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] Consolidation of family member accounts

[James Thomas]

I’m not sure why you’re maintaining separate books for each family member
but it occurs to me that, rather than keeping them separate and having
trouble combining when you want, you might try keeping all the accounts
together but giving each a different name (perhaps just add each  family
member’s initials before each account name). Then you could produce
statements which included only those accounts pertaining to one entity at a
time.

You could even make each entity account subsidiary to its master account
which (the master accounts) would then be the sum of all combined and could
be displayed exclusively in the combined entity statements.

Without trying it myself I’m not sure how many challenges might arise out
of this but it might be worth giving a shot.

Jim Thomas

On Mon, Aug 14, 2023 at 10:48 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
>
> > As I have replied to Liz and addressing your valid point, i am
> maintaining three separate books for each one of us, independent to each
> other. And that is why I raised a query how I can combine or consolidate
> three books to create one virtual book which I would call a family book.
> >
> When I suggested a spreadsheet application (instead of paper) to add up
> the components of individual family members to get a family totals
> report I was not meaning to imply that you could not use gnucash for
> that. I make a lot of use of gnucash for "virtual entities". But that is
> mainly when "sort of like a real entity" so you want the usual reports
> "as if it were a real entity".
>
> Thus when our "solar system" in effect "pays" an electric bill on my
> behalf (we are a "net billing" state)  treated as if this "business"
> received income (no money has changed hands) and when SRECs it generated
> were sold, gets credited for money I received (not it) and debited for
> the tax liability I incurred from that. Similarly, while it was (still)
> paying off the initial loan, implied interest was an expense, its share
> of the property insurance premium, etc. WHY do this? To correctly be
> able to determine when this "investment" paid off (as opposed to the
> over simplified examples they show you which assume interest rates are
> zero and no "other" expenses are incurred) . In other words, when the
> initial loan had been paid off in full (out of its net income) THAT the
> correct date of being paid off. Currently building a "repair and
> replacement" fund.
>
> However, not going to advise "how to" (set up books for virtual
> entities). If you need help, you shouldn't be trying this
>
> Michael D Novack
>
>
> ___
> 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.
>
-- 
Sent from Gmail Mobile (my iPhone)
___
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] Update F::Q in flatpak GC?

[john]

> On Aug 14, 2023, at 04:33, rsbrux via gnucash-user  
> wrote:
> 
> I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.
> 
> The included F::Q version is 1..56, which I have modified with the Yahoo as 
> JSON patch already published to this mailing list.
> 
> However, it looks as though the current F::Q release, 1.58, includes quite a 
> few fixes for various sources.
> 
> The last I heard,  it wasn't possible to update F::Q within a flatpak 
> installation of GC.  Is that still the case?
> 
> If so, when can a flatpak update of GC containing F::Q 1.58 be expected?
> 
> If not, how can I update F::Q within my flatpak installation?

The update will be available when someone (probably I) have time to update the 
F::Q module in gnucash-on-flatpak. That update will be immediately available in 
nightly builds; it won't be available on Flathub until the regular release at 
the end of September.

It's not possible to use CPAN, and consequently gnc-fq-update, in the flatpak, 
but you can do it manually similarly to the way you applied the yahoo_json 
patch: Download and untar the release tarball or clone the repo then copy 
Quote.pm and the contents of Quote/ into the right places in your flatpak.

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.

[GNC] Copying report formats to new PC

[Richard Stanton]

Hi,

I'm moving GNUCash to a new PC. I've moved the data files, but I've also got a 
bunch of customised graphs that open by default when I open that file. When I 
open the file on the new PC, those are missing. I've googled, and as a result 
have tried copying the files located at users\username\appdata\roaming\gnucash, 
but that hasn't helped. Obviously there's some extra data/preferences stored 
elsewhere, but I can't seem to find the info?

I'm on GNUCash 5.3 on both PCs, and windows 11 on both.

Thanks,

Rich
[d14fcb23-8f58-4585-a6d1-d6c95a1dea1d]
___
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] how to search for transactions with new line character in description?

[Lipp F.]

When doing paste into a transaction description field, special characters
are stored "as is". I need to find a way to delete all these special
characters.

Can you guys recommend a proper way? 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.

Re: [GNC] Consolidation of family member accounts

[Paras Desai]

Thanks for a sharing fundamental understanding of accounting, that too coming 
from a person who seems to have actually done booking keeping with pen and 
paper is a real treat. 


It crossed my mind to treat family members as partners but it would have been 
more complicated than maintaining individual and independent books for every 
member.

Yes, when I raised question about consolidation, i had in my mind that singular 
entity (I do work for a public limited entity having few subsidiary)  and i was 
kind of trying to mimic the consolidation done between such entities by 
elimination of inter company transaction.

But I will stick with your suggestion to use equity account to post "within 
family" transaction. That is the cleanest way and future ready way.

Thanks again.

With my best regards

Paras

Get Outlook for Android

From: Michael or Penny Novack 
Sent: Monday, August 14, 2023 7:36:06 PM
To: Paras Desai 
Cc: gnucash-user@gnucash.org 
Subject: Re: Consolidation of family member accounts


>
> Generally, I consider equity as a holy account, as it is a result of
> all we do with all other accounts, but this case could be an exception.

That's a misunderstanding of equity coming from the (very common)
special case of "sole" entities. But say, for example, the entity were a
partnership. Then under equity would be the accounts representing the
shares of the partners. And let's say a partner took a "draw" (or in
reverse, made an increase to their investment). Then "cash" would be one
side of the transaction and THEIR equity share the other side.

And of course, back in the days of pen and ink on paper when we did an
actual "close the books" every so often, just like accounts of type
"income" and "expense" are really temporary accounts of fundamental type
equity*, there would be other temporary accounts under equity. Notably
"profit and loss" because the income and expense accounts would first be
closed into that account and then it closed to equity by the net gain of
loss amount << and that account would be the "profit and loss" report >>

IF you were insisting on keeping just one set of books for the family
(but all having their own banks accounts, income, expenses, some
individual and some shared, all doing their own tax reporting, etc.) it
COULD be done using gnucash. But I would strongly suggest you first had
a good understanding about accounting for partnerships, especially
professional partnerships (where partners have income and expenses
considered just theirs as well as income and expenses shared -- often
law firms like this).

Michael D Novack

* Notice that if accounts of type income and expense were actually in
the tree under equity (as opposed to having their own top levels) then
the fundamental equation assets = liabilities + equity remains true in
its simplest form.


___
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] Consolidation of family member accounts

[Michael or Penny Novack]

As I have replied to Liz and addressing your valid point, i am maintaining 
three separate books for each one of us, independent to each other. And that is 
why I raised a query how I can combine or consolidate three books to create one 
virtual book which I would call a family book.

When I suggested a spreadsheet application (instead of paper) to add up 
the components of individual family members to get a family totals 
report I was not meaning to imply that you could not use gnucash for 
that. I make a lot of use of gnucash for "virtual entities". But that is 
mainly when "sort of like a real entity" so you want the usual reports 
"as if it were a real entity".


Thus when our "solar system" in effect "pays" an electric bill on my 
behalf (we are a "net billing" state)  treated as if this "business" 
received income (no money has changed hands) and when SRECs it generated 
were sold, gets credited for money I received (not it) and debited for 
the tax liability I incurred from that. Similarly, while it was (still) 
paying off the initial loan, implied interest was an expense, its share 
of the property insurance premium, etc. WHY do this? To correctly be 
able to determine when this "investment" paid off (as opposed to the 
over simplified examples they show you which assume interest rates are 
zero and no "other" expenses are incurred) . In other words, when the 
initial loan had been paid off in full (out of its net income) THAT the 
correct date of being paid off. Currently building a "repair and 
replacement" fund.


However, not going to advise "how to" (set up books for virtual 
entities). If you need help, you shouldn't be trying this


Michael D Novack


___
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] Consolidation of family member accounts

[Michael or Penny Novack]

Generally, I consider equity as a holy account, as it is a result of 
all we do with all other accounts, but this case could be an exception.


That's a misunderstanding of equity coming from the (very common) 
special case of "sole" entities. But say, for example, the entity were a 
partnership. Then under equity would be the accounts representing the 
shares of the partners. And let's say a partner took a "draw" (or in 
reverse, made an increase to their investment). Then "cash" would be one 
side of the transaction and THEIR equity share the other side.


And of course, back in the days of pen and ink on paper when we did an 
actual "close the books" every so often, just like accounts of type 
"income" and "expense" are really temporary accounts of fundamental type 
equity*, there would be other temporary accounts under equity. Notably 
"profit and loss" because the income and expense accounts would first be 
closed into that account and then it closed to equity by the net gain of 
loss amount << and that account would be the "profit and loss" report >>


IF you were insisting on keeping just one set of books for the family 
(but all having their own banks accounts, income, expenses, some 
individual and some shared, all doing their own tax reporting, etc.) it 
COULD be done using gnucash. But I would strongly suggest you first had 
a good understanding about accounting for partnerships, especially 
professional partnerships (where partners have income and expenses 
considered just theirs as well as income and expenses shared -- often 
law firms like this).


Michael D Novack

* Notice that if accounts of type income and expense were actually in 
the tree under equity (as opposed to having their own top levels) then 
the fundamental equation assets = liabilities + equity remains true in 
its simplest form.



___
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] Update F::Q in flatpak GC?

[rsbrux via gnucash-user]

I am running GC 5.3+ as a flatpak under Ubuntu  Studio 22.04 LTS.

The included F::Q version is 1..56, which I have modified with the Yahoo 
as JSON patch already published to this mailing list.


However, it looks as though the current F::Q release, 1.58, includes 
quite a few fixes for various sources.


The last I heard,  it wasn't possible to update F::Q within a flatpak 
installation of GC.  Is that still the case?


If so, when can a flatpak update of GC containing F::Q 1.58 be expected?

If not, how can I update F::Q within my flatpak installation?

___
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] Consolidation of family member accounts

[G R Hewitt]

I'm coming late to this party I know, but what about looking at it from
another angle.
Suppose you run the 'Family' [cue 'Godfather' theme] as a business and each
of you is a customer?
All the in's and out's would be visible in each customer's account making
it easy to keep track, and all
the heavy lifting would be done between a single set of nominal accounts,
providing the balance sheet and P reports
to show the status of the family's financial state. Were a 'customer' to
leave it's a simple matter to close out the account
with a payment transfer in or out.


On Mon, 14 Aug 2023 at 04:51, Paras Desai  wrote:

> Hello Stan
>
> Thanks for your response.
>
> As I have replied to Liz and addressing your valid point, i am maintaining
> three separate books for each one of us, independent to each other. And
> that is why I raised a query how I can combine or consolidate three books
> to create one virtual book which I would call a family book.
>
> Your and Liz point is absolutely correct and fortunately I am following
> the same.
>
> Thanks a lot
>
> With my best regards
>
> Paras
>
>
>
>
> Get Outlook for Android
> 
> From: Stan Brown 
> Sent: Monday, August 14, 2023 9:04:48 AM
> To: gnucash-user@gnucash.org 
> Cc: Paras Desai 
> Subject: Re: [GNC] Consolidation of family member accounts
>
> On 2023-08-13 20:16, Paras Desai wrote:
> > Your idea of debiting equity is good. May need to create a sub account
> of equity  specifically to capture related party transaction (as they call
> in legal parlance ).
>
> Well, that's one possibility. Another would be to have a placeholder
> account, "Family Equity", with three subaccounts for the three of you.
> (No transactions to a placeholder account can be made directly.
> Transactions are always made to a subaccount. In reports, you can set
> placeholder accounts to have value equal to the total of their
> subaccount values.)
>
> Please understand, however, that your question is not really a question
> about GnuCash. GC is just the old pen-and-ink accounting translated to
> computer files. The question of how to structure a transaction has the
> same answer in GC as it would have if you were making pen-and-ink
> transactions in one of those old leatherbound journals.
>
> I didn't see you respond to the person who suggested that you should
> perhaps have a separate book for each of the three of you. As that
> person suggested, if you have everything in one book, when your son
> leaves to establish his own household, it may be significant work to
> separate his affairs for yours. The same is true if you and your wife
> should ever establish separate households, or if one of you should
> predecease the other.
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.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
> -
> 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.