Re: [GNC] v5.0: Not finding Import OFX/QFX File choice

[Geert Janssens]

Hi,

This is reported in https://bugs.gnucash.org/show_bug.cgi?id=798813[1]

The menu item will be back in gnucash 5.1.

Regards,

Geert

Op donderdag 30 maart 2023 14:19:14 CEST schreef Joseph St. Denis via 
gnucash-user:
> I have seen the same problem with the QFX file missing. Luckily my bank
> still supports the QIF downloads.
> 
> I how ever have a problem with CSV files I get up to point of selecting the
> suggested amount but I get no results no matter what I select.
> 
> Joseph St Denis
> 
> Get Outlook for Android
> 
> From: gnucash-user  on
> behalf of L Smith  Sent: Thursday, March 30, 2023
> 7:38:07 AM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] v5.0: Not finding Import OFX/QFX File choice
> 
> Running Windows 11. Just updated from v4.16 to v5.0. When I look for "File >
> Import > Import OFX/QFX file", it's not there.
> 
> [cid:55230af7-f625-4598-a209-72b947f47d01]
> 
> Section  6.16.1 of the updated documentation still lists OFX/QFX as a valid
> import file. Is this a bug?
> 
> Lamar
> 
> 
> ___
> 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.




[1] https://bugs.gnucash.org/show_bug.cgi?id=798813
___
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] 5.0-1 (Flathub) issue

[Geert Janssens]

Op donderdag 30 maart 2023 23:06:36 CEST schreef Dale Alspach:
> What if there is no more to type?
> Example: I enter ONG
> That is exactly what I want. The list includes Amanda Szongo, all
> possibities including words such as long, e.g., long term care. The
> highlighted entry is Amand Szongo so I cannot just hit tab. How do I move
> the cursor off the description ? I don't want to scroll through a list for
> something that is already in the field.
> I have not played with this or searched the documentation, so there may be
> something simple.
> For me it would help if the matching assumed that I was typing the first
> few characters.
> Dale

I think you make a valid point here. Perhaps the filter code should prefer 
exact matches over 
partial matches for sorting rather than just alphabetically ? Using your 
example, if previous 
descriptions exist for "ONG" and for "Amazon Szongo", and you type "ONG", then 
ONG 
should be first in the list.

Regards,

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

Re: [GNC] import

[Geert Janssens]

Meanwhile this has been reported as 
https://bugs.gnucash.org/show_bug.cgi?id=798813[1] 
and it will be fixed in gnucash 5.1.

Regards,

Geert

Op zaterdag 1 april 2023 08:16:48 CEST schreef Gyle McCollam:
> Using Gnucash 5.0 and Windows 11.
> What happened to the import QFX/OFX option?  It is missing from the chioces.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> ___
> 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.




[1] https://bugs.gnucash.org/show_bug.cgi?id=798813
___
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] Flatpak ldconfig error

[Geert Janssens]

That's unfortunately not related. The warning about the magic bytes has nothing 
to do with 
recompilation attempts and is still present. I have removed that part from the 
sample.

As for the warning itself. It's harmless, albeit annoying when using 
gnucash-cli from flatpak.

Feel free to report it as a bug in our bugzilla instance against the 
packaging/flatpak 
component.

Thanks,

Geert

Op zondag 2 april 2023 21:44:50 CEST schreef David H:
> Simple fix/workaround documented in the docs at
> https://wiki.gnucash.org/wiki/Flatpak, excerpt below.
> 
> Cheers David H.
> 
> 
>- Current versions of GnuCash flatpak will no longer attempt to
>recompile all scm sources though it will continue to emit warnings about
>obsolete .go files:
> 
>ldconfig: /app/lib/libguile-2.2.so.1.3.0-gdb.scm is not an ELF file
> - it has the wrong magic bytes at the start.
>;;; note: source file /app/share/guile//2.2/ice-9/eval.scm;;;
> newer than compiled /app/lib/guile/2.2/ccache/ice-9/eval.go:
> 
> 
> Workaround
>  8429>
> 
> 
> # --system installcd /var/lib/flatpak/app/org.gnucash.GnuCash# OR
> --user installcd $HOME/.local/share/flatpak/app/org.gnucash.GnuCash
> 
> sudo find . -name '*.go' -exec touch '{}' ';'
> 
> On Mon, 3 Apr 2023 at 02:42, Jon Schewe  wrote:
> > When I run flatpak to get quotes I get a warning about a scheme file
> > not being an ELF file. Is this a bug in the packaging or expected based
> > on how flatpak works?
> > 
> > >flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get
> > 
> > ~/Documents/banking/gnucash/accounts.gnucash
> > ldconfig: /app/lib/libguile-2.2.so.1.3.0-gdb.scm is not an ELF file -
> > it has the wrong magic bytes at the start.
> > 
> > 
> > Thanks
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] gnucash 5.0 register color settings don't save

[Geert Janssens]

The contents of the tracefile would indeed be helpful to diagnose whether this 
is a gsettings 
migration related bug or something else. A few bugs in that area have been 
fixed, but 
perhaps there are more or we look at a regression.

Regards,

Geert

Op maandag 3 april 2023 22:31:24 CEST schreef Adrien Monteleone:
> I'd check the Wiki about obtaining a Tracefile. (and/or run GnuCash from
> the command line to watch output)
> 
> Then attempt changing a preference and see if any messages appear in
> either that might indicate what is happening.
> 
> Regards,
> Adrien
> 
> On 4/3/23 3:14 PM, John Griessen wrote:
> > On 4/3/23 13:44, Adrien Monteleone wrote:
> >> Are other preferences saved?
> >> 
> >> I think there was a bug a while back about this being an issue in some
> >> cases on Linux. It had to do with Gsettings and file locations
> > 
> > Nope.  All check boxes are empty and cannot be checked and saved.
> > 
> > The flatpak is at 5.0 also and runs OK, (like a flatpak should), but I
> > wanted to lose the flatpak org.gnome.Platform
> > org.freedesktop.Platform.GL.default bloat of 1.3GB...
> 
> ___
> 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] Company plan for stocks and stock options

