Re: [GNC] Two Instances as opposed to two separate files

[edodd]

On Fri, 14 Jul 2023 20:02:21 -0500
R Losey  wrote:

> Actually, when a conversation has mixed before-and-after comments, it
> is pretty hard to follow. I don't know if there is a standard for how
> to reply to the list, but it would be good if we would use the same
> one.

I can never see that happening, so I don't worry about it.
Liz (Moderator hat)
___
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] Two Instances as opposed to two separate files

[edodd]

On Fri, 14 Jul 2023 12:49:25 +0100
Paul Feakins  wrote:

> Anyway, why go as complicated as having a shortcut to the GnuCash 
> executable with an argument?
> 
> Not not have your shortcuts to the data files themselves and the OS
> will know to use GnuCash to open them.

Using Debian and Xfce4, it is just as simple to make the shortcuts with
the /usr/bin/gnucash executable and the data file also in the shortcut.

Of course Mac doesn't know how to open a file in Gnucash, so that
remains different.

Liz
___
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] Finance::Quote 1.57_01 - YahooJSON Quick Fix

[Bruce Schuck]

Greetings,

A beta pre-release for F::Q v1.58 has been uploaded to CPAN. It has the 
quick fix I noted in the earlier "Yahoo Closed the Door on Finance API" 
thread.


Not a production indexed release, you can install it using CPAN.


$ cpan BPSCHUCK/Finance-Quote-1.57_01.tar.gz

or

$ cpanm BPSCHUCK/Finance-Quote-1.57_01.tar.gz

or

$ perl -MCPAN -e shell
cpan> install BPSCHUCK/Finance-Quote-1.57_01.tar.gz

For those who have been trying the YahooJSON currency rates module, that 
was also fixed.


And now to relax and start the weekend with Johnnie Walker Black on ice.

Bruce S.
___
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] Two Instances as opposed to two separate files

[William Prescott]

Just to be a devil's advocate...
The advantage of top posting is that the new addition to the thread is obvious. 
With bottom posting, the new reply appears in the middle of the message, often 
with text both above and below it.

Probably because of the default behavior of many email clients, most email 
chains I see are top posted. This forum is the only place where I commonly see 
bottom posting.

To quote from Wikipedia on the subject:
"For a long time the traditional style was to post the answer below as much of 
the quoted original as was necessary to understand the reply (bottom or 
inline). Many years later, when email became widespread in business 
communication, it became a widespread practice to reply above the entire 
original and leave it (supposedly untouched) below the reply.
While each online community  
differs on which styles are appropriate or acceptable, within some communities 
the use of the "wrong" method risks being seen as a breach of netiquette 
, and can provoke vehement response 
from community regulars."


Personally, I'm neutral. Either is fine with me.

Will

On 14 Jul 2023, at 19:17, Stan Brown  wrote:

> On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins 
> wrote:
>> With a mailing list such as this, I believe the convention is to put
>> replies at the bottom?

On 2023-07-14 17:56, R Losey wrote:
> Is there really a convention for replies? Gmail puts my replies at the top
> by default (like this), but if they are supposed to be at the bottom, I can
> pretty easily do that as well. But I haven't seen a FAQ or heard that this
> is a convention.

It is a long-standing convention, predating computers, that the response
comes after the thing being responded to. (That's unless you're a
contestant on Jeopardy, of course.)

Without even considering everybody's _other_ email, there are multiple
topics on the GC mailing list, and few people can keep all of that in
their heads. Some brief context (usually _not_ a full quote of the
article) is helpful before making one's response. To me it seems like
basic courtesy for the writer to consider the convenience of the
readers, who outnumber the writer manyfold.

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.

Re: [GNC] Yahoo Closed the Door on Finance API

[Bruce Schuck]

At 07/14/2023 at 1958 EDT, WR D wrote:


Thanks for this - the yahooweb source worked for retrieving
crypto-AUD exchange rates too.


At 07/14/2023 at 08:50:29 EDT, Bart A.J. Seesing wrote:


The latest release of F::Q (1.57) contains a new YahooWeb module
that still works, at least for my selection of European ETFs. Install
that release if you haven't done so already, go to Tools > Security
Editor, edit your security, change 'Type of source quote' to
'Unknown', and select 'yahooweb' from the dropdown list.
Just note there is currently a caveat for the YahooWeb module. The trade 
date is not available (at least not without JavaScript). The date 
returned is the date the data is retrieved unless it's a weekend, in 
which case it will be set to the previous Friday.


A recent web based URL with the trade date has been identified, but the 
module has not yet been modified to use it. Other modules that work 
without requiring an API key (at least for US exchanges) are Fool 
(fool), GoogleWeb (googleweb), and MarketWatch (marketwatch).


Thank you.

Bruce S.
___
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] Two Instances as opposed to two separate files

[Stan Brown]

> On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins 
> wrote:
>> With a mailing list such as this, I believe the convention is to put
>> replies at the bottom?

On 2023-07-14 17:56, R Losey wrote:
> Is there really a convention for replies? Gmail puts my replies at the top
> by default (like this), but if they are supposed to be at the bottom, I can
> pretty easily do that as well. But I haven't seen a FAQ or heard that this
> is a convention.

It is a long-standing convention, predating computers, that the response
comes after the thing being responded to. (That's unless you're a
contestant on Jeopardy, of course.)

Without even considering everybody's _other_ email, there are multiple
topics on the GC mailing list, and few people can keep all of that in
their heads. Some brief context (usually _not_ a full quote of the
article) is helpful before making one's response. To me it seems like
basic courtesy for the writer to consider the convenience of the
readers, who outnumber the writer manyfold.

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] Two Instances as opposed to two separate files

[Stephen M. Butler]

I saw this in an email exchange a few years back that can be summarized as:

A3: Then you get email chains like this.

Q3: But I prefer to top post to see what was entered last!


A2: So the response makes sense after reading the relevant question.

Q2: Why bottom post?


A1: Please use bottom posting.

Q1: Do we top or bottom post?



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 7/14/23 17:56, R Losey wrote:

Is there really a convention for replies? Gmail puts my replies at the top
by default (like this), but if they are supposed to be at the bottom, I can
pretty easily do that as well. But I haven't seen a FAQ or heard that this
is a convention.


On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins  wrote:


With a mailing list such as this, I believe the convention is to put
replies at the bottom?


