[GNC] All Reports Crashing Version 5.6-1

[Rodney Harrex via gnucash-user]

Running any report will crash GnuCash.  In 
C:\Users\Rodney\AppData\Local\Temp.  Any of the reports selected will 
appear as HTML file along with a file like


gnucash.trace.ITONN2.log with the content: 17:31:13  WARN  
[taxtable_reset_refcount()] Fixing refcount on taxtable 
8e7068a6313b4b21861f31a8461b9469 (3 -> 2).


Would this a corrupted table within the dB?



___
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] Accounts page error

[Ken Farley]

I have seen "overnight" massive gains when there's been a stock split I 
wasn't aware of, a 10 to 1 reverse split, or something like that. 
Usually it is the opposite effect of what you are seeing, where suddenly 
I'm down a lot of net worth.


The only other thing I can think of is that maybe one of your quote 
sources for securities is giving prices in a different currency than 
expected? I think there was some sort of oddness  recently where prices 
were being reported in pence rather than pounds, or some such. A 100X 
overprice would mess things up.

___
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] Delete a trading account => crash

[Kalpesh Patel]

That is the behavior, sadly, where it goes back to what the original 
transaction was. It is undesired but it is there and not likely to be fixed.. 
(I run into it when I want to duplicate the transaction and then just update 
the quantity)

To get around, you technically have to enter the entire transaction from 
beginning to end. Work around is to "modify" transaction is to open up the 
transaction, select first row from split view, go to first column highlight 
what is in it, copy it to clipboard, delete it, paste it from clipboard 
(correct as you need to during this paste phase). Rinse-&-repeat for all 
columns across for all rows in the transaction... you can minimize this by 
doing cut-&-paste to only the Shares, Buy and Sell columns and let it calculate 
the Price column. It does get crazy when you have multi-currency enabled and/or 
are dividend reinvestment transactions ...


-Original Message-
From: Fred Tydeman  
Sent: Sunday, May 19, 2024 1:04 AM
To: Gnucash Users 
Subject: [GNC] Delete a trading account => crash

Running GnuCash 4.14 on Fedora Linux.

Due to a mistake on my part, I have two Trading accounts:
  IVR-PC
  IVRPRC
for the same security.

First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy 
transaction from the cash account. However, when I pressed Enter, Gnucash undid 
my change.

Then, I tried deleting Trading:IVRPRC account and moving its transactions to 
Trading: IVR-PC.
That crashed Gnucash.

I am now running a Check & Repair all (takes many minutes).


___
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] Saved Reports accross several PCs

[David Long]

I am running gnucash on more than one PCs. When I create report on one PC I
find I have create that report on other PC even though they are both
pulling in data from the same file. Is there anything I can do to not have
recreate these reports?.
Also, I am using Gnucash for 2 different organisations so data is saved
under two different file names. If I create a report for one organisation
it also shows up when I load the file for the other organisation even
though it is not relevant the other.
Is there away to eliminate this issue?
Thanks
David

On Mon, 20 May 2024, 00:00 ,  wrote:

> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
>1.  reports blank query (Elmar)
>2.  Delete a trading account => crash (Fred Tydeman)
>3.  All Reports Crashing Version 5.6-1 (Rodney Harrex)
>4. Re:  Accounts page error (Ken Farley)
>
>
> --
>
> Message: 1
> Date: Sat, 18 May 2024 13:55:27 -0400
> From: Elmar 
> To: gnucash-user@gnucash.org
> Subject: [GNC] reports blank query
> Message-ID: <58613ef0-19ef-4b97-93a6-ae72a17bb...@gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> This command works great for my flatpak GC from the terminal window
> (spews a bunch of stuff into the window first, but then launches GC fine
> with visible reports). But -? if I paste that command line into a
> launcher, it fails.? Is this a limitation of the launcher?
>
> - Elmar
>
> On 5/18/24 12:00, gnucash-user-requ...@gnucash.org wrote:
> > On 12/14/23 10:58, john wrote:
> > It won't be fixed in the next release because it's not something that
> > GnuCash can fix. As you say, the work around is to stop WebKit using the
> > GPU with WEBKIT_DISABLE_COMPOSITING_MODE=1 in the environment.
> >
> > There's a typo in your flatpak command line that might trip up somebody
> > not paying close enough attention. The correct command is
> >   ? ? WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash
> > with a space between flatpak and run.
>
>
>
> --
>
> Message: 2
> Date: Sat, 18 May 2024 22:04:06 -0700
> From: Fred Tydeman 
> To: Gnucash Users 
> Subject: [GNC] Delete a trading account => crash
> Message-ID:
>  ynorugn...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Running GnuCash 4.14 on Fedora Linux.
>
> Due to a mistake on my part, I have two Trading accounts:
>   IVR-PC
>   IVRPRC
> for the same security.
>
> First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> transaction from the cash account. However, when I pressed Enter,
> Gnucash undid my change.
>
> Then, I tried deleting Trading:IVRPRC account and moving its transactions
> to Trading: IVR-PC.
> That crashed Gnucash.
>
> I am now running a Check & Repair all (takes many minutes).
>
>
> --
>
> Message: 3
> Date: Sun, 19 May 2024 18:05:10 +1000
> From: Rodney Harrex 
> To: gnucash-user@gnucash.org
> Subject: [GNC] All Reports Crashing Version 5.6-1
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Running any report will crash GnuCash.? In
> C:\Users\Rodney\AppData\Local\Temp.? Any of the reports selected will
> appear as HTML file along with a file like
>
> gnucash.trace.ITONN2.log with the content: 17:31:13? WARN 
> [taxtable_reset_refcount()] Fixing refcount on taxtable
> 8e7068a6313b4b21861f31a8461b9469 (3 -> 2).
>
> Would this a corrupted table within the dB?
>
>
>
>
>
> --
>
> Message: 4
> Date: Sun, 19 May 2024 09:15:48 -0400
> From: Ken Farley 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Accounts page error
> Message-ID: <364daf4c-1099-45b2-a811-560bb0c75...@gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> I have seen "overnight" massive gains when there's been a stock split I
> wasn't aware of, a 10 to 1 reverse split, or something like that.
> Usually it is the opposite effect of what you are seeing, where suddenly
> I'm down a lot of net worth.
>
> The only other thing I can think of is that maybe one of your quote
> sources for securities is giving prices in a different currency than
> expected? I think there was some sort of oddness? recently where prices
> were being reported in pence rather than pounds, or some such. A 100X
> overprice would mess things up.
>
>
> --
>
> Subject: Digest Footer
>
> ___
>
> gnucash-user

[GNC] Manipulating data extracted from gnucash to Excel

[David Long]

When I copy data from Gnucash to Excel it arrives on text format along with
the currency denomination, so I cannot then manipulate it in Excel.
Is there anyway I can export data to Excel in data format?.
Thanks
David
___
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] Delete a trading account => crash

[John Ralls]

> On May 18, 2024, at 22:04, Fred Tydeman  wrote:
> 
> Running GnuCash 4.14 on Fedora Linux.
> 
> Due to a mistake on my part, I have two Trading accounts:
>  IVR-PC
>  IVRPRC
> for the same security.
> 
> First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> transaction from the cash account. However, when I pressed Enter,
> Gnucash undid my change.
> 
> Then, I tried deleting Trading:IVRPRC account and moving its transactions
> to Trading: IVR-PC.
> That crashed Gnucash.
> 
> I am now running a Check & Repair all (takes many minutes).

Fred,

Do you have two commodities IVRPRC and IVR-PC in your book or did you rename 
IVRPRC to IVR-PC?
If the former have you changed all of the accounts that were denominated in 
IVRPRC to use IVR-PC?

Trading splits are deleted and regenerated as part of the transaction balancing 
code run during transaction commit when trading accounts are enabled in 
File>Preferences so once you have the account commodities fixed you can edit 
the transactions with the wrong trading account in some register other than the 
trading account and delete the trading splits then close the transaction.

Deleting the IVRPRC trading account will only work if you renamed the 
commodity: If you have separate commodities then GnuCash won’t let you transfer 
the splits because the commodities don’t match. You also need to turn off 
trading accounts in File>Preferences before you do the delete-and-transfer then 
turn it back on again. If you have two commodities you need to change all of 
the accounts using IVRPRC to use IVR-PC then edit every transaction that used 
IVRPRC, delete the trading splits, and commit it to generate new trading spits 
in IVR-PC.

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] All Reports Crashing Version 5.6-1

[John Ralls]

