Re: [GNC] [SPAM] Re: Font size change

[Axel Essbaum]

I just went through this. Be aware that the path in the link John sent points 
to the wrong place.

You need to create the following file:

~/Library/Application Support/GnuCash/gtk-3.0.css

Which should contain something(s) like this:

* {font: 13px Lucida Grande, sans-serif;}

The online documentation wrongly directs you to create ~/Library/Application 
Support/GnuCash/config/gtk-3.0/gtk-3.0.css.

Good luck,

- Axel

—
Axel Essbaum
a...@essbaum.com 


> On 31 Dec 2024, at 04:34, John Ralls  wrote:
> 
> Maybe. The stylesheets only work on reports and you sort of implied that 
> you’re trying to change the font size in the UI. 
> 
> For a discussion about how t change the fonts in the UI see 
> https://wiki.gnucash.org/wiki/Gtk3.
> 
> Regards,
> John Ralls
> 
> 
>> On Dec 30, 2024, at 18:02, Ted Rubin via gnucash-user 
>>  wrote:
>> 
>> Greetings 
>> 
>> I’m having an issue with GNU Cash on my Apple Silicon machine. GNU Cash 
>> version: 
>> 
>> Version: 5.10
>> Build ID: 5.10+(2024-12-14)
>> 
>> The main issue is I can’t get the font size to actually reflect in the 
>> program.
>> 
>> Example 
>> 
>> I go to Edit> Style Sheets > default 
>> 
>> 
>> 
>> However, when I restart GNUcash, no changes take effect. Am I missing 
>> something, or is there a specific CSS file I need to edit?
>> 
>> Thanks 
>> 
>> Ted___
>> 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] Budget data disappeared in 4.14

[larry johnston]

Hi,

False alarm. She had mistakenly entered data as if it was 2025 and I guess
that triggered GNUcash to think we were in 2025 and there was no 2025
budget, so no data was available. Everything seems to be back.

Larry

On Tue, Dec 31, 2024 at 4:53 PM larry johnston 
wrote:

> Hi,
>
> My companion is working in GNUcash 4.14. she has entered most of her year
> end data and went to check her budget and all the information in the budget
> except for the categories is gone. She made a backup of the file, which now
> has her data but no budget. She opened the most recent copy of the file and
> the budget is there but none of the data she had entered today (which is
> quite a lot since she was behind in entering data). Can she copy the budget
> and move it to the backup file that has the data but not the budget? If so,
> what are the steps?
>
> TIA,
>
> Larry
>
___
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] previous issue with gnucash-cli on macOS

[gnucash]

Jim DeLaHunt, I think you have a BINGO!


Last login: Tue Dec 31 15:47:12 on ttys000
kcburns@Mac001 ~ % /Applications/GnuCash.app/Contents/MacOS/gnucash-cli 
-Q get /Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Found Finance::Quote version 1.64.
kcburns@Mac001 ~ %


That is the result I expected to see!

I think I was had by the copy & paste.

I have already updated my quotes for this evening, so I will verify it 
on Thursday after the market reopens.


Thanks,

Ken


On 12/31/24 4:45 PM, gnucash-user-requ...@gnucash.org wrote:

Hello, KCBurns:

On 2024-12-31 12:52,gnuc...@kcburns.com wrote:

Last login: Tue Dec 31 15:24:15 on console
kcburns@Mac001 ~ %
/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get
/Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Missing data file parameter

gnucash-cli [options] [datafile] - GnuCash, accounting for personal
and small business finance:

... [help text elided] ...


? --output-file arg? Output file for report


zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash
kcburns@Mac001 ~ %


It looks like your command is now spelled correctly, but it is broken
into two lines in the email message.? Is that just an artifact of email
line wrapping, or is there in fact a linefeed character in your command
line?

I see that Gnucash says, "Missing data file parameter", as if all it saw
was "/App?/gnucash-cli -Q get". Then the Terminal shell ("zsh") says,
"zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash", as if
it was trying to run "/Users/kcburns/GnuCash/KCBurns.gnucash" as a command.

Perhaps try to enter the command again, but being careful of the
spelling and spacing?

e.g. Copy "/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get"
from your previous command, then type a space character, then copy
"/Users/kcburns/GnuCash/KCBurns.gnucash" from your previous command,
then press Return. See if that gets interpreted as a single command.


___
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] Why did "Assign as payment…" remove splits and notes from my payment transaction?