[Brad Morrison]

Hi Wolfgang/all,

While I definitely echo what John has mentioned about having a tax 
professional that has experience preparing tax returns with stock 
options review the situation and your accounting setup, I will also note 
how helpful it is when a tax client is actually interested enough in how 
the relevant accounting rules works to assemble the necessary 
information correctly. The difference between working on a tax return 
for a "shoebox client" and a client that is organized is the frequently 
the difference between a good workday and a bad one...


Wolfgang: did your company provide you with a form 3922 or form 3921 for 
your stock options? https://www.irs.gov/forms-pubs/about-form-3922 & 
https://www.irs.gov/forms-pubs/about-form-3921


Another thing to think about is whether those stock options that are 
vested & distributed annually show up as compensation on your W2 - 
https://www.irs.gov/forms-pubs/about-form-w-2


Brad

On 4/4/23 12:26, john wrote:

The whole bucket of deferred compensation is really complicated and how you 
account for it is tied up in tax law. If the value of the options, stock plan, 
retirement plan subsidies, and whatever else is large enough to matter to your 
tax returns you really, really need the help of a licensed accountant with 
direct experience with the types of deferred compensation you get. Ask your 
colleagues for recommendations.

Regards,
John Ralls



On Apr 4, 2023, at 11:14 AM, Murugan Muruganandam  
wrote:

Employee stock options are normally not taxed until the vesting is done.  
Restricted Stock Units (RSU) has a different mechanism though

What is your objective of this accounting? if you can detail then there are 
couple of ways to account for the same




Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of Stan Brown
Sent: Tuesday, April 4, 2023 2:06 PM
To:gnucash-user@gnucash.org  
Subject: Re: [GNC] Company plan for stocks and stock options


On 2023-04-04 10:40, Wolfgang Paul Rauchholz wrote:

Fairly new to gnucash and not a finance export, I want to run all my
personal finances with this great tool.

I installed 5.0 by compiling it under fedora core 37.

I started adding normal daily expenses and all look fine.

One of the doubts I have is how do I correctly add a company plan for stock
options and stock plan that get vested/distributed every year. As I don't
buy them there is no cash leaving my bank account.

The options and stocks are part of your compensation as an employee,
right? As such, the accounting would be similar to your accounting for
your paycheck.

Your paycheck (ignoring tax withholding) is
Debit: Cash or Bank account
Credit: Employee income

The stocks would be
Debit: Stock in Company X
Credit: Employee income
and similarly for the options. With stocks and options you'll want to
know number of shares and share prices so that you can compute gains and
losses when you sell them. If they aren't fully vested you will want to
note the vesting date as well.

You'll probably want to have separate accounts for stocks in the company
and stock options. To simplify computing your income tax, you may want
to have separate income accounts for income in money and income in
securities; they could both be subaccounts under an Employee Income account.

The usual disclaimer: I don't know your tax situation or any legal
requirements for how you may need to account for all of this.

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.

___
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] Command line quotes still not fixed

[David G. Pickett via gnucash-user]

I can still only update quotes with the interactive button, the flatpak run 
gnucash command that ran in 4.* is still broken:
dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash 
--quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file 
parameter
gnucash-cli [options] [datafile] - GnuCash, accounting for personal and small 
business finance:
Common Options:  -h [ --help ]          Show this help message  -v [ --version 
]       Show GnuCash version  --debug                Enable debugging mode: 
provide deep detail in the                          logs.                       
  This is equivalent to: --log "=info" --log "qof=info"                         
 --log "gnc=info"  --extra                Enable extra/development/debugging 
features.  --log arg              Log level overrides, of the form              
            "modulename={debug,info,warn,crit,error}"                         
Examples: "--log qof=debug" or "--log                          
gnc.backend.file.sx=info"                         This can be invoked multiple 
times.  --paths                Show paths  --logto arg            File to log 
into; defaults to "/tmp/gnucash.trace";                          can be 
"stderr" or "stdout".
Price Quotes Retrieval Options:  -Q [ --quotes ] arg    Execute price quote 
related commands. The following                          commands are 
supported.                                                    info: Show 
Finance::Quote version and exposed quote                                  
sources.                            get: Fetch current quotes for all foreign   
                               currencies and stocks in the given GnuCash       
                           datafile.                           dump: Fetch 
current quotes for specified currencies                                  or 
stocks from a specified namespace and print                                 the 
results to the console.                                 This must be followed 
with a source and one or                                 more symbols, unless 
the source is "currency"                                  in which case it must 
be followed with two or                                  more symbols, the 
first of which is the                                  currency in which 
exchange rates for the rest                                  will be quoted.    
                       --namespace arg        Regular expression determining 
which namespace                          commodities will be retrieved for when 
using the get                          command  -V [ --verbose ]       When 
using the dump command list all of the parameters                         
Finance::Quote returns for the symbol instead of the                          
ones that Gnucash requires.
Report Generation Options:  -R [ --report ] arg    Execute report related 
commands. The following                          commands are supported.        
                                            list: Lists available reports.      
                     show: Describe the options modified in the named           
                       report. A datafile may be specified to                   
               describe some saved options.                           run: Run 
the named report in the given GnuCash                                 datafile. 
                          --name arg             Name of the report to run      
                     --export-type arg      Specify export type                 
          --output-file arg      Output file for report                         