--

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

___
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] Two Instances as opposed to two separate files

[R Losey]

Actually, when a conversation has mixed before-and-after comments, it is
pretty hard to follow. I don't know if there is a standard for how to reply
to the list, but it would be good if we would use the same one.


On Fri, Jul 14, 2023 at 3:11 PM David H  wrote:

> No-one really cares any more - top posting saves scrolling through rows of
> someone else's opinion sometimes and gmail doesn't make it easy :-)
>
> Cheers David H.
>
> --
_
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] Two Instances as opposed to two separate files

[R Losey]

On Fri, Jul 14, 2023 at 11:31 AM kschneider bout-tyme.net <
kschnei...@bout-tyme.net> wrote:

>
>
> > On Jul 14, 2023, at 12:20 PM, David Carlson 
> wrote:
> >
> > Nope, Ctrl-End doesn't move the curser at all in a Gmail reply-all
> window.
>
> Then just hi-lite the part you want to reply to before hitting
> reply-to-all. It’s wha I did here.
>
> Ken Schneider


Note that this doesn't work on macOS using the web-based gmail version; it
still quotes everything. Thunderbird is great, and only copies what you
highlight.

-- 
_
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] Two Instances as opposed to two separate files

[R Losey]

Is there really a convention for replies? Gmail puts my replies at the top
by default (like this), but if they are supposed to be at the bottom, I can
pretty easily do that as well. But I haven't seen a FAQ or heard that this
is a convention.


On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins  wrote:

> With a mailing list such as this, I believe the convention is to put
> replies at the bottom?
>
>
> --
_
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] Yahoo Closed the Door on Finance API

[WR D]

Thanks for this - the yahooweb source worked for retrieving crypto-AUD exchange 
rates too.

Regards,
Bill


-Original Message-
From: gnucash-user  On 
Behalf Of Bart A.J. Seesing via gnucash-user
Sent: Friday, 14 July 2023 10:50 PM
To: rsb...@yahoo.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Yahoo Closed the Door on Finance API

The latest release of F::Q (1.57) contains a new YahooWeb module that still 
works, at least for my selection of European ETFs. Install that release if you 
haven't done so already, go to Tools > Security Editor, edit your security, 
change 'Type of source quote' to 'Unknown', and select 'yahooweb' from the 
dropdown list.

Sincerely,
B

--

Date: Fri, 14 Jul 2023 10:49:27 +0200
From: "rsbrux"
To:
Subject: [GNC] Yahoo Closed the Door on Finance API
Message-ID:



Content-Type: text/plain;   charset="UTF-8"

Any suggestions as to what would be the next best currently available source in 
F::Q for a broad spectrum of securities, especially European stocks?

--

Some of us suspected this would come, getting reports of the Yahoo 
URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
  now returning a 404 (v11) or "Unauthorized" (v10).

Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) 
is going to be removed from Finance::Quote in the next release. This is not to 
say that if someone can figure out a way to successfully access 
Yahoo'shttps://query2.finance.yahoo.com/v?... APIs, please pass on that info or 
better yet, have a go at reworking the current module.

There is already an issue raised on F::Q's 
GitHub,https://github.com/finance-quote/finance-quote/issues/318. Please 
refrain from "me too" comments. Unfortunately as I said in the previous 
paragraph, this issue will likely be resolved by removing the module.

Bruce S.

--

___
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] Two Instances as opposed to two separate files

[David H]

Reposting to the list as it seems to have been directed solely at me, sorry
about the top posting :-)

Regards David H.


On Sat, 15 Jul 2023 at 06:39, Chris Green  wrote:

> On Sat, Jul 15, 2023 at 06:10:37AM +1000, David H wrote:
> > No-one really cares any more - top posting saves scrolling through rows
> of
> > someone else's opinion sometimes and gmail doesn't make it easy :-)
> >
> The whole point of bottom posting is that you also remove all the bits
> you don't want, just leaving the bit you are replying to.
>
> Even more important is if you are replying to a post which has several
> questions in it, you reply to each question under the question.
>
>
> A: Because it messes up the order in which people normally read text.
> Q: Why is top-posting such a bad thing?
> A: Top-posting.
> Q: What is the most annoying thing in e-mail?
>
> --
> Chris Green
>
___
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] Yahoo Closed the Door on Finance API

[Bruce Schuck]

On 07/14/23 at 00:14 EDT, Bruce S wrote:

Some of us suspected this would come, getting reports of the Yahoo 
URLs


> 
https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics



and


> 
https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics



now returning a 404 (v11) or "Unauthorized" (v10).
For those comfortable with locating and editing the YahooJSON.pm module 
manually I have a quick fix. If you have F::Q v1.57 change the lines 
defining $YIND_URL_HEAD and $YIND_URL_TAIL (lines 38 and 39) to:


my $YIND_URL_HEAD = 
'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=';

my $YIND_URL_TAIL = '&modules=price,summaryDetail,defaultKeyStatistics';

Or you can wait for new release to be pushed to CPAN.

On 07/14/13:43 EDT, Tom T replied:

> The YahooWeb module mostly works for me except for some reason it
> gives a ridiculously high value for AT&T (call sign T).

Interesting. It also returns a bad value for Genpact Limited (G), but 
not Hyatt Hotels (H). Will need to open an issue and hopefully Vincent 
(who originally wrote the YahooWeb module) will take a look.


Thanks all.

Bruce S.
___
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] Two Instances as opposed to two separate files

[David H]

No-one really cares any more - top posting saves scrolling through rows of
someone else's opinion sometimes and gmail doesn't make it easy :-)

Cheers David H.


On Fri, 14 Jul 2023 at 21:50, Paul Feakins  wrote:

> On 14/07/2023 12:34, Fross, Michael wrote:
> > I  run multiple instances at the same time, but you have to open
> > different data files. I’d keep them in different directories to be tidy.
> >
> > I have two different icons each with a different name of the data file
> > as an argument.
> >
> > There is a an argument to not auto open the last file(no -file?). I’m
> > not near my computer.
> >
> > As a note, I don’t change any settings that are program wide with both
> > running.
> >
> > Michael
> >
> With a mailing list such as this, I believe the convention is to put
> replies at the bottom?
>
> Anyway, why go as complicated as having a shortcut to the GnuCash
> executable with an argument?
>
> Not not have your shortcuts to the data files themselves and the OS will
> know to use GnuCash to open them.
>
> Paul Feakins.
>
> ___
> 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] Unable to open GnuCash file: "No suitable backend was found for ."