[Geert Janssens]

Op dinsdag 31 december 2024 11:17:49 Midden-Europese standaardtijd schreef 
Geert 
Janssens:
> The other option I would have suggested is to work with two payment
> transactions rather than one transaction with multiple splits. One payment
> transaction representing the money you actually received and one payment
> transaction representing the service charge. Unfortunately you can't create
> a payment transaction that transfers to an expense account (for no other
> reason than the expense accounts are not shown in the list of transfer
> accounts in the payment window). So even in this case you would have to do
> some post-processing. I'll describe the steps anyway in case you prefer
> this way of working:
> 
> 
> 1. as in the other scenario, import the Paypal transactions as simple
> two-split transactions, only representing the money you effectively
> receive.
> 
> 
> 2. again use Assign as payment to assign this transaction without
> modification to the invoice as partial payment.
> 
> 
> 3. Next, create a new payment for this invoice using Process Payment for the
> amount of the service charge. Now it would have been nice to be able to
> select an expense account directly but that's not possible via the payment
> window. So instead choose an arbitrary account you can select and complete
> this payment.
> 
> 
> 4. Open this new payment in a register and change the arbitrary account into
> the proper expense account.
> 
> 
> That as well should mark your invoice as fully paid.

I have pushed a change to gnucash this afternoon that will let you select an 
expense 
account as transfer account. So the second scenario should become easier to 
apply 
starting with gnucash 5.11

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] Why did "Assign as payment…" remove splits and notes from my payment transaction?

[Geert Janssens]

Op maandag 30 december 2024 22:45:09 Midden-Europese standaardtijd schreef Jim 
DeLaHunt:
> > When you assign payment to the invoice, the existing transaction will
> > be overwritten with an entry in the account payable, and the split
> > will apply automatically in the AP.
> 
> This certainly matches what I observe in my GnuCash book, but it
> certainly is not what I want to happen.  Can you point me to further
> documentation about what GnuCash intends to do when I assign a
> transaction as payment? Or, can you point me to which parts of the code
> I should read?
> 

The payment management logic in the business features is limited in what it can 
do. 
Basically it can only handle pre-existing transactions with a single split 
outside of the AR or 
AP accounts.

If there are more it will choose one (using some very simple heuristics) and 
discard the 
others. It will also discard the pre-existing AR or AP splits and replace them 
with whatever 
you select in the payment dialog (though it will use the AR or AP splits to 
pre-select 
documents and pre-payments in the payment window if it can).

The use case this was written for is the most simple case of importing payment 
data from 
your bank account and later linking this with one or more invoices.

The use case of payment charges was never considered unfortunately.

It's been a while so I have to think really hard why I chose to discard all 
splits except that 
one - or more precisely why I chose not to change that behavior when I was 
working on 
the business code.

I believe the reason is the payment window has no way to visualize multiple non 
AR/AP 
splits so it can not reliably display such a pre-existing transaction.

What it can represent is any AR/AP split that links to an invoice or 
pre-/overpayment from 
the selected customer and one transfer split (the "bank" account split). Every 
aspect of it 
can also be modified: which invoices are being (partially or over-)paid, what 
is the total 
amount of the payment, and what is the transfer account.

Having more than one transfer split would result in a incomplete and possibly 
misleading 
representation of the transaction in the current payment window and would lead 
to 
ambiguity when making changes.

For example the value in the Payment field, should that represent the invoice 
amount 
being paid (meaning the sum of the money you actually received and the service 
charge) 
or just the amount of money you received ? What if you need to change that 
value for 
some reason, would that change reflect only a change in money received or also 
an 
increase in service charge ? So would that affect the amount of invoice being 
paid for or 
not ? As the service charge is not visible in the dialog, you can't 
disambiguate that. To 
avoid this ambiguity I chose to only work with a single non-AR/AP split. In 
hindsight it 
would have been much nicer to warn the user about this. I know the code does in 
some 
scenarios, but this one was seemingly skipped.

To really support your use case, the gui should be extended to be able to show 
all non-AR/
AP splits. I did consider that, but it was more work than I could do at the 
time.