dgp@dgp-p6803w:~$ ls -l /home/dgp/GnuCash/ubuntu-DGPickett.gnucash-rw-rw-r-- 2 
dgp dgp 2899938 Apr  4 17:55 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucashdgp@dgp-p6803w:~$
___
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] Company plan for stocks and stock options

[Wolfgang Paul Rauchholz]

Hi Stan / Murugan all,

Thanks for picking up and providing your insight. That was very helpful.
I would assume that options and stocks I have not exercised yet cannot get
managed in gnucash?
Only when exercising options into stocks or selling stock or options?

The objective with gnucash is that I want to manage personal finances;
expense control, planning, etc..


Best regards,


Wolfgang Rauchholz
+34 627 994 977
https://www.linkedin.com/in/wolfgangrauchholz/



On Tue, Apr 4, 2023 at 8:07 PM Stan Brown 
wrote:

>
> On 2023-04-04 10:40, Wolfgang Paul Rauchholz wrote:
> >  Fairly new to gnucash and not a finance export, I want to run all my
> > personal finances with this great tool.
> >
> > I installed 5.0 by compiling it under fedora core 37.
> >
> > I started adding normal daily expenses and all look fine.
> >
> > One of the doubts I have is how do I correctly add a company plan for
> stock
> > options and stock plan that get vested/distributed every year. As I don't
> > buy them there is no cash leaving my bank account.
>
> The options and stocks are part of your compensation as an employee,
> right? As such, the accounting would be similar to your accounting for
> your paycheck.
>
> Your paycheck (ignoring tax withholding) is
> Debit: Cash or Bank account
> Credit: Employee income
>
> The stocks would be
> Debit: Stock in Company X
> Credit: Employee income
> and similarly for the options. With stocks and options you'll want to
> know number of shares and share prices so that you can compute gains and
> losses when you sell them. If they aren't fully vested you will want to
> note the vesting date as well.
>
> You'll probably want to have separate accounts for stocks in the company
> and stock options. To simplify computing your income tax, you may want
> to have separate income accounts for income in money and income in
> securities; they could both be subaccounts under an Employee Income
> account.
>
> The usual disclaimer: I don't know your tax situation or any legal
> requirements for how you may need to account for all of this.
>
> 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] Company plan for stocks and stock options

[Murugan Muruganandam]

hi Wolfgang

if it is only for tracking purpose i use the following method,  you can review 
and improvise as your need be.  


| Date| Operation | Account| Stock 
Qty | Price | Dr | Cr |
|:-:|:-:|:--:|:-:|:-:|::|::|
| 01-01-2022 | Options Grant   | Asset: Stock Options | 5000  |  $20  | 
 $100.000  |   |
||   | Asset: Contingent Asset |
  |  |   |  $100.000  |
||   |  
  |  |  |   |  |
||   |  
  |  |  |   |  |
| 01-01-2023 | Options Vesting | Asset:Stock:Stock ABC   | 1000 |  $20  |   
$20.000   |  |
||   | Income: Other Income|
 |   |  |  $20.000   |
||   | Asset: Stock Options  | 
-1000|   $20  |  |  $20.000   |
||   | Asset: Contingent Asset |
  |   |  $20.000   |









Saludos Cordiales



Murugan




From: Wolfgang Paul Rauchholz 
Sent: Wednesday, April 5, 2023 9:01 AM
To: Stan Brown ; m.muruganan...@hotmail.com 

Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Company plan for stocks and stock options 
 
Hi Stan / Murugan all,

Thanks for picking up and providing your insight. That was very helpful. 
I would assume that options and stocks I have not exercised yet cannot get 
managed in gnucash?
Only when exercising options into stocks or selling stock or options?

The objective with gnucash is that I want to manage personal finances; expense 
control, planning, etc..



Best regards,


Wolfgang Rauchholz
+34 627 994 977
https://www.linkedin.com/in/wolfgangrauchholz/



On Tue, Apr 4, 2023 at 8:07 PM Stan Brown  wrote:

On 2023-04-04 10:40, Wolfgang Paul Rauchholz wrote:
>  Fairly new to gnucash and not a finance export, I want to run all my
> personal finances with this great tool.
> 
> I installed 5.0 by compiling it under fedora core 37.
> 
> I started adding normal daily expenses and all look fine.
> 
> One of the doubts I have is how do I correctly add a company plan for stock
> options and stock plan that get vested/distributed every year. As I don't
> buy them there is no cash leaving my bank account.

The options and stocks are part of your compensation as an employee,
right? As such, the accounting would be similar to your accounting for
your paycheck.

Your paycheck (ignoring tax withholding) is
    Debit: Cash or Bank account
    Credit: Employee income

The stocks would be
    Debit: Stock in Company X
    Credit: Employee income
and similarly for the options. With stocks and options you'll want to
know number of shares and share prices so that you can compute gains and
losses when you sell them. If they aren't fully vested you will want to
note the vesting date as well.

You'll probably want to have separate accounts for stocks in the company
and stock options. To simplify computing your income tax, you may want
to have separate income accounts for income in money and income in
securities; they could both be subaccounts under an Employee Income account.

The usual disclaimer: I don't know your tax situation or any legal
requirements for how you may need to account for all of this.

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.

[GNC] Keyboard shortcut to open a custom report

[Macho Philipovich]

Dear all,

I'm hoping someone can provide advice or, ideally, a code snippet 
example showing how to set a keyboard shortcut that would open a custom 
report. I open a custom invoice all the time so this would be helpful.


Because custom reports (unlike built-in reports) are not openable 
directly by a menu item, my understanding is that this would have to be 
done using a binding rather than an accelerator (according to my reading 
of the "Keyboard Shortcuts" wiki page).


Many thanks for any help you can provide!

Macho

___
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] 5.0 Crash on Customer Report->Options

[Tom Weichmann]

Hello,