[Tomer Altman]

On 7/14/23 12:15 PM, john wrote:



On Jul 13, 2023, at 23:52, Tomer Altman  wrote:

On 7/13/23 8:55 AM, john wrote:



On Jul 13, 2023, at 01:34, Tomer Altman  wrote:

On 7/12/23 6:26 PM, john wrote:



On Jul 12, 2023, at 16:16, Tomer Altman  wrote:

Hi everyone,

Due to filesystem errors, I had to reinstall MacOS on my 2015 Macbook Air 
(current OS version: Monterey 12.6.7). After doing so, and restoring my files 
from a TimeMachine backup using Migration Assistant, I started getting this 
error when trying to open my accounting file:

"No suitable  backend was found for ."

(where "" is a stand-in for the actual file name)

I was at the time using a version of GnuCash from December 2022. I then reinstalled using 
the installer available from gnucash.org (current version: "5.3+(2023-06-26)" 
). Unfortunately, the error persists.

Looking at this error message in the mailing list archives, it seems like this 
has something to do with using the SQLite back-end. I looked at the 
'environment' text file, and it is implementing already the environment 
variable recommended as a fix:

GNC_DBD_DIR={SYS_LIB}/dbd

It seems like my install is still unable to find the libraries that it needs, 
though.

It's unclear to me how to diagnose which version of the back-end my file is 
using, since I cannot open it. Using 'file' and 'head' shows that it is not 
XML, and I am unable to decompress the file using Gzip. I'm also unable to open 
it using the sqlite3 command line tool.

So, two questions:

1. What's the correct way to verify the back-end type using something other 
than GnuCash itself?

2. What is wrong with my fresh install that is preventing me from opening up 
the file?

Thanks in advance for any and all advice and assistance!

If it's a SQLite file you can open it with sqlite3, provided by macOS. Just 
open Terminal and run
sqlite3 /path/to/my/gnucash/file
You can use the `.tables` command to list the tables and `.schema ` 
to show the structure and compare it with https://wiki.gnucash.org/wiki/SQL.

99% of the time when users report this problem it's because they're trying to 
open a log file or a .gcm file instead of their actual book.

Regards,
John Ralls


Hi John,

Thank you very much for taking the time to reply. I appreciate it.

I've tried doing what you are suggesting. Let's say that my "" name is 
"foo.gnucash". When I type the following:

sqlite3 foo.gnucash


.tables

I get:

"Error: file is not a database"

I thought to myself, "Perhaps the SQLite3 file was corrupted?" So I went to a 
TimeMachine backup of the directory from April (before any issues with my laptop), and 
copied over foo.gnucash to a temporary directory. This file would open successfully with 
GnuCash. Using the command line, I see that 'file' correctly identifies it as a gzip 
compressed file.

So it seems that this was an issue with the foo.gnucash file getting corrupted, 
perhaps from the filesystem errors that I was experiencing. Thanks for 
prompting me to debug this further. I'll restore my file using the *.gnucash 
backup files, and by adding in the relevant log files.

If I may be so bold as to suggest a UI improvement: Telling the user "No suitable backend was found for 
" implies that the file is fine, it's just that there's no back-end to support it. That 
impression was bolstered by the mailing list discussion of missing library paths. I'd suggest wording that 
makes it clear that the *FILE* is the issue, as in it's either the wrong type, or it is corrupted. Perhaps, 
" is not a recognized GnuCash formatted file."


Tomer,

Good that you sorted it. Note though that if it's gzip-compressed it's an XML 
file, not a sqlite3 database. Does `file` on the apparently corrupted gnucash 
file claim that it's a sqlite3 database?

Regards,
John Ralls



When I use the `file` command on the corrupted file, it just reports it as 
"data". It's a binary file, but not recognized as being in Gzip format.

OK, it probably lost some bits from its header, and maybe some other places 
too. Good thing that you have backups!

Regards,
John Ralls


Yes, TimeMachine backups, plus GnuCash's backup files, saved the day!

Thanks again for your help,

~Tomer

--
Please do not send me sensitive information (e.g., passwords, personal details, 
financial/health information) via email, as it is not secure.
Please contact me to determine the best way to transfer sensitive information 
safely. Thank you!

___
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] Unable to open GnuCash file: "No suitable backend was found for ."

[john]

> On Jul 13, 2023, at 23:52, Tomer Altman  wrote:
> 
> On 7/13/23 8:55 AM, john wrote:
>> 
>> 
>>> On Jul 13, 2023, at 01:34, Tomer Altman  wrote:
>>> 
>>> On 7/12/23 6:26 PM, john wrote:
 
 
> On Jul 12, 2023, at 16:16, Tomer Altman  wrote:
> 
> Hi everyone,
> 
> Due to filesystem errors, I had to reinstall MacOS on my 2015 Macbook Air 
> (current OS version: Monterey 12.6.7). After doing so, and restoring my 
> files from a TimeMachine backup using Migration Assistant, I started 
> getting this error when trying to open my accounting file:
> 
> "No suitable  backend was found for ."
> 
> (where "" is a stand-in for the actual file name)
> 
> I was at the time using a version of GnuCash from December 2022. I then 
> reinstalled using the installer available from gnucash.org (current 
> version: "5.3+(2023-06-26)" ). Unfortunately, the error persists.
> 
> Looking at this error message in the mailing list archives, it seems like 
> this has something to do with using the SQLite back-end. I looked at the 
> 'environment' text file, and it is implementing already the environment 
> variable recommended as a fix:
> 
> GNC_DBD_DIR={SYS_LIB}/dbd
> 
> It seems like my install is still unable to find the libraries that it 
> needs, though.
> 
> It's unclear to me how to diagnose which version of the back-end my file 
> is using, since I cannot open it. Using 'file' and 'head' shows that it 
> is not XML, and I am unable to decompress the file using Gzip. I'm also 
> unable to open it using the sqlite3 command line tool.
> 
> So, two questions:
> 
> 1. What's the correct way to verify the back-end type using something 
> other than GnuCash itself?
> 
> 2. What is wrong with my fresh install that is preventing me from opening 
> up the file?
> 
> Thanks in advance for any and all advice and assistance!
 
 If it's a SQLite file you can open it with sqlite3, provided by macOS. 
 Just open Terminal and run