> This also does not match what I took from the documentation. The GnuCash
> 
> manual, section 7.6. "Process Invoice Payment", says:
> > There is an alternative way of assigning a payment to (one or more)
> > invoices where the payment transaction already exists…. This can best
> > be done starting from the asset account register holding the imported
> > payment transaction (like your bank account). In that account, select
> > the payment, right-click ([two-finger]-click for |macOS|) and choose
> > *Assign as payment...*. The payment window will pop-up, partly filled
> > in with the information from the transaction. Fill in the missing
> > information like the proper customer and invoice to complete the payment.
> 
> This does not mention that the payment transaction will get rewritten,
> and splits will get discarded.
> 

True, though it doesn't mention all data from the existing transaction will be 
kept either :(
I agree this could do with a better warning.

> It occurs to me that one workaround is that I enter the payment
> transaction as if there were no service charges. Then I assign the
> transaction as payment for the invoice, letting GnuCash rewrite it. Then
> I modify the transaction to add the service charge and reduce the amount
> deposited in my bank account.
> 

That is probably the easiest way to work around this. A slight variation is to 
enter the 
payment transaction with only the amount you really received, then assign the 
transaction 
as partial payment (the exact same process as in your suggestion, only with a 
lower 
payment amount) and then afterwards add the service charge and increase the AR 
split 
amount to match your invoice total.

> Also, you advise:
> > You should create your three-split transactions in your invoice…
> 
> I am a bit surprised by this.  

Re: [GNC] Why did "Assign as payment…" remove splits and notes from my payment transaction?

[Jediator]

You really don't want to read the code.  It would be more confusing and 
you would have more questions than answers.  I will try to answer your 
questions as best I can.


Q1 & Q2:  I guess the term "rewrite transaction" may not be accurate.  
What really happened is that the transaction entry in your cash account, 
when you assign it as payment to an invoice, will be linked to a new 
payment entry in the AP registry, indicating that the invoice is paid.  
The old entry in your cash account, regardless if it has a split or not, 
will be removed or discarded.  This is due to the double-entry system of 
GnuCash.  Each transaction has two entries in two different accounts.  
So when you changed one entry to a different account, GnuCash 
automatically removed the entry in the old account.  In your case of 
assigning a payment to an invoice, you basically change the payment 
entry to a new one in AP.  The old one will be removed.


Q3: Again, the correct way to do this is create multiple entries in your 
invoice.  Say if you create an itemized invoice with parts and labor and 
shipping etc., you create an invoice entry for each item associated with 
a corresponding income account.  When the invoice is created, an invoice 
entry with split will be created in your AP account.  When you assign a 
payment from a cash account, a new payment entry will be created in the 
same AP account, which balances out that invoice.


Q4: When an invoice is paid, you should see an entry in the AP account 
with the same amount in the payment column.  Or you can view in the 
customer report.  Unfortunately the current customer report doesn't show 
which payment is for which invoice (maybe a new feature request is 
needed), especially when you have multiple invoices with the same 
amount.  So what I usually do is to manually enter the invoice ID in the 
reference field when assigning a payment or directly in the AP registry.


Hope this helps!  Cheers!

ND

On 12/30/24 4:45 PM, Jim DeLaHunt wrote:

Thank you for the reply. It leads me to further questions.

When you assign payment to the invoice, the existing transaction will 
be overwritten with an entry in the account payable, and the split 
will apply automatically in the AP.
This certainly matches what I observe in my GnuCash book, but it 
certainly is not what I want to happen.  Can you point me to further 
documentation about what GnuCash intends to do when I assign a 
transaction as payment? Or, can you point me to which parts of the 
code I should read?


This also does not match what I took from the documentation. The 
GnuCash manual, section 7.6. "Process Invoice Payment", says:


There is an alternative way of assigning a payment to (one or more) 
invoices where the payment transaction already exists…. This can best 
be done starting from the asset account register holding the imported 
payment transaction (like your bank account). In that account, select 
the payment, right-click ([two-finger]-click for |macOS|) and choose 
*Assign as payment...*. The payment window will pop-up, partly filled 
in with the information from the transaction. Fill in the missing 
information like the proper customer and invoice to complete the 
payment.


This does not mention that the payment transaction will get rewritten, 
and splits will get discarded.


It occurs to me that one workaround is that I enter the payment 
transaction as if there were no service charges. Then I assign the 
transaction as payment for the invoice, letting GnuCash rewrite it. 
Then I modify the transaction to add the service charge and reduce the 
amount deposited in my bank account.


Also, you advise:


You should create your three-split transactions in your invoice…
I am a bit surprised by this.  Do you mean that I should I should list 
the service charge from my payment processor as a credit in the 
invoice, where the customer will see it?  It seems to me that my 
customer won't care, and does not need to know, details about the 
terms and feed of my payment processor.


Implicit answers to my questions:


Q1. Is this the expected behaviour?

Apparently "yes".


Q2. What does the "Assign as payment" of a payment transaction to an 
invoice actually do?  The GnuCash manual, section 7.6. "Process 
Invoice Payment", says what steps to take to perform an assignment, 
but it does not explain what GnuCash does in the course of the 
assignment.  It does not lead me to believe that it will rewrite a 
transaction, and discard splits.
Apparently the expected behaviour is for GnuCash to rewrite the 
payment transaction.


These questions are still open:

Q3. What is the correct way to enter a transaction which pays an 
invoice and incurs service fees? Should I always create the 
transaction with "Process Payment…" from the business features if it 
will eventually be part of an invoice payment?  Is there a way to 
make an existing transaction an invoice payment without losing what I 
put into the transaction?


Q4. If I 

Re: [GNC] [SPAM] Re: Font size change

[Ted Rubin via gnucash-user]

Thanks so much for all the help, I’m still trying to get this to work.

 File is located in the correct folder ~/application support/gnucash/gtk.css


These are the two attempts and making the code work both don’t change anything. 




This is what it shows when I reboot and also creates a stylesheet 2.0.css file 










I know this is simple in some way and appreciate all the help.

Ted

> On Dec 31, 2024, at 12:59 PM, John Ralls  wrote:
> 
> There’s a short one at https://wiki.gnucash.org/wiki/GTK3#Via_css that will 
> set the font globally.
> 
> Regards,
> John Ralls
> 
> 
>> On Dec 31, 2024, at 09:53, Ted Rubin  wrote:
>> 
>> Thanks 
>> 
>> Could someone send me a example of a style sheet that would work?
>> 
>> Ted 
>> 
>>> On Dec 31, 2024, at 12:33 PM, Flyeta  wrote:
>>> 
>>> Odd. I’ve found 
>>> ~/Library/Application Support/GnuCash/gtk-3.0.css
>>> to be the only path that works for me. Just tested it again, with the same 
>>> result:
>>> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css
>>> does not work for me.
>>> 
>>> MacOS 14.7.1 Sonoma, Gnucash 5.10 (Apple silicon). 
>>> 
 On Dec 31, 2024, at 12:19 PM, John Ralls  wrote:
 
 I just tested that path and it works, as does the one you suggest.
 
 Regards,
 John Ralls
 
> On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
> 
> The online documentation wrongly directs you to create 
> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css.
 
 ___
 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] Budget data disappeared in 4.14