I'm running GNUCash on Ubuntu 22.04 compiled from source.  I get a segfault
if I open a customer report and click the Options button on the top bar.  I
started from the command line hoping for some info but I only get a
segfault notification after the crash.

$ gnucash
Segmentation fault (core dumped)

Tom
___
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] Company plan for stocks and stock options

[Murugan Muruganandam]

hi Wolfgang

The following example is for Restricted Stock Unit and not Employee Stock 
Options.  (my bad)

ESOPs needs additional steps. i have included a spread sheet (it was easier) to 
give both the accounting.

For ESOP pricing you can manually enter to view the unrealized profit or loss 
in the portfolio report


welcome comments from others


Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Murugan Muruganandam 
Sent: Wednesday, April 5, 2023 10:20 AM
To: Wolfgang Paul Rauchholz ; Stan Brown 

Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Company plan for stocks and stock options

hi Wolfgang

if it is only for tracking purpose i use the following method,  you can review 
and improvise as your need be.


| Date| Operation | Account| Stock 
Qty | Price | Dr | Cr |
|:-:|:-:|:--:|:-:|:-:|::|::|
| 01-01-2022 | Options Grant   | Asset: Stock Options | 5000  |  $20  | 
 $100.000  |   |
||   | Asset: Contingent Asset |
  |  |   |  $100.000  |
||   |  
  |  |  |   |  |
||   |  
  |  |  |   |  |
| 01-01-2023 | Options Vesting | Asset:Stock:Stock ABC   | 1000 |  $20  |   
$20.000   |  |
||   | Income: Other Income|
 |   |  |  $20.000   |
||   | Asset: Stock Options  | 
-1000|   $20  |  |  $20.000   |
||   | Asset: Contingent Asset |
  |   |  $20.000   |









Saludos Cordiales



Murugan




From: Wolfgang Paul Rauchholz 
Sent: Wednesday, April 5, 2023 9:01 AM
To: Stan Brown ; m.muruganan...@hotmail.com 

Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Company plan for stocks and stock options

Hi Stan / Murugan all,

Thanks for picking up and providing your insight. That was very helpful.
I would assume that options and stocks I have not exercised yet cannot get 
managed in gnucash?
Only when exercising options into stocks or selling stock or options?

The objective with gnucash is that I want to manage personal finances; expense 
control, planning, etc..



Best regards,


Wolfgang Rauchholz
+34 627 994 977
https://www.linkedin.com/in/wolfgangrauchholz/



On Tue, Apr 4, 2023 at 8:07 PM Stan Brown  wrote:

On 2023-04-04 10:40, Wolfgang Paul Rauchholz wrote:
>  Fairly new to gnucash and not a finance export, I want to run all my
> personal finances with this great tool.
>
> I installed 5.0 by compiling it under fedora core 37.
>
> I started adding normal daily expenses and all look fine.
>
> One of the doubts I have is how do I correctly add a company plan for stock
> options and stock plan that get vested/distributed every year. As I don't
> buy them there is no cash leaving my bank account.

The options and stocks are part of your compensation as an employee,
right? As such, the accounting would be similar to your accounting for
your paycheck.

Your paycheck (ignoring tax withholding) is
Debit: Cash or Bank account
Credit: Employee income

The stocks would be
Debit: Stock in Company X
Credit: Employee income
and similarly for the options. With stocks and options you'll want to
know number of shares and share prices so that you can compute gains and
losses when you sell them. If they aren't fully vested you will want to
note the vesting date as well.

You'll probably want to have separate accounts for stocks in the company
and stock options. To simplify computing your income tax, you may want
to have separate income accounts for income in money and income in
securities; they could both be subaccounts under an Employee Income account.

The usual disclaimer: I don't know your tax situation or any legal
requirements for how you may need to account for all of this.

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 

[GNC] SQLLite + OFX Import + Bayes = Massive network traffic

[peterb]

I've been maintaining a GnuCash database in a MySQL database for several
years. Lately, I've noticed various stages of OFX import (including
changing accounts, but also hitting the "OK" button to finish the import)
taking more and more time. When on the same LAN as the database it's bad,
perhaps 10 seconds, but when SSH tunnelling from a remote location the
delay becomes truly ridiculous, on the order of 10 to 20 minutes.

Peeking at what's going on with tcpdump, it looks like for an import of
around 50 items clicking the ok button triggers thousands coupon thousand
of SQL inserts, the vast majority of which are somehow related to updating
the bayesian inference database.

My questions are:

(1) Anyone else seeing this? I feel like I must have hit some sort of
quadratic threshold because as I said I've been using this for literally
years and only recently has it gotten noticeably worse.
(2) Workarounds: Is there some reasonable way to prevent OFX import from
doing these updates at all? Failing that, is there some way to safely nuke
*just* the bayesian inference DB and start over (short of starting a
completely new GnuCash db?). This isn't my ideal solution but it might buy
me some time.
(3) Clearly "accessing an SQL DB, remotely, across the internet" is not a
core use case compared to updating a local GnuCash file. But might be a
good performance work issue for some interested person who wants to
contribute to an open source project to poke at.

Thanks!
-Peter
___
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] SQLLite + OFX Import + Bayes = Massive network traffic

[peterb]

Also, despite my error in the Subject: line of this post, I did
actually meant MySQL, and *not* SQLite.


On Wed, Apr 5, 2023 at 2:35 PM peterb  wrote:

> I've been maintaining a GnuCash database in a MySQL database for several
> years. Lately, I've noticed various stages of OFX import (including
> changing accounts, but also hitting the "OK" button to finish the import)
> taking more and more time. When on the same LAN as the database it's bad,
> perhaps 10 seconds, but when SSH tunnelling from a remote location the
> delay becomes truly ridiculous, on the order of 10 to 20 minutes.
>
> Peeking at what's going on with tcpdump, it looks like for an import of
> around 50 items clicking the ok button triggers thousands coupon thousand
> of SQL inserts, the vast majority of which are somehow related to updating
> the bayesian inference database.
>
> My questions are:
>
> (1) Anyone else seeing this? I feel like I must have hit some sort of
> quadratic threshold because as I said I've been using this for literally
> years and only recently has it gotten noticeably worse.
> (2) Workarounds: Is there some reasonable way to prevent OFX import from
> doing these updates at all? Failing that, is there some way to safely nuke
> *just* the bayesian inference DB and start over (short of starting a
> completely new GnuCash db?). This isn't my ideal solution but it might buy
> me some time.
> (3) Clearly "accessing an SQL DB, remotely, across the internet" is not a
> core use case compared to updating a local GnuCash file. But might be a
> good performance work issue for some interested person who wants to
> contribute to an open source project to poke at.
>
> Thanks!
> -Peter
>
___
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] Command line quotes still not fixed

[David H]

And you'll see there's a whole other thread on this -
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.
Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815

If you include a namespace parameter for now it will work.

Cheers David H.

On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I can still only update quotes with the interactive button, the flatpak
> run gnucash command that ran in 4.* is still broken:
> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash
> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file
> parameter
> gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
> small business finance:
> Common Options:  -h [ --help ]  Show this help message  -v [
> --version ]   Show GnuCash version  --debugEnable
> debugging mode: provide deep detail in the  logs.
>This is equivalent to: --log "=info" --log
> "qof=info"  --log "gnc=info"  --extra
>   Enable extra/development/debugging features.  --log arg  Log
> level overrides, of the form
>  "modulename={debug,info,warn,crit,error}"
>  Examples: "--log qof=debug" or "--log
> gnc.backend.file.sx=info" This can be invoked
> multiple times.  --pathsShow paths  --logto arg
> File to log into; defaults to "/tmp/gnucash.trace";
>  can be "stderr" or "stdout".
> Price Quotes Retrieval Options:  -Q [ --quotes ] argExecute price
> quote related commands. The following  commands are
> supported.info: Show
> Finance::Quote version and exposed quote
>  sources.get: Fetch current quotes for all
> foreign  currencies and stocks in the given
> GnuCash  datafile.
>  dump: Fetch current quotes for specified currencies
>or stocks from a specified namespace and print
>the results to the console.
>  This must be followed with a source and one or
>  more symbols, unless the source is "currency"
>  in which case it must be followed with two or
>  more symbols, the first of which is the
>currency in which exchange rates for the rest
>will be quoted.   --namespace arg
> Regular expression determining which namespace
>  commodities will be retrieved for when using the get
>command  -V [ --verbose ]   When using the dump command list all of
> the parameters Finance::Quote returns for the
> symbol instead of the  ones that Gnucash requires.
> Report Generation Options:  -R [ --report ] argExecute report related
> commands. The following  commands are supported.
> list: Lists available
> reports.   show: Describe the options modified in
> the named  report. A datafile may be
> specified to  describe some saved options.
>  run: Run the named report in the given GnuCash
> datafile.   --name arg
>Name of the report to run
> --export-type arg  Specify export type
> --output-file arg  Output file for report
> dgp@dgp-p6803w:~$ ls -l
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash-rw-rw-r-- 2 dgp dgp 2899938 Apr
> 4 17:55 /home/dgp/GnuCash/ubuntu-DGPickett.gnucashdgp@dgp-p6803w:~$
> ___
> 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] Command line quotes still not fixed

[David G. Pickett via gnucash-user]

I saw that later.  What's the default namespace?


-Original Message-
From: David H 
To: David G. Pickett 
Cc: gnucash-user@gnucash.org 
Sent: Wed, Apr 5, 2023 3:45 pm
Subject: Re: [GNC] Command line quotes still not fixed

And you'll see there's a whole other thread on this - 
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.  Bug 
report at https://bugs.gnucash.org/show_bug.cgi?id=798815

If you include a namespace parameter for now it will work.
Cheers David H.
On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user 
 wrote:

I can still only update quotes with the interactive button, the flatpak run 
gnucash command that ran in 4.* is still broken:
dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash 
--quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file 
parameter
gnucash-cli [options] [datafile] - GnuCash, accounting for personal and small 
business finance:
Common Options:  -h [ --help ]          Show this help message  -v [ --version 
]       Show GnuCash version  --debug                Enable debugging mode: 
provide deep detail in the                          logs.                       
  This is equivalent to: --log "=info" --log "qof=info"                         
 --log "gnc=info"  --extra                Enable extra/development/debugging 
features.  --log arg              Log level overrides, of the form              
            "modulename={debug,info,warn,crit,error}"                         
Examples: "--log qof=debug" or "--log                          
gnc.backend.file.sx=info"                         This can be invoked multiple 
times.  --paths                Show paths  --logto arg            File to log 
into; defaults to "/tmp/gnucash.trace";                          can be 
"stderr" or "stdout".
Price Quotes Retrieval Options:  -Q [ --quotes ] arg    Execute price quote 
related commands. The following                          commands are 
supported.                                                    info: Show 
Finance::Quote version and exposed quote                                  
sources.                            get: Fetch current quotes for all foreign   
                               currencies and stocks in the given GnuCash       
                           datafile.                           dump: Fetch 
current quotes for specified currencies                                  or 
stocks from a specified namespace and print                                 the 
results to the console.                                 This must be followed 
with a source and one or                                 more symbols, unless 
the source is "currency"                                  in which case it must 
be followed with two or                                  more symbols, the 
first of which is the                                  currency in which 
exchange rates for the rest                                  will be quoted.    
                       --namespace arg        Regular expression determining 