sqlite3 /path/to/my/gnucash/file
 You can use the `.tables` command to list the tables and `.schema 
 ` to show the structure and compare it with 
 https://wiki.gnucash.org/wiki/SQL.
 
 99% of the time when users report this problem it's because they're trying 
 to open a log file or a .gcm file instead of their actual book.
 
 Regards,
 John Ralls
 
>>> Hi John,
>>> 
>>> Thank you very much for taking the time to reply. I appreciate it.
>>> 
>>> I've tried doing what you are suggesting. Let's say that my "" name 
>>> is "foo.gnucash". When I type the following:
>>> 
>>> sqlite3 foo.gnucash
>>> 
>>> > .tables
>>> 
>>> I get:
>>> 
>>> "Error: file is not a database"
>>> 
>>> I thought to myself, "Perhaps the SQLite3 file was corrupted?" So I went to 
>>> a TimeMachine backup of the directory from April (before any issues with my 
>>> laptop), and copied over foo.gnucash to a temporary directory. This file 
>>> would open successfully with GnuCash. Using the command line, I see that 
>>> 'file' correctly identifies it as a gzip compressed file.
>>> 
>>> So it seems that this was an issue with the foo.gnucash file getting 
>>> corrupted, perhaps from the filesystem errors that I was experiencing. 
>>> Thanks for prompting me to debug this further. I'll restore my file using 
>>> the *.gnucash backup files, and by adding in the relevant log files.
>>> 
>>> If I may be so bold as to suggest a UI improvement: Telling the user "No 
>>> suitable backend was found for " implies that the file is fine, it's 
>>> just that there's no back-end to support it. That impression was bolstered 
>>> by the mailing list discussion of missing library paths. I'd suggest 
>>> wording that makes it clear that the *FILE* is the issue, as in it's either 
>>> the wrong type, or it is corrupted. Perhaps, " is not a recognized 
>>> GnuCash formatted file."
>>> 
>> 
>> Tomer,
>> 
>> Good that you sorted it. Note though that if it's gzip-compressed it's an 
>> XML file, not a sqlite3 database. Does `file` on the apparently corrupted 
>> gnucash file claim that it's a sqlite3 database?
>> 
>> Regards,
>> John Ralls
>> 
>> 
> When I use the `file` command on the corrupted file, it just reports it as 
> "data". It's a binary file, but not recognized as being in Gzip format.

OK, it probably lost some bits from its header, and maybe some other places 
too. Good thing that you have backups!

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] Yahoo Closed the Door on Finance API

[Tom Teixeira]

The YahooWeb module mostly works for me except for some reason it gives 
a ridiculously high value for AT&T (call sign T). I switched that to 
"Motley Fool" which is a different screen scraping source under 'Type of 
source quote' 'Single'.


On 7/14/23 8:50 AM, Bart A.J. Seesing via gnucash-user wrote:
The latest release of F::Q (1.57) contains a new YahooWeb module that 
still works, at least for my selection of European ETFs. Install that 
release if you haven't done so already, go to Tools > Security Editor, 
edit your security, change 'Type of source quote' to 'Unknown', and 
select 'yahooweb' from the dropdown list.


Sincerely,
B

--

Date: Fri, 14 Jul 2023 10:49:27 +0200
From: "rsbrux"
To:
Subject: [GNC] Yahoo Closed the Door on Finance API
Message-ID:
 



Content-Type: text/plain;    charset="UTF-8"

Any suggestions as to what would be the next best currently available 
source in F::Q for a broad spectrum of securities, especially European 
stocks?


--

Some of us suspected this would come, getting reports of the Yahoo 
URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics 

andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics 
now returning a 404 (v11) or "Unauthorized" (v10).


Sorry to say this, but more than likely the YahooJSON module (aka 
yahoo_json) is going to be removed from Finance::Quote in the next 
release. This is not to say that if someone can figure out a way to 
successfully access Yahoo'shttps://query2.finance.yahoo.com/v?... 
APIs, please pass on that info or better yet, have a go at reworking 
the current module.


There is already an issue raised on F::Q's 
GitHub,https://github.com/finance-quote/finance-quote/issues/318. 
Please refrain from "me too" comments. Unfortunately as I said in the 
previous paragraph, this issue will likely be resolved by removing the 
module.


Bruce S.

--

___
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] Fw: Finance::Quote terminal commands not working with Flatpak v:5.3 install

[doug brown via gnucash-user]

 Old dog learning new tricks comes hard: I forgot to cc the mailing list in my 
reply  to the valuable information Geert shared so this is to rectify that 
omission.
Also, it occurs to me that it would be very useful if somebody who knows how to 
edit the Gnucash Wiki could put a link in the Online Quotes page, Section 3 
(https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface) pointing 
to the Flatpak page on Using Command Line Tools 
(https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools) which 
documents the information that Geert supplied me.
Cheers,doug

 

   - Reply - From: doug brown To: Geert Janssens 
Sent: Tuesday, July 11, 2023 at 02:45:37 PM 
GMT-7Subject: Re: Re: [GNC] Finance::Quote terminal commands not working with 
Flatpack v:5.3 install
 Thanks Geert-
This works! The whole topic of flatpack is  a complete mystery to me that I'm 
not sure I have the motivation to unravel.
One small error in the code line you sent. The  option keyword needs to 
be preceded with a double dash as follows:
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes dump

and dump requires some  arguements.
Thanks again.
Cheers,doug 

On Tuesday, July 11, 2023 at 08:30:29 AM GMT-7, Geert Janssens 
 wrote:  
 
 
Hi Doug,


For the flatpak edition of gnucash the command to fetch quotes is slightly more 
complex:


flatpak run --command=gnucash-cli org.gnucash.GnuCash -quotes dump


This boils down to the following components:

- flatpak run  org.gnucash.GnuCash

  => indicate you want to execute a command in the org.gnucash.GnuCash sandbox

 without any further options, this will run the default command in that

 sandbox, which is "gnucash"

- --command=gnucash-cli

  => indicate you don't want to run the default command, but gnucash-cli

 instead

- -quotes dump

  => the arguments to pass to the command to run


Regards,


Geert


Op dinsdag 11 juli 2023 16:13:37 CEST schreef doug brown via gnucash-user:

> I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the

> terminal commands that I previously used to find sources for quotes on

> longer work.  Here is the output: doug@sager:~$ gnucash-cli --quotes dump

> yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump

> -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed

> with:sudo apt install gnucash Any thoughts?

> 

> 

> 

> ___

> 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] Two Instances as opposed to two separate files

[kschneider bout-tyme . net]

> On Jul 14, 2023, at 12:20 PM, David Carlson  
> wrote:
> 
> Nope, Ctrl-End doesn't move the curser at all in a Gmail reply-all window.

Then just hi-lite the part you want to reply to before hitting reply-to-all. 
It’s wha I did here.

Ken Schneider 
___
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] Two Instances as opposed to two separate files

[Paul Feakins]

On 14/07/2023 17:19, David Carlson wrote:

Nope, Ctrl-End doesn't move the curser at all in a Gmail reply-all window.


It does but you have to click the 3 dots to expand the previous 
conversations first.


Also on Apple it would be the Apple key and End.

Paul Feakins.

___
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] Two Instances as opposed to two separate files

[David Carlson]

Nope, Ctrl-End doesn't move the curser at all in a Gmail reply-all window.

On Fri, Jul 14, 2023 at 10:53 AM Stan Brown 
wrote:

>
> On 2023-07-14 05:15, David Carlson wrote:
> > You brought up something that I have not been able to solve: namely
> > replying at the bottom in Gmail
> > I gave up on that years ago.
> >  Is there a way to configure Gmail to do that?
>
> Pressing Ctrl+End (or the equivalent in your OS) doesn't just take you
> to the end of the composition window?
>
> In any case, just quoting the entire previous email is usually
> suboptimal. It's more helpful to readers if you quote only enough to
> establish the context of your reply.
>
> And of course there's never a good reason to quote the GC mailing list
> footer -- the mailserver is not smart enough to sense that, so you end
> up with multiple copies of the footer in the message you compose.
>
> 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] Two Instances as opposed to two separate files

[kschneider bout-tyme . net]

> On Jul 14, 2023, at 4:05 AM, Paul Feakins  wrote:
> 
> 
>> 
>>> 
 Question about a matter of setup.  I use Windows 11 - so
 answers/information specific to that OS would be appreciated.
 
 First - can two instances of the program be loaded (exist in the system)
 such that one instance opens a personal file and one opens a business file?
 Second - if answer to question one is yes - is this a preference you can
 set and are there advantages to doing it?
 Third - if answer to question one is no - then is the only way to have
 two separate data files is to load the program and force load the specific
 file you want since the program always default opens to the last file you
 dealt with?
 
 Answers, opinions and other information welcomed.  Thanks!  -- Ken
> 
> I think you're overcomplicating this.
> 
> If you want to load a specific .gnucash file then double-click it.

You can’t do that on macOS, it doesn’t 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Two Instances as opposed to two separate files

[Stan Brown]

On 2023-07-14 05:15, David Carlson wrote:
> You brought up something that I have not been able to solve: namely
> replying at the bottom in Gmail
> I gave up on that years ago.
>  Is there a way to configure Gmail to do that?

Pressing Ctrl+End (or the equivalent in your OS) doesn't just take you
to the end of the composition window?

In any case, just quoting the entire previous email is usually
suboptimal. It's more helpful to readers if you quote only enough to
establish the context of your reply.

And of course there's never a good reason to quote the GC mailing list
footer -- the mailserver is not smart enough to sense that, so you end
up with multiple copies of the footer in the message you compose.

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] Two Instances as opposed to two separate files

[Michael or Penny Novack]

On 7/14/2023 1:14 AM, Ken Pyzik wrote:

Question about a matter of setup.  I use Windows 11 - so answers/information 
specific to that OS would be appreciated.

First - can two instances of the program be loaded (exist in the system) such 
that one instance opens a personal file and one opens a business file?
Second - if answer to question one is yes - is this a preference you can set 
and are there advantages to doing it?
Third - if answer to question one is no - then is the only way to have two 
separate data files is to load the program and force load the specific file you 
want since the program always default opens to the last file you dealt with?

Answers, opinions and other information welcomed.  Thanks!  -- Ken


First --- Best to treat as a "no". Not strictly speaking impossible, but 
leave this for pros who would not be needing to ask how to do it.


Third --- You can try following the suggestions from other how to do. 
But ONE way is to have gnucash start not opening any file (use the 
runtime parameter -nofile) and then select from the drop drop down list 
which you want opened (or specify the file explicitly, which you would 
do if more files than four). That is what those of us who are keeping 
the books for multiple entities are likely to do.


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] Two Instances as opposed to two separate files

[Paul Feakins]

On 14/07/2023 13:15, David Carlson wrote:

Paul,

You brought up something that I have not been able to solve: namely 
replying at the bottom in Gmail

I gave up on that years ago.
 Is there a way to configure Gmail to do that?


I use Google Suite with Thunderbird - it has the option, but it only 
applies to all emails and normal work emails I reply above the conversation.


So I just manually put my reply below on a list like this.

Paul Feakins.

___
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] Two Instances as opposed to two separate files

[Ken Pyzik]

Thanks to all who answered.  All answers/opinions were very good.   Honorable 
mention to David H. for the screen shot!  Thanks!

Ken

From: David H 
Sent: Friday, July 14, 2023 12:57 AM
To: Ken Pyzik 
Cc: Gnucash Users 
Subject: Re: [GNC] Two Instances as opposed to two separate files

Ken,

In case the shortcut idea wasn't clear - see pic below...  You can set the 
"Start in:" property to wherever your gnucash data file is located, mine is in 
C:\Users\\Documents\Gnucash\Data" as per the pic.  This saves adding a 
path to the file name you pass to Gnucash, and then just include the file name 
after the "Target:" as per example.

Cheers David H.

[cid:image001.png@01D9B618.9BB26390]

On Fri, 14 Jul 2023 at 17:44, David H 
mailto:hell...@gmail.com>> wrote:
Ken,

1. Don't think so
2. See 1.
3. Setup 2 shortcuts using the gnucash file name and probably the file path for 
each file then you can just double click on the appropriate shortcut.  If your 
file paths contain spaces you'll probably need double quotes around them.

Cheers David H.