[larry johnston]

Hi,

My companion is working in GNUcash 4.14. she has entered most of her year
end data and went to check her budget and all the information in the budget
except for the categories is gone. She made a backup of the file, which now
has her data but no budget. She opened the most recent copy of the file and
the budget is there but none of the data she had entered today (which is
quite a lot since she was behind in entering data). Can she copy the budget
and move it to the backup file that has the data but not the budget? If so,
what are the steps?

TIA,

Larry
___
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] previous issue with gnucash-cli on macOS

[gnucash]

Last login: Tue Dec 31 15:24:15 on console
kcburns@Mac001 ~ % /Applications/GnuCash.app/Contents/MacOS/gnucash-cli 
-Q get

/Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Missing 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


zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash
kcburns@Mac001 ~ %





On 12/31/24 10:48 AM, gnucash-user-requ...@gnucash.org wrote:

/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get
/Users/kcburns/GnuCash/KCBurns.gnucash

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

Re: [GNC] previous issue with gnucash-cli on macOS

[gnucash]

Sherlock, I don't care whether I user a URI with a scheme, I just want 
something that works.


Ken


kcburns@Mac001 ~ % /Applications/GnuCash.app/Contents/MacOS/gnucash-cli 
-Q get

file:///Users/kcburns/GnuCash/KCBurns.gnucash
Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Missing 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


zsh: no such file or directory: 
file:///Users/kcburns/GnuCash/KCBurns.gnucash

kcburns@Mac001 ~ %





Ken,

If you insist on using a URI with a scheme, try:

/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get
file:///Users/kcburns/GnuCash/KCBurns.gnucash

Note: Three slashes after file:

Regards,

Sherlock