which namespace                          commodities will be retrieved for when 
using the get                          command  -V [ --verbose ]       When 
using the dump command list all of the parameters                         
Finance::Quote returns for the symbol instead of the                          
ones that Gnucash requires.
Report Generation Options:  -R [ --report ] arg    Execute report related 
commands. The following                          commands are supported.        
                                            list: Lists available reports.      
                     show: Describe the options modified in the named           
                       report. A datafile may be specified to                   
               describe some saved options.                           run: Run 
the named report in the given GnuCash                                 datafile. 
                          --name arg             Name of the report to run      
                     --export-type arg      Specify export type                 
          --output-file arg      Output file for report                         
dgp@dgp-p6803w:~$ ls -l /home/dgp/GnuCash/ubuntu-DGPickett.gnucash-rw-rw-r-- 2 
dgp dgp 2899938 Apr  4 17:55 
/home/dgp/GnuCash/ubuntu-DGPickett.gnucashdgp@dgp-p6803w:~$
___
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 b

Re: [GNC] SQLLite + OFX Import + Bayes = Massive network traffic

[David Carlson]

I am not sure which OS TCPDump runs in, but it would still be very helpful
to list which version of GnuCash you are running and which OS.

On Wed, Apr 5, 2023 at 2:45 PM peterb  wrote:

> Also, despite my error in the Subject: line of this post, I did
> actually meant MySQL, and *not* SQLite.
>
>
> On Wed, Apr 5, 2023 at 2:35 PM peterb  wrote:
>
> > I've been maintaining a GnuCash database in a MySQL database for several
> > years. Lately, I've noticed various stages of OFX import (including
> > changing accounts, but also hitting the "OK" button to finish the import)
> > taking more and more time. When on the same LAN as the database it's bad,
> > perhaps 10 seconds, but when SSH tunnelling from a remote location the
> > delay becomes truly ridiculous, on the order of 10 to 20 minutes.
> >
> > Peeking at what's going on with tcpdump, it looks like for an import of
> > around 50 items clicking the ok button triggers thousands coupon thousand
> > of SQL inserts, the vast majority of which are somehow related to
> updating
> > the bayesian inference database.
> >
> > My questions are:
> >
> > (1) Anyone else seeing this? I feel like I must have hit some sort of
> > quadratic threshold because as I said I've been using this for literally
> > years and only recently has it gotten noticeably worse.
> > (2) Workarounds: Is there some reasonable way to prevent OFX import from
> > doing these updates at all? Failing that, is there some way to safely
> nuke
> > *just* the bayesian inference DB and start over (short of starting a
> > completely new GnuCash db?). This isn't my ideal solution but it might
> buy
> > me some time.
> > (3) Clearly "accessing an SQL DB, remotely, across the internet" is not a
> > core use case compared to updating a local GnuCash file. But might be a
> > good performance work issue for some interested person who wants to
> > contribute to an open source project to poke at.
> >
> > Thanks!
> > -Peter
> >
> ___
> 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] Command line quotes still not fixed

[David H]

What default namespace, look in YOUR security editor - as far as
I know it's whatever you set up.  I have a vague recollection that it
doesn't really care and will be happy with just a single character
i.e. --namespace=x
but don't quote me on that.

By the way your original email could do with some halfway decent formatting
- see what the mailing list received at
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html you
might like to tweak that to make it readable in future.

Cheers David H.

On Thu, 6 Apr 2023 at 07:46, David G. Pickett  wrote:

> I saw that later.  What's the default namespace?
>
>
> -Original Message-
> From: David H 
> To: David G. Pickett 
> Cc: gnucash-user@gnucash.org 
> Sent: Wed, Apr 5, 2023 3:45 pm
> Subject: Re: [GNC] Command line quotes still not fixed
>
> And you'll see there's a whole other thread on this -
> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.
> Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815
>
> If you include a namespace parameter for now it will work.
>
> Cheers David H.
>
> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> I can still only update quotes with the interactive button, the flatpak
> run gnucash command that ran in 4.* is still broken:
> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash
> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file
> parameter
> gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
> small business finance:
> Common Options:  -h [ --help ]  Show this help message  -v [
> --version ]   Show GnuCash version  --debugEnable
> debugging mode: provide deep detail in the  logs.
>This is equivalent to: --log "=info" --log
> "qof=info"  --log "gnc=info"  --extra
>   Enable extra/development/debugging features.  --log arg  Log
> level overrides, of the form
>  "modulename={debug,info,warn,crit,error}"
>  Examples: "--log qof=debug" or "--log
> gnc.backend.file.sx=info" This can be invoked
> multiple times.  --pathsShow paths  --logto arg
> File to log into; defaults to "/tmp/gnucash.trace";
>  can be "stderr" or "stdout".
> Price Quotes Retrieval Options:  -Q [ --quotes ] argExecute price
> quote related commands. The following  commands are
> supported.info: Show
> Finance::Quote version and exposed quote
>  sources.get: Fetch current quotes for all
> foreign  currencies and stocks in the given
> GnuCash  datafile.
>  dump: Fetch current quotes for specified currencies
>or stocks from a specified namespace and print
>the results to the console.
>  This must be followed with a source and one or
>  more symbols, unless the source is "currency"
>  in which case it must be followed with two or
>  more symbols, the first of which is the
>currency in which exchange rates for the rest
>will be quoted.   --namespace arg
> Regular expression determining which namespace
>  commodities will be retrieved for when using the get
>command  -V [ --verbose ]   When using the dump command list all of
> the parameters Finance::Quote returns for the
> symbol instead of the  ones that Gnucash requires.
> Report Generation Options:  -R [ --report ] argExecute report related
> commands. The following  commands are supported.
> list: Lists available
> reports.   show: Describe the options modified in
> the named  report. A datafile may be
> specified to  describe some saved options.
>  run: Run the named report in the given GnuCash
> datafile.   --name arg
>Name of the report to run
> --export-type arg  Specify export type
> --output-file arg  Output file for report
> dgp@dgp-p6803w:~$ ls -l
> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash-rw-rw-r-- 2 dgp dgp 2899938 Apr
> 4 17:55 /home/dgp/GnuCash/ubuntu-DGPickett.gnucashdgp@dgp-p6803w:~$
>
> ___
> 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 