> On May 19, 2024, at 01:05, Rodney Harrex via gnucash-user 
>  wrote:
> 
> Running any report will crash GnuCash.  In 
> C:\Users\Rodney\AppData\Local\Temp.  Any of the reports selected will appear 
> as HTML file along with a file like
> 
> gnucash.trace.ITONN2.log with the content: 17:31:13  WARN  
> [taxtable_reset_refcount()] Fixing refcount on taxtable 
> 8e7068a6313b4b21861f31a8461b9469 (3 -> 2).
> 
> Would this a corrupted table within the dB?

Probably not. Please file a bug report (see 
https://wiki.gnucash.org/wiki/Bugzilla#Commenting_on_existing_bugs_or_entering_new_ones)
 and if possible get a stack trace (see 
https://wiki.gnucash.org/wiki/Stack_Trace#Windows) and attach it to the bug 
report. Please also attach gnucash.trace.ITONN2.log,

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] Manipulating data extracted from gnucash to Excel

[Stan Brown (using GC 4.14)]

On 2024-05-19 09:39, David Long wrote:
> When I copy data from Gnucash to Excel it arrives on text format along with
> the currency denomination, so I cannot then manipulate it in Excel.
> Is there anyway I can export data to Excel in data format?.
> Thanks
> David

Hi, David!

Which "data" are you copying? Reports? Some stuff you highlighted in an
account register and then copy/pasted? Other?

If it's a report, export it as HTML from GnuCash, then open it in Excel.
Yes, Excel will let you select an .htm or .html file in the File » Open
dialog; you don't even have to fiddle with the file type box in that
dialog because Excel considers .htm and .html as "Excel files".

If it's an account register (or search results), in GC click File »
Export and export in CSV format. (In Windows, remember to put ".csv" at
the end of the filename you specify in the dialog; GC apparently doesn't
do this automatically.) Excel will open CSV files, too; the easiest way
is to double-click the file..

If it's something else, please give us more details of what you're
trying to do. (Also please say which version number of GC, and which
operating system and version -- it's always a good idea to mention those
when asking for help.)

I'm puzzled by your remark about the currency designation. Excel doesn't
have a problem with my pasting an amount with a leading dollar sign ($).
And if I recall correctly, there's also no problem with exporting a
report that contains currency symbols -- again, the dollar sign is the
only one I've tried. Maybe that's different in other currencies? Please
give us more information about what you're doing and what error message
you get.


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] Saved Reports accross several PCs

[Stan Brown (using GC 4.14)]

On 2024-05-19 09:35, David Long wrote:
> I am running gnucash on more than one PCs. When I create report on one PC I
> find I have create that report on other PC even though they are both
> pulling in data from the same file. Is there anything I can do to not have
> recreate these reports?.

Sure -- synchronize the saved reports file between computers. Since I
don't know which version of GC and which operating system you're using I
can't be more specific about where to find that file, but this document
will guide you:
https://wiki.gnucash.org/wiki/Configuration_Locations#USER_DATA_HOME
Caution: make sure GnuCash is not running on either computer when you
synchronize.

> Also, I am using Gnucash for 2 different organisations so data is saved
> under two different file names. If I create a report for one organisation
> it also shows up when I load the file for the other organisation even
> though it is not relevant the other.
> Is there away to eliminate this issue?

Saved reports are a per-user setting, not a per-book setting. The only
way I know to make saved reports invisible to the "wrong" organization
is to set up one user account for each organization; then they will each
have their private sets of reports. (Of course, you'll now have two
report files to synchronize across your multiple PCs.)

A simpler way to solve this problem is to prefix a short string to each
report's name when you save it. When I was keeping books for the
Tehachapi Symphony, I prefixed each report name with either "TSO_" or
"SB_" so that I could easily select the one I wanted, and I had no need
to create an extra user account.

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] Manipulating data extracted from gnucash to Excel

[sunfish62--- via gnucash-user]

And if your currency is using character strings ("USD", "CHF", etc.), you can 
customize the currency designator so that Excel can process them. 

⁣David T. ​

On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" 
 wrote:
>On 2024-05-19 09:39, David Long wrote:
>> When I copy data from Gnucash to Excel it arrives on text format
>along with
>> the currency denomination, so I cannot then manipulate it in Excel.
>> Is there anyway I can export data to Excel in data format?.
>> Thanks
>> David
>
>Hi, David!
>
>Which "data" are you copying? Reports? Some stuff you highlighted in an
>account register and then copy/pasted? Other?
>
>If it's a report, export it as HTML from GnuCash, then open it in
>Excel.
>Yes, Excel will let you select an .htm or .html file in the File » Open
>dialog; you don't even have to fiddle with the file type box in that
>dialog because Excel considers .htm and .html as "Excel files".
>
>If it's an account register (or search results), in GC click File »
>Export and export in CSV format. (In Windows, remember to put ".csv" at
>the end of the filename you specify in the dialog; GC apparently
>doesn't
>do this automatically.) Excel will open CSV files, too; the easiest way
>is to double-click the file..
>
>If it's something else, please give us more details of what you're
>trying to do. (Also please say which version number of GC, and which
>operating system and version -- it's always a good idea to mention
>those
>when asking for help.)
>
>I'm puzzled by your remark about the currency designation. Excel
>doesn't
>have a problem with my pasting an amount with a leading dollar sign
>($).
>And if I recall correctly, there's also no problem with exporting a
>report that contains currency symbols -- again, the dollar sign is the
>only one I've tried. Maybe that's different in other currencies? Please
>give us more information about what you're doing and what error message
>you get.
>
>
>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] Manipulating data extracted from gnucash to Excel

[Joseph Keithley]

Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
you can export your accounts to a csv file.  You pick the account, the date
range, and the separator (usually a comma).  There is also an option to
either add double quotes or not.

On Sun, May 19, 2024 at 12:41 PM David Long 
wrote:

> When I copy data from Gnucash to Excel it arrives on text format along with
> the currency denomination, so I cannot then manipulate it in Excel.
> Is there anyway I can export data to Excel in data format?.
> Thanks
> David
> ___
> 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.
>


-- 
iii
___
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] Delete a trading account => crash

[Fred Tydeman]

By mistake, I had two Asset accounts for the same stock, but with different
spellings.
That is what produced the two similar Trading accounts.

So, I ended up doing in the Cash account that did the buys and sells:
In split view mode: change the stock asset account from one to the other,
press Enter, that got me a popup to adjust the number of shares.
Press Enter and all was fixed.

Doing that was a lot easier than deleting and re-entering the transactions.

When I was done, one stock asset account and one trading account were
both empty, so could be deleted.  I also deleted the wrong spelling in the
Security editor.

On Sun, May 19, 2024 at 9:28 AM Kalpesh Patel  wrote:

> That is the behavior, sadly, where it goes back to what the original
> transaction was. It is undesired but it is there and not likely to be
> fixed.. (I run into it when I want to duplicate the transaction and then
> just update the quantity)
>
> To get around, you technically have to enter the entire transaction from
> beginning to end. Work around is to "modify" transaction is to open up the
> transaction, select first row from split view, go to first column highlight
> what is in it, copy it to clipboard, delete it, paste it from clipboard
> (correct as you need to during this paste phase). Rinse-&-repeat for all
> columns across for all rows in the transaction... you can minimize this by
> doing cut-&-paste to only the Shares, Buy and Sell columns and let it
> calculate the Price column. It does get crazy when you have multi-currency
> enabled and/or are dividend reinvestment transactions ...
>
>
> -Original Message-
> From: Fred Tydeman 
> Sent: Sunday, May 19, 2024 1:04 AM
> To: Gnucash Users 
> Subject: [GNC] Delete a trading account => crash
>
> Running GnuCash 4.14 on Fedora Linux.
>
> Due to a mistake on my part, I have two Trading accounts:
>   IVR-PC
>   IVRPRC
> for the same security.
>
> First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy
> transaction from the cash account. However, when I pressed Enter, Gnucash
> undid my change.
>
> Then, I tried deleting Trading:IVRPRC account and moving its transactions
> to Trading: IVR-PC.
> That crashed Gnucash.
>
> I am now running a Check & Repair all (takes many minutes).
>
>
>
___
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] Easier way to print to PDF

[Daffy Duck]

A few years ago, when you wanted to print to PDF a report, it started
in the last directory used.  It was then changed to basically go
through the print dialogue and start in home directory, which wastes a
lot of time.

I do now notice there is a "make PDF" icon that does nothing but bring
up the print dialogue.

Is there any way to have a quick way to print the current report to PDF
starting in the most recent directory, like it used to be?

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] Easier way to print to PDF

[Joseph Keithley]