On 12/30/24 7:07 PM, Sherlock wrote:

Ken,

Try:

/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get /Users/
kcburns/GnuCash/KCBurns.gnucash

Regards,

Sherlock


On 12/30/24 6:14 PM, gnuc...@kcburns.com wrote:

I am using zsh and default XML storage.

Last login: Mon Dec 30 20:33:37 on ttys001
kcburns@Mac001 ~ % ls /Users/kcburns/GnuCash/KCBurns.gnucash
/Users/kcburns/GnuCash/KCBurns.gnucash

kcburns@Mac001 ~ %
kcburns@Mac001 ~ % /Applications/GnuCash.app/Contents/macOS/gnucash-
cli -Q get file:/Users/kcburns/GnuCash/KCBurns.gnucash
Application Path /Applications/GnuCash.app/Contents/macOS/gnucash-cli
* 20:42:44? WARN  failed to load gncmod-backend-dbi from
relative path
* 20:42:44 ERROR  required library gncmod-backend-dbi not
found.
* 20:42:44? WARN  failed to load gncmod-backend-xml from
relative path
* 20:42:44 ERROR  required library gncmod-backend-xml not
found.
* 20:42:44 ERROR  g_settings_schema_source_lookup: assertion
'source != NULL' failed
* 20:42:44 ERROR  g_settings_new_full: assertion 'schema !=
NULL' failed
* 20:42:44? WARN 
[gnc_gsettings_get_settings_obj()] Ignoring attempt to access unknown
gsettin

Re: [GNC] previous issue with gnucash-cli on macOS

[Jim DeLaHunt]

Hello, KCBurns:

On 2024-12-31 12:52, gnuc...@kcburns.com wrote:

Last login: Tue Dec 31 15:24:15 on console
kcburns@Mac001 ~ % 
/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get

/Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Missing data file parameter

gnucash-cli [options] [datafile] - GnuCash, accounting for personal 
and small business finance:


... [help text elided] ...


  --output-file arg  Output file for report


zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash
kcburns@Mac001 ~ %

It looks like your command is now spelled correctly, but it is broken 
into two lines in the email message.  Is that just an artifact of email 
line wrapping, or is there in fact a linefeed character in your command 
line?


I see that Gnucash says, "Missing data file parameter", as if all it saw 
was "/App…/gnucash-cli -Q get". Then the Terminal shell ("zsh") says, 
"zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash", as if 
it was trying to run "/Users/kcburns/GnuCash/KCBurns.gnucash" as a command.


Perhaps try to enter the command again, but being careful of the 
spelling and spacing?


e.g. Copy "/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get" 
from your previous command, then type a space character, then copy 
"/Users/kcburns/GnuCash/KCBurns.gnucash" from your previous command, 
then press Return. See if that gets interpreted as a single command.


Best regards,
 —Jim DeLaHunt


___
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] Error running gnucash-cli --quote dump

[Justin Smith]

I have GnuCash 5.10 installed via flatpak on an Ubuntu 24.04 PC.

When running (from the command line):
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump

I get the following error:
/app/lib/dbd/libdbdmysql.so: undefined symbol: mysql_ping
libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so
Not enough information for quotes dump

BTW I ran into this error while trying to troubleshoot another issue when
updating quotes. I get a pop-up window with the text:

Quotes for the following commodities owere unavailable or unusable:
* CURRENCY:USD Finance::Quote reported failure set no error

I have GnuCash set up with AUD as the default currency but one of the
securities is quoted in USD.

Does anyone know how to fix either of these issues?
___
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 Won't Start Widnows

[Jonathan A. Cohen]

Since they are two different OS, I don't know how I would compare the
installs to see if anything is wrong.  There seem to be two logical
conclusions:  the gnucash data file is fine and the problem is in the
Windows install or Windows configuration.  Or the gnucash data file has an
issue which does not show up under Ubuntu.  (I am using the original stored
data file in my Windows OS, accessed through VirtualBox shared folder.)


Jonathan A. Cohen
jco...@urgrad.rochester.edu



On Sat, Dec 28, 2024 at 3:54 PM David Carlson 
wrote:

> I am thrilled to see that you have finally been able to make GnuCash work
> again!
>
> I hope you are able to address the issue with your Windows machine that
> caused GnuCash to fail in that instance.  I think that one clue might be to
> look at what you needed to do to make VirtualBox run, since it should have
> run on a windows host without any significant changes unless there had been
> other conflicting changes made to the host.
>
> On Sat, Dec 28, 2024 at 2:26 PM Jonathan A. Cohen <
> jco...@urgrad.rochester.edu> wrote:
>
>> I was unable to get WSL working on my machine, as I use VirtualBox and
>> have
>> to disable some Windows components for that to work.  So, I created a new
>> Ubuntu VM and installed GnuCash.  My data file opened without issue and
>> has
>> worked for almost a week,  No idea what I can do about my Windows
>> installation.  Is there a way to completely remove GnuCash so I get
>> pristine install?
>>
>> 
>> Jonathan A. Cohen
>> jco...@urgrad.rochester.edu
>>
>>
>>
>> On Sun, Dec 22, 2024 at 10:45 PM John Ralls  wrote:
>>
>> > If you’re not able to open old files and old versions of GnuCash that
>> > worked before now don’t something outside of GnuCash is messed up. Let’s
>> > try a different tack entirely: Try installing GnuCash in a WSL instance
>> and
>> > see if that will read your file.
>> >
>> > Regards,
>> > John Ralls
>> >
>> > On Dec 22, 2024, at 15:48, Jonathan A. Cohen <
>> jco...@urgrad.rochester.edu>
>> > wrote:
>> >
>> > John,
>> >
>> > I use WinMerge all the time.  Excellent program.
>> >
>> > I have tried a handful of backup files from before the start of the
>> > problem.  None are working.  Wonder if this is an application issue?  I
>> > have tried uninstalling and reinstalling 5.8, 5.9, and 5.10 without
>> success.
>> >
>> > Any other ideas before I decide to send you my file?
>> >
>> > Thanks,
>> > Jonathan
>> > 
>> > Jonathan A. Cohen
>> > 26 Patriots Drive
>> > Canton, MA 02021
>> > 781-929-8204
>> > jco...@urgrad.rochester.edu
>> >
>> > http://www.linkedin.com/in/jonathanaaroncohen
>> >
>> >
>> >
>> > On Sun, Dec 22, 2024 at 5:55 PM John Ralls  wrote:
>> >
>> >> If Notepad++ is able to indent XML you could look for a  tag at
>> >> the wrong indentation level. It should be in one level and the
>> top-level
>> >> element will be 
>> >>
>> >> Once you find a backup file that loads you could uncompress that and
>> diff
>> >> between the good file and bad file. A brief web search found winmerge (
>> >> https://winmerge.org/?lang=en) to be frequently recommended as a
>> Windows
>> >> replacement for diff.
>> >>
>> >> Regards,
>> >> John Ralls
>> >>
>> >> On Dec 22, 2024, at 12:11, Jonathan A. Cohen <
>> jco...@urgrad.rochester.edu>
>> >> wrote:
>> >>
>> >> I tried Notepad++ XML Tools.  Check errors found nothing.  The
>> validation
>> >> cannot seem to understand the schema.
>> >>
>> >> John, is there anything else I can try myself before I decide whether
>> to
>> >> send it to you?
>> >>
>> >> Thank you,
>> >> Jonathan
>> >> 
>> >> Jonathan A. Cohen
>> >> jco...@urgrad.rochester.edu
>> >>
>> >>
>> >>
>> >> On Sun, Dec 22, 2024 at 12:54 PM Steve Butler <
>> >> stephen.m.butle...@gmail.com> wrote:
>> >>
>> >>> No, I'm not knowledgeable about XML other than a sudden end to the
>> file
>> >>> would jump out.  And that the file is human readable when
>> uncompressed.
>> >>>
>> >>> I suspect that there are tools to edit the beast.
>> >>>
>> >>> On Sun, Dec 22, 2024, 09:42 Jonathan A. Cohen <
>> >>> jco...@urgrad.rochester.edu> wrote:
>> >>>
>>  Any idea what I should look for in the XML?  I have some technical
>>  expertise, so could write some python to examine, if there is
>> anything
>>  systematic.
>> 
>> 
>>  
>>  Jonathan A. Cohen
>>  26 Patriots Drive
>>  <
>> https://www.google.com/maps/search/26+Patriots+Drive+Canton,+MA+02021?entry=gmail&source=g
>> >
>>  Canton, MA 02021
>>  <
>> https://www.google.com/maps/search/26+Patriots+Drive+Canton,+MA+02021?entry=gmail&source=g
>> >
>>  781-929-8204
>>  jco...@urgrad.rochester.edu
>> 
>>  http://www.linkedin.com/in/jonathanaaroncohen
>> 
>> 
>> 
>>  On Sun, Dec 22, 2024 at 11:56 AM Steve Butler <
>>  stephen.m.butle...@gmail.com> wrote:
>> 
>> > But it did uncompress!   That eliminates 

[GNC] Font size change

[Ted Rubin]

Greetings 

I’m having an issue with GNU Cash on my Apple Silicon machine. GNU Cash 
version: 

Version: 5.10
Build ID: 5.10+(2024-12-14)

The main issue is I can’t get the font size to actually reflect in the program.

Example 

I go to Edit> Style Sheets > default 



However, when I restart GNUcash, no changes take effect. Am I missing 
something, or is there a specific CSS file I need to edit?

Thanks 

Ted___
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] Error running gnucash-cli --quote dump