On Fri, 14 Jul 2023 at 15:15, Ken Pyzik 
mailto:py...@outlook.com>> wrote:
Question about a matter of setup.  I use Windows 11 - so answers/information 
specific to that OS would be appreciated.

First - can two instances of the program be loaded (exist in the system) such 
that one instance opens a personal file and one opens a business file?
Second - if answer to question one is yes - is this a preference you can set 
and are there advantages to doing it?
Third - if answer to question one is no - then is the only way to have two 
separate data files is to load the program and force load the specific file you 
want since the program always default opens to the last file you dealt with?

Answers, opinions and other information welcomed.  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.

Re: [GNC] Yahoo Closed the Door on Finance API

[Bart A.J. Seesing via gnucash-user]

The latest release of F::Q (1.57) contains a new YahooWeb module that still works, 
at least for my selection of European ETFs. Install that release if you haven't 
done so already, go to Tools > Security Editor, edit your security, change 
'Type of source quote' to 'Unknown', and select 'yahooweb' from the dropdown list.

Sincerely,
B

--

Date: Fri, 14 Jul 2023 10:49:27 +0200
From: "rsbrux"
To:
Subject: [GNC] Yahoo Closed the Door on Finance API
Message-ID:



Content-Type: text/plain;   charset="UTF-8"

Any suggestions as to what would be the next best currently available source in 
F::Q for a broad spectrum of securities, especially European stocks?

--

Some of us suspected this would come, getting reports of the Yahoo 
URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
  now returning a 404 (v11) or "Unauthorized" (v10).

Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) 
is going to be removed from Finance::Quote in the next release. This is not to 
say that if someone can figure out a way to successfully access 
Yahoo'shttps://query2.finance.yahoo.com/v?... APIs, please pass on that info or 
better yet, have a go at reworking the current module.

There is already an issue raised on F::Q's 
GitHub,https://github.com/finance-quote/finance-quote/issues/318. Please refrain from 
"me too" comments. Unfortunately as I said in the previous paragraph, this 
issue will likely be resolved by removing the module.

Bruce S.

--

___
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] Two Instances as opposed to two separate files

[Chris Green]

On Fri, Jul 14, 2023 at 01:06:36PM +0100, Maf. King wrote:
> On Friday, 14 July 2023 12:34:28 BST Fross, Michael wrote:
> > I  run multiple instances at the same time, but you have to open different
> > data files. I’d keep them in different directories to be tidy.
> > 
> 
> I don't do it often, but have had occasion to have GC side-by-side on 2 data 
> files at the same time.
> 
> What I have done is start a 2nd instance of GC, let it warn me that the data 
> file is in use already, select open read-only then file-> open to the second 
> data file.  (I have 6 in regular use).  But I'm on Linux, don't know it that 
> would work the same on any WinOs flavour.
> 
> Agree 100% about keeping each data file in its own sub-directory, and about 
> not 
> changing prefs while 2 instances are running!
> 
I have quite a lot of separate GnuCash 'instances' where 'instance'
means a GnuCash data file (Sqlite database in my case).

I am a PCC (Parochial Church Council) treasurer, this requires me to
submit audited accounts to the Diocese each year.  It also requires
separate accounts for 'restricted' and 'unrestricted' funds. 
Restricted funds are those donations which have been specifically
given for the upkeep of our church building as opposed to being used
for general expenses.

I thus keep separate GnuCash data files for 'restricted' and
'unrestricted' in each financial year.  With a little bit of simple
scripting (this is Linux) I can go to any year's dirctory and simply
enter 'gnc' to see that year's current/unrestricted accounts and 'gnb'
to see the building/restricted accounts. I never have to mess about
changing the dates on reports to see different years, I never have to
explicitly specify which data file to use (because it's in the
directory for the year I'm looking at).

-- 
Chris Green
___
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] Two Instances as opposed to two separate files

[David Carlson]

Paul,

You brought up something that I have not been able to solve: namely
replying at the bottom in Gmail
I gave up on that years ago.
 Is there a way to configure Gmail to do that?

On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins  wrote:

> On 14/07/2023 12:34, Fross, Michael wrote:
> > I  run multiple instances at the same time, but you have to open
> > different data files. I’d keep them in different directories to be tidy.
> >
> > I have two different icons each with a different name of the data file
> > as an argument.
> >
> > There is a an argument to not auto open the last file(no -file?). I’m
> > not near my computer.
> >
> > As a note, I don’t change any settings that are program wide with both
> > running.
> >
> > Michael
> >
> With a mailing list such as this, I believe the convention is to put
> replies at the bottom?
>
> Anyway, why go as complicated as having a shortcut to the GnuCash
> executable with an argument?
>
> Not not have your shortcuts to the data files themselves and the OS will
> know to use GnuCash to open them.
>
> Paul Feakins.
>
> ___
> 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] Two Instances as opposed to two separate files

[Maf. King]

On Friday, 14 July 2023 12:34:28 BST Fross, Michael wrote:
> I  run multiple instances at the same time, but you have to open different
> data files. I’d keep them in different directories to be tidy.
> 

I don't do it often, but have had occasion to have GC side-by-side on 2 data 
files at the same time.

What I have done is start a 2nd instance of GC, let it warn me that the data 
file is in use already, select open read-only then file-> open to the second 
data file.  (I have 6 in regular use).  But I'm on Linux, don't know it that 
would work the same on any WinOs flavour.

Agree 100% about keeping each data file in its own sub-directory, and about not 
changing prefs while 2 instances are running!

HTH,
Maf.


___
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] Two Instances as opposed to two separate files

[Paul Feakins]

On 14/07/2023 12:34, Fross, Michael wrote:
I  run multiple instances at the same time, but you have to open 
different data files. I’d keep them in different directories to be tidy.


I have two different icons each with a different name of the data file 
as an argument.


There is a an argument to not auto open the last file(no -file?). I’m 
not near my computer.


As a note, I don’t change any settings that are program wide with both 
running.


Michael

With a mailing list such as this, I believe the convention is to put 
replies at the bottom?


Anyway, why go as complicated as having a shortcut to the GnuCash 
executable with an argument?


Not not have your shortcuts to the data files themselves and the OS will 
know to use GnuCash to open them.


Paul Feakins.

___
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] Yahoo Closed the Door on Finance API

[Fross, Michael]

You are correct Paul, but Yahoo-json has still been working.

On Fri, Jul 14, 2023 at 3:40 AM Paul Feakins  wrote:

> On 14/07/2023 05:14, Bruce Schuck wrote:
> > Some of us suspected this would come, getting reports of the Yahoo URL
> >
> https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
> > and
> >
> https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
> > now returning a 404 (v11) or "Unauthorized" (v10).
> >
> > Sorry to say this, but more than likely the YahooJSON module (aka
> > yahoo_json) is going to be removed from Finance::Quote in the next
> > release. This is not to say that if someone can figure out a way to
> > successfully access Yahoo's https://query2.finance.yahoo.com/v?...
> > APIs, please pass on that info or better yet, have a go at reworking
> > the current module.
> >
> > There is already an issue raised on F::Q's GitHub,
> > https://github.com/finance-quote/finance-quote/issues/318. Please
> > refrain from "me too" comments. Unfortunately as I said in the
> > previous paragraph, this issue will likely be resolved by removing the
> > module.
> >
> As far as I know, and I may be wrong, this was shut down many years ago?
>
> Paul Feakins.
>
> ___
> 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] Two Instances as opposed to two separate files

[Fross, Michael]

I  run multiple instances at the same time, but you have to open different
data files. I’d keep them in different directories to be tidy.

I have two different icons each with a different name of the data file as
an argument.

There is a an argument to not auto open the last file(no -file?). I’m not
near my computer.

As a note, I don’t change any settings that are program wide with both
running.

Michael

On Fri, Jul 14, 2023 at 3:05 AM Paul Feakins  wrote:

>
> >
> >>
> >>> Question about a matter of setup.  I use Windows 11 - so
> >>> answers/information specific to that OS would be appreciated.
> >>>
> >>> First - can two instances of the program be loaded (exist in the
> system)
> >>> such that one instance opens a personal file and one opens a business
> file?
> >>> Second - if answer to question one is yes - is this a preference you
> can
> >>> set and are there advantages to doing it?
> >>> Third - if answer to question one is no - then is the only way to have
> >>> two separate data files is to load the program and force load the
> specific
> >>> file you want since the program always default opens to the last file
> you
> >>> dealt with?
> >>>
> >>> Answers, opinions and other information welcomed.  Thanks!  -- Ken
>
> I think you're overcomplicating this.
>
> If you want to load a specific .gnucash file then double-click it.
>
> Paul.
>
> ___
> 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] Yahoo Closed the Door on Finance API

[rsbrux via gnucash-user]

Any suggestions as to what would be the next best currently available source in 
F::Q for a broad spectrum of securities, especially European stocks?

>>
Some of us suspected this would come, getting reports of the Yahoo URL 
https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
and
https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics
now returning a 404 (v11) or "Unauthorized" (v10).

Sorry to say this, but more than likely the YahooJSON module (aka
yahoo_json) is going to be removed from Finance::Quote in the next release. 
This is not to say that if someone can figure out a way to successfully access 
Yahoo's https://query2.finance.yahoo.com/v?... APIs, please pass on that info 
or better yet, have a go at reworking the current module.

There is already an issue raised on F::Q's GitHub, 
https://github.com/finance-quote/finance-quote/issues/318. Please refrain from 
"me too" comments. Unfortunately as I said in the previous paragraph, this 
issue will likely be resolved by removing the module.

Bruce S.
<<


___
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] Yahoo Closed the Door on Finance API

[Paul Feakins]

On 14/07/2023 05:14, Bruce Schuck wrote:
Some of us suspected this would come, getting reports of the Yahoo URL 
https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics 
and 
https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics 
now returning a 404 (v11) or "Unauthorized" (v10).


Sorry to say this, but more than likely the YahooJSON module (aka 
yahoo_json) is going to be removed from Finance::Quote in the next 
release. This is not to say that if someone can figure out a way to 
successfully access Yahoo's https://query2.finance.yahoo.com/v?... 
APIs, please pass on that info or better yet, have a go at reworking 
the current module.


There is already an issue raised on F::Q's GitHub, 
https://github.com/finance-quote/finance-quote/issues/318. Please 
refrain from "me too" comments. Unfortunately as I said in the 
previous paragraph, this issue will likely be resolved by removing the 
module.



As far as I know, and I may be wrong, this was shut down many years ago?

Paul Feakins.

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

[Derek Atkins]

HI,

On Thu, July 13, 2023 12:59 am, Alex Dorsch wrote:
> On Sun, 2023-07-09 at 23:01 -0400, Derek Atkins wrote:
>> Hi,
>>
>> On Sun, July 9, 2023 2:55 pm, Alex Dorsch wrote:
>> > Hi,
>> >
>> > I'm continuing to having troubles posting to the gnucash IRC:
>> >
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> > > NickServ< register  alex.dor...@posteo.net
>> > -NickServ- Nickname sunyibo is already registered!
>>
>> Is this YOUR registration?  Or does someone else have the
>> registration?
>> If it is your registration then you need to identify as the user to
>> gain
>> voice.  If it is someone else's then you need to choose a new name.
>
> Yes, it's my registration and I'm identified as the user.
>
> Still no luck connecting to the channel. As it had worked before, I'm
> guessing it has something to do with the gnome->libera migration.
>
> Best,
>
> Alex

Maybe -- but we are at irc.gimp.org, not irc.gnome.org (== libera).

Once you /msg nickserv identify then you should be able to /join #gnucash
and have a voice.

-derek

>
>>
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> > * You have left channel #gnucash
>> > * Now talking on #gnucash
>> > * Topic for #gnucash is: Free GPL Personal and Small Business
>> > Accounting || Moderated mode: To get a voice, register with
>> > NickServ
>> > and then re-join. || Please don't ask to ask, just ask and wait!
>> > (Possibly a few hours!!) || publicly-logged channel
>> > https://code.gnucash.org/logs || latest stable: 5.3 ||
>> > https://www.gnucash.org/ || https://wiki.gnucash.org/wiki/
>> > * Topic for #gnucash set by jralls (Mon Jun 26 22:37:10 2023)
>> >  hi
>> > * #gnucash :You need voice (+v) (#gnucash)
>> >
>> > I just can't voice. Please help,
>> >
>> > Best,
>> >
>> > Alex
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>>
>> -derek
>>
>
> ___
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] user groups that meet in person?

[Steve Freeman]

Are there any user groups that meet in person? I'd really like to
occasionally work with others. Live in Connecticut, but travel to New York
(especially Westchester), New Jersey  and Philadelphia.

 