If you are on a Windows machine you can use the Windows built-in PDF
printer driver (Settings >  Devices > Printers > Add Printer - "Microsoft
Print to PDF").  Alternatively, you can export the report (shows up as an
.html) and open it with Microsoft Edge and save it as a PDF.

On Sun, May 19, 2024 at 6:07 PM Daffy Duck  wrote:

> A few years ago, when you wanted to print to PDF a report, it started
> in the last directory used.  It was then changed to basically go
> through the print dialogue and start in home directory, which wastes a
> lot of time.
>
> I do now notice there is a "make PDF" icon that does nothing but bring
> up the print dialogue.
>
> Is there any way to have a quick way to print the current report to PDF
> starting in the most recent directory, like it used to be?
>
> 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.
>


-- 
iii
___
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] Manipulating data extracted from gnucash to Excel

[David Long]

Hi
I mean copy paste from a gnucash  report.
Rgds
David


On Mon, 20 May 2024, 04:13 Joseph Keithley,  wrote:

> Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
> you can export your accounts to a csv file.  You pick the account, the date
> range, and the separator (usually a comma).  There is also an option to
> either add double quotes or not.
>
> On Sun, May 19, 2024 at 12:41 PM David Long 
> wrote:
>
>> When I copy data from Gnucash to Excel it arrives on text format along
>> with
>> the currency denomination, so I cannot then manipulate it in Excel.
>> Is there anyway I can export data to Excel in data format?.
>> Thanks
>> David
>> ___
>> 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.
>>
>
>
> --
> iii
>
___
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] Can't download stock prices

[Ernie Wakamatsu]

Hi,

First time user of this mailing list and just starting to use gnucash.  Been 
transferring information over from Quicken and I am getting things close to the 
way I would like.

I am trying to download stock prices, but getting the following errors.

Ernie@Ernie-Mac-mini ~ % /Applications/Gnucash.app/Contents/macOS/gnucash-cli 
-Q info
Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli
* 11:59:02  WARN  failed to load gncmod-backend-dbi from relative 
path 
* 11:59:02 ERROR  required library gncmod-backend-dbi not found.
* 11:59:02  WARN  failed to load gncmod-backend-xml from relative 
path 
* 11:59:02 ERROR  required library gncmod-backend-xml not found.
* 11:59:02 ERROR  g_settings_schema_source_lookup: assertion 'source 
!= NULL' failed
* 11:59:02 ERROR  g_settings_new_full: assertion 'schema != NULL' 
failed
* 11:59:02  WARN  [gnc_gsettings_get_settings_obj()] 
Ignoring attempt to access unknown gsettings schema org.gnucash.GnuCash.general
zsh: segmentation fault  /Applications/Gnucash.app/Contents/macOS/gnucash-cli 
-Q info
Ernie@Ernie-Mac-mini ~ % 

As you can tell, I am on a Mac Mini running Sonoma 14.4.1 (latest?).  Looks 
like I may be missing some files.  Tried the wiki and other search engines but 
not finding any answers.  How can I resolve the above?

Thanks in advance for any assistance.

Best regards,
Ernie



smime.p7s
Description: S/MIME cryptographic signature
___
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] Manipulating data extracted from gnucash to Excel

[Joseph Keithley]

Understood.  I can tell you what I do with copy/pasting a paticular
report.  I've never had a problem with double quotes.  In my case, I
copy/paste the "Investment Portfolio" report under "Assets and Liabilities"
to Excel.  When the tab opens with the report, I put the mouse cursor on
the top left of the tab window just in front of where I want the copy to
start.  I then left-click the mouse and hold the button down and drag the
cursor down the page until everything I want to copy is highlighted and
release the left-click.  The page will automatically scroll as long as you
keep the mouse button depressed and directed at the bottom of the tab.  As
long as what want I want to copy stays highlighted, I then right click the
mouse and a small pop-up menu shows "Copy".  Then I left-click the word
copy.  I usually already have a spreadsheet open, I then right-click on an
empty cell on the spreadsheet and on the pop-up menu I pick "Paste Special"
and choose "Text".  If the pop-up menu doesn't have "Paste Special" , look
for "Paste Options" and left-click.  Another window should pop-up and
"Paste Special" should be one of the choices.The resulting spreadsheet
has everything set up in columns just like the GnuCash report.  If the
number of decimal places in your resulting Excel file isn't right then you
have to go back to the GnuCash Report tab and choose the "Options" button
on the menu bar.  You can change the number of decimal places the report
provides.  One note, when I change the number of decimal places the report
automatically alpahbetically resorts itself.  An oddity but not an issue.