Re: [GNC] SQLLite + OFX Import + Bayes = Massive network traffic

[peterb]

Good point. Mac OS X, Gnucash 4.11.

On Wed, Apr 5, 2023 at 6:00 PM David Carlson 
wrote:

> I am not sure which OS TCPDump runs in, but it would still be very helpful
> to list which version of GnuCash you are running and which OS.
>
> On Wed, Apr 5, 2023 at 2:45 PM peterb  wrote:
>
>> Also, despite my error in the Subject: line of this post, I did
>> actually meant MySQL, and *not* SQLite.
>>
>>
>> On Wed, Apr 5, 2023 at 2:35 PM peterb  wrote:
>>
>> > I've been maintaining a GnuCash database in a MySQL database for several
>> > years. Lately, I've noticed various stages of OFX import (including
>> > changing accounts, but also hitting the "OK" button to finish the
>> import)
>> > taking more and more time. When on the same LAN as the database it's
>> bad,
>> > perhaps 10 seconds, but when SSH tunnelling from a remote location the
>> > delay becomes truly ridiculous, on the order of 10 to 20 minutes.
>> >
>> > Peeking at what's going on with tcpdump, it looks like for an import of
>> > around 50 items clicking the ok button triggers thousands coupon
>> thousand
>> > of SQL inserts, the vast majority of which are somehow related to
>> updating
>> > the bayesian inference database.
>> >
>> > My questions are:
>> >
>> > (1) Anyone else seeing this? I feel like I must have hit some sort of
>> > quadratic threshold because as I said I've been using this for literally
>> > years and only recently has it gotten noticeably worse.
>> > (2) Workarounds: Is there some reasonable way to prevent OFX import from
>> > doing these updates at all? Failing that, is there some way to safely
>> nuke
>> > *just* the bayesian inference DB and start over (short of starting a
>> > completely new GnuCash db?). This isn't my ideal solution but it might
>> buy
>> > me some time.
>> > (3) Clearly "accessing an SQL DB, remotely, across the internet" is not
>> a
>> > core use case compared to updating a local GnuCash file. But might be a
>> > good performance work issue for some interested person who wants to
>> > contribute to an open source project to poke at.
>> >
>> > Thanks!
>> > -Peter
>> >
>> ___
>> 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] 5.0 Crash on Customer Report->Options

[john]

That's been reported as https://bugs.gnucash.org/show_bug.cgi?id=798812.

Regards,
John Ralls


> On Apr 5, 2023, at 8:17 AM, Tom Weichmann  wrote:
> 
> Hello,
> 
> I'm running GNUCash on Ubuntu 22.04 compiled from source.  I get a segfault
> if I open a customer report and click the Options button on the top bar.  I
> started from the command line hoping for some info but I only get a
> segfault notification after the crash.
> 
> $ gnucash
> Segmentation fault (core dumped)
> 
> Tom
> ___
> 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] Command line quotes still not fixed

[john]

The namespace parameter is a regular expression, so .* will get the quotes from 
all of your namespaces.

Regards,
John Ralls


> On Apr 5, 2023, at 3:46 PM, David H  wrote:
> 
> What default namespace, look in YOUR security editor - as far as
> I know it's whatever you set up.  I have a vague recollection that it
> doesn't really care and will be happy with just a single character
> i.e. --namespace=x
> but don't quote me on that.
> 
> By the way your original email could do with some halfway decent formatting
> - see what the mailing list received at
> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106230.html you
> might like to tweak that to make it readable in future.
> 
> Cheers David H.
> 
> On Thu, 6 Apr 2023 at 07:46, David G. Pickett  wrote:
> 
>> I saw that later.  What's the default namespace?
>> 
>> 
>> -Original Message-
>> From: David H 
>> To: David G. Pickett 
>> Cc: gnucash-user@gnucash.org 
>> Sent: Wed, Apr 5, 2023 3:45 pm
>> Subject: Re: [GNC] Command line quotes still not fixed
>> 
>> And you'll see there's a whole other thread on this -
>> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106181.html.
>> Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798815
>> 
>> If you include a namespace parameter for now it will work.
>> 
>> Cheers David H.
>> 
>> On Wed, 5 Apr 2023 at 23:00, David G. Pickett via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>> I can still only update quotes with the interactive button, the flatpak
>> run gnucash command that ran in 4.* is still broken:
>> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash
>> --quotes get /home/dgp/GnuCash/ubuntu-DGPickett.gnucashMissing data file
>> parameter
>> gnucash-cli [options] [datafile] - GnuCash, accounting for personal and
>> small business finance:
>> Common Options:  -h [ --help ]  Show this help message  -v [
>> --version ]   Show GnuCash version  --debugEnable
>> debugging mode: provide deep detail in the  logs.
>>   This is equivalent to: --log "=info" --log
>> "qof=info"  --log "gnc=info"  --extra
>>  Enable extra/development/debugging features.  --log arg  Log
>> level overrides, of the form
>> "modulename={debug,info,warn,crit,error}"
>> Examples: "--log qof=debug" or "--log
>> gnc.backend.file.sx=info" This can be invoked
>> multiple times.  --pathsShow paths  --logto arg
>> File to log into; defaults to "/tmp/gnucash.trace";
>> can be "stderr" or "stdout".
>> Price Quotes Retrieval Options:  -Q [ --quotes ] argExecute price
>> quote related commands. The following  commands are
>> supported.info: Show
>> Finance::Quote version and exposed quote
>> sources.get: Fetch current quotes for all
>> foreign  currencies and stocks in the given
>> GnuCash  datafile.
>> dump: Fetch current quotes for specified currencies
>>   or stocks from a specified namespace and print
>>   the results to the console.
>> This must be followed with a source and one or
>> more symbols, unless the source is "currency"
>> in which case it must be followed with two or
>> more symbols, the first of which is the
>>   currency in which exchange rates for the rest
>>   will be quoted.   --namespace arg
>>Regular expression determining which namespace
>> commodities will be retrieved for when using the get
>>   command  -V [ --verbose ]   When using the dump command list all of
>> the parameters Finance::Quote returns for the
>> symbol instead of the  ones that Gnucash requires.
>> Report Generation Options:  -R [ --report ] argExecute report related
>> commands. The following  commands are supported.
>>list: Lists available
>> reports.   show: Describe the options modified in
>> the named  report. A datafile may be
>> specified to  describe some saved options.
>> run: Run the named report in the given GnuCash
>>datafile.   --name arg
>>   Name of the report to run
>> --export-type arg  Specify export type
>> --output-file arg  Output file for report
>> dgp@dgp-p6803w:~$ ls -l
>> /home/dgp/GnuCash/ubuntu-DGPickett.gnucash-rw-rw-r-- 2 dgp dgp 2899938 Apr
>> 4 17:55 /home/dgp/GnuCash/ubuntu-DGPickett.gnucashdgp@dgp-p6803w:~$
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription prefer