[Sherlock]

Justin,

Regarding the "Not enough information for quotes dump" message, it 
appears you have not provided sufficient arguments.


Try:

flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump 
currency USD AUD


Regards,

Sherlock

On 12/28/24 8:03 PM, Justin Smith wrote:

I have GnuCash 5.10 installed via flatpak on an Ubuntu 24.04 PC.

When running (from the command line):
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump

I get the following error:
/app/lib/dbd/libdbdmysql.so: undefined symbol: mysql_ping
libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so
Not enough information for quotes dump

BTW I ran into this error while trying to troubleshoot another issue when
updating quotes. I get a pop-up window with the text:

Quotes for the following commodities owere unavailable or unusable:
* CURRENCY:USD Finance::Quote reported failure set no error

I have GnuCash set up with AUD as the default currency but one of the
securities is quoted in USD.

Does anyone know how to fix either of these issues?




___
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] Error running gnucash-cli --quote dump

[John Ralls]

Somebody else mentioned the MySql problem a couple of weeks ago. I haven’t had 
time to look into it yet. If you’re not using the MySQL backend you can ignore 
it, otherwise you’ll want to roll back to 5.9.

“Not enough information for quotes dump” is because you didn’t tell it a quote 
to dump. You probably want to say

  flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump currency 
USD AUD

My guess is that the failure to get an exchange rate was either a transient or 
that you’d used up your Alphavantage quota of 25 prices for the day.

Regards,
John Ralls



> On Dec 28, 2024, at 8:03 PM, Justin Smith  wrote:
> 
> I have GnuCash 5.10 installed via flatpak on an Ubuntu 24.04 PC.
> 
> When running (from the command line):
> flatpak run --command=gnucash-cli org.gnucash.GnuCash --quote dump
> 
> I get the following error:
> /app/lib/dbd/libdbdmysql.so: undefined symbol: mysql_ping
> libdbi: Failed to load driver: /app/lib/dbd/libdbdmysql.so
> Not enough information for quotes dump
> 
> BTW I ran into this error while trying to troubleshoot another issue when
> updating quotes. I get a pop-up window with the text:
> 
> Quotes for the following commodities owere unavailable or unusable:
> * CURRENCY:USD Finance::Quote reported failure set no error
> 
> I have GnuCash set up with AUD as the default currency but one of the
> securities is quoted in USD.
> 
> Does anyone know how to fix either of these issues?
> ___
> 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] [SPAM] Re: Font size change

[John Ralls]

I just tested that path and it works, as does the one you suggest.

Regards,
John Ralls

> On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
> 
> The online documentation wrongly directs you to create ~/Library/Application 
> Support/GnuCash/config/gtk-3.0/gtk-3.0.css.

___
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] [SPAM] Re: Font size change

[Ted Rubin via gnucash-user]

Thanks 

Could someone send me a example of a style sheet that would work?

Ted 

> On Dec 31, 2024, at 12:33 PM, Flyeta  wrote:
> 
> Odd. I’ve found 
> ~/Library/Application Support/GnuCash/gtk-3.0.css
> to be the only path that works for me. Just tested it again, with the same 
> result:
> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css
> does not work for me.
> 
> MacOS 14.7.1 Sonoma, Gnucash 5.10 (Apple silicon). 
> 
>> On Dec 31, 2024, at 12:19 PM, John Ralls  wrote:
>> 
>> I just tested that path and it works, as does the one you suggest.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
>>> 
>>> The online documentation wrongly directs you to create 
>>> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css.
>> 
>> ___
>> 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] [SPAM] Re: Font size change