On Sun, May 19, 2024 at 8:35 PM David Long 
wrote:

> Hi
> I mean copy paste from a gnucash  report.
> Rgds
> David
>
>
> On Mon, 20 May 2024, 04:13 Joseph Keithley,  wrote:
>
>> Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
>> you can export your accounts to a csv file.  You pick the account, the date
>> range, and the separator (usually a comma).  There is also an option to
>> either add double quotes or not.
>>
>> On Sun, May 19, 2024 at 12:41 PM David Long 
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> ___
>>> 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.
>>>
>>
>>
>> --
>> iii
>>
>

-- 
iii
___
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] Manipulating data extracted from gnucash to Excel

[Joseph Keithley]

If the whole left-click hold copy and drag doesn't work well, there is an
alternate method.  When you move the mouse cursor to the top left of the
tab, move the cursor slowly to the right until the mouse cursor changes
from an arrow to a line (assuming your PC set up is similar to mine) and
left-click the mouse. Then hold down the shift key (with a finger on the
hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
navigate to the end of your desired data.  Release the shift key and then
left-click the end of you data.  All your data should be highlighted.
Right-click the mouse and then left-click on "Copy".

On Sun, May 19, 2024 at 8:35 PM David Long 
wrote:

> Hi
> I mean copy paste from a gnucash  report.
> Rgds
> David
>
>
> On Mon, 20 May 2024, 04:13 Joseph Keithley,  wrote:
>
>> Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
>> you can export your accounts to a csv file.  You pick the account, the date
>> range, and the separator (usually a comma).  There is also an option to
>> either add double quotes or not.
>>
>> On Sun, May 19, 2024 at 12:41 PM David Long 
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> ___
>>> 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.
>>>
>>
>>
>> --
>> iii
>>
>

-- 
iii
___
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] Manipulating data extracted from gnucash to Excel

[Adrien Monteleone]

Any reason not to use CTRL+A?

Regards,
Adrien

On 5/19/24 9:08 PM, Joseph Keithley wrote:

If the whole left-click hold copy and drag doesn't work well, there is an
alternate method.  When you move the mouse cursor to the top left of the
tab, move the cursor slowly to the right until the mouse cursor changes
from an arrow to a line (assuming your PC set up is similar to mine) and
left-click the mouse. Then hold down the shift key (with a finger on the
hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
navigate to the end of your desired data.  Release the shift key and then
left-click the end of you data.  All your data should be highlighted.
Right-click the mouse and then left-click on "Copy".


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

Re: [GNC] Can't download stock prices

[John Ralls]

> On May 19, 2024, at 18:03, Ernie Wakamatsu  wrote:
> 
> Hi,
> 
> First time user of this mailing list and just starting to use gnucash.  Been 
> transferring information over from Quicken and I am getting things close to 
> the way I would like.
> 
> I am trying to download stock prices, but getting the following errors.
> 
> Ernie@Ernie-Mac-mini ~ % /Applications/Gnucash.app/Contents/macOS/gnucash-cli 
> -Q info
> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli
> * 11:59:02  WARN  failed to load gncmod-backend-dbi from relative 
> path 
> * 11:59:02 ERROR  required library gncmod-backend-dbi not found.
> * 11:59:02  WARN  failed to load gncmod-backend-xml from relative 
> path 
> * 11:59:02 ERROR  required library gncmod-backend-xml not found.
> * 11:59:02 ERROR  g_settings_schema_source_lookup: assertion 
> 'source != NULL' failed
> * 11:59:02 ERROR  g_settings_new_full: assertion 'schema != NULL' 
> failed
> * 11:59:02  WARN  [gnc_gsettings_get_settings_obj()] 
> Ignoring attempt to access unknown gsettings schema 
> org.gnucash.GnuCash.general
> zsh: segmentation fault  /Applications/Gnucash.app/Contents/macOS/gnucash-cli 
> -Q info
> Ernie@Ernie-Mac-mini ~ % 
> 
> As you can tell, I am on a Mac Mini running Sonoma 14.4.1 (latest?).  Looks 
> like I may be missing some files.  Tried the wiki and other search engines 
> but not finding any answers.  How can I resolve the above?
> 
> Thanks in advance for any assistance.

Not quite the latest macOS version, 14.5 dropped last week. That’s unlikely to 
matter.

The two files that it can’t find, libgncmon-backend-dbi.dylib and 
libgncmod-backend-xml.dylib, should be in 
/Applications/Gnucash.app/Contents/Rsources/lib/gnucash. If you have Xcode or 
Xcode command line tools installed and they’re present you can run e.g.
  otool -L 
/Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib
The output should be
Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib:
@executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libgnc-backend-sql.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libgnc-engine.dylib (compatibility 
version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libdbi.3.dylib (compatibility version 
4.0.0, current version 4.0.0)
@executable_path/../Resources/lib/libgnc-core-utils.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libboost_regex.dylib (compatibility 
version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libboost_date_time.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libicui18n.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libicuuc.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libicudata.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libgmodule-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
@executable_path/../Resources/lib/libglib-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
@executable_path/../Resources/lib/libintl.8.dylib (compatibility 
version 13.0.0, current version 13.0.0)
@executable_path/../Resources/lib/libgobject-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 
1300.36.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 1319.0.0)

You can check that the application bundle is complete and matches its code 
signature with
  spctl —assess -vv /Applications/Gnucash.app
It should report
  /Applications/Gnucash.app/: accepted
  source=Notarized Developer ID
  origin=Developer ID Application: John D Ralls (Y9EHT5WMK7)

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] Manipulating data extracted from gnucash to Excel

[Stan Brown (using GC 4.14)]

Open the report in Excel and _then_ do your copy and pasting. (You
probably want Edit » Paste Special » Values, keyboard Alt+E, S, V.)

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2024-05-19 17:35, David Long wrote:
> Hi
> I mean copy paste from a gnucash  report.
> Rgds
> David
> 
> 
> On Mon, 20 May 2024, 04:13 Joseph Keithley,  wrote:
> 
>> Not sure what you mean by "copy".  In the Windows version of GnuCash 5.5
>> you can export your accounts to a csv file.  You pick the account, the date
>> range, and the separator (usually a comma).  There is also an option to
>> either add double quotes or not.
>>
>> On Sun, May 19, 2024 at 12:41 PM David Long 
>> wrote:
>>
>>> When I copy data from Gnucash to Excel it arrives on text format along
>>> with
>>> the currency denomination, so I cannot then manipulate it in Excel.
>>> Is there anyway I can export data to Excel in data format?.
>>> Thanks
>>> David
>>> ___
>>> 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.
>>>
>>
>>
>> --
>> iii
>>
> ___
> 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] Easier way to print to PDF

[Stan Brown (using GC 4.14)]

On 2024-05-19 16:29, Joseph Keithley wrote:
> If you are on a Windows machine you can use the Windows built-in PDF
> printer driver (Settings >  Devices > Printers > Add Printer - "Microsoft
> Print to PDF"). 

Caution!  Microsoft Print to PDF makes huge, bloated PDF files. A
one-page simple all-text document will be megabytes, or so I found. If
you do this on a regular basis you're much better advised to use a
third-party Print-to-PDF driver, such as the free Cute PDF, which I've
used for years. 

> Alternatively, you can export the report (shows up as an
> .html) and open it with Microsoft Edge and save it as a PDF.

Well, you _could_ do that, if you like extra steps. But there's really
no reason to involve any browser, let alone Edge. Excel opens HTML files
just fine, as I posted this morning.

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] Can't download stock prices

[Ernie Wakamatsu]

Thanks John,

I ran the below commands and this is what I got.

Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app
/applications/gnucash.app: accepted
source=Notarized Developer ID
origin=Developer ID Application: John D Ralls (Y9EHT5WMK7)
Ernie@Ernie-Mac-mini contents % otool -L 
/Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib
/Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib:
@executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libgnc-backend-sql.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libgnc-engine.dylib (compatibility 
version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libdbi.3.dylib (compatibility version 
4.0.0, current version 4.0.0)
@executable_path/../Resources/lib/libgnc-core-utils.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libboost_regex.dylib (compatibility 
version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libboost_date_time.dylib 
(compatibility version 0.0.0, current version 0.0.0)
@executable_path/../Resources/lib/libicui18n.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libicuuc.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libicudata.73.dylib (compatibility 
version 73.0.0, current version 73.2.0)
@executable_path/../Resources/lib/libgmodule-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
@executable_path/../Resources/lib/libglib-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
@executable_path/../Resources/lib/libintl.8.dylib (compatibility 
version 13.0.0, current version 13.0.0)
@executable_path/../Resources/lib/libgobject-2.0.0.dylib (compatibility 
version 7601.0.0, current version 7601.3.0)
/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 
1300.36.0)
/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current 
version 1319.0.0)
Ernie@Ernie-Mac-mini contents % 