Steve Freeman

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

[Alex Dorsch]

On Sun, 2023-07-09 at 23:01 -0400, Derek Atkins wrote:
> Hi,
> 
> On Sun, July 9, 2023 2:55 pm, Alex Dorsch wrote:
> > Hi,
> > 
> > I'm continuing to having troubles posting to the gnucash IRC:
> > 
> >  hi
> > * #gnucash :You need voice (+v) (#gnucash)
> > > NickServ< register  alex.dor...@posteo.net
> > -NickServ- Nickname sunyibo is already registered!
> 
> Is this YOUR registration?  Or does someone else have the
> registration?
> If it is your registration then you need to identify as the user to
> gain
> voice.  If it is someone else's then you need to choose a new name.

Yes, it's my registration and I'm identified as the user.

Still no luck connecting to the channel. As it had worked before, I'm
guessing it has something to do with the gnome->libera migration.

Best,

Alex

> 
> >  hi
> > * #gnucash :You need voice (+v) (#gnucash)
> > * You have left channel #gnucash
> > * Now talking on #gnucash
> > * Topic for #gnucash is: Free GPL Personal and Small Business
> > Accounting || Moderated mode: To get a voice, register with
> > NickServ
> > and then re-join. || Please don't ask to ask, just ask and wait!
> > (Possibly a few hours!!) || publicly-logged channel
> > https://code.gnucash.org/logs || latest stable: 5.3 ||
> > https://www.gnucash.org/ || https://wiki.gnucash.org/wiki/
> > * Topic for #gnucash set by jralls (Mon Jun 26 22:37:10 2023)
> >  hi
> > * #gnucash :You need voice (+v) (#gnucash)
> > 
> > I just can't voice. Please help,
> > 
> > Best,
> > 
> > Alex
> 
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> 
> -derek
> 

___
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] Two Instances as opposed to two separate files

[Paul Feakins]

Question about a matter of setup.  I use Windows 11 - so
answers/information specific to that OS would be appreciated.

First - can two instances of the program be loaded (exist in the system)
such that one instance opens a personal file and one opens a business file?
Second - if answer to question one is yes - is this a preference you can
set and are there advantages to doing it?
Third - if answer to question one is no - then is the only way to have
two separate data files is to load the program and force load the specific
file you want since the program always default opens to the last file you
dealt with?

Answers, opinions and other information welcomed.  Thanks!  -- Ken


I think you're overcomplicating this.

If you want to load a specific .gnucash file then double-click it.

Paul.

___
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] Window/Mac Summary Box difference

[Neil Campbell]

Thank you all for your very helpful information on the data in this Summary 
Box. Thanks for the latest info from Stephen and David.

BTW the Grand Total has always been blank for me. I now think that I have the 
final key to solve the problem. I didn’t notice that in the Preferences section 
of the PC app under Accounting Periods, that the Relative dates were ticked. 
When I changed this to Absolute dates, it worked perfectly and the right 
numbers are there. The Profit numbers do represent Income less Expenses but 
this is based on the date selected for the Accounting Period. The Net Equity is 
calculated for the current date which in practice is the date of the last 
transactions. 

Your prompt action to help me was very much appreciated. Thank you all.

Best regards.  
Neil
neilcam...@gmail.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] Two Instances as opposed to two separate files

[David H]

Ken,

In case the shortcut idea wasn't clear - see pic below...  You can set the
"Start in:" property to wherever your gnucash data file is located, mine is
in C:\Users\\Documents\Gnucash\Data" as per the pic.  This saves
adding a path to the file name you pass to Gnucash, and then just include
the file name after the "Target:" as per example.

Cheers David H.

[image: image.png]

On Fri, 14 Jul 2023 at 17:44, David H  wrote:

> Ken,
>
> 1. Don't think so
> 2. See 1.
> 3. Setup 2 shortcuts using the gnucash file name and probably the file
> path for each file then you can just double click on the appropriate
> shortcut.  If your file paths contain spaces you'll probably need double
> quotes around them.
>
> Cheers David H.
>
> On Fri, 14 Jul 2023 at 15:15, Ken Pyzik  wrote:
>
>> Question about a matter of setup.  I use Windows 11 - so
>> answers/information specific to that OS would be appreciated.
>>
>> First - can two instances of the program be loaded (exist in the system)
>> such that one instance opens a personal file and one opens a business file?
>> Second - if answer to question one is yes - is this a preference you can
>> set and are there advantages to doing it?
>> Third - if answer to question one is no - then is the only way to have
>> two separate data files is to load the program and force load the specific
>> file you want since the program always default opens to the last file you
>> dealt with?
>>
>> Answers, opinions and other information welcomed.  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.

Re: [GNC] Two Instances as opposed to two separate files

[David H]

Ken,

1. Don't think so
2. See 1.
3. Setup 2 shortcuts using the gnucash file name and probably the file path
for each file then you can just double click on the appropriate shortcut.
If your file paths contain spaces you'll probably need double quotes around
them.

Cheers David H.

On Fri, 14 Jul 2023 at 15:15, Ken Pyzik  wrote:

> Question about a matter of setup.  I use Windows 11 - so
> answers/information specific to that OS would be appreciated.
>
> First - can two instances of the program be loaded (exist in the system)
> such that one instance opens a personal file and one opens a business file?
> Second - if answer to question one is yes - is this a preference you can
> set and are there advantages to doing it?
> Third - if answer to question one is no - then is the only way to have two
> separate data files is to load the program and force load the specific file
> you want since the program always default opens to the last file you dealt
> with?
>
> Answers, opinions and other information welcomed.  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.

Re: [GNC] Unable to open GnuCash file: "No suitable backend was found for ."

[Paul Feakins]

Tomer,

Good that you sorted it. Note though that if it's gzip-compressed 
it's an XML file, not a sqlite3 database. Does `file` on the 
apparently corrupted gnucash file claim that it's a sqlite3 database?


Regards,
John Ralls


When I use the `file` command on the corrupted file, it just reports 
it as "data". It's a binary file, but not recognized as being in Gzip 
format.


~T

If you're talking about the ".gnucash" file then just add ".tar" and 
unzip it. It's only tarred, not gzipped.


It's definitely an XML file, I do lots of stuff with it programmatically 
in PHP.


Paul.

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