Re: [GNC] SQLLite + OFX Import + Bayes = Massive network traffic

[john]

You can remove Bayesian matches using Tools>Import Map Editor. 

Regards,
John Ralls


> On Apr 5, 2023, at 4:37 PM, peterb  wrote:
> 
> Good point. Mac OS X, Gnucash 4.11.
> 
> On Wed, Apr 5, 2023 at 6:00 PM David Carlson 
> wrote:
> 
>> I am not sure which OS TCPDump runs in, but it would still be very helpful
>> to list which version of GnuCash you are running and which OS.
>> 
>> On Wed, Apr 5, 2023 at 2:45 PM peterb  wrote:
>> 
>>> Also, despite my error in the Subject: line of this post, I did
>>> actually meant MySQL, and *not* SQLite.
>>> 
>>> 
>>> On Wed, Apr 5, 2023 at 2:35 PM peterb  wrote:
>>> 
 I've been maintaining a GnuCash database in a MySQL database for several
 years. Lately, I've noticed various stages of OFX import (including
 changing accounts, but also hitting the "OK" button to finish the
>>> import)
 taking more and more time. When on the same LAN as the database it's
>>> bad,
 perhaps 10 seconds, but when SSH tunnelling from a remote location the
 delay becomes truly ridiculous, on the order of 10 to 20 minutes.
 
 Peeking at what's going on with tcpdump, it looks like for an import of
 around 50 items clicking the ok button triggers thousands coupon
>>> thousand
 of SQL inserts, the vast majority of which are somehow related to
>>> updating
 the bayesian inference database.
 
 My questions are:
 
 (1) Anyone else seeing this? I feel like I must have hit some sort of
 quadratic threshold because as I said I've been using this for literally
 years and only recently has it gotten noticeably worse.
 (2) Workarounds: Is there some reasonable way to prevent OFX import from
 doing these updates at all? Failing that, is there some way to safely
>>> nuke
 *just* the bayesian inference DB and start over (short of starting a
 completely new GnuCash db?). This isn't my ideal solution but it might
>>> buy
 me some time.
 (3) Clearly "accessing an SQL DB, remotely, across the internet" is not
>>> a
 core use case compared to updating a local GnuCash file. But might be a
 good performance work issue for some interested person who wants to
 contribute to an open source project to poke at.
 
 Thanks!
 -Peter
 
>>> ___
>>> 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.

___
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] Online Quotes

[Anna Scott]

Since installing version 5.0 of gnucash, online quotes has stopped 
working for me. I have tried uninstalling and reinstalling perl and the 
finance quote function several times but no joy. When I try and retrieve 
quotes via the price tool, I get two blank perl screens flash up but not 
error messages and no update. I have looked in the bin directory and 
gnc-fq-dump seems to be missing?? Could this be the problem? How can I 
download it?


Many thanks for any help, Anna

___
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] Find not working in Gnucash for Windows 5.0

[Tute Terner]

When I search in the Find dialog box using the Description field, 
everything works. But when I search by the Memo field or the 
'Description, Notes or Memo' field or the Action field the Search 
Results always turn out empty, even though the search string is present 
in the Memo or Action fields of some transactions.  I am using Gnucash 
5.0 for Windows, but I have noticed this in some previous versions too. 
Am I doing something incorrect or is this a bug. I don't see that 
anybody has mentioned this behaviour in the mailing list or in the bug 
list. 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] Find not working in Gnucash for Windows 5.0

[Stan Brown]

On 2023-04-05 07:18, Tute Terner wrote:
> When I search in the Find dialog box using the Description field,
> everything works. But when I search by the Memo field or the
> 'Description, Notes or Memo' field or the Action field the Search
> Results always turn out empty, even though the search string is present
> in the Memo or Action fields of some transactions.  I am using Gnucash
> 5.0 for Windows, but I have noticed this in some previous versions too.
> Am I doing something incorrect or is this a bug. I don't see that
> anybody has mentioned this behaviour in the mailing list or in the bug
> list. Thank you.

Probably you already know this, but ...

Gnucash will only find transactions that are in the window that is on
top when you initiate the Find.

Therefore, if you want to make sure of getting all matching transactions
in all accounts rather than just one, you need to start your Find while
the Accounts window (lost of accounts) is on top.

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.