[Flyeta via gnucash-user]

Odd. I’ve found 
~/Library/Application Support/GnuCash/gtk-3.0.css
to be the only path that works for me. Just tested it again, with the same 
result:
 ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css
does not work for me.

MacOS 14.7.1 Sonoma, Gnucash 5.10 (Apple silicon). 

> On Dec 31, 2024, at 12:19 PM, John Ralls  wrote:
> 
> I just tested that path and it works, as does the one you suggest.
> 
> Regards,
> John Ralls
> 
>> On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
>> 
>> The online documentation wrongly directs you to create ~/Library/Application 
>> Support/GnuCash/config/gtk-3.0/gtk-3.0.css.
> 
> ___
> 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] [SPAM] Re: Font size change

[John Ralls]

It’s ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk.css.

You misread the wiki (which I just changed): It said 
GNC_CONFIG_HOME/gtk-3.0.css. GNC_CONFIG_HOME on macOS is ~/Library/Appllication 
Support/gnucash, so that’s the path that you were using. ~/Library/Application 
Support/gnucash/config/gtk-3.0 is GTK_CONFIG_HOME.

I changed the wiki page to reflect both paths, noting that the GNC_CONFIG_HOME 
one is deprecated: It won’t work in Gtk4—not that we’re anywhere near switching 
to that.

Regards,
John Ralls


> On Dec 31, 2024, at 09:33, Flyeta  wrote:
> 
> Odd. I’ve found 
> ~/Library/Application Support/GnuCash/gtk-3.0.css
> to be the only path that works for me. Just tested it again, with the same 
> result:
> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css
> does not work for me.
> 
> MacOS 14.7.1 Sonoma, Gnucash 5.10 (Apple silicon). 
> 
>> On Dec 31, 2024, at 12:19 PM, John Ralls  wrote:
>> 
>> I just tested that path and it works, as does the one you suggest.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
>>> 
>>> The online documentation wrongly directs you to create 
>>> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css.
>> 
>> ___
>> 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] [SPAM] Re: Font size change

[John Ralls]

There’s a short one at https://wiki.gnucash.org/wiki/GTK3#Via_css that will set 
the font globally.

Regards,
John Ralls


> On Dec 31, 2024, at 09:53, Ted Rubin  wrote:
> 
> Thanks 
> 
> Could someone send me a example of a style sheet that would work?
> 
> Ted 
> 
>> On Dec 31, 2024, at 12:33 PM, Flyeta  wrote:
>> 
>> Odd. I’ve found 
>> ~/Library/Application Support/GnuCash/gtk-3.0.css
>> to be the only path that works for me. Just tested it again, with the same 
>> result:
>> ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css
>> does not work for me.
>> 
>> MacOS 14.7.1 Sonoma, Gnucash 5.10 (Apple silicon). 
>> 
>>> On Dec 31, 2024, at 12:19 PM, John Ralls  wrote:
>>> 
>>> I just tested that path and it works, as does the one you suggest.
>>> 
>>> Regards,
>>> John Ralls
>>> 
 On Dec 31, 2024, at 01:52, Axel Essbaum  wrote:
 
 The online documentation wrongly directs you to create 
 ~/Library/Application Support/GnuCash/config/gtk-3.0/gtk-3.0.css.
>>> 
>>> ___
>>> 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] Why did "Assign as payment…" remove splits and notes from my payment transaction?

[Jim DeLaHunt]

Geert and ND:

Thank you for your very helpful replies. I'm especially making a note of 
Geert's comprehensive explanation and suggestions:


 
on Tue, 31 Dec 2024 11:17:49 +0100,
 
on Tue, 31 Dec 2024 16:48:34 +0100.


It is great to have these business features at all, even if there are 
some limitations. It is even better to have such helpful and 
illuminating replies from the author of the features.


I am filing these replies away for future reference. One helpful thing I 
can do with them is to propose the documentation improvements which 
would have answered my questions.


Thank you, and best wishes for the new year!
 —Jim DeLaHunt

On 2024-12-31 07:48, Geert Janssens wrote:

Op dinsdag 31 december 2024 11:17:49 Midden-Europese standaardtijd schreef Geert
Janssens:


...[replies elided, see links above] ...


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