Compared to your output, the only difference I can find is in the first line 
where I have a double slash:

@executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib 
(compatibility version 0.0.0, current version 0.0.0)

Just eyeballing, everything else looks the same. Could this double slash be 
causing me troubles?

Ernie





> On 20 May 2024, at 1:52 PM, John Ralls  wrote:
> 
> 
> 
>> On May 19, 2024, at 18:03, Ernie Wakamatsu  wrote:
>> 
>> Hi,
>> 
>> First time user of this mailing list and just starting to use gnucash.  Been 
>> transferring information over from Quicken and I am getting things close to 
>> the way I would like.
>> 
>> I am trying to download stock prices, but getting the following errors.
>> 
>> Ernie@Ernie-Mac-mini ~ % 
>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info
>> Application Path /Applications/Gnucash.app/Contents/macOS/gnucash-cli
>> * 11:59:02  WARN  failed to load gncmod-backend-dbi from 
>> relative path 
>> * 11:59:02 ERROR  required library gncmod-backend-dbi not found.
>> * 11:59:02  WARN  failed to load gncmod-backend-xml from 
>> relative path 
>> * 11:59:02 ERROR  required library gncmod-backend-xml not found.
>> * 11:59:02 ERROR  g_settings_schema_source_lookup: assertion 
>> 'source != NULL' failed
>> * 11:59:02 ERROR  g_settings_new_full: assertion 'schema != NULL' 
>> failed
>> * 11:59:02  WARN  
>> [gnc_gsettings_get_settings_obj()] Ignoring attempt to access unknown 
>> gsettings schema org.gnucash.GnuCash.general
>> zsh: segmentation fault  
>> /Applications/Gnucash.app/Contents/macOS/gnucash-cli -Q info
>> Ernie@Ernie-Mac-mini ~ % 
>> 
>> As you can tell, I am on a Mac Mini running Sonoma 14.4.1 (latest?).  Looks 
>> like I may be missing some files.  Tried the wiki and other search engines 
>> but not finding any answers.  How can I resolve the above?
>> 
>> Thanks in advance for any assistance.
> 
> Not quite the latest macOS version, 14.5 dropped last week. That’s unlikely 
> to matter.
> 
> The two files that it can’t find, libgncmon-backend-dbi.dylib and 
> libgncmod-backend-xml.dylib, should be in 
> /Applications/Gnucash.app/Contents/Rsources/lib/gnucash. If you have Xcode or 
> Xcode command line tools installed and they’re present you can run e.g.
>  otool -L 
> /Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib
> The output should be
> Applications/Gnucash.app/Contents/Resources/lib/gnucash/libgncmod-backend-dbi.dylib:
>   @executable_path/../Resources//lib/gnucash/libgncmod-backend-dbi.dylib 
> (compatibility version 0.0.0, current version 0.0.0)
>  

Re: [GNC] Manipulating data extracted from gnucash to Excel

[Joseph Keithley]

Only because I don't have any keyboard shortcuts memorized except ctrl-c
and ctrl-v.

On Sun, May 19, 2024 at 11:25 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Any reason not to use CTRL+A?
>
> Regards,
> Adrien
>
> On 5/19/24 9:08 PM, Joseph Keithley wrote:
> > If the whole left-click hold copy and drag doesn't work well, there is an
> > alternate method.  When you move the mouse cursor to the top left of the
> > tab, move the cursor slowly to the right until the mouse cursor changes
> > from an arrow to a line (assuming your PC set up is similar to mine) and
> > left-click the mouse. Then hold down the shift key (with a finger on the
> > hand that doesn't work the mouse).  Then, using either the "Page Up/Down"
> > keyss, the arrow keys, or by clicking and/or dragging the scroll bar,
> > navigate to the end of your desired data.  Release the shift key and then
> > left-click the end of you data.  All your data should be highlighted.
> > Right-click the mouse and then left-click on "Copy".
>
> ___
> 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.
>


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