Re: [GNC] Finance Quotes Yahoo off the rails again?

[Geert Janssens]

gnc-fq-dump's functionality has been replaced with

gnucash-cli -Q dump   [ ...]

Regards,

Geert

Op zaterdag 23 maart 2024 20:40:43 CET schreef David G. Pickett via 
gnucash-user:
> Version: 5.5Build ID: Flathub 5.5Finance::Quote: 1.58
> Ubuntu 22.04.4 LTS (all the latest updates from flatpak, snap, Software
> Updater, Software).
> 
> Apparently the Usage is a bit off, or that script is not being distributed
> by flatpak: $ (cd
> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F
> /Program\ Files/gnucash2.2.6/bin ; perl ./gnc-fq-dump; ) Usage:
> ./gnc-fq-dump  [-v]  [ ...]
> 
> $ (cd
> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F
> /Program\ Files/gnucash2.2.6/binfor s in bseindia tmx fidelity hufund
> finanzpartner tsx za six fondsweb iexcloud xetra unionfunds
> troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref
> nasdaq romania hu morningstarch bse alphavantage hungary dutch
> fetch_live_currencies goldmoney treasurydirect twelvedata deka
> fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet
> fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp
> ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual
> tradeville france bloomberg aufunds australia usa amfiindia hustock
> morningstaruk tesouro_direto nseindia troweprice fool tradegate europe
> greece bamoszdo time perl ./gnc-fq-dump $s -v vz echodone)-v not
> foundFinance::Quote fields Gnucash uses:symbol: -v (deduced)   
>  <=== required  date: ** missing **<=== required  currency: **
> missing **<=== required  last:  <=\
>  nav:  <=== one of these price:   
>   <=/  timezone:  <=== optional ** This
> stock quote cannot be used by gnucash!!
> =
> vz not foundFinance::Quote fields Gnucash uses:symbol: vz (deduced) 
><=== required  date: ** missing **<=== required  currency:
> ** missing **<=== required  last:  <=\ 
> nav:  <=== one of these price: 
> <=/  timezone:  <=== optional ** This
> stock quote cannot be used by gnucash!!
> 
> real0m35.045suser0m1.709ssys 0m0.135s
> ^C
> ==without -v,  bourso 30s, france 29s,
> europe 2:16: (cd
> /mnt/37e7c8a7-a11a-41b9-8b5e-107f726a5475/Arc2/310GB/media/0A32075E32074E5F
> /Program\ Files/gnucash2.2.6/bin; for s in bseindia tmx fidelity hufund
> finanzpartner tsx za six fondsweb iexcloud xetra unionfunds
> troweprice_direct known_currencies bvb dwsfunds nzx oslobors tiaacref
> nasdaq romania hu morningstarch bse alphavantage hungary dutch
> fetch_live_currencies goldmoney treasurydirect twelvedata deka
> fidelity_direct india ukfunds yahoo_json fundlibrary asegr sinvestor bet
> fundata onvista morningstarau canadamutual aex nyse morningstarjp asx tsp
> ftfunds cse mstaruk seb_funds comdirect bourso canada indiamutual
> tradeville france bloomberg aufunds australia usa amfiindia hustock
> morningstaruk tesouro_direto nseindia troweprice fool tradegate europe
> greece bamosz; do  echo $s  ; time perl ./gnc-fq-dump $s vz; 
> echo; done; )bseindia vz not foundFinance::Quote fields Gnucash
> uses:symbol: vz (deduced) <=== required  date: ** missing
> **<=== required  currency: ** missing **<=== required 
> last:  <=\  nav:  <===
> one of these price:  <=/  timezone:   
>   <=== optional ** This stock quote cannot be used by gnucash!!
> 
> real0m23.730suser0m1.180ssys 0m0.111s
> tmx Finance::Quote fields Gnucash uses:symbol: vz (deduced) 
><=== required  date: ** missing **<=== required 
> currency: ** missing **<=== required  last:   
>   <=\  nav:  <=== one of these price: 
> <=/  timezone:  <===
> optional ** This stock quote cannot be used by gnucash!!
> 
> real0m16.354suser0m1.022ssys 0m0.096s
> fidelity No results found for stock vz.
> real0m22.290suser0m1.167ssys 0m0.133s
> hufund Finance::Quote fields Gnucash uses:symbol: vz
> (deduced) <=== required  date: ** missing **<===
> required  currency: ** missing **<=== required  last: 
> <=\  nav:  <=== one of these   
>  price:  <=/  timezone: 
> <=== optional ** This stock quote cannot be used by gnucash!!
> 
> real0m22.200suser0m0.985ssys 0m0.125s
> finanzpartner 

Re: [GNC] File format question

[Geert Janssens]

Op woensdag 31 januari 2024 20:13:32 CET schreef Simon Roberts:
> Ah, excellent, thank you. I can continue with the compressed format for the
> main file and simply use zcat when needed :)
> 
> The wiki description of the XML format doesn't seem to offer much, but I'm
> not worried about that, I recall from previous forays in that file that
> it's pretty self evident what's going on (at least for the purpose I have
> in mind--i.e. putting names to UUIDs).
> 
> I guess the only part unresolved is whether there is anything outlining the
> log format. the single character code at column 1 seems like it might be
> important, but I'm at a loss for a guess as to what it's describing. It
> *feels* like it might explain what the numerous seemingly duplicated, and
> often zero-value, entries are about. But that's a wild stab in the dark :)
> 

There's not much documentation other than the comments in the source files. The 
'single 
characters' you refer to are briefly explained here:
https://github.com/Gnucash/gnucash/blob/
b7e68144154c3677293148a40d66bea36d492a96/libgnucash/engine/TransLog.h#L58[1]

Though I'm not sure the behaviour is exactly like described there. I don't 
think a D(elete) 
line is still preceded by a B(egin) line. But the meaning of the characters is 
still unchanged.
B for "begin edit"
C for "commit changes"
R for "rollback changes"
D for "delete"

Note these log files are call transaction logs. And that's pretty accurate. 
They only log 
changes to transactions (and their splits). Changes to accounts or invoices or 
anything else 
is not recorded in these logs.

Regards,

Geert

> Many thanks Glenn for very helpful pointers!
> 
> Cheers,
> Simon
> 
> On Wed, Jan 31, 2024 at 11:39 AM Glenn Fowler  wrote:
> > Hi,
> > 
> > Yes you have the option to compress the XML or not.
> > 
> > Here is the info you are looking for:
> > 
> > https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-files1.html
> > 
> > https://wiki.gnucash.org/wiki/GnuCash_XML_format
> > --
> > *From:* gnucash-user  > outlook@gnucash.org> on behalf of Simon Roberts <
> > si...@dancingcloudservices.com>
> > *Sent:* Wednesday, January 31, 2024 1:11 PM
> > *To:* Gnucash Users 
> > *Subject:* [GNC] File format question
> > 
> > Hi all, perhaps I should be asking this on the developer's list, but I
> > figured that misdirecting here would be less disruptive / annoying than
> > miscrirecting there. Please forgive me if this is the wrong place.
> > 
> > I'm investigating using logfiles as a means to identify changes that will
> > be made by my accountants for my year end. This leads me to two questions
> > 
> > First, is there documentation I can look at on this topic"? I didn't find
> > anything in the user guide, but am not particularly surprised at that.
> > 
> > Second, I notice that the main data file is binary. I thought it was XML
> > (perhaps that was at version 4?) But what's odder is that even if I
> > expressly request "save as XML", I still get a binary file. Is this
> > compressed, and if so, does anyone know what the compression is? I'm aware
> > that interpreting the logs will be much easier if I can correlate the
> > UUIDs
> > of the accounts (used in the logs) with the actual account info (which I
> > have previously seen in a tolerably intelligible format in the XML files
> > of
> > old).
> > 
> > Any pointers / references?
> > 
> > TIA
> > Simon
> > 
> > --
> > Simon Roberts
> > 303 249 3613
> > https://www.youtube.com/@DancingCloudServices
> > https://www.linkedin.com/in/simonhgroberts/
> > ___
> > 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://github.com/Gnucash/gnucash/blob/
b7e68144154c3677293148a40d66bea36d492a96/libgnucash/engine/TransLog.h#L58
___
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] "Make PDF" button just prints

[Geert Janssens]

Op dinsdag 16 januari 2024 20:06:59 CET schreef Chris Green:
> On Tue, Jan 16, 2024 at 12:55:00PM -0600, Adrien Monteleone wrote:
> > On 1/16/24 8:05 AM, Chris Green wrote:
> > > I'm running Gnucash 5.3 on xubuntu linux.
> > > 
> > > The "Make PDF" button on the toolbar just does exactly the same as the
> > > "Print" button, it calls up the standard printer dialogue.
> > > 
> > > How can I get a report output as a PDF file?
> > 
> > I think that has something to do with the mess of Webkit versions
> > between Mac, Win, & *nix. If I recall correctly, the button was left for
> > a future fix, but set to bring up the printer dialog for now which can
> > then use the system PDF 'printer'. Since all three operating systems now
> > have this feature, I'd say the button should either invoke it directly,
> > or the button should be removed. (those on older Windows systems can
> > still use a 3rd party 'printer' like Bullzip)
> 
> Ah, I see, thanks.  Yes, I would agree that removing the button would
> make sense as it's somewhat confusing when it just brings up the print
> dialogue.

On Windows it still effectively creates a pdf as far as I know (as the version 
of WebKit used 
on Windows still allows for it).

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] GnuCash getting worse?

[Geert Janssens]

Hi R Losey,

Your concerns are appreciated. As a currently non-active developer I was a bit 
sad to see 
the struggles of the two most recent releases. I know the current devs do what 
they can 
though.

Their issue is not a lack of money. It's less available time in a shrinking 
pool of volunteers. 
This is a hard problem to solve.

There is so much that needs to be done. Obviously there is the actual coding
- fixing bugs
- keeping up withc changing requirements of our dependencies (think webkit, 
gtk, 
aqbanking,...)
- adapting to evolving coding practices
- and even adapting to changes in a larger ecosystem (like changes in the 
Windows, 
MacOS or Linux environments, changes in the financial world ranging from 
currency 
symbol changes to new requirements for tax filings)
- refactor code to keep it maintainable in the long run
- improving test suites to catch regressions
- ...

Besides that it is also about everything else that's required to maintain a 
project. Things 
that come to mind immediately are
- bug triaging
- responding to user questions on mailing lists and irc
- maintaining automated build systems for nightly development snapshots
- running these nightly builds in order to verifying bug fixes, catch 
regressions and test 
new features
- guiding less experienced or new contributors to successful contributions
- maintaining a website
- translations (which have vastly improved since we changed to Weblate!)
- ...

That's a huge pile of work for only a handful of volunteers. Money won't 
increase the 
amount of available time unfortunately. The available time can be increased 
though by 
having more people helping out in any of the above.

A simple example: if more users would from time to time download a nightly 
build and do 
their typical GnuCash routines with it, we could potentially catch more 
regressions before 
release. I'm sure there are others.

My main point is (and this is not only for GnuCash but for many free software 
projects) we 
really need more helping hands!

End of my plea :)

Regards,

Geert

Op donderdag 28 december 2023 05:33:11 CET schreef R Losey:
> Let me start off by trying to avoid hateful responses...
> 
> I worked in the software industry, and the programs I supported have had
> their share of issues. I remember (with hung head) when we went through a
> patch in which we would claim to have fixed a problem, only to have it
> recur, and then fixed that and then had another problem occur. It was a
> really bad time, and we took a lot of heat for it.
> 
> I also know that GnuCash is free, thanks to the intense dedication of a
> relatively small number of people... for whom and to whom, I am very
> grateful.
> 
> However.
> 
> I started using GnuCash about 8 years ago, and I generally upgraded each
> quarter as the new versions came out. My own experience in software led me
> to delay doing the update for 7-10 days -- just in case there was a bug
> that necessitated a re-release (and it happened just enough to make me glad
> I waited from time to time).
> 
> I am still running 5.3 because (as has been documented here), the 5.4
> windows release had a bug that left a process running.  "No problem", I
> thought -- I'll just skip 5.4 and install 5.5 when it comes out.
> 
> Well, 5.5 is out, and it looks like the Scheduled Transactions no longer
> function properly, especially in regard to variable placeholders. This is a
> feature I used and cannot use GnuCash if this is broken. This makes 5.5
> also unusable for me. This is the first time I can remember when I could
> not download a new release - let alone two of them.
> 
> I don't know what the problem is or what the best solution is -- perhaps
> everyone on this list could contribute a few dollars to give
> the hardworking developers a chance to "re-charge", as it were? Perhaps
> a quarter needs to be spent only fixing bugs and ignoring adding new
> features? Perhaps the developers just need to take a break for a quarter?
> 
> I don't mean this at all in a harsh or critical way; I am just concerned
> that a program I really like seems to be slipping somehow.


___
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] Best way to resolve an unpaid but posted bill

[Geert Janssens]

Op woensdag 8 november 2023 13:40:15 CET schreef David Kirkby:
> I have created a bill, which just says
> 
> Keysight
> Bits
> £1.00
> 
> The bill was actually for several hundred pounds, but Keysight wanted a
> purpose order number, so I must have created that.
> 
> What's the best way to handle this? Can I just unpost, edit, then post and
> pay?

Yes.

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] How to use refunds or credit notes

[Geert Janssens]

Op woensdag 25 oktober 2023 18:10:22 CEST schreef John Walker:
> I have a situation where I have charged say$2 008 in an invoice. After
> posting, the customer correctly told me that the invoice should have
> been $2 000. The invoice has already been correctly paid at $2 000 and
> payment due date has already happened.
> 
> When processing the payment, I entered $8 in the refund and the invoice
> changed to $2 000 as one would expect. After processing the payment, I
> still had the $8 to process in the process payment window. How do I
> properly process this?
> 
> If I should have used a credit note, how do I do that?

You will indeed require a credit note for the remainder. You can still create 
it now. Creating a credit note is the same as creating an invoice, except you 
choose "credit note" instead of "invoice".

Once the credit note is created, you can select to pay it, as you would for 
invoices. In the payment window you will find the $8 due payment and apply 
that to the credit note.

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] Assigning payment inside a split

[Geert Janssens]

I believe it's not possible to assign specific splits to as a payment to a 
bill. You can only assign complete transactions and from that point on GnuCash 
will manage the Accounts Payable part of that transaction. That does 
effectively mean that if your payment transaction has more than one split in 
an AP account, they may be reset by GnuCash.

That's proper to how the business features in gnucash work - anything in AP or 
AR is managed by code.

Regards,

Geert

Op woensdag 25 oktober 2023 07:25:17 CEST schreef Jediator:
> I was trying to assign a payment to a transaction inside a split (a
> parent transaction).  However, to my surprise, this action resulted not
> only the child entity assigned as a payment, but also the rest of the
> siblings merged together and assigned as a payment to the same bill.  I
> ended up with loosing the split completely, and the bill got messed up
> as well.  Is this a bug or did I do something wrong here?
> 
> Using GC version 5.4 on Mac with Postgresql as the back-end DB.
> 
> Thanks in advance!  -- JC
> ___
> 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] Potential issue with inversion of currency conversion rate during CSV import of transactions

[Geert Janssens]

Hi,

That looks like a bug indeed. To make sure this doesn't get lost on the mailing 
list, can you 
file a bug report for this in bugzilla please ?

Regards,

Geert

Op zaterdag 9 september 2023 13:51:39 CEST schreef Bjoern:
> Hi!
> 
> I came across a potential issue with the use of the correct rate for
> cross-currency transactions during CSV imports where I hope others here
> could reproduce the issue or tell me where I took a wrong turn during
> thinking.
> 
> 
> use case:
> As a German national I live and work abroad in Sweden temporarily. I have
> both DEU and SWE bank accounts. Salary comes via the DEU account in EUR,
> which I transfer to the SWE account to cover local expenses in SEK. I use
> GnuCash to track personal expenses.
> 
> The main, or up until recently only, currency I have used in GnuCash is the
> EUR so all expense accounts are in that. To avoid duplicate accounts for
> each expense in both EUR and SEK I convert spent SEK to EUR when filing the
> transactions to the existing GnuCash accounts already in EUR.
> 
> 
> issue:
> When using the CSV transactions import feature for the SWE bank statements
> GnuCash uses the reciprocal value of the available conversion rates
> displayed. In other words, the transaction dialogue states it would go from
> SEK to EUR when in fact after the import the transaction would register as
> if the conversion had been done for EUR to NOK instead. Given the rates the
> effect on values is quite pronounced.
> 
> 
> notes:
> The manual input of cross-currency transactions into GnuCash works as
> intended. I use the trading account feature.
> 
> I included an example book for further testing.
> Conversion rates (10 SEK to 1 EUR) and expense values are roughly realistic.
> So the imported transaction for "butter" costing 40 SEK in realiter should
> account for as 4 EUR in the groceries expense and not the registered 400
> EUR (1 SEK to 10 EUR erroneously). Attached as well is a mock CSV statement
> for the SWE bank to use during import.
> 
> 
> software details:
> GnuCash Version: 5.3 Build ID: 5.3+(2023-06-26) with Finance::Quote: 1.57
> Windows 10
> 
> 
> Thanks and kind regards
> Björn


___
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 Transactions: Withdrawals vs Deposits, and Account

[Geert Janssens]

Op zondag 3 september 2023 17:25:48 CEST schreef Geert Janssens:
> ... The other would have been (although non-obvious) to set
> both accounts as "Deposit"...

I meant "amounts" rather than accounts here.

Sorry for the confusion.

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 Transactions: Withdrawals vs Deposits, and Account

[Geert Janssens]

That's one solution. The other would have been (although non-obvious) to set 
both accounts 
as "Deposit". That's allowed in the csv importer. Deposit and Withdrawal come 
from the 
early days of the importer and don't cover all use cases very well.

"Deposit" here really means, use the number unchanged (positive numbers will be 
imported 
as positive numbers, negative numbers as negative ones) while "Withdrawal" 
means reverse 
the sign of these numbers before importing them. So if your column already had 
negative 
numbers where you wanted these, "Deposit" is the number type that does what you 
want. In 
GnuCash 5.x these names have been changed in an attempt to make them more 
generic, to 
"Amount" and "Amount (negated)", but even that requires some interpretation due 
to the 
many possible ways csv data can be structured.

Regards,

Geert

Op zondag 3 september 2023 15:48:43 CEST schreef Tom Balazs:
> Problem solved: the withdrawal columns were all negative numbers. I changed
> them to positive and it worked correctly.
> 
> On Sun, Sep 3, 2023 at 9:20 AM Tom Balazs  wrote:
> > I'm importing transactions into a checking account. Why do all transaction
> > amounts go into the deposits column?
> > 
> > I'm trying to import transactions one month at a time for a checking
> > account.
> > I have a CSV file with one month of transactions. I went through the
> > Transaction Import Assistant / Import Preview. I set "Import Account" to
> > the checking account. I use the column headings map Date column,
> > Description column, Withdrawals, and Deposits. Many
> > withdrawal transactions, few deposit transactions. I import. And then I
> > view the ledger for that checking account and all the transactions are put
> > in the Deposits column. How do I fix this problem?
> 
> ___
> 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] How to Enter Account in CSV Before Import

[Geert Janssens]

Op zondag 3 september 2023 15:47:26 CEST schreef Tom Balazs:
> I'm importing checking account transactions from a CSV file.
> 
> I see that in the Transaction Import Assistant I can
> A. Choose Account at the top of the Assistant (Import Preview), where I
> would designate it Checking Account #1
> OR I can
> B. Choose Account as a column heading. Where I would designate it: Expense:
> Auto : Auto Repair
> I can't do both. Is there a way for me to do both?
> That might save me the trouble of having to go in an manually choose
> account for each transaction.
> 
> Check Account #1 Transaction ... Date: 1/1/23, Description: Bob's Auto,
> Account: Auto Repair, Amount: 50.00

A transaction in GnuCash involves (at least) two accounts.

I assume you want to import a csv file with several transactions related to 
your Checking 
Account #1. As the example you give doesn't have a column with this account 
name in it, 
that's probably what you want to set as your base account. Your csv example 
holds the other 
account related to the transaction: "Auto Repair". In the CSV importer that's 
known as the 
"Transfer account". You should be able to select that in the list with no 
issues.

Put differently: if your csv data has two account columns, one will be your 
"Account" and the 
other will be "Transfer Account". If you only have one account column, the 
whole csv file is 
assumed to go into one account. That account is what you have to set as base 
account. The 
column in your csv data will be the "Transfer Account" in this case.

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] How to transfer all my accounts etc. to new computer. Linux version

[Geert Janssens]

That data is managed via GSettings, which on Linux uses dconf as back-end. I 
have no idea how dconf manages its internal database unfortunately. It's tied 
into dbus but that's a black box for me.

You can dump the the contents via dconf or GSettings tools and then import this 
on the new machine. As I'm not near a computer right now, I can't offer much 
more than a pointer in the right direction.

Liz  schreef op 13 augustus 2023 04:50:34 CEST:
>On Sun, 13 Aug 2023 11:15:52 +1000
>David Cousens  wrote:
>
>> The saved reports are in
>> /home/liz/.local/share/gnucash/saved_reports2.8. GNC_USERDATA_DIR is
>> the location for the user preferences data 
>
>all very well, but that file
>~/.local/share/gnucash/books/*.gcm contains the data for the registry
>displays but where is the date format, the last invoice number,
>accounting period and so on?
>
>Liz
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

-- 
Verzonden van mijn Android telefoon met K-9 Mail.
Sent from my smartphone. Please excuse my brevity.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to transfer all my accounts etc. to new computer.

[Geert Janssens]

Several option:

1. If you remember where you stored your gnucash data file on the old computer, 
use your 
system's file manager to copy it to the new computer (either via a network 
share, cloud drive 
or usb stick. Then on the new computer, start gnucash and use File->Open to 
locate your 
gnucash data file.

2. If you don't remember where you stored it, open gnucash on your old computer 
and 
select save as... From there you can either detect where you stored your 
gnucash data file 
originally, or simply save a copy somewhere you can find it later. The take 
step one above to 
complete the migration.

Note that besides your data file there are a few files that are managed by 
gnucash directly 
which you also might want to copy over. They have for example your saved 
reports and such. 
Under Windows these are stored under
%APPDATA%\gnucash

Regards,

Geert

Op vrijdag 11 augustus 2023 16:00:35 CEST schreef Shevach Pepper:
>I’m sure this is really simple but I’m not successful.
> 
>I installed gnucash on new computer but I can’t find an option to
>import all my old accounts from old computer. I’m sure this has been
>asked before, but I can’t find any instructions on how to do it.
> 
>On my old computer in the AppData>Roaming>GnuCash>books folder I found
>a file with end in gnucash.gcm. Can I just copy that file and put into
>the new computer in the same place and I’ll get back old of the old
>info?
> 
>Tried that but it didn’t work.
> 
>Can someone help me and tell me what to do?
> 
>Thank you very much
> 
> 
> 
>Sent from [1]Mail for Windows
> 
> References
> 
>1. https://go.microsoft.com/fwlink/?LinkId=550986
> ___
> 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] Finance::Quote terminal commands not working with Flatpack v:5.3 install

[Geert Janssens]

Hi Doug,

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

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

This boils down to the following components:
- flatpak run  org.gnucash.GnuCash
  => indicate you want to execute a command in the org.gnucash.GnuCash sandbox
 without any further options, this will run the default command in that
 sandbox, which is "gnucash"
- --command=gnucash-cli
  => indicate you don't want to run the default command, but gnucash-cli
 instead
- -quotes dump
  => the arguments to pass to the command to run

Regards,

Geert

Op dinsdag 11 juli 2023 16:13:37 CEST schreef doug brown via gnucash-user:
> I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the
> terminal commands that I previously used to find sources for quotes on
> longer work.  Here is the output: doug@sager:~$ gnucash-cli --quotes dump
> yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump
> -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed
> with:sudo apt install gnucash Any thoughts?
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Report Options

[Geert Janssens]

To add to Stan's answer, you can select your preferred report to use for 
printing invoices via 
File->Properties->Business->Default Invoice Report

In Gnucash 4.x and older the choices are limited to the four base reports 
included in 
GnuCash. Starting with gnucash 5.0 the list has been extended with all your 
saved reports 
that are based on one of these base reports.

So if you configure an invoice report to your taste and then save it as a saved 
report 
configuration, you can select that configuration in the business properties - 
again starting 
with 5.1.

Regards,

Geert Janssens

Op maandag 10 juli 2023 06:32:31 CEST schreef Stan Brown:
> On 2023-07-09 11:29, Titus Renno | Topsoil Magazine wrote:
> > When printing an invoice in GnuCash 4.10, is there no way to make the
> > 'Options' remain at the last specified settings, so that when I want to
> > print another invoice, I don't have to always change the options? (The
> > options always revert to defaults after closing the printable invoice.)
> 
> Before closing the report, click "Save Report Configuration As" in the
> icons at the top. Select a name that will help you remember the
> difference between this report and other similar reports you may save.
> 
> Later, to recall the report with the saved options, click Report » Saved
> Report Configurations, then click the pay button on our desired report.
> 
> 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] What is wrong with this custom stylesheet code?

[Geert Janssens]

Any error messages in gnucash.trace when the loading fails ?

Regards,

Geert

Op dinsdag 4 juli 2023 03:57:17 CEST schreef Vincent Dawans:
> HI Robert:
> 
> Here are a few things you need to change:
> 
> That very last statement (gnc:make-html-style-sheet "DWS_Stylesheet" (N_
> "DWS Stylesheet")) the first parameter is actually the template name
> defined just above, so it should be "DWS Stylesheet" without the
> underscore. The second parameter is the name of the default stylesheet
> created based on that template. You can use the same name as the template
> or you could call your Template "DWS Template" both here and above, as in:
> 
> (gnc:define-html-style-sheet
>  'version 3.0
>  'name (N_ "DWS Template")
>  'renderer dws-renderer
>  'options-generator dws-options)
> 
> (gnc:make-html-style-sheet "DWS Template" (N_ "DWS Stylesheet"))
> 
> I would also advise you put your code in a separate scm file, for instance
> dws.scm, then store it in the USER_DATA directory .local/share/gnucash and
> load it from config-user.scm by adding
> 
> (load (gnc-build-userdata-path "dws.scm"))
> 
> Finally, possibly you are hitting a bug with the inability to save or there
> is something I don't know about loading the template because I have the
> same problem. Actually it's saving fine, you can see it in
> local/share/gnucash/stylesheets-2.0. It's the loading that's not working. I
> am wondering if it's not trying to load the saved stylesheet before running
> config-user.scm and therefore not finding it or something like that. But if
> I put the scm file directly in the main template directory under gnucash
> then it works, it's loading the saved settings, so that's a work-around.
> You don't load it in config-user.scm; instead you copy the file to
> 
>  dir>/gnucash/share/guile/site/2.2/gnucash/report/stylesheets/
> 
> Sincerely,
> 
> Vincent Dawans
> 
> Then it saves fine for me.
> 
> On Mon, Jul 3, 2023 at 7:17 AM Robert Heller  wrote:
> > I have written a style sheet module and it *seems* to be loading now, but
> > things are wonky any I don't know why.
> > 
> > What I am *trying to go:
> > 
> > 1) Put my company letterhead across the top of the invoice
> > 2) Put a "button image" (Payments by PayPal) under the invoice table.
> > 
> > My custom stylesheet code adds two options: the button image and some
> > (optional) text to put under the button image (typically the e-mail
> > address to
> > use as the payment target).
> > 
> > Several things are not working:
> > 
> > If I use the Edit->Style Sheets options and create a new stylesheet from
> > my
> > template, the addition options are not available (why?) If I just edit the
> > template itselt (with Edit->Style Sheets) I can set the header image and
> > the
___
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] Where is config-user.scm supposed to be under Linux

[Geert Janssens]

Op dinsdag 4 juli 2023 01:32:09 CEST schreef Robert Heller:
>
> config-user.scm is only needed if you are loading user-supplied Scheme.
> 
> It belongs in $HOME/.config/gnucash (appearently).  The Wiki is vauge and
> confusing.  Doing a gnucash --paths helped.
> 
> > $ locate config-user.scm
> > $

That page should be treated as a key to resolve pathnames. As they are 
different on each 
platform, you have to recursively assemble the answer yourself.

Easiest is to start from the file you want to store somewhere. In your initial 
mail you 
mentioned "config.user". If you search for that file name on the wiki page, 
you'll find a note 
mentioning this file has been renamed to "config-user.scm" in the subsection 
"In 
GNC_CONFIG_HOME" of section "Files". So you now know your file should be named 
"config-
user.scm" and that it goes in GNC_CONFIG_HOME (whatever that means).

To resolve that, you can look in the page index for GNC_CONFIG_HOME (it has its 
own 
section). In that section you will learn GNC_CONFIG_HOME on linux resolves to 
"USER_CONFIG_HOME/gnucash". Again with whathever USER_CONFIG_HOME may mean.

To continue resolving the path you can click directly on "USER_CONFIG_HOME" to 
learn that 
on linux that's equivalent to "$HOME/.config".

Putting that all together then yields

$HOME/.config/gnucash.config-user.scm

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] HELP! Invoice Stylesheet, how to? V4.8

[Geert Janssens]

Op zondag 2 juli 2023 21:54:00 CEST schreef Robert Heller:
> At Sat,  1 Jul 2023 11:03:14 -0400 (EDT) Robert Heller  
> wrote:
> > At Sat, 1 Jul 2023 09:36:19 -0500 adrien.montele...@lusfiber.net wrote:
> > > Ah, you want TWO images. (Your own logo, plus the PayPal logo)
> > > 
> > > My guess would be a custom report (via Scheme) or maybe via CSS as I
> > > mentioned with a :before or :after pseudo class that inserts the image
> > > somewhere but I haven't tested that approach with GnuCash. (I can't see
> > > why it wouldn't work though)
> > 
> > There is the Wiki page on custom reports, but I'll have to check it out. 
> > I
> > did this once before back in the days of 1.x and/or 2.x (don't remember
> > when exactly).  I have the old code lying around -- guessing I can
> > probably adapt/update it.
> 
> OK, I have created a new stylesheet renderer, but how to I get it into the
> menus?
> 
> I have this in ~/.local/share/gnucash/config.user:
> 
> ;; Hacked from:
> /usr/local/share/guile/site/3.0/gnucash/report/stylesheets/footer.scm (load
> "/home/heller/gnucash/dws-stylesheet.scm")
> 
> ;; copied and hacked from ~/.local/share/gnucash/stylesheets-2.0
> (let ((template (gnc:html-style-sheet-template-find "DWS")))
>   (if template
> (let ((options ((gnc:html-style-sheet-template-options-generator
> template
> 
>  (gnc:restore-html-style-sheet "Deepwoods Software Stylesheet" "DWS"
> options
> 
> But my stylesheet is not showing up anywhere... not getting any errors or
> messages (other then telling me about finding Finance::Quote version 1.51).
> 
> (Is ~/.local/share/gnucash/config.user the correct file to put the load in?)

No, you would want this file path:
~/.config/gnucash/config-user.scm

This changed somewhere around gnucash 3.0. More details on which file goes 
where can be 
found on https://wiki.gnucash.org/wiki/Configuration_Locations[1]

Regards,

Geert

> > > You won't find instructions anywhere in the GnuCash documentation for
> > > this, you'll just need to tinker and do studying outside a la Scheme and
> > > CSS/HTML.
> > 
> > Not really a problem for me.  I am proficent in Lisp (Scheme is just a
> > Lisp
> > variant).  I know HTML and CSS as well.
> > 
> > > An alternative might be to make a logo image that has both yours and the
> > > PayPal logo in it with a white or transparent background so they appear
> > > as separate images - maybe one to the left, the other to the right, for
> > > example, and then place and size the image so it looks reasonable in the
> > > header.
> > 
> > My "header" image is the full width of the page (this is working
> > properly).
> > The other is a "button" image that goes somewhere below the invoice
> > content
> > (exactly where depends on how much space the invoice content takes up --
> > eg
> > how many line items are in the invoice).
> > 
> > > Regards,
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to revert to previous input mode?

[Geert Janssens]

Op zondag 2 juli 2023 20:01:53 CEST schreef Pierre Fortin:
> On Sat, 1 Jul 2023 18:30:44 -0700 Vincent Dawans wrote:
> >Pierre:
> >
> >On this point in particular:
> >> Worse, typing "Pens" auto-populated an old "Camper expenses" entry
> >
> >which
> >
> >> now had to be canceled and restarted.
> >
> >This was an issue in early 5 releases but as far as I know 5.3 no longer
> >does a mid-word match so it should no longer happen in 5.3. In fact a lot
> >of the old 4.x behavior such as giving priority to recent matches and start
> >of string matches has been brought back in 5.3 so I would give it a try.
> 
> Version: 5.3
> Build ID: 5.3+(2023-06-26)
> 
> pens  is my test; there are many entries displayed when I type 'p';
> at 'pe', it's down to just 'Amazon - pens' (at least 'Camper expenses' is
> no longer in the list; but at 'pens', 'Amazon - pens' is still available
> and it get auto-filled on TAB -- not what I expected...  At TAB, the entry
> should be considered a match if the entire typed string is a match,
> otherwise it should be considered a new unique entry.  If a visible
> selection is what is desired, then that can be selected directly.
> However, it's still forcing a change to the user's years long muscle
> memory actions...
> 
> Stated differently:  if the user enters 'pens' and 'Amazon - pens' is in
> the list, TAB should assume the entered characters are the complete
> entry, not what's in the list, even if it's the only match; that should be
> explicitly selected. Otherwise, creating a new unique entry becomes
> convoluted...

Unfortunately that's not how autocomplete works. It didn't in the old days and 
it still doesn't. 
The only difference between the old way an the new way is the new way now 
extends 
autocompletion to matches on all word boundaries in previous descriptions, 
where in the old 
days it only matched on beginning of description. So it's true the old method 
would not have 
autocompleted to "Amazon - pens" if you typed "pens", but it for sure would 
also have 
autocompleted to "Amazon - pens" if you only typed "ama", and did not behave as 
you 
described above.

If you want what you have typed to be unique, you have to tell the autocomplete 
system you 
don't want the suggestion. In the old days you did so by typing backspace. In 
the new 
system you can do so by either typing ESCAPE when you're done with your full 
description or 
selecting "Don't autocomplete" from the list.

Note that for your next transaction, if you type "pens" again, it will then 
autocomplete to 
"pens" only as at that point it will be the most recent possible match, rather 
than "Amazon -
pens" (assuming the date for your "pens" transaction is more recent that the 
earlier entered 
"Amazon - pens" transaction.

I accept that it requires to retrain your muscle memory and that can trigger 
some initial 
frustration. On the other hand the new system can potentially save you even 
more 
keystrokes once you master it, because it is able to offer more suggestions to 
choose from.

Regards,

Geert

> 
> HTH,
> Pierre
> 
> >Sincerely,
> >
> >Vincent
> >
> >On Sat, Jul 1, 2023 at 4:17 PM Pierre Fortin  wrote:
> >> On Sat, 1 Jul 2023 16:31:55 + Gyle McCollam wrote:
> >> >Pierre,
___
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] balance of interests between users and developers

[Geert Janssens]

I really shouldn't answer this, but it's too painful to read...

Perhaps the user's expectations are too high for a volunteer project such as 
gnucash. It's 
true, things go wrong. Especially with major releases which typically have 
changes 
accumulating over the longer development cycle which gets very little end user 
testing. we 
do encourage this by the way but we get surprisingly little of it. I suppose 
end users are 
volunteers as well and have limited time to help out in testing.

That aside, we do take these issues seriously. From what I can tell almost 
**all** the 
changes that went into gnucash 5.1 were to solve problems that appeared in the 
5.0 release. 
There were more than we could handle in the single month between these two 
releases. 
We're still working on fixing more for the next release.

Those include the issue with entering descriptions in the register and the 
broken multi-
column reports.Please do understand that while it's sometimes easy to point out 
a problem, 
it does take time for a proper fix.

Yesterday we added a fix for the multi column report which we hope should solve 
the issue. 
You are most welcome to download the latest nightly builds to help us verify 
this.

The other one has a patch waiting, which is still under discussion. It has high 
priority but we 
don't want to make it a half-baked solution.

More hands helping out are always welcome by the way. In the absence of more 
helping 
hands, things proceed at the pace the current development team can handle. 
You're free to 
feel happy or sad about that.

Regards,

Geert

Op zaterdag 20 mei 2023 09:37:08 CEST schreef G R Hewitt:
> I agree with the sentiments WM expressed; I have had the growing feeling
> from reading the emails that pet projects are worked on in isolation to the
> main.
> It kind of reminds me of a model railway exhibition I once went to many
> moons ago. On one large display, all nicely set out, no trains were running
> as everyone involved was working on their particular pet project; the
> signals weren't working as they were all in bits as 'something new was
> being tried out',
> the power to the track wasn't on for the same reason, and people with
> trains to run were just hanging about with a cup of tea flicking switches
> in the
> hope that it, somehow, might work beyond the odd pulse of power that moved
> the train a few inches and then stopped - or worse ran the train backwards
> so it came off the lines.
> 
> On Fri, 19 May 2023 at 22:41, Wm  wrote:
> > I think the balance between users of gnc and developers of gnc has
> > broken down.
> > 
> > My personal instinct is inclined towards development, towards software
> > getting better, being more inclusive, making things easier, you get the
> > drift.
> > 
> > Unfortunately it seems some personal projects got in the way of making
> > gnc 5 better for everyone.
> > 
> > The most obvious interaction fail is transaction completion which should
> > have been an improvement but has ended up as an "I'm right, you are all
> > wrong" issue :(
> > see 798829 – 5.0 transaction completion features are buggy (gnucash.org)
> >  for details :(
> > 
> > For small organizations / charitable organizations / whatever they are
> > in your locale, v5 broke reporting in a significant way.
> > see 798809 – Multicolumn report error when reopened after saving.
> > (gnucash.org) 
> > why? because preparing a standard set of reports is what is expected of
> > small businesses, etc
> > it is understood, pretty much in every jurisdiction, that you start with
> > last year's balance sheet, you add in the income statement for the last
___
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] Finance:Quote again [sorry]

[Geert Janssens]

The new command is
c:\Program Files (x86)\gnucash\bin\gnucash-cli --quotes info

More details can be found on our online quotes wiki page, section command line 
interface:
https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface[1]

Regards,

Geert

Op donderdag 11 mei 2023 18:58:18 CEST schreef David Reiser via gnucash-user:
> except that there is no gnc-fq-check in gnucash 5
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> > On May 11, 2023, at 12:55 PM, Kalpesh Patel  wrote:
> > 
> > That sounds like GNC is not in your path ... try running following in a
> > console window:
> > 
> > c:\Strawberry\perl\bin\perl.exe "c:\Program Files
> > (x86)\gnucash\bin\gnc-fq-check"
> > 
> > It should spit out something like this:
> > 
> > Microsoft Windows [Version 10.0.22621.1702]
> > (c) Microsoft Corporation. All rights reserved.
> > 
> > C:\Users\kalpesh>c:\Strawberry\perl\bin\perl.exe "c:\Program Files
> > (x86)\gnucash\bin\gnc-fq-check" ("1.54" "aex" "alphavantage" "amfiindia"
> > "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bloomberg" "bourso"
> > "bse" "bseindia" "canada" "canadamutual" "comdirect" "cse" "deka" "dutch"
> > "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> > "finanzpartner" "fondsweb" "fool" "france" "ftfunds" "fundata"
> > "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary" "hustock"
> > "iexcloud" "india" "indiamutual" "known_currencies" "morningstarau"
> > "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse"
> > "nzx" "onvista" "oslobors" "romania" "seb_funds" "sinvestor" "six"
> > "tesouro_direto" "tiaacref" "tmx" "tradegate" "tradeville"
> > "treasurydirect" "troweprice" "troweprice_direct" "tsp" "tsx" "ukfunds"
> > "unionfunds" "usa" "xetra" "yahoo_json" "za")
> > 
> > C:\Users\kalpesh>
> > 
> > 
> > 
> > 
> > -Original Message-
> > From: Graham 
> > Sent: Thursday, May 11, 2023 11:49 AM
> > To: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Finance:Quote again [sorry]
> > 
> > Dear team
> > 
> > Apologies if I am being particularly thick, but I can't get up to date
> > stock prices. The last ones on the system are from March. I've spent ages
> > with the documentation, so I uninstalled strawberry perl, re-run the
> > windows install online price retrieval tool. All went well. But...when I
> > attempt to run perl gnc-fq-check, I get 'Can't open perl script
> > "gnc-fq-check": No such file or directory'.
> > 
> > In the About section of Gnucash , i get the attached list, with no finance
> > quote shown. Trying to get updated quotes with the price database, it now
> > tells me Finance:Quote is not installed properly.
> > 
> > Win10, Gnucash 5.
> > 
> > Any help gratefully received
> > 
> > --
___
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] Issues with Release 5.1

[Geert Janssens]

Hi Eliot,

Op zondag 7 mei 2023 04:52:56 CEST schreef eliotr...@gmail.com:
> Dear list,
> 
> 
> 
> I have been using GNUCash in various forms for 3-4 years. However with the
> 5.1 release I have some issues:
> 
> 1.When uploading transactions, I can select the date, description, but
> the "Deposit" option has disappeared from the dropdown selection. The
> "requirements" that indicate what dropdowns must be selected, rather than
> stating select a column for Deposits, says a column must be selected for
> Amount (negated).

The "requirements" message really meant to convey you should either select an 
"Amount" or 
an "Amount (negated)" column, but I understand from your reaction it's poorly 
formulated. It 
tried to squeeze both names in one phrase using brackets to mark negated as 
optional. But 
as the brackets are also used in the real column type name, this is ambiguous.

So in your case, if you originally had selected a "Deposit" column, you will 
now want to set 
that column to "Amount" instead. Sorry for the confusino.

> 2.If I select the column I would usually use for Deposit to be "Amount
> (negated)", which does appear in the dropdown, when I click next to select
> the accounts (for transfer or for income/ expense), there are no options to
> select the accounts
> 

I'm not sure I understand exactly what you mean here. Can you explain this in a 
bit more 
detail ? What page of the assistant are you looking at, and what were you 
expecting to find 
vs what is there now ? You could also attach screenshots (with sensitive data 
removed or 
blurred) if that makes it easier to explain.

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] Turn of drop list when entering data in memo/description line

[Geert Janssens]

Carsten,

Do you already have gnucash installed from flathub or only from 
code.gnucash.org?

To update with this procedure, you'd need to have the flathub gnucash package 
installed. 
And I don't know what happens if you have gnucash installed from multiple 
repositories. 
That may need some extra consideration...

Regards,

Geert

Op zondag 7 mei 2023 21:04:19 CEST schreef Carsten Hütter:
> Am 05.05.23 um 15:42 schrieb Geert Janssens:
> > Op donderdag 4 mei 2023 21:40:14 CEST schreef Carsten Hütter: >
> > [...]
> > 
> > The releases on the other hand are found on flathub. And while not obvious
> > from their website you can install older versions from there as well from
> > the command line.
> > 
> > Our wiki explains how you can do this:
> > https://wiki.gnucash.org/wiki/Flatpak#Getting_Older_Releaseses
> 
> Thanks. Got it. That's nice. But sadly, I get the following reply:
> 
>  carsten@carsten-HP:~$ flatpak update --commit
>  511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f
>  org.gnucash.GnuCash
>  Looking for updates…
>  Fehler: Server returned status 404: Not Found
>  carsten@carsten-HP:~$
> 
> 404 error. Not found. Even after the "flatpak remote-info --log flathub
> org.gnucash.GnuCash" command showed the correct package:
> 
>   Commit:
>  511cf18127561c55b5999121c6b301ca1e90d6cc988a00701257606df7fae86f
> Subject: Release GnuCash 4.14 (b2942403)
> Date: 2023-03-25 23:27:27 +
> 
> So, in my case, on my system (Ubuntu 22.04), there is some kind of issue
> with this procedure...
> 
> > [...]
> 
> Regards
> 
> Carsten
> 
> PS: Thanks for all your effort and dedication here! Bedankt voor je
> inzet en je bijdragen!
> 
> > 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] Cannot find gnc-fq-check and gnc-fq-helper

[Geert Janssens]

Just a heads-up, I have updated https://wiki.gnucash.org/wiki/Online_Quotes to 
reflect these changes.

Regards,

Geert

Op donderdag 4 mei 2023 00:17:20 CEST schreef WR D:
> I am on Windows 11, using latest Gnucash 5.1, with Finance::Quote 1.54
> installed
> 
> There are some helper scripts described here:
> https://wiki.gnucash.org/wiki/Online_Quotes
> 
> But looking in this folder "C:\Program Files (x86)\gnucash\bin", I don't see
> either "gnc-fq-check" or "gnc-fq-helper" - have these been removed from
> Gnucash installation, or are they somewhere else?
> 
> Regards,
> Bill
> 
> ___
> 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] Turn of drop list when entering data in memo/description line

[Geert Janssens]

Op donderdag 4 mei 2023 21:40:14 CEST schreef Carsten Hütter:
> > On 4/29/23 5:14 AM, Trevor Dempsey via gnucash-user wrote:
> >> Greetings,
> >> 
> >> I just upgraded to version 5.0 and I would like to know how to turn
> >> OFF the drop list when entering a description in the memo line.
> >> 
> >> I can only enter 3 letters before it seizes up and I must cancel my
> >> entry to continue. To enter new data into this memo line, I must
> >> first write it in a text file and then copy/paste it onto the line.
> 
> In fact there is an option "Auto-raise lists" in the register
> preferences. But at least in my current 5.0-159 build switching off does
> not change the behavior of the description drop down list. Allowing to
> switch it off could be an improvement in your case.
> 
> But I cannot completely follow the issue. In my case (flatpak GnuCash
> 5.0-159 on Ubuntu 22.04 LTS), the drop down list does not prevent me
> from entering some more text. And as soon as the entered text is found
> in less descriptions, the list shrinks, until it disappears completely
> (i. e. when it's a complete new description).

These issues are currently being worked on. The freeze will only happen if 
there are pre-existing descriptions with newlines in them. That will be fixed.

Also the precedence of matches will be revised to be much more like the 
original behaviour in 4.x.

The other major issue was being able to ignore suggestions, which is also 
being looked at.

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] Turn of drop list when entering data in memo/description line

[Geert Janssens]

Op donderdag 4 mei 2023 21:40:14 CEST schreef Carsten Hütter:
> Am 02.05.23 um 14:49 schrieb Adrien Monteleone:
> > If 4.14 is not available in your distro's repos, you can certainly use
> > the flatpak. You should probably remove 5.0 though first.
> 
> Sadly, code.gnucash.org/builds/flatpak/maint/ does not list 4.14. The
> latest one is 4.13-164 from 2023-03-18. Later build logs tell me:
> "error: Writing content object: min-free-space-percent '3%' would be
> exceeded, at least 143.4 kB requested". So the latest maint branch
> versions are missing, including 4.14. But I'm fine with 4.13-164 as a
> fallback.

The nightly builds are not releases, though you can of course use them in the 
way you describe.

The releases on the other hand are found on flathub. And while not obvious 
from their website you can install older versions from there as well from the 
command line.

Our wiki explains how you can do this:
https://wiki.gnucash.org/wiki/Flatpak#Getting_Older_Releaseses

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] [GNC-dev] GnuCash 5.1 Released

[Geert Janssens]

Indeed. I have looked at the build failure, which is a bit odd. It complains 
about a 
directory already existing while installing the Portuguese documentation.

I have checked all changes between the 5.0 release and the 5.1 release, but I 
don't see 
any change that could trigger this.

So instead I have restarted the build and it seems to pass now. Flathub is 
currently 
committing the successful builds. So in a few hours the new version should be 
available 
there.

Regards,

Geert

Op donderdag 4 mei 2023 04:23:09 CEST schreef Tommy Trussell:
> On Sun, Apr 30, 2023 at 2:22 PM John Ralls  wrote:
> > The GnuCash development team announces GnuCash 5.1, the second release in
> > the stable 5.x series
> 
> GnuCash 5.1 doesn't seem to be available yet on flathub. Looks like the
> aarch64 build failed, but the x86_64 build succeeded.
> 
> https://github.com/flathub/org.gnucash.GnuCash/pull/71
> ___
> 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 - import transactions

[Geert Janssens]

That's good to hear! Thanks for the feedback.

Regards,

Geert

Op maandag 1 mei 2023 10:44:27 CEST schreef Christian Lynbech:
> I can confirm that automatching on import now has started to work again,
> in 5.1.
> 
>/Christian
> 
> 
> ---
> On Thu, Apr 27 2023, Geert Janssens wrote:
> 
> Ok, so the aqbanking log entries were just noise.
> 
> I have further experimented with your samples and that helped me to pinpoint
> the issue. It's effectively a regression that was introduced while
> improving the import of multi-currency data.
> 
> It should be fixed now, in either tomorrow's nightly Windows or Flatpak
> builds and the upcoming 5.1 release.
> 
> Regards,
> 
> Geert
> 
> Op woensdag 26 april 2023 18:29:25 CEST schreef Christian Lynbech:
> > Sure.
> > 
> > 
> > 
> > I am not using AqBanking, my problem is with CSV import. I did notice
> > 
> > those errors/warnings in the log but I could not immediately find
> > 
> > anywhere to turn aQbanking off. I know I had tried at one point to
> > 
> > experiment to see if my bank somehow showed up, it didn't, and I have
> > 
> > never used it for anything. It is of course possible something lingers
> > 
> > from that.
> > 
> > Attached are three files:
> >   test.gnucash - a very simple book (based on the simple check book
> > 
> > template)
> > 
> >   abc.csv - two transactions (already imported into test.gnucash)
> >   
> >   
> >   
> >   def.csv - two more transactions (not yet imported)
> > 
> > def.csv is formed from abc.csv, just with dates and amounts modified
> > 
> > such that gnucash would not think they can reconciled. It is therefore
> > 
> > otherwise the very same transactions and I would expect matching to
> > 
> > occur.
> > 
> > 
> > 
> > As abc.csv has been imported, test.gnucash contains the import settings
> > 
> > (named "test") that I am using.
> > 
> >/Christian
___
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 - import transactions

[Geert Janssens]

Ok, so the aqbanking log entries were just noise.

I have further experimented with your samples and that helped me to pinpoint 
the issue. It's 
effectively a regression that was introduced while improving the import of 
multi-currency 
data.

It should be fixed now, in either tomorrow's nightly Windows or Flatpak builds 
and the 
upcoming 5.1 release.

Regards,

Geert

Op woensdag 26 april 2023 18:29:25 CEST schreef Christian Lynbech:
> Sure.
> 
> I am not using AqBanking, my problem is with CSV import. I did notice
> those errors/warnings in the log but I could not immediately find
> anywhere to turn aQbanking off. I know I had tried at one point to
> experiment to see if my bank somehow showed up, it didn't, and I have
> never used it for anything. It is of course possible something lingers
> from that.
> 
> Attached are three files:
> 
>   test.gnucash - a very simple book (based on the simple check book
> template)
> 
>   abc.csv - two transactions (already imported into test.gnucash)
> 
>   def.csv - two more transactions (not yet imported)
> 
> def.csv is formed from abc.csv, just with dates and amounts modified
> such that gnucash would not think they can reconciled. It is therefore
> otherwise the very same transactions and I would expect matching to
> occur.
> 
> As abc.csv has been imported, test.gnucash contains the import settings
> (named "test") that I am using.
> 
> 
>/Christian


___
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 - import transactions

[Geert Janssens]

I have tried to look into this, but I don't have enough information to go 
further.

First off, from your logs I infer you are importing data via AqBanking. I have 
no accounts that 
are compatible with aqbanking so I can't go that route.

Instead I have tried to import data via the generic CSV importer. If I tweak my 
import data to 
fall in the bayesian thresholds, it is properly matched this way.

So to continue, I will need some test data from you. Can you create a minimal 
book with a 
few transactions in it already and a csv file to import in there that should 
give matches ? 
Please do change any private data.

Additionally, please specify which profile you are using in the Aqbanking 
importer.

Perhaps the easiest is to append all of these in a new bug report. The mailing 
list is a bit 
cumbersome to track updates.

Regards,

Geert

Op dinsdag 25 april 2023 21:34:33 CEST schreef Christian Lynbech:
> I have now done a few more experiments and is not any less confused.
> 
> So to iterate, using 4.14, automatching works, using 5.0 it does not
> work.
> 
> I tried turning on logging as John suggested. When I import to 5.0, I
> get nothing logged during the operation. However, when trying to do the
> import with 4.14, I am getting a number of warnings like this:
> 
> * 20:07:17  INFO  [GncTxImport::update_pre_split_props] User
> warning: Column 'Konto' could not be understood.
> 
> The word "Konto" is danish for "Account". Even so, automatching did
> work. I am attaching the log files from the two attempts below.
> 
> I then thought, perhaps this is a language thing (I am using danish both
> on my computer and in the books), so I c'tried changing the language to
> english but it did change the results, no automatching on verson 5.
> Also, the warnings I see in version 4, now was in english (e.g
> "Account").
> 
> I have also tried generating a completely new book, as simple as can be,
> but the behaviour is exactly the same, so it is not something something
> that has piled up in my actual book.
> 
> Since this does not appear to be a universal issue, it is possible that
> it is somehow language related.
> 
> Attached below are the two aforementioned log files, the one named with
> "4" is from the 4.14 run (which works) and the one with a "5" is from the
> 5.0 version (that is not working).
> 
> I can provide my test book and sample CSV files as well, if anybody
> would like to see them.
> 
> Thanks for taking an interest in my issue.
> 
>/Christian


___
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] CVS Deposit Issue

[Geert Janssens]

Hi Chris,

The names "Deposit" and "Withdrawal" are a bit misleading. In 5.0 they have 
been renamed 
to "Amount" and "Amount (negated)" in the hopes this will slightly improve the 
situation.

Internally, gnucash stores only one single amount per transaction(split). So 
that's what 
eventually has to be derived from the CSV data. Which columns to select depends 
on the 
initial structure of your CSV data.

I'll give a few examples to illustrate (I have added spaces in the examples to 
have a nicer 
alignment - they should not be in the CSV data):

Example 1:
Date,   Description,   Amount
23/04/2024, Sell Widget A, 100.00
23/04/2024, Buy Groceries, -56.00

This is an example of a CSV file in which all the amounts are in a single 
column. Incoming 
money is represented with a positive amount, money going out is represented 
with a 
negative amount.

To import this you'd set the Amount column to "Deposit" (or "Amount" in 5.0), 
which gnucash 
interprets as "use these amounts as they are, no changes required".

Example 2:
Date,   Description,   Debit,  Credit
23/04/2024, Sell Widget A, 100.00,   0.00
23/04/2024, Buy Groceries, 0.00,56.00

This is an example of a CSV file in which incoming money is represented as a 
positive 
number in the Debit column and money going as a positive number in the Credit 
column.

To import this you'd set the Debit column to "Deposit" (or "Amount" in 5.0) and 
the Credit 
column to "Withdrawal" ("Amount (negated)" in 5.0). That way you instruct 
GnuCash to use 
the Debit numbers unchanged and negate the Credit numbers.


Example 3:
Date,   Description,   Deposit, Withdrawal
23/04/2024, Sell Widget A, 100.00,  -100.00
23/04/2024, Buy Groceries, -56.00,56.00

This example is similar to your demo. It has both a deposit and a withdrawal 
column which 
essentially hold the same information, albeit one is negated version of the 
other.

GnuCash only needs this information once, so in this case you choose only one 
column in the 
importer. You can either set the "Deposit" column to "Deposit" (or "Amount" in 
5.0) or set the 
"Withdrawal column to "Withdrawal" (or "Amount (negated)" in 5.0), but not 
both. If you set 
both, GnuCash will assume you meant to combine both columns in to a single one 
(like the 
previous example) and will perform the calculation
amount = deposit - withdrawal
for each row. And that would indeed result in doubling all amounts while 
importing for this 
kind of CSV file.

Hopefully this will clear it up for you.

Regards,

Geert

Op woensdag 26 april 2023 01:13:51 CEST schreef Chris Ledbetter via 
gnucash-user:
> I am importing Transactions via CSV.  When the importing is finished the
> Deposit is being doubled upon import.  I am using 4.12 and have not updated
> yet since I am doing a lot of input and would rather not mess with this
> until later.  I use a MacBook Pro M1 Ventura 13.3.1.  Here is a demo import
> CSV file that Deposits $15 via import but should be $7.50.  I have been
> going in and dividing transactions in the register by 2 to get the correct
> values.  I just tried dividing the cells by 2 before exporting to CSV but
> when the system doubles the amount at import, there is often a penny
> difference.  If there is an easy work around that will be fine.  I can get
> by doing the math in the register but I’d rather not.  Here is a screenshot
> of my sample numbers file that I export to CSV before I import.  Thanks
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 5 - import transactions

[Geert Janssens]

Hi and welcome to the list!

You have got it right, so far no solution has been offered. This is likely 
because we're looking 
at a regression introduced in version 5.0 but nobody has had the time yet to 
investigate this 
further. I plan to look into this somewhere this week.

If the matching is really important for you, you may try installing gnucash 
4.14 in the interim.

Regards,

Geert

Op woensdag 26 april 2023 00:37:41 CEST schreef Valued Customer via 
gnucash-user:
> Hi. This is the first time I've tried to use the mailing list for help. I
> think I may having the same issue being described in this string. iMac
> Intel 2021 Ventura
> Gnucash Version: 5.0
> Build ID: 5.0+(2023-03-25)
> 
> When I import transactions from CVS no matching is occurring even though
> many of the transactions' descriptions are exact matches. If there is a
> solution in this email exchange, I'm not understanding it.
> 
> I've spent a lot of time with Gnucash over the last few months and have
> entered two years worth of transactions. I've had some limited success with
> the import matcher but, my last attempt resulted in zero matches.
> 
> Mitch
> 
> 
> 
> Sincerely,
> Valued Customer
> 
> Sent with Proton Mail secure email.
> 
> --- Original Message ---
> 
> On Tuesday, April 25th, 2023 at 3:16 PM, Joseph St. Denis via gnucash-user 
>  wrote:
> > I finally got the CVS download to work in 5.0. I had to drop using the
> > type of transaction to get it to work. Instead of the four columns that I
> > used in 4.13. When I tried a second CVS transfer from a second account
> > Gnucash shutdown. When I reopened Gnucash all the transactions were
> > present.
> > 
> > All the best
> > 
> > Joseph St Denis
> > 
> > Get Outlook for Androidhttps://aka.ms/AAb9ysg
> > 
> > 
> > From: gnucash-user gnucash-user-bounces+stdenis0=yahoo@gnucash.org on
> > behalf of Christian Lynbech christ...@defun.dk
> > 
> > Sent: Tuesday, April 25, 2023 3:34:33 PM
> > To: john jra...@ceridwen.us
> > 
> > Cc: gnucash-user@gnucash.org gnucash-user@gnucash.org
> > 
> > Subject: Re: [GNC] Gnucash 5 - import transactions
> > 
> > I have now done a few more experiments and is not any less confused.
> > 
> > So to iterate, using 4.14, automatching works, using 5.0 it does not
> > work.
> > 
> > I tried turning on logging as John suggested. When I import to 5.0, I
> > get nothing logged during the operation. However, when trying to do the
> > import with 4.14, I am getting a number of warnings like this:
> > 
___
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 - import transactions

[Geert Janssens]

Hi Joseph,

Can you be a bit more precise here ? What steps have you taken to import (which 
menu 
item you started from, which options in the importer did you tweak, what do you 
see on 
screen at the spot you get stuck,...)

Regards,

Geert

Op maandag 24 april 2023 22:39:18 CEST schreef Joseph St. Denis via 
gnucash-user:
> I am also having problems with the CVS imports, but my problem is that the
> only way I can complete the download is to eliminate the errors and no
> entrys are selected. I tried the date, discretionary
> 

___
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] Building Gnucash on Fedora 37 - "No package 'glib-2.0' found" error

[Geert Janssens]

Hi,

A late reply...

I'm on Fedora 37 as well, but can't reproduce the error.

I'm currently building the current stable branch though, not 4.13. Where does 
your 
gnucash-4.13 come from ? Is that a release tarball, or a git checkout ?

Regards,

Geert

Op donderdag 9 maart 2023 23:52:52 CEST schreef Vivek Gani:
> Hi,
> 
> I'm trying to build gnucash from source (rather than the rpm package or
> flatpak for python bindings) on Linux (Fedora 37) and keep running into an
> issue where on build I get the error:
> 
> ```
> -- Checking for module 'glib-2.0>=2.56.1'
> --   No package 'glib-2.0' found
> ```
> 
> What I've tried so far:
> - I've installed glib2.0-devel via `sudo dnf install glib2-devel`
> - I've checked via `yum provides */glib2.0.pc` which shows it is in the
> `/usr/lib64/pkgconfig` directory.
> - I've checked the contents of `echo $PKG_CONFIG_PATH` which shows
> directories like `/usr/lib64/pkgconfig` are listed.
> - I've tried building gnucash with various different arguments, but similar
> to the directions in
> https://wiki.gnucash.org/wiki/CMake#GnuCash_Configuration_Variables &
> https://wiki.gnucash.org/wiki/Building_On_Linux#Build_using_CMake_and_Ninja
> I've tried in my build directory:
> `cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt
> -DCMAKE_PREFIX_PATH=$PKG_CONFIG_PATH  -DCMAKE_VERBOSE_MAKEFILE=on
> ../gnucash-4.13`
> 
> and get the glib error. It happens also without the CMAKE_PREFIX_PATH, just
> running plain `cmake .` in the gnucash source directory, etc.
> 
> Any idea what I'm missing to get things to build?
> 
> Thanks in advance,
> Vivek
> ___
> 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] CSV import crash in 5.0+

[Geert Janssens]

Op vrijdag 21 april 2023 04:59:40 CEST schreef John Ralls:
> > On Apr 20, 2023, at 6:52 AM, Joseph Vernice  wrote:
> > 
> > I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading
> > to
> > 5.0 (and above nightly builds) I am unable to import transactions from
> > CSV.  The system crashes when I select the CSV import profile or when I
> > try
> > to create a new one.  The crash accors immediately after selecting the
> > profile OR after assigning the AMOUNT column. I have resorted to the
> > latest
> > pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
> > checking account only allows for CSV export, so this is an essential means
> > for me to import into gnucash. Thank you everyone for all your help.
> 
> There are two open CSV crashers,
> https://bugs.gnucash.org/show_bug.cgi?id=798799 and
> https://bugs.gnucash.org/show_bug.cgi?id=798830. The first is about the CSV
> having fewer fields in the first line than in the second and while GnuCash
> shouldn't crash in that case IMO it should reject the file as ill-formed.
> The second involves entries having a '/' character.
> 
> If your problem file matches neither of those please file a new bug report.
> Be sure to attach the trace file[1] and if possible a stack trace[2].
> 
> Regards,
> John Ralls
> 
> [1] https://wiki.gnucash.org/wiki/Tracefile
> [2] https://wiki.gnucash.org/wiki/Stack_Trace
> 
> 
If GnuCash crashes then this is very likely the same issues as
https://bugs.gnucash.org/show_bug.cgi?id=798877
(https://bugs.gnucash.org/show_bug.cgi?id=798799 is a duplicate of this one)

That issue has now been fixed and will appear in tomorrow's nightly. You can 
try that one to 
test if you like.

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] Pack with Python bindings on macOS?

[Geert Janssens]

Out of curiosity, would it be much more work to create two release bundles ? 
One with and 
one without python bindings ?

I recall Libreoffice has done that for quite a while to optionally bundle a 
java runtime. 
Though they seem to have stopped doing that.

Regards,

Geert

Op vrijdag 21 april 2023 18:20:10 CEST schreef john:
> > On Apr 21, 2023, at 3:17 AM, monson  wrote:
> > 
> > Hi there,
> > 
> > The pure python client `piecash` seems obsoleted and no longer worked with
> > latest sqlalchemy and gnucash, so I'm trying to switch to original python
> > bindings. Since they aren't shipped in the pre-built bundle, I tried to
> > build those bindings but it seems have to build the whole gnucash and
> > doesn't work well. On Linux (e.g. archlinux) those python bindings are
> > shipped with the gnucash package. May I ask if we can do the same on
> > macOS? Thanks.
> Unfortunately there's no good way to do that. The Python bindings need to be
> linked with libpython3 and Apple only provides one in recent versions of
> Xcode--Xcode itself, mind, not the SDK--with a decidedly quirky framework
> layout. Supporting that across 5 versions of macOS isn't practical. Worse,
> since it's not in the SDK it can't be linked from another bundle: Apple's
> notarization doesn't allow linking anything outside the bundle that's not
> in either /usr/lib or /System/Library/Frameworks. With that latter rule the
> only way to include the python bindings in GnuCash app is to include a full
> build of Python in the bundle and you'd have to use the Python executable
> in the bundle with the scripts. That's a lot of extra baggage for the few
> users who want it.
> 
> If building GnuCash with gtk-osx is too hard consider MacPorts instead.
> Homebrew just "bottles" GnuCash.app so it's not an alternative.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] gnucash 4.8 does not save settings

[Geert Janssens]

Before you go the flatpak route though, it may be worth figuring out why your 
settings are 
not saved. Are there any messages in your trace file ?

A known issue with saving settings is when you have applications installed in 
/usr/local. Or 
more specifically if there are schema files in 
/usr/local/share/glib-2.0/schemas/. In that case 
gnucash fails to find its own schema files in /usr/share/glib-2.0/schemas/. 
This issue was 
fixed for gnucash 4.13.

Regards,

Geert



Op vrijdag 14 april 2023 15:51:08 CEST schreef Papa Oz:
> Hello, Carsten, and thanks for the reply.
> 
> Please forgive the anti-spam thing.  I had put @gnucash.org in my address
> book and I assumed all list-oriented traffic would come through their
> server.  Now that I see how it works I will probably have to change my
> registration to a different address that lacks the filtering.  Meanwhile
> you are "allowed".
> 
> All the files are within my home directory tree and I checked the
> permissions already.  There are some symlinks involved.  They work with 3.8
> but I suppose something might have changed in 4.8 such that they are a
> problem.
> 
> I did notice that the developers have gone the flatpak route.  I am not fond
> of flatpaks, which is why I mentioned deb in my post.  I suspect the
> sandbox aspect of flatpaks will give me some trouble sharing files between
> two systems.  But I guess I will have to add gnucash to my very small
> collection of flatpaks and figure out how to work out the sharing.
> 
> Thank you for your recommendation of 4.13.  I will give it a try.
> 
> -Original Message-
> From: Carsten Htter 
> Sent: Apr 14, 2023 7:17 AM
> To: Papa Oz , 
> Subject: Re: [GNC] gnucash 4.8 does not save settings
> 
> Hi Papa Oz!
> 
> First of all: I'd recommend updating to a more current version both of
> GnuCash (latest 4.x is 4.14 from 2023-03-25) and Finance::Quote (latest is
> 1.54 from 2022-12-26). GnuCash 5.0 still has some issues.
> 
> The developers decided to publish the stable GnuCash Linux versions as
> flatpak, not as deb packages. So in order to get the cutting edge version
> without building from source code, you have to install flatpak. I'm on
> Ubuntu 22.04 LTS, only limited experience with other Linux flavors
> (switched from OpenSUSE sometime in the last century or millennium), but
> the following instructions should work more or less: $ sudo apt install
> flatpakThe latest GnuCash 4.x flatpak on code.gnucash.org is 4.13 from
> 2023-03-18, can be downloaded here:
> https://code.gnucash.org/builds/flatpak/maint/gnucash-maint-C4.13-164-g207b
> 105b9c-D4.13-7-g96300db7.flatpakrefCan be installed with: $ cd
> ~/Downloads/GnuCash/  # Change to location of your flatpak file $ flatpak
> install gnucash-maint-C4.13-164-g207b105b9c-D4.13-7-g96300db7.flatpakref  #
> sudo not neededAnd started with: $ flatpak run org.gnucash.GnucashThere you
> go. Each flatpak package includes it's own current Finance::Quote.
> 
> To get the gnucash starter icon in your environment, you may need to install
> the Linux mint 21 cinnamon flatplak plugin: $ sudo apt install
> flatpak-plugin-cinnamonOn my system there are two flatpak GnuCash versions
> installed, which reside peacefully next door to each other: $ flatpak list
> --app
> Name Application ID Version 
>  Zweig Ursprung
>Installation GnuCash  org.gnucash.GnuCash   
> 4.13-164-g207b105b9c+ maint-C4.13-164-g207b105b9c-D4.13-7-g96300db7
___
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 4.8 does not save settings

[Geert Janssens]

Hi Papa OZ,

I'd like to respond to the "developers have gone the gnucash route" remark.

That suggests the developers prefer the use of flatpaks over distro packages. 
As one of these 
developers (though less active these days) and the initiator of the flatpak for 
gnucash effort, 
I like to state that would be misleading.

Personally I don't have a preference per se. There are plenty of arguments for 
or against 
either approach and I think it's up to each individual user to make a choice 
based on what 
they consider most important.

The choice to introduce flatpaks comes from a very practical standpoint.

The situation is that the gnucash packages found in distributions have never 
been created 
by gnucash developers themselves. This has always been done by distro 
packagers. Due to 
the policies that each distribution has wrt updating packages, we are in a 
situation that 
distro packages often lag behind on gnucash releases. The lag ranges from a few 
weeks 
(good!) to a couple of years.

We can't and won't create up to date packages for all possible distros out 
there (in various 
formats like deb, rpm, arch-flavoured,...).

However we can provide a single up-to-date flatpak as an alternative that works 
on all 
distributions. So that's what we have done.

Users that have reasons to stick with their distro but want to have a newer 
gnucash than 
their distro ships by default now have an alternative that's likely easier to 
use than building 
from source.

But to each their own. If you prefer to stick with your distro package, by all 
means enjoy that 
version!


Should you choose to go with flatpak, I should address your question about 
sharing files.

Your data file is not stored in the sandbox. It will be somewhere in your home 
directory. So 
you should be able to share that without issues as you did before.

If you also shared config files or saved reports, they do indeed move to a 
different location. 
But that location is also accessible from outside the sandbox, so I expect you 
can share those 
as well, though maybe not via ordinary softlinks. The location of these 
configuration files 
however is controlled by two environment variables GNC_DATA_HOME and 
GNC_CONFIG_HOME. If you point these to a location outside of the typical 
in-sandbox 
locations, I expect you can share them as you like.

Hope that helps,

Geert

Op vrijdag 14 april 2023 15:51:08 CEST schreef Papa Oz:
> Hello, Carsten, and thanks for the reply.
> 
> Please forgive the anti-spam thing.  I had put @gnucash.org in my address
> book and I assumed all list-oriented traffic would come through their
> server.  Now that I see how it works I will probably have to change my
> registration to a different address that lacks the filtering.  Meanwhile
> you are "allowed".
> 
> All the files are within my home directory tree and I checked the
> permissions already.  There are some symlinks involved.  They work with 3.8
> but I suppose something might have changed in 4.8 such that they are a
> problem.
> 
> I did notice that the developers have gone the flatpak route.  I am not fond
> of flatpaks, which is why I mentioned deb in my post.  I suspect the
> sandbox aspect of flatpaks will give me some trouble sharing files between
> two systems.  But I guess I will have to add gnucash to my very small
> collection of flatpaks and figure out how to work out the sharing.
> 
> Thank you for your recommendation of 4.13.  I will give it a try.
> 
> -Original Message-
___
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] Reports will not display on screen, print to file works

[Geert Janssens]

Op dinsdag 11 april 2023 20:53:06 CEST schreef Adrien Monteleone:
> Jeff,
> 
> Report display has to do with webkit.
> 
> Perhaps check to see if it needs updating as well, or if for some reason
> you've pinned an old version to prevent updating. (but then you'd need
> to recall why you pinned it so as not to break something else.)
> 
> That might not be the culprit, but it would be the first thing I'd check.
> 
> Regards,
> Adrien
> 
The flathub edition of gnucash uses the webkit version that's part of the 
flatpak. The one on 
the system is irrelevant.

There has been an issue with webkit requiring opengl recently. Perhaps that's 
also causing 
this ?

The workaround then was to set WEBKIT_DISABLE_COMPOSITING_MODE=1  in the 
environment. I'm not sure whether this can just be in the user's environment or 
whether it 
has to be done in the flatpak's sandbox environment though.

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.

[GNC] Fwd: Re: Save button never seems to activate anymore

[Geert Janssens]

Forwarding to list so others following the thread can keep up...

Regards,

Geert

--  Doorgestuurd bericht  --

Onderwerp: Re: [GNC] Save button never seems to activate anymore
Datum: dinsdag 11 april 2023, 12:13:59 CEST
Van: G R Hewitt 
Aan: Geert Janssens 

Thanks Geert,
You could be right, I 'Saved As' before trying something out and it went
pear-shaped
so reloaded my 'Saved As'.
On checking just now I can see that the default 'Save As' is 'xml', which I
didn't notice;
which also means I have been using xml, when all the time I though it was
sqlite - which explains a few things.

On Tue, 11 Apr 2023 at 11:00, Geert Janssens 
wrote:

> That sounds as if you changed the file format from xml to sqlite.
>
> Normally, the save button is only active for data files in xml format and
> should not be active for data files in sqlite format.
>
> The way to change between formats is by using the File->Save As... menu
> item.
>
> Regards,
>
> Geert
>
> Op dinsdag 11 april 2023 11:34:53 CEST schreef G R Hewitt:
>
> > Greetings all,
>
> > MacPro 2010, High Sierra Gnucash 5.0
>
> >
>
> > I have noted that the 'Save' button never seems to come on anymore.
>
> > Recently, after doing a few things to the accounts, it showed active and
>
> > I'd click it, when the little watch appeared and then the 'Save' button
>
> > would be
>
> > deactivated, until I made some other change, when it would reactivate.
>
> >
>
> > This is no longer happening, and I have tried changing things and
> entering
>
> > new things
>
> > and the like, but still there is no change in its deactivated status.
>
> >
>
> > When I close and re-open, all the changes made are there, so there's no
>
> > real problem about it, other than I found it reassuring to manually save.
>
> >
>
___
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] Save button never seems to activate anymore

[Geert Janssens]

That sounds as if you changed the file format from xml to sqlite.

Normally, the save button is only active for data files in xml format and 
should not be active 
for data files in sqlite format.

The way to change between formats is by using the File->Save As... menu item.

Regards,

Geert

Op dinsdag 11 april 2023 11:34:53 CEST schreef G R Hewitt:
> Greetings all,
> MacPro 2010, High Sierra Gnucash 5.0
> 
> I have noted that the 'Save' button never seems to come on anymore.
> Recently, after doing a few things to the accounts, it showed active and
> I'd click it, when the little watch appeared and then the 'Save' button
> would be
> deactivated, until I made some other change, when it would reactivate.
> 
> This is no longer happening, and I have tried changing things and entering
> new things
> and the like, but still there is no change in its deactivated status.
> 
> When I close and re-open, all the changes made are there, so there's no
> real problem about it, other than I found it reassuring to manually save.
> 
> Any idea's on this? Thanks in advance.
> ___
> 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

[Geert Janssens]

Op zondag 9 april 2023 16:22:42 CEST schreef David G. Pickett:
> As it should never have occurred, and should not be a warning, it is a (low
> priority) bug report, not an enhancement.  Assume everything is good but
> validate inputs before using, leads to simpler, cleaner code.  The code
> should complain about the key when it has occasion to use it, not as a
> warning, but as an error.  If it has occasion to use it 30 times, 30 errors
> until the user configures it correctly.
> 
Call it what you will. Regardless both a bug report or an enhancement request 
should be reported in bugzilla, not on the mailing 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] Command line quotes still not fixed

[Geert Janssens]

What you get is not an error but a warning. In your case it's superfluous 
because as you say 
you don't have currency rate quotes. So it adds some noise for you but should 
otherwise 
work (barring the other bugs we're fixing in the online quote retrieval area).

However for users that would have currency quotes but omitted to set an 
AlphaVantage key, 
not getting the warning would leave them puzzled.

I agree it's currently a bit of an all-or-nothing approach but that can be 
refined eventually. A 
good improvement would be to check whether currency quotes are requested and 
only then 
emit a warning for a missing AlphaVantage API key.

That would be an enhancement request for you to file though.

Regards,

Geert

Op zondag 9 april 2023 01:50:55 CEST schreef David G. Pickett via gnucash-user:
> I have no currency rate quotes, just US stocks in US dollars.
> 
> 
> -Original Message-
> From: Murugan Muruganandam 
> To: hell...@gmail.com ; David G. Pickett
>  Cc: gnucash-user@gnucash.org 
> Sent: Thu, Apr 6, 2023 5:08 pm
> Subject: Re: [GNC] Command line quotes still not fixed
> 
> #yiv0949692185 P {margin-top:0;margin-bottom:0;}Alphavantage is required for
> currency rates
> 
> 
> Saludos Cordiales
> Murugan
> From: gnucash-user
>  on behalf of
> David G. Pickett via gnucash-user  Sent:
> Thursday, April 6, 2023 4:41 PM
> To: hell...@gmail.com 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] Command line quotes still not fixed As I do not use
> Alphavantage, just 'Yahoo as json', why is it looking for an api key?
> 
> 
> -Original Message-
> From: David H 
> To: David G. Pickett 
> Cc: geert.gnuc...@kobaltwit.be ;
> gnucash-user@gnucash.org ; jra...@ceridwen.us
>  Sent: Thu, Apr 6, 2023 4:21 pm
> Subject: Re: [GNC] Command line quotes still not fixed
> 
> I don't think the version difference is a mystery - remember that Flatpak is
> a sandbox so presumably brings along whatever perl version it was
> built/packaged with.  If you set your Alphavantage api key in the Gnucash
> application itself you'll probably also also get rid of the other error
> message. The following is all I get displayed using Geert's command format:
> flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get --
> '/home/h/Documents/GnuCash/Data Files/h.gnucash' Found Finance::Quote
> version 1.5301.
> 
> Cheers David H.
> 
> On Fri, 7 Apr 2023 at 05:08, David G. Pickett  wrote:
> 
> I don't understand why, but "--" does also work, like "--namespace='.*'".
> 
> I still get a lot of errors that do not affect my quote fetch.
> It finds 1.5301 even though I installed 1.5401, a different mystery!
> 
> dgp@dgp-p6803w:~$ flatpak run --command=gnucash-cli org.gnucash.GnuCash
> --quotes get -- /home/dgp/GnuCash/ubuntu-DGPickett.gnucash* 15:05:17  WARN
___
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] Assign as payment does nothing

[Geert Janssens]

Hi Tom,

Please file this as a bug report as well, to avoid this from getting lost on 
the mailing list.

Thank you and regards,

Geert

Op zaterdag 8 april 2023 15:24:16 CEST schreef Tom Weichmann:
> Note: after having this issue I decided to go to GNUCash 4.14, however I
> noticed 4.14 has the same issue.  So then I went back to 4.13 and the issue
> was fixed.  So there is something that was added to both 4.14 as well as
> 5.0 which has created a regression,
> 
> On Fri, Apr 7, 2023 at 6:12 PM Tom Weichmann  wrote:
> > GNUCash 5.0
> > Ubuntu 22.04
> > Compiled from source
> > 
> > Right click on item in regester, click assign as payment, choose
> > customer from dialog -> choose open invoice from dialog (highlighting open
> > invoice).  Click OK.  The items transfer account should change to Accounts
> > receivable and mark the invoice as paid, but neither of these happen.
> > 
> > Wanted to check if anyone else has seen this behaviour or if I need to
> > file a bug report.
> > 
> > Thanks,
> > 
> > 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] Find not working in Gnucash for Windows 5.0

[Geert Janssens]

Op donderdag 6 april 2023 08:07:12 CEST schreef 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.
> 

To expand on this: the description is a transaction property, while action and 
memo are split 
properties.

If you initiate a search from an account register on any split property, it 
will only search the 
splits that belong to that account and not the other splits for all 
transactions shown. 
Searching for transaction properties will always work as they are shared by all 
splits in the 
split register.

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

[Geert Janssens]

Actually instead of adding a --namespace parameter, you can just use '--' to 
separate the 
named parameters from the positional parameters like so:
flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- /home/dgp/
GnuCash/ubuntu-DGPickett.gnucash

That's a common unix way to solve such ambiquities.

Regards,

Geert

Op donderdag 6 april 2023 05:04:02 CEST schreef 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
> >> 
___
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] 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] 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] 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] 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] GnuCash flatpak "invisible" update?

[Geert Janssens]

Op zondag 12 maart 2023 16:07:55 CET schreef john:
> A related and perhaps more interesting question for folks with a firmer
> grasp of flathub than I have: I'll be releasing both 4.14 and 5.0 in two
> weeks. IIUC flathub supports only one version at a time so there's no point
> in making a flathub build for 4.14. Both would be available from
> https://code.gnucash.org/builds/flatpak. Is my understanding correct?

FWIW I think it's worth pushing both releases to flathub, first the 4.14 one 
and right 
afterwards 5.0. There are ways to install an earlier version of a package from 
a flatpak repo 
(like flathub). So if you push both, we can document how to install 4.14 if 
there are 
(important) issues with 5.0.

As for installing from https://code.gnucash.org/builds/flatpak, that works, but 
was never 
really set up to be a source of release packages. So it's a bit awkward for 
people that are 
used to the convenience of flatpak.

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] Confusing version numbers

[Geert Janssens]

Op donderdag 9 maart 2023 09:34:36 CET schreef aeg via gnucash-user:
>  The fact that 9 is less than 12 is not confusing to me, but sorting by
> Windows File Explorer routinely puts 12 before 9, whereas 09 is always
> correctly arranged before 12 (and before 900). From the
> link, https://semver.org/ provided by LI Daobing, I now understand that
> there is a conventional way of numbering software releases, but I remain
> puzzled by the insistence that leading zeros must not be used. It is often
> the case that the status quo can be seen to work, but it is my opinion
> that, if an improvement can be made and the effort to do so is minimal, it
> is normally worth making that improvement. I assume that's what drives the
> developers to make evolutionary changes and introduce updates. I'd just
> like to see a numbering system that works in all circumstances. Alan

Well, it's all context related.

On my linux desktop files get properly sorted already now with .9 appearing 
before .12. 

In fact linux desktop environments have been properly sorting such version 
numbers for 
years. So I don't even notice this on the PC I use every day. Looks like the 
Windows' file 
manager does not have that feature (yet) or perhaps it's configurable somewhere 
?

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] GnuCash 4.902 Released

[Geert Janssens]

Op maandag 6 maart 2023 05:17:33 CET schreef John Ralls:
> The following fixes will also appear in GnuCash 4.14:
> 

snip

>   • Bug 798600 - CSV import of multi-split security transactions fails to
> load capital gain Transactions with capital gains processing can have
> splits in transaction currency with a zero amount and a non-zero value. To
> properly import those, prefer the value column even if transaction currency
> equals account commodity. Previous (wrong) assumption was that in case of a
> same-currency split, the amount would always be the value.
> 
> Update csv transaction export format to include split values. In the csv
> importer the 'GnuCash Export Format' option will now include values. For
> compatibility with filex exported from older gnucash versions the previous
> preset is still available under the name 'GnuCash Export Format (4.x and
> older)'.
> 

Contrary to what the announcement said, this bug fix will not be part of 
gnucash 4.14. It 
depends on other changes that are only available in 4.902 and up.

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] Gnucash,org url is now working

[Geert Janssens]

It looks like an http vs https thing.

https://www.gnucash.org works fine, plain http doesn't. Probably the redirect 
is not working 
as it should.

Regards,

Geert

Op vrijdag 3 maart 2023 13:31:14 CET schreef Derek Atkins:
> Hi.
> Indeed, it does appear that www.gnucash.org lost its brain and, although
> responding, is not the gnucash website.  I will notify Linas to ask what's
> up.
> As for # subscribers, we have a dozen lists with some overlapping
> subscriptions, but there are over 2000 subscribers to gnucash-user.
> 
> -derek
> 
> On Fri, March 3, 2023 7:13 am, Brad Morrison wrote:
> > Hi Ken, John, & all,
> > 
> > I just tried the link that Ken provided and it took me to some "Apache2
> > Ubuntu Default Page," but not the GnuCash homepage...?
> > 
> > I also tried the link that John provided and that seems to work fine for
> > the GnuCash homepage for me.
> > 
> > Is anyone else having similar results?
> > 
> > I would attach screenshots, but I don't know if the Mailman2 mailing
> > list software allows for that - ? I am on the board of the North Bay
> > Linux Users Group (NBLUG - https://nblug.org/) and we have gone through
> > some transition difficulties in our recent upgrade from MailMan2 to
> > MailMan3 (https://www.gnu.org/software/mailman/index.html), so when I
> > saw that these GnuCash mailing lists are still using MailMan2
> > (https://lists.gnucash.org/mailman/listinfo) I made a mental note of
> > that. Although with the amount of email traffic /volume that I have seen
> > on this list, I am willing to bet that this list has far more
> > subscribers than all of our NBLUG lists combined (we have about 250 on
> > the 'talk' list and about 450 on the 'announce' list).
> > 
> > Thanks,
> > 
> > Brad
> > 
> > On 2/21/23 21:00, Ken Pyzik wrote:
> >> Tested it this evening - 9:00PM PST in the
> >> US.www.gnucash.org  now appears to be working.
> >> FYI.
> >> 
> >> Ken
> >> 
> >> 
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > 
> > On 2/19/23 15:40, John Ralls wrote:
> >> As most everyone already knowswww.gnucash.org  has been offline since 11
> >> February because Linas Vepstas lost internet access and his ISP, Grande
> >> Networks in Austin, TX, has not fixed it.
> >> 
> >> To provide replacement service until Linas gets back online we've set up
> >> an alternate site,https://code.gnucash.org/website/.
> >> 
> >> Regards,
___
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] Postgress connection string for nonstandard port

[Geert Janssens]

Op donderdag 23 februari 2023 22:00:12 CET schreef Bob Treumann:
> Thanks for all the feedback.   I will share my learnings;
> 
> The database must be created before you connect to it.The install
> process creates all the tables in the Public schema in that database once
> it connects successfully.

If your postgresql user has proper database creation rights, the database 
doesn't have to 
exist prior.

> 
> Geert Janssens referenced the code where he could tell that the appended
> port should work.
> Geert, can you tell me where to find that? I would like to see if I can
> modify it to connect to my chosen database and schema rather than using the
> public schema in a dedicated database.

I can give you a few pointers, but I'm afraid the whole path is not that 
straightforward.

I have started from the code that reads the database parameters:
https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/dialog-file-access.c#L71[1]
That code will eventually call 'gnc_uri_create_uri' in
_https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/dialog-file-access.c#L9_8
Note the port parameter is set to 0, which suggests to omit adding a port 
number to the uri 
by code. However if the host parameter contains a port part, that will be 
retained in the final 
uri, and that's how you can pass a non-standard port when entering database 
parameters.

> 
> I mentioned in another post that Postgress creates multiple schemas in a
> single database.That is my preferred way of operating because I can
> read and write to other schemas without connecting across databases.I'm
> not even sure if PG supports cross database connections.

There is no support for schemas other than the default, because schemas are a 
feature 
specific to postgresql and the same database code in gnucash also has to work 
with mysql 
and sqlite.

If you want to look into implementing some kind of generic table prefix (which 
could 
translate into a schema in posgresql and just a name prefix in the other 
databases), you will 
probably have to combine amandments in the gnc_uri code with changes in the dbi 
backend 
code found here
https://github.com/Gnucash/gnucash/tree/maint/libgnucash/backend/dbi[2]

Regards,

Geert


[1] 
https://github.com/Gnucash/gnucash/blob/maint/gnucash/gnome-utils/dialog-file-access.c#L71
[2] https://github.com/Gnucash/gnucash/tree/maint/libgnucash/backend/dbi
___
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] Postgress connection string for nonstandard port

[Geert Janssens]

The attached image only shows the connection parameters as entered by the OP. 
It doesn't 
indicate any errors in itself.

But to be sure I have just verified this myself. I created a postgresql server 
listening on a 
non-standard port, and used the method I described below to successfully save a 
gnucash 
session to a pre-existing, empty database.

Regards,

Geert

Op donderdag 23 februari 2023 09:36:04 CET schreef Peter West:
> The OP said that that was not working (see his attached image.)
> 
> 
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
> 
> > On 23 Feb 2023, at 6:30 pm, Geert Janssens 
> > wrote:
> > 
> > From what I read in the code you should be able to pass a custom port by
> > adding it in the hostname field, like so:
> > 
> > yourserver.xyz:6543
> > 
> > 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] Postgress connection string for nonstandard port

[Geert Janssens]

From what I read in the code you should be able to pass a custom port by adding 
it in the 
hostname field, like so:

yourserver.xyz:6543

Regards,

Geert

Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West:
> Are you on Windows, Mac or linux? How do you invoke GnuCash? There will be
> some sort of environment in which the invocation occurs from your end.
> 
> —
> Peter West
> p...@pbw.id.au
> “Blessed are the peacemakers, for they shall be called sons of God.”
> 
> > On 23 Feb 2023, at 2:13 am, Bob Treumann  wrote:
> > 
> > 
> > 
> > I could set it since I control the server, but I don't know where I would
> > set it so that it would take effect before the connection attempt is
> > made.
> > 
> > On Tue, Feb 21, 2023 at 10:53 PM Peter West  > > wrote: Is it possible for you to set the PGPORT
> > environment variable?
> > 
> > 
> > —
> > Peter West
> > p...@pbw.id.au 
> > “Blessed are the peacemakers, for they shall be called sons of God.”
> > 
> >> On 22 Feb 2023, at 11:01 am, Peter West  >> > wrote:
> >> 
> >> I’m using the default port, so I can’t help there.
> >> 
> >> “Database” refers to the database, in my case, gnucash.
> >> 
> >> 
> >> —
> >> Peter West
> >> p...@pbw.id.au 
> >> “Blessed are the pure in heart, for they shall see God.”
> >> 
> >>> On 22 Feb 2023, at 8:07 am, Bob Treumann  >>> > wrote:
> >>> 
> >>> I am running PG on an amazon server on a non standard port (6543).
> >>> 
> >>> The connection setup on gnucash does not have a filed to input the port.
> >>> I added the port to the end of the hostname, a style that has worked
> >>> with
> >>> other applications.
> >>> 
> >>> There is a field to enter the "database", which in PG contains multiple
> >>> schemas.
> >>> The user is typically connected to a schema by a default path.
> >>> 
> >>> My questions are:
> >>> How do I define the port?
> >>> Does "Database" refer to "Schema"?
> >>> 
> >>> I would try every combination but the interface only gives me one
> >>> chance.
> >>> It gives a "cannot connect" message then closes.
> >>> 
> >>> 
___
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 on multi-currency transactions.

[Geert Janssens]

Even more correct.

Op donderdag 2 februari 2023 13:55:43 CET schreef David Carlson:
> I believe the correct URL is https://bugs.gnucash.org/show_bug.cgi?id=779926
> 
> On Thu, Feb 2, 2023 at 4:58 AM Geert Janssens 
> 
> wrote:
> > Op donderdag 2 februari 2023 08:56:29 CET schreef Dr. David Kirkby:
> > > I found what I feel is a bug - see attachment. It's basically the same
> > > as
> > > 
> > > https://bugs.gnucash.org/show_bug.cgi?id=779888
> > > 
> > > reported by Christopher Lam, and marked as fixed. But I don't think it
> > > is
> > > fixed, so I added a comment.
> > 
> > So did I to explain why you experience what you describe. In short I think
> > you want to find
> > by amount, not by value.
> > 
> > > There's a link to another bug on that bug, but the link points to
> > > nowhere
> > > useful.
> > 
> > That's a leftover from when we tracked our bugs on bugzilla.gnome.org.
> > The new url is this
> > https://bugzilla.gnome.org/show_bug.cgi?id=779926[1]
> > 
> > Regards,
> > 
> > Geert
> > 
> > 
> > [1] https://bugzilla.gnome.org/show_bug.cgi?id=779926
> > ___
> > 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] Find not working on multi-currency transactions.

[Geert Janssens]

Op donderdag 2 februari 2023 08:56:29 CET schreef Dr. David Kirkby:
> I found what I feel is a bug - see attachment. It's basically the same as
> 
> https://bugs.gnucash.org/show_bug.cgi?id=779888
> 
> reported by Christopher Lam, and marked as fixed. But I don't think it is
> fixed, so I added a comment.
> 
So did I to explain why you experience what you describe. In short I think you 
want to find 
by amount, not by value.

> There's a link to another bug on that bug, but the link points to nowhere
> useful.
> 
That's a leftover from when we tracked our bugs on bugzilla.gnome.org. The new 
url is this
https://bugzilla.gnome.org/show_bug.cgi?id=779926[1]

Regards,

Geert


[1] https://bugzilla.gnome.org/show_bug.cgi?id=779926
___
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] Is there any way to find all outstanding bills?

[Geert Janssens]

Most likely you have created payments and bills independently of each other and 
never 
linked them. In that case your balances show 0, but the gnucash business logic 
doesn't know 
the bill is actually paid.

There are a few ways to solve this. I propose to try this:
* Open Business->Vendor->Process Payment...
* Select the vendor that's listed in your payable ageing as having unpaid bills.
* Select the proper "Post To" account. It should be different depending on the 
currency of 
the outstanding bills.

=> This should show a list of pre-payments and bills in the documents view that 
haven't been 
considered as processed by the business logic.

* Use shift-click or ctrl-click to select one or more payments and bills that 
should be linked 
together.

=> If the payments and bills balance, the payment and refund fields should both 
be 0 and 
the "Transfer Account" list greyed out.

* Click the Ok button to complete linking the bill(s) and payment(s).

* Repeat for each of the vendors that appear to have unpaid bills.

Hope that helps,

Geert

Op dinsdag 24 januari 2023 03:39:02 CET schreef Dr. David Kirkby:
> On Tue, 24 Jan 2023 at 01:50, Murugan Muruganandam <
> 
> m.muruganan...@hotmail.com> wrote:
> > have you tried looking at the Payable ageing report
> > 
> > 
> > Saludos Cordiales
> > 
> > 
> > Murugan
> 
> No, I had not, and that seems to have what I wanted. I'm just a bit puzzled
> that some of the figures don't make sense. If I look at Accounts Payable,
> which is in GBP, the data seems correct - I owe RS £210.41.
> 
> Accounts Payable for USD and HKD are both zero, but the report indicates
> monies are owed. But when I click on the vendors, it shows nothing owed.
> When I click on the bills, it shows these are paid.
> 
> These seem to have a pre-payment on these couple of transactions. I assume
> I have done something wrong with these transactions, It's a lot more
> complicated dealing with payments in another currency. I assume this means
> there's a good chance reports I generate will be wrong. One of the amounts
> (USD amount) is very small, but the one in HKD is not so small.
> 
> BTW, I was in the pub a couple of weeks ago, and somehow got chatting to a
> chartered accountant. I was telling him about issues when invoicing people
> in USD or Euros (my native currency is GBP). He said that I should not be
> billing people in anything other than GBP. I asked him whether he thought I
> was breaking the law in invoicing in USD and Euros, and he said that* in
> his opinion, it is against the law for me to invoice customers in anything
> other than GBP*. My accountant has never had a problem with this, but it
> obviously caused me to research it more. Our government website clearly
> states we can invoice in any currency. The only requirement is that if VAT
> is payable, then that amount needs to be in GBP. But it would be quite rare
> to invoice someone in USD if they are in the UK.
> 
> I'm pretty sure this guy in the pub was wrong, despite him saying he was a
> chartered accountant. From our own government website.
> 
> https://www.gov.uk/guidance/foreign-currency-transactions-vat-and-tour-opera
> tors
> 
> *You can invoice in any currency for the goods and services that 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] [SOLVED] Report charts are empty on fresh 4.8 install

[Geert Janssens]

Op vrijdag 20 januari 2023 07:35:58 CET schreef Jason Spencer:
> Following this thread
> , I
> noticed I still had old schemas in /usr/local/share/glib-2.0/schemas from
> maybe two versions ago (and maybe a flatpak version at that.) There was
> nothing in that folder except gnucash schemas from 2 years ago, so I
> removed the whole thing. Now 4.8 runs fine, charts show up, and I see that
> you *didn't* in fact re-style the register background :)
> 
> Thanks, John--then and now.
> 
> BTW, if this seems dangerous and I should re-compile these older schemas
> for some reason, please let me know the steps to follow. I don't really
> understand the details here.
> 
Glad you got it sorted.

There is indeed a known issue with gnucash 4.8 to 4.12 wrt to the settings 
(stored in 
gsettings). It is usually triggered by other schema files in 
/usr/local/share/glib-2.0/schemas 
(though there may be other triggers we didn't encounter yet). It doesn't matter 
whether 
these schema files are from gnucash or another application.

As there were only gnucash related schema files there, just manually removing 
them is fine. 

Lastly and for your information, they won't be from flatpak gnucash. flatpak 
would store 
them in an isolated directory under /home/janssege/.local/share/flatpak/app/ or 
/var/lib/
flatpak/app/.

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] GnuCash 4.900 Released

[Geert Janssens]

Op zaterdag 14 januari 2023 00:23:21 CET schreef Fred Tydeman:
> On Fri, Jan 13, 2023 at 3:00 PM David H  wrote:
> > Yeah seems to be a typo which will cause the remote-add to fail if you
> > already have the flathub repository installed as follows:-
> > 
> > Wiki says - flatpak remote-add --user --if-not-exists *flathub*
> > https://flathub.org/beta-repo/flathub-beta.flatpakrepo
> > Should be - flatpak remote-add --user --if-not-exists *flathub-beta*
> > https://flathub.org/beta-repo/flathub-beta.flatpakrepo
> 
> Thanks.  That fix lets me get farther.
> I have done a fresh install of Fedora 37 with Gnome 43.2 on Intel 64-bit
> CPU.
> When I try to install the beta, I get an error saying that beta requires
> runtime org.gnome.Platform/x86_64/43
> Is there some way to force the beta to use the system wide Gnome?

No, you can't. Runtimes are a fundamental base concept of flatpaks (and snaps 
or 
appimages by the way) and you can't avoid them.

These runtimes ensure that there's a known common set of libraries available on 
the system 
for the flatpak application to depend on, regardless of the state of the base 
system. Aside 
from allowing the application to install on systems that don't have the proper 
base system, it 
also eliminates a whole host of compatibility issues early on in the 
development process. 
Issues that otherwise have to be solved by distribution maintainers when they 
package the 
applications for the regular packaging system of said distro.

Personally I think both systems (flatpaks vs distro packages) have their own 
distinct 
advantages and disadvantages. And I think both have their place. However in 
this particular 
scenario - distributing beta software for testing - I believe the isolation is 
actually a big 
advantage.

So if you want to install the (beta) gnucash flatpak on your system you will 
also have to 
accept to install the required gnome runtime for it.

If this is a hurdle for you, consider you can also only install it for as long 
as you want to beta 
test gnucash. You can easily remove this runtime together with the gnucash beta 
flatpak 
when you're done testing with the "flatpak uninstall" command.

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] Trying to build 4.13 on Ubuntu 22.10 with Ninja

[Geert Janssens]

There's a good chance this issue arises if you try to build gnucash on a system 
that already 
has an older version of gnucash installed via the system's package manager.

Regards,

Geert

Op woensdag 11 januari 2023 04:53:10 CET schreef Michoel via gnucash-user:
> Im trying to install  4.13 on Ubuntu 22.10 with Ninja, but I am running into
> this error which I have tried to find an answer to, but to no avail:
> 
> ninja
> [1/495] Generating
> ../../lib/x86_64-li.../site-ccache/tests/unittest-support.go FAILED:
> lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/unittest-support.go
> /home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/u
> nittest-support.go cd /home/papa/gnucash-build/common/test-core &&
> /usr/bin/cmake -E env
> LD_LIBRARY_PATH=/home/papa/gnucash-build/lib:/home/papa/gnucash-build/lib/g
> nucash: GNC_UNINSTALLED=YES GNC_BUILDDIR=/home/papa/gnucash-build
> GUILE_LOAD_PATH=/home/papa/Desktop/gnucash-4.13/common/test-core:/home/papa
> /gnucash-build/common/test-core:/home/papa/gnucash-build/common/test-core/de
> precated:/home/papa/gnucash-build/share/guile/site/3.0
> GUILE_LOAD_COMPILED_PATH=/home/papa/gnucash-build/common/test-core:/home/pa
> pa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache:/home/papa/gnuca
> sh-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/gnucash/deprecated
> GNC_MODULE_PATH=/home/papa/gnucash-build/lib:/home/papa/gnucash-build/lib/g
> nucash: /usr/bin/guile -e "(@@ (guild) main)" -s /usr/bin/guild compile -o
> /home/papa/gnucash-build/lib/x86_64-linux-gnu/guile/3.0/site-ccache/tests/u
> nittest-support.go
> /home/papa/Desktop/gnucash-4.13/common/test-core/unittest-support.scm
> Backtrace:
> In /usr/bin/guild:
> 72:17 19 (main _)
> In srfi/srfi-1.scm:
> 634:9 18 (for-each # …)
> In scripts/compile.scm:
>279:27 17 (_ _)
> In system/base/target.scm:
>  65:6 16 (with-target _ _)
> In system/base/compile.scm:
> 187:6 15 (compile-file "/home/papa/Desktop/gnucash-4.13/common/…" …)
>  53:4 14 (call-with-output-file/atomic _ _ _)
> In ice-9/boot-9.scm:
>   1752:10 13 (with-exception-handler _ _ #:unwind? _ # _)
> In system/base/compile.scm:
> 69:11 12 (_)
>190:11 11 (_ #)
>331:39 10 (read-and-compile # # _ …)
>261:27  9 (_ _ _)
> In ice-9/boot-9.scm:
>2836:4  8 (save-module-excursion #)
> In language/scheme/compile-tree-il.scm:
> 31:16  7 (_)
> In ice-9/psyntax.scm:
>   1218:36  6 (expand-top-sequence (#) …)
>   1210:19  5 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
>259:10  4 (parse _ (("placeholder" placeholder)) ((top) #(# # …)) …)
> In unknown file:
>3 (load-extension "libtest-core-guile" "scm_init_unittest…")
> In system/foreign-library.scm:
>190:25  2 (load-foreign-library _ #:extensions _ # _ #:search-path …)
> In unknown file:
>1 (dlopen "libtest-core-guile.so" 1)
> In ice-9/boot-9.scm:
>   1685:16  0 (raise-exception _ #:continuable? _)
> 
> ice-9/boot-9.scm:1685:16: In procedure raise-exception:
> In procedure dlopen: file "libtest-core-guile.so", message
> "libtest-core-guile.so: cannot open shared object file: No such file or
> directory" [10/495] Building C object
> gnucash/gno...nc-gnome.dir/Debug/gnc-budget-view.c.o
___
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] Deleting Transaction from Reconcile Deletes Wrong Transaction

[Geert Janssens]

Op vrijdag 30 december 2022 15:47:35 CET schreef Thomas Forrester:
(snip)
> I use database storage over the XML storage method because it does afford
> me opportunities that the XML plain text file does not.  I now have data
> going back seven years in GnuCash and I think that's too much to push on a
> text file.  At some point the scales tip in favor of a
> full-fledged database over text file read/write operations.

I haven't followed the rest of this thread, but this paragraph caught my eye...

The way gnucash works the storage method hardly has any impact on performance. 
In all 
cases the whole data set is loaded completely into memory when the data set is 
opened (be 
it an xml file or a database backend). And all work is performed purely in 
memory.

The major difference is that with a database backend, any change you make is 
immediately 
written to the db right after the model in memory has been altered. With the 
xml backend, 
changes are written to the xml file only on explicit save, or at the autosave 
interval (if set).

So the load and save experiences may be slightly different (last time I was 
involved in this the 
initial db load was slower than the xml load, but saving to xml takes more time 
as it has to 
write everything at once, yet that is not done as frequently as saving each 
atomic change to 
db directly...)

But for both the db or xml storage, after the initial read, the data is never 
read again from 
the storage and gnucash will only work with what's in memory.

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] Settings not respected

[Geert Janssens]

Op dinsdag 27 december 2022 17:25:42 CET schreef Jeff:
> On 27/12/2022 16:21, Geert Janssens wrote:
> > Is there a way to get gnucash 4.13 installed on your system (and not via 
> > flatpak ?) That would be another useful test.
> 
> 
> I just built a deb for 4.13 and indeed the problem is fixed.
> 
> Thanks for your help.
> 
Great!

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] Settings not respected

[Geert Janssens]

Op dinsdag 27 december 2022 14:27:33 CET schreef Jeff:
> On 27/12/2022 13:30, Geert Janssens wrote:
> 
> > I'm not sure what the typical paths on Debian are, but on Fedora the 
> > schemas for system packages end up in
> > 
> > /usr/share/glib-2.0/schemas/
> > 
> > While locally built schemas typically end up in
> > 
> > /usr/local/share/glib-2.0/schemas/
> > 
> > 
> > If there are schema files in both locations (not necessarily gnucash 
> > related), a gnucash installed from a deb package will not find its 
> > schema files in the former location and hence settings will not work.
> 
> 
> The first path has lots of xml-files and a few others.
> 
Can you post the output of
cd /usr/share/glib-2.0/schemas
stat -c'%w %n' org.gnucash.* gschemas.compiled

> The second path does not exist.
> 
> echo $XDG_DATA_DIRS
> 
> gives:
> 
> /usr/share/gnome:/usr/local/share/:/usr/share/
> 

GnuCash can manipulate the contents of XDG_DATA_DIRS at startup. To figure out 
the exact 
value GnuCash sees, you can create a 
file named "config-user.scm" in $HOME/.config/gnucash
with this contents:
(use-modules (gnucash utilities)) 
(gnc:warn "XDG_DATA_DIRS=" (getenv "XDG_DATA_DIRS"))

The next time you start gnucash it will print the value of XDG_DATA_DIRS in the 
gnucash.trace file somewhere. Can you look for this and check whether there's 
another 
directory on the path that has a non-empty glib-2.0/schemas subdirectory ?

> But there isn't a glib-2.0 directory in /usr/share/gnome, either.
> 

Considering both dconf-editor and the gsettings command line tool show the 
proper value, 
to me this is still most likely a variation of
https://bugs.gnucash.org/show_bug.cgi?id=798672[1]

If there's no clear hint in the above, can you post the full gnucash.trace 
contents here, or at 
least up until the first gsettings schema error you get ?

Is there a way to get gnucash 4.13 installed on your system (and not via 
flatpak ?) That would 
be another useful test.

Regards,

Geert


[1] https://bugs.gnucash.org/show_bug.cgi?id=798672
___
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] Settings not respected

[Geert Janssens]

Hi,

There is a bug ins gnucash 4.12 and earlier in which settings may not be 
retrieved/set when 
there is more than one path on your system with gsettings schemas.

I'm not sure what the typical paths on Debian are, but on Fedora the schemas 
for system 
packages end up in
/usr/share/glib-2.0/schemas/
While locally built schemas typically end up in 
/usr/local/share/glib-2.0/schemas/

If there are schema files in both locations (not necessarily gnucash related), 
a gnucash 
installed from a deb package will not find its schema files in the former 
location and hence 
settings will not work.

Typically you'd have plenty of errors or warnings about this in the 
gnucash.trace file (which 
John suggested to check for).


This was fixed for gnucash 4.13 only. So perhaps you are suffering from this 
bug ?

Regards,

Geert

Op dinsdag 27 december 2022 08:45:30 CET schreef Jeff:
> On 26/12/2022 19:26, R Losey wrote:
> 
> > This is probably a dumb question, but do your preferences file still 
> > exist? And are they readable/writeable by you? And the permissions of 
> > the parent directory (or directories) haven't been changed?
> 
> 
> I've been trying to work out where the changes land.
> 
> 
> > When you make a small minor tweak to preferences, does the timestamp 
> > change on the preferences file?
> 
> 
> Edit/Preferences give the date format to be ISO. If I change it to, say, 
> UK and hit close, and then open the dialogue again, it is back to ISO.
> 
> When I open Edit/Preferences, I get
> 
> sys:1: Warning: g_hash_table_foreach: assertion 'hash_table != NULL' failed
> 
> on the command line, which I assume is then the problem.
> 
> Regards
> 
> Jeff

___
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] Problems upgrading to 4.8a

[Geert Janssens]

A bug (https://bugs.gnucash.org/show_bug.cgi?id=798672[1]) was opened reporting 
this 
same issue, which prompted me to look at it again.

I think I have found the cause of the issue this time and added a fix to our 
source code. It 
should be fixed for gnucash 4.13. If you can build for yourself from source, 
you could 
apply this minor change:
https://github.com/Gnucash/gnucash/commit/
98251d59a6e6940efae2001a1e619c08828c8738[2]

Otherwise, you can monitor the bugs on the Ubuntu bug tracker (which the 
original poster 
added to our own bug report mentioned above) and/or poke the package 
maintainers to 
apply the fix earlier.

Regards,

Geert

Op dinsdag 11 oktober 2022 21:29:12 CET schreef Phil Wolff:
> On 10/10/22 12:14, Geert Janssens wrote:
> 
> 
> Phil,
> 
> 
> 
> 
> I'm sorry I stopped responding on this thread. I ran out of time and also
> out of things to suggest. This is the first time I have ever seen the
> situation where dconf-editor and gsettings (cli tool) work fine and gnucash
> doesn't.
> 
> 
> 
> 
> So far gsettings issues have always been the result of missing schema files
> or an old set being found before the proper ones.
> 
> 
> 
> 
> So the only clue left for now is to figure out exactly which schema folders
> gnucash checks. That's why I was looking for a way to print the contents of
> variable XDG_DATA_DIRS gnucash sees while starting.
> 
> 
> 
> 
> Do you still have the file
> 
> $HOME/.config/gnucash/config-user.scm
> 
> With the contents to print XDG__DATA_DIRS ?
> 
> Welcome back!! Yes, I still have it.
> 
> 
> 
> 
> If so, can you run gnucash from the command line as follows:
> 
> 
> 
> 
> gnucash --no-file --logto stderr
> 
> 
> 
> 
> And post the result that's printed in the terminal here ?
> 
> I ran it, and got a long dump of error messages (below). The first few lines
> confirm that /usr/share/glib-2.0/schemas/gschemas.compiled is not being
___
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] Reusing old invoices?

[Geert Janssens]

Op vrijdag 18 november 2022 16:54:01 CET schreef Morgan Read via gnucash-user:
> Hi Adrian,
> 
> 
> > I recall an issue not long ago with an uneditable, unposted invoice. 
> > I'll check to see if I resolved it and if so, how. (this was an issue 
> > with the line-items, the details were editable)
> 
> Yes, those are my symptoms - on one particular invoice the line-items 
> are uneditable whereas the details are editable.  Any pointers would be 
> great, thanks.

Is this an invoice tab you keep permanently open across gnucash restarts ? In 
rare cases this 
may lead to gnucash becoming confused on the posted status of the invoice, 
which could 
lead to the symptoms you see.

You can try to close the invoice tab and use any the common methods to reopen 
it (Business-
>Customer->Find Invoice..., clicking on an invoice link in some report,...). 
>That should fix the 
gnucash confusion.

If it's still not editable at that point, something else may be happening.

> > You should be able to simply renumber the Note/Invoice to avoid 
> > duplication confusion.
> 
> Yes, but then I've found that the numbering goes out - that is, the 
> auto-numbering creates invoices with a number that was created last time 
> (iirc) and so duplicates...

If you manually (had to) set the number on an invoice, you can afterwards 
update the invoice 
counter under File->Properties->Counters so the the next invoice will have the 
right number 
assigned automatically again.

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] Create New Gnucash File From Old One

[Geert Janssens]

Op woensdag 9 november 2022 20:45:34 CET schreef Joseph Hesse:
> On 11/9/22 02:55, Geert Janssens wrote:
> > Hi Joe,
> > 
> > 
> > In order to help you, can you describe exactly what you have tried and
> > what went wrong ?
> > 
> > 
> > Regards,
> > 
> > 
> > Geert
> 
> Thank you for your reply.
> 
> Here is what I have done.
> 
> I used "File -> Export Account Tree to CSV" to create a CSV file which I
> then imported into a new file. The new file is the same as the old one I
> exported from but it has no transactions.  This is what I expected.
> 
> I then opened the old file and did "File -> Export Transactions to
> CSV".  I chose the single account I wanted to export and got my exported
> CSV file.  Although not necessary, I opened the CSV with LibreOffice
> Calc to verify I had the desired transactions.
> 
> I next opened the new file with no transactions and did "File -> Import
> Transactions from CSV".  On the Import Preview Screen I chose GnuCash
> Export Format and changed the date format to mdy.  Doing this allowed me
> to go to the next screen.  At this point I am stuck.  I am supposed to
> Match Import and GnuCash accounts but no amount of trial and error
> allowed me to go to the next screen.  How do I proceed?
> 
On that screen you have to create a mapping between the names of the accounts 
as they 
appear in the csv file and the accounts in your empty gnucash book.

There are two columns in that page. The first holds the names of accounts as 
found in the 
csv file. In the second column you have to add matching names from your list of 
accounts for 
each line that has "No linked account" in that column. You can alter the cells 
of the second 
column by double-clicking a line, or by selecting a line and then clicking on 
the button at the 
bottom right.

Once there's a matching account from your book next to each account from the 
csv file you 
should be able to proceed.

Note that for your particular use case this is a bit cumbersome as the names of 
your 
accounts match exactly with the names in the csv files. But gnucash can't know 
that for sure 
in all situations, hence it asks. It will remember your selections for future 
imports though.

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] Create New Gnucash File From Old One

[Geert Janssens]

Hi Joe,

In order to help you, can you describe exactly what you have tried and what 
went wrong ?

Regards,

Geert

Op dinsdag 8 november 2022 13:35:55 CET schreef Joseph Hesse:
> On 11/7/22 15:59, Derek Atkins wrote:
> > Hi,
> > 
> > On Mon, November 7, 2022 1:49 pm, Joseph Hesse wrote:
> >> Hello,
> >> 
> >> Here is what I want to accomplish.
> >> 
> >> 1. Create a new gnucash file with the same accounts as an old one but no
> >> transactions from the old one.
> >> 2. Copy the transactions from a single account from the old gnu cash
> >> file to the new one.
> >> 
> >> I can accomplish 1. by exporting the account tree from the old one to a
> >> csv file and then importing the csv file to the new one.
> > 
> > There is an even easier way:  File -> Export -> Export Accounts
> > This will create a new data file with just the account tree, so all you
> > need to do is File -> Open the "exported" file.
> > 
> >> I tried to accomplish 2. by exporting the transactions from the desired
> >> account on the old file to a csv file and then import the csv to the the
> >> new file.  I can export the transactions but no amount of fiddling or
> >> trying options allows me to successfully import the csv file.
> > 
> > What version of GnuCash?  I *THOUGHT* that we fixed the issue where
> > exported data could not be imported.
> > 
> >> Any help you can give me would be appreciated.
> >> 
> >> Thank you,
> >> Joe Hesse
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > 
> > -derek
> 
> Derek,
> 
> Thank you for your reply.
> 
> I had no problem creating a new gnucash file with the same accounts as
> the old one but  with no transactions.
> 
> My problem is when I "File->Export Transactions to CSV" and choose a
> single account to export, I can not successfully import this account.  I
> am using gnucash 4.12 on Fedora 36 linux.
> 
> Joe
> 
> 
> ___
> 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] 4.12 ERROR: In procedure scm-error: no code for module (gnucash utilities)

[Geert Janssens]

Op dinsdag 25 oktober 2022 14:02:28 CEST schreef Derek Atkins:
> Hi,
> 
> I do not see a "make install" in here.
> 
> You cannot run GnuCash from the build tree, you need to install it to run
> it.
> 
That's actually no longer the case. With the switch to cmake the build system 
has also been 
transformed to be able to run GnuCash from the build tree.

In fact I do this all the time.

As for the original issue: do you have another gnucash installed somewhere ? Or 
do you 
have cached *.go files under 
$HOME/.cache/guile/ccache//$HOME/Applications/
You may want to remove these just in case they are interfering. There's no 
risk, they are just 
cache files and will be recreated if needed.

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] [GNC-dev] ANNOUNCE: Updated GnuCash with Finance::Quote 1.53 available on Flathub

[Geert Janssens]

Hi David,

I have just tried again on my system and I don't get that error. Perhaps there 
was a 
download glitch ? Have you tried again some time later ?

Regards,

Geert

Op maandag 17 oktober 2022 02:56:10 CEST schreef David H:
> Hi Geert,
> 
> Thanks for the update, it's appreciated.  Unfortunately I'm getting the
> following checksum error when trying to update :
> 
> 1. [✗] org.gnucash.GnuCash  stable  u  flathub
> 2.7 MB / 110.1 MB
> 
> Error: While pulling app/org.gnucash.GnuCash/x86_64/stable from remote
> flathub: opcode close: Corrupted file object; checksum
> expected='72a432ec6003270f7b3ff6a60dc9112743006c41e63019d457e1fdad963ed0d9'
> actual='3e6e3dd99408f9a5cfc78d1d1c77e2fbaf7ae282f1a6f220f05c6ff7d878a1a1'
> Updates complete.
> error: There were one or more errors
> 
> Cheers David H.
> 
> 
> On Mon, 17 Oct 2022 at 05:19, Geert Janssens 
> 
> wrote:
> > We have updated the GnuCash package on flathub to
> > include Finance::Quote 1.53.
> > 
> > The new flatpak is released as version 4.12-1.
> > 
> > Update the org.gnucash.GnuCash flatpak via your
> > distribution's package manager or by runing 'flatpak --
> > update org.gnucash.GnuCash' on the command line.
> > ___
> > gnucash-devel mailing list
> > gnucash-de...@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> 
> ___
> 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] Problems upgrading to 4.8a

[Geert Janssens]

Phil,

I'm sorry I stopped responding on this thread. I ran out of time and also out 
of things to 
suggest. This is the first time I have ever seen the situation where 
dconf-editor and gsettings 
(cli tool) work fine and gnucash doesn't.

So far gsettings issues have always been the result of missing schema files or 
an old set 
being found before the proper ones.

So the only clue left for now is to figure out exactly which schema folders 
gnucash checks. 
That's why I was looking for a way to print the contents of variable 
XDG_DATA_DIRS gnucash 
sees while starting.

Do you still have the file
$HOME/.config/gnucash/config-user.scm
With the contents to print XDG__DATA_DIRS ?

If so, can you run gnucash from the command line as follows:

gnucash --no-file --logto stderr

And post the result that's printed in the terminal here ?

Regards,

Geert

Op maandag 12 september 2022 14:49:18 CEST schreef Phil Wolff:
> On 9/11/22 13:02, Geert Janssens wrote:
> 
> Op zaterdag 10 september 2022 19:49:52 CEST schreef Phil Wolff:
> > On 9/10/22 08:34, Geert Janssens wrote:
> > 
> > That is really odd and again suggesting your gnucash is not configured as
> > 
> > per default. We'll have to find out where this comes from...
> > 
> > 
> > 
> > Can you provide the result of commands
> > 
> > 
> > 
> > alias gnucash
> > 
> > type gnucash
> > 
> > ls -l $(type gnucash)
> > 
> > 
> > 
> > dellbert@dellbert:~$ alias gnucash
> > 
> > bash: alias: gnucash: not found
> > 
> > dellbert@dellbert:~$ type gnucash
> > 
> > gnucash is /usr/bin/gnucash
> > 
> > dellbert@dellbert:~$ ls -l $(type gnucash)
> > 
> > ls: cannot access 'gnucash': No such file or directory
> > 
> > ls: cannot access 'is': No such file or directory
> > 
> > -rwxr-xr-x 1 root root 142088 Feb  9  2022 /usr/bin/gnucash
> 
> Ok, these were to ensure our basic assumption is correct. You're effectively
> running /usr/bin/gnucash and not some alias or link to another location.
> > Also can you start gnucash once as follows:
> > 
> > 
___
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] Ubuntu: Documentation not working

[Geert Janssens]

Op zaterdag 8 oktober 2022 09:33:05 CEST schreef R Losey:
> When I installed GnuCash in Ubuntu, it seemed to install everything -- the
> price quote program as well as the documentation... however, when I run
> GnuCash, it won't find the documentation and speculates that it is not
> installed (but it is). I can take my browser to
> /usr/share/docs/gnucash-docs/gnucash-guide-en/index.html, and everything
> looks fine.
> 
> Is there some environment variable I need to set? It would be nice to have
> the "Help" buttons actually work.

Ubuntu ships our documentation in the wrong format and in the wrong location.

GnuCash expects to find the documentation in docbook format and located in
/usr/share/help.

What you have found in /usr/share/docs is the html formatted version of our 
documentation. That's only meant for general consumption via a browser, not via 
gnucash 
(on linux). It was never even intended to be distributed via linux 
distributions, though 
distributions are free to do so. It's just not the format gnucash itself 
expects to present to 
you.

This is a bug that was already in the upstream Debian distribution.

Meanwhile is has been fixed there. I'm not sure what's needed to get the fix in 
Ubuntu. 
Probably a bug report in the Ubuntu bug tracker ?


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] Gnucash invoicing and payment - questions on process

[Geert Janssens]

Op donderdag 6 oktober 2022 23:57:45 CEST schreef Adrien Monteleone:
> On 10/6/22 1:59 PM, Charles Vincent wrote:
> > Hello Gnucash users list members,
> > I come back on the issue of invoicing clients and payment by the clients
> > or
> > a third party.
> > 
> > As background:
> > For info, I am keeping the accounts for a small not for profit school in
> > Cambodia.
> > I have done the 70 invoices, one for each child, using a standard
> > accounting layout: R1 income school fees, R2 income registration, R3
> > income
> > extracurricular, etc etc..
> > So far so good.
> > I post the invoices, still good.
> > The invoices show up in  an accounts receivable STUDENT INVOICES as I
> > believe they should. If so, so far so very good.
> 
> Just to be clear - GnuCash can have *only 1* account of 'type' Accounts
> Receivable (same for Payables) and that is the account used by the
> Business Features. (invoicing, payments, customers, vendors, etc.)
> 
That's not a GnuCash restriction. You can have multiple. If you create multiple 
however, that 
complicates processing and some report are limited to displaying only one 
account at the 
time. A potential use case is to have one AR account per currency in which you 
write invoices. 
Though I believe it to be better to keep your AR account(s) in your book's 
currency generally.

> I don't know if you can rename that account.

You can rename it. Only trading accounts are picky about their names (or did we 
fix that 
already?)

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] Problems upgrading to 4.8a

[Geert Janssens]

Op zaterdag 10 september 2022 19:49:52 CEST schreef Phil Wolff:
> On 9/10/22 08:34, Geert Janssens wrote:
> That is really odd and again suggesting your gnucash is not configured as
> per default. We'll have to find out where this comes from...
> 
> Can you provide the result of commands
> 
> alias gnucash
> type gnucash
> ls -l $(type gnucash)
> 
> dellbert@dellbert:~$ alias gnucash
> bash: alias: gnucash: not found
> dellbert@dellbert:~$ type gnucash
> gnucash is /usr/bin/gnucash
> dellbert@dellbert:~$ ls -l $(type gnucash)
> ls: cannot access 'gnucash': No such file or directory
> ls: cannot access 'is': No such file or directory
> -rwxr-xr-x 1 root root 142088 Feb  9  2022 /usr/bin/gnucash
> 

Ok, these were to ensure our basic assumption is correct. You're effectively 
running /usr/bin/
gnucash and not some alias or link to another location.

> Also can you start gnucash once as follows:
> 
> gnucash --log "gnc.app-utils=debug"
> 
> You can leave out the name to your data file. It will reduce the amount of
> messages in the trace file.
> 
> After having run, can you filter the trace file for messages coming from
> gnc.app-utils and post them here?
> 
> That's a way to find out where gnucash looks for the config-user.scm file...
> 
> Filtering reduced line count from 943 to 815 
> 

I'm sorry about that. I could have asked to filter more aggressively (but it 
was very late here 
when I wrote my last mail). This is the info I was looking for:

> [gfec_try_load] looking for /etc/gnucash/config * 09:00:08 DEBUG
> 
> 
> [gfec_try_load] looking for /home/dellbert/.config/gnucash/config-user.scm
> * 09:00:08 DEBUG
> 
> 
> [gfec_try_load] trying to load
> /home/dellbert/.config/gnucash/config-user.scm * 09:00:08 DEBUG
>   
> 

These lines show that the config-user.scm file is found. No idea why this 
wouldn't print the 
value of XDG_DATA_DIRS to your gnucash trace file. But if needed we can debug 
that later. 
Let's first follow the other possible clue below.



> 
> As these early queries fail, no migration is started. And in general
> considering most queries fail, I think no preferences are ever kept across
> gnucash restarts. You could experiment with this by setting a preference to
> non-default in gnucash. Restart gnucash and check the preference again ?
> 
> I've done that - any changes I make are lost on a restart.
> 

Ok, that confirms gnucash has an issue with finding settings schemas in some 
way.

> And if so can you use the 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] More UI downgrades

[Geert Janssens]

Op zondag 11 september 2022 02:22:34 CEST schreef Geoff:
> In the reconciliation window, as you observed, SPACE will select /
> deselect the current transaction, but not move to the next transaction.
>   As Gyle mentioned, using Ctrl-A and SPACE makes for a very speedy
> reconciliation.
> 

All common keyboard selection methods are available in these lists.
Besides Ctrl-A to select all, perhaps using Shift-ArrowDown can also be useful 
to select 
a multiple splits (each Shift-ArrowDown will add one split to the selection) 
and then 
press SPACE to mark those as reconciled.

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] Problems upgrading to 4.8a

[Geert Janssens]

Op zaterdag 10 september 2022 16:36:03 CEST schreef Phil Wolff:
> On 9/9/22 16:14, Geert Janssens wrote:
> 
> Op vrijdag 9 september 2022 22:19:08 CEST schreef Phil Wolff:
> > dellbert@dellbert:~$ gsettings get org.gnucash.GnuCash.general.register
> > 
> > double-line-mode true
> > 
> > dellbert@dellbert:~$
> > 
> > 
> > 
> > But when I run gnucash all of my registers are single-line.
> 
> The only explanation I can come up with is that gnucash runs in a different
> environment than gsettings.
> 
> 
> 
> 
> How do you start gnucash exactly ? From the command line or from the Ubuntu
> menus ?
> 
> I start by clicking on a Desktop icon. If I use the .desktop file from the
> package manager installation which contains the line "Exec=gnucash %f," I
> get a window titled "Unsaved Book - GnuCash" and I have to use File/Open to
> access my data file, so instead I use a copy of the .desktop file with the
> modified line "Exec=gnucash
> /home/dellbert/Documents/gnucash/Household.db.gnucash" to open the data
> file directly.
> 
> 
> 
> 
> 
> And to test for the most relevant environment variable wrt to settings, can
> you add create a file named "config-user.scm" in $HOME/.config/gnucash
> 
> with this contents:
> 
> (use-modules (gnucash utilities)) 
> (gnc:warn "XDG__DATA_DIRS=" (getenv "XDG_DATA_DIRS"))
> 
> The next time you run gnucash this will add a line at the top of your
> gnucash.trace file showing the value of environment variable
> "XDG_DATA_DIRS".
> 
> dellbert@dellbert:~$ cat ~/.config/gnucash/config-user.scm
> (use-modules (gnucash utilities))
> (gnc:warn "XDG__DATA_DIRS=" (getenv "XDG_DATA_DIRS"))
> dellbert@dellbert:~$ cat /tmp/gnucash.trace
> cat: /tmp/gnucash.trace: No such file or directory
> 
> < run gnucash >
> 
> dellbert@dellbert:~$ cat /tmp/gnucash.trace
> * 11:14:57 ERROR  g_settings_new_full: assertion 'schema != NULL'
> failed * 11:14:57  WARN 
> [gnc_gsettings_get_settings_ptr()] Ignoring attempt to access unknown
> gsettings schema org.gnucash.GnuCash.general * 11:14:57 ERROR
>  GVariant* gnc_gsettings_get_user_value(const gchar*, const
> gchar*): assertion 'G_IS_SETTINGS (settings_ptr)' failed * 11:14:57 ERROR
>  g_settings_new_full: assertion 'schema != NULL' failed *
> 11:14:57  WARN  [gnc_gsettings_get_settings_ptr()]
> Ignoring attempt to access unknown gsettings schema org.gnucash.general *
> 11:14:57 ERROR  GVariant* gnc_gsettings_get_user_value(const
> gchar*, const gchar*): assertion 'G_IS_SETTINGS (settings_ptr)' failed
> 14:57  WARN  [gnc_gsettings_get_settings_ptr()]
> Ignoring attempt to access unknown gsettings schema org.gnucash.general
> 
> 
> *
___
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] Problems upgrading to 4.8a

[Geert Janssens]

Op vrijdag 9 september 2022 22:19:08 CEST schreef Phil Wolff:
> dellbert@dellbert:~$ gsettings get org.gnucash.GnuCash.general.register
> double-line-mode true
> dellbert@dellbert:~$
> 
> But when I run gnucash all of my registers are single-line.
> 
> 
The only explanation I can come up with is that gnucash runs in a different 
environment 
than gsettings.

How do you start gnucash exactly ? From the command line or from the Ubuntu 
menus ?

And to test for the most relevant environment variable wrt to settings, can you 
add create a 
file named "config-user.scm" in $HOME/.config/gnucash
with this contents:
(use-modules (gnucash utilities)) 
(gnc:warn "XDG__DATA_DIRS=" (getenv "XDG_DATA_DIRS"))

The next time you run gnucash this will add a line at the top of your 
gnucash.trace file 
showing the value of environment variable "XDG_DATA_DIRS".

I'd like to know what this is. And can you compare it to what XDG_DATA_DIRS is 
set to in your 
terminal ?

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] Problems upgrading to 4.8a

[Geert Janssens]

Weird, my answer got stripped from the mail as it returned from the mailing 
list... I'll send 
again below for reference.

Geert

Op vrijdag 9 september 2022 17:23:36 CEST schreef Phil Wolff:
> Schema files should be compiled at install time before gnucash can use them.
> That's more or less the answer to your question whether they should be
> created at install time. Perhaps this went wrong for some reason.
> 
> 
> 
> 
> Can you run the following command to test this?
> 
> strings /usr/share/glib-2.0/schemas/gschemas.compiled | grep
> org.gnucash.general
> 
> 
> 
> 
> Just post the output here.
> 
> 
> 
> dellbert@dellbert:/usr/local/share/glib-2.0/schemas$ strings
> /usr/share/glib-2.0/schemas/gschemas.compiled | grep org.gnucash.general
> (())org.gnucash.general.report
> /org/gnucash/general/report/
> org.gnucash.general.report.pdf-export
> org.gnucash.general
> org.gnucash.general.report
> org.gnucash.general.register
> /org/gnucash/general/
> (i)org.gnucash.general.finance-quote
> /org/gnucash/general/finance-quote/
> org.gnucash.general.register
> /org/gnucash/general/register/
> (s(yau))org.gnucash.general.report.pdf-export
> (s).path/org/gnucash/general/report/pdf-export/
> general/org.gnucash.general
> dellbert@dellbert:/usr/local/share/glib-2.0/schemas$
> 

The output is slightly different from mine, but that's not abnormal.


Another test would be to run
gsettings list-schemas | grep org.gnucash.general

gsettings is the interface gnucash uses to access the preferences, so contrary 
to dconf-editor 
this should use the same code internally as gnucash.


Does this command return the org.gnucash.general schema (together with a few 
others) ?


Lastly to verify if compilation was completely successful you can also run


sudo glib-compile-schemas --strict /usr/share/glib-2.0/schemas


And check the result for errors. If compilation didn't result in any errors you 
could recheck if 
gnucash now works without the GSettings warnings in gnucash.trace.


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] Problems upgrading to 4.8a

[Geert Janssens]

Op vrijdag 9 september 2022 17:23:36 CEST schreef Phil Wolff:
> On 9/9/22 07:49, Geert Janssens wrote:
> 
> 
> Hi Phill,
> 
> 
> 
> 
> I'm trying to remember how everything panned out exactly back when 4.8 was
> released. There was a critical issue with the preference migration causing
> gnucash to crash on startup in certain situations. This has been fixed in
> 4.8a, which is what you have installed.
> 
> 
> 
> 
> It is slightly odd that gnucash itself fails to load these schema files
> while dconf-editor sees them just fine. But I don't know the internals of
> dconf-editor so perhaps it uses a different method of scanning for schema
> files than gnucash does.
> 
> 
> 
> 
> As to your feedback:
> 
> The gschema files you have found are the correct ones and it's good the old
> ones are not present anywhere on the system.
> 
> 
> 
> 
> The list of missing gsettings schemas you report is probably not exhaustive.
> The warnings will only be emitted when the schema is queried. Not all
> preferences are queried at once at startup.
> 
> 
> 
> 
> What we can state is that the source files for these schema definitions are
> installed. That the list of gschema files you report.
> 
> It's worth to check if the missing schemas are actually defined in these
> source files. For exmple the schema "org.gnucash.general" should be found
> in
> 
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.deprecated.gschema.xml
> 
> Can you verify this ?
> 
> 
> 
> 
> Schema files should be compiled at install time before gnucash can use them.
> That's more or less the answer to your question whether they should be
> created at install time. Perhaps this went wrong for some reason.
> 
> 
> 
> 
> Can you run the following command to test this?
> 
> strings /usr/share/glib-2.0/schemas/gschemas.compiled | grep
> org.gnucash.general
> 
> 
> 
> 
> Just post the output here.
> 
> 
___
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] Problems upgrading to 4.8a

[Geert Janssens]

Hi Phill,

I'm trying to remember how everything panned out exactly back when 4.8 was 
released. 
There was a critical issue with the preference migration causing gnucash to 
crash on startup 
in certain situations. This has been fixed in 4.8a, which is what you have 
installed.

It is slightly odd that gnucash itself fails to load these schema files while 
dconf-editor sees 
them just fine. But I don't know the internals of dconf-editor so perhaps it 
uses a different 
method of scanning for schema files than gnucash does.

As to your feedback:
The gschema files you have found are the correct ones and it's good the old 
ones are not 
present anywhere on the system.

The list of missing gsettings schemas you report is probably not exhaustive. 
The warnings 
will only be emitted when the schema is queried. Not all preferences are 
queried at once at 
startup.

What we can state is that the source files for these schema definitions are 
installed. That the 
list of gschema files you report.
It's worth to check if the missing schemas are actually defined in these source 
files. For 
exmple the schema "org.gnucash.general" should be found in
/usr/share/glib-2.0/schemas/org.gnucash.GnuCash.deprecated.gschema.xml
Can you verify this ?

Schema files should be compiled at install time before gnucash can use them. 
That's more or 
less the answer to your question whether they should be created at install 
time. Perhaps this 
went wrong for some reason.

Can you run the following command to test this?
strings /usr/share/glib-2.0/schemas/gschemas.compiled | grep org.gnucash.general

Just post the output here.

Regards,

Geert


Op vrijdag 9 september 2022 16:12:46 CEST schreef Phil Wolff:
> On 9/8/22 13:28, Geert Janssens wrote:
> 
> Op woensdag 7 september 2022 21:54:17 CEST schreef Phil Wolff:
> > Geert ~
> > 
> > 
> > 
> > Before doing anything, I looked at the current trace file. Lots of WARNs
> > and
> > 
> > ERRORs like
> > 
> > 
> > 
> > * 12:03:55  WARN 
> > 
> > [gnc_gsettings_get_settings_ptr()] Ignoring attempt to access unknown
> > 
> > gsettings schema org.gnucash.GnuCash.general * 12:03:55 ERROR
> > 
> >  gboolean gnc_gsettings_get_bool(const gchar*, const
> > 
> > gchar*): assertion 'G_IS_SETTINGS (settings_ptr)' failed
> 
> This is probably the core of your problem. For some reason gnucash can't
> find the schema definitions for our preferences. If I remember correctly in
> most cases this is because it finds another location with the old schemas
> (starting with org.gnucash and no extra .GnuCash in the path). The most
> common candidate for this would be in /usr/local/share/glib-2.0/schemas/
> 
> Can you search your system for other such files ?
> 
___
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] Problems upgrading to 4.8a

[Geert Janssens]

Op woensdag 7 september 2022 23:06:50 CEST schreef Phil Wolff:
> /org/gnucash/GnuCash/general/prefs-version Use default value is set, Current
> value = Default value, Default = 0
> 
> If it matters, /org/gnucash/general/prefs-version Use default value is not
> set, Current value = 308
> 

Yes, considering gnucash can't find the proper schema files, it will also never 
change 
any preference. So the first one (using the new preference paths) is expected 
to be 
default still and the second one (using the old preference paths) is expected 
to be what 
your previous gnucash version set it to.

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] Problems upgrading to 4.8a

[Geert Janssens]

Op woensdag 7 september 2022 21:54:17 CEST schreef Phil Wolff:
> Geert ~
> 
> Before doing anything, I looked at the current trace file. Lots of WARNs and
> ERRORs like
> 
> * 12:03:55  WARN 
> [gnc_gsettings_get_settings_ptr()] Ignoring attempt to access unknown
> gsettings schema org.gnucash.GnuCash.general * 12:03:55 ERROR
>  gboolean gnc_gsettings_get_bool(const gchar*, const
> gchar*): assertion 'G_IS_SETTINGS (settings_ptr)' failed
> 

This is probably the core of your problem. For some reason gnucash can't find 
the schema 
definitions for our preferences. If I remember correctly in most cases this is 
because it finds 
another location with the old schemas (starting with org.gnucash and no extra 
.GnuCash in 
the path). The most common candidate for this would be in 
/usr/local/share/glib-2.0/
schemas/
Can you search your system for other such files ?

Regards,

Geert

> So I took a look for schema files:
> 
> dellbert@dellbert:~$ sudo find /  -xdev -name
> org.gnucash.GnuCash\*.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.business.gschema.xm
> l /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.totd.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.import.csv.gschema.
> xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.general.finance-quote.gsche
> ma.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.window.pages.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.warnings.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.history.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.reconcile.gschema.x
> ml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.export.csv.gschema.
> xml /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.deprecated.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.import.hbci.gschema
> .xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.flicker.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.checkprinting.gsche
> ma.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.import.generic.gsch
> ema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.commodities.gschema
> .xml /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.sxs.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.import.ofx.gschema.
> xml /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.gschema.xml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.dialogs.import.qif.gschema.x
> ml
> /usr/share/glib-2.0/schemas/org.gnucash.GnuCash.window.pages.account.tree.g
> schema.xml dellbert@dellbert:~$
> 
> 
> Should there be more?
> 
> Phil ~
> 
> 
> 
> On 9/7/22 11:59, Geert Janssens wrote:
> 
> 
> Hi Phil,
> 
> Op woensdag 7 september 2022 18:50:16 CEST schreef Phil Wolff:
> > > "Backup files" are autogenerated by gnucash and - as the name suggests -
___
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] Problems upgrading to 4.8a

[Geert Janssens]

Hi Phil,

Op woensdag 7 september 2022 18:50:16 CEST schreef Phil Wolff:
> > "Backup files" are autogenerated by gnucash and - as the name suggests -
> > contain backups of your accounting data. They are generated in the same
> > directory as your "Data file" and have as file name
> > 
> > ..gnucash
> 
> Don't see any of these

You may have disabled backup file generation.



> > "Saved reports" is a bit of an outlier. It is a single file that contains
> > all "Saved report configurations" you have created in gnucash. For
> > historical reasons this file is shared by all your "Data files". It is
> > found in GNC_DATA_HOME and is called saved-reports-
> 
> 3 files; -2.8,
> -2.8~ and -2.8-backup suffixes. If the 2.8 is the GNC version, that means
> that my recollection of seeing "1.something" in Synaptic is faulty.
> 

2.8 is the compatibility version and actually refers to gnucash 3.x (a small 
historical hiccup).



> A few final remarks:
> 
> * You never mentioned this, but normally gnucash would pop up a message when
> it has attempted this migration. Did you actually get this message ?
> 
> No. If the migration occurred during the Ubuntu 20.04 -> 22.04 upgrade, I
> would not have seen it go by in the torrent  generated by the upgrader. If
> it showed such a message the first time I ran gnucash after the upgrade, I
> missed seeing it.
> 

It should be displayed the first time you run gnucash after the upgrade. So you 
may have 
missed it.
> 
> * You mentioned you were migrating from gnucash 1.x. Was that really the
> previous version of gnucash you ran on your system, or just that the data
> file you now opened was last opened with gnucash 1.x ? Somewhere in the 2.x
> series we switched backends for these preferences (from the old GConf to
> the newer DConf). Migration between these two backends has been done
> somewhere between 2.x and 3.x, but that migration code is no longer present
> in gnucash 4.x. So if you really never ran gnucash 2.x and 3.x, this means
> all your preferences have been reset to default. In that case you probably
> want to go through your preferences again in "Edit->Preferences" to check
> if they are still as you want them to be.
> 
> That is what I found late yesterday. I had reported that my Scheduled
> Transactions were not being posted, and John Ralls pointed me to the ST
> section in Preferences. Sure enough, none of the boxes were checked, and
> manually running Actions/Scheduled Transactions/Since Last  Run entered all
> of the delinquents. However when I called up dconf-editor, I found a folder
> /org/gnucash with 7 subfolders, one of which is GnuCash. Oddly, GnuCash
> contains 6 subfolders named the same as ones in its parent, and both sets
> of folders contain folders /dialogs/scheduled-trans/since-last-run with
> binary keys show-file-at-open and show-notify-window-at-file-open that are
> enabled. It appears that GConf did get migrated to DConf but gnucash isn't
> reading dconf.

Considering you were previously on Ubuntu 20.04LTS the most recent gnucash on 
that 
system was 3.8b. The 1: in the package version number is a specific packaging 
prefix. I used 
to know what it was about. I do know it's not relevant to determine the actual 
gnucash 
version. So you're good.

And indeed the migration to dconf has already happened by then.
___
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] help: vs. ghelp: was: Problems upgrading to 4.8a

[Geert Janssens]

I have looked at the link and moved a bit upwards in the hierarchy to this page:
https://packages.debian.org/bookworm/all/gnucash-docs[1]
There's a link there to download the debian gnucash-docs source package on the 
right hand 
side. I have extracted that and found a rules file (presumably that's what's 
used to build and 
install ?)

Comparing the rules file in there between bullseye (stable) and bookworm 
(testing) does 
indeed suggest this happens because of the change to cmake.

It looks like the new rules file should explicitly add ghelp as target in the 
make rule that also 
builds html and pdf. So line 42 may have to become
$(MAKE) -C $(BDIR) ghelp html pdf

Or for the upcoming 4.12
$(MAKE) -C $(BDIR) xdghelp html pdf

Note that html and pdf were never really meant for inclusion in the linux 
distribution 
packages and not what gnucash has been designed to interact with. If the 
packager wants to 
they can be included though.

I'll add that due to a recent change in the build scripts the html target is no 
longer installed 
by default. If this installation is required for the debian package to contain 
the html output (it 
doesn't look like that) the override_dh_auto_configure line requires an 
additional option, 
namely
  -DWITH_HTML_INSTALL=ON

Final note: the -DWITH_PDF=ON should not be necessary. It's enabled by default 
when 
building on linux.

An alternative way to fix it would be to *disable* the unwanted targets 
(currently that would 
be epub via "-DWITH_EPUB=OFF") and then have override_dh_auto_build just build 
all 
instead of specific targets, like so:
$(MAKE) -C $(BDIR)

Hopefully this extra info can help Dmitry decide on how to fix the gnucash-docs 
package on 
Debian.

Regards,

Geert

Op woensdag 7 september 2022 16:20:59 CEST schreef john:
> I'm pretty sure that the whole Debian ecosystem uses the Debian packages
> created by Dmitry Smirnov, which is why he's CC'd on this thread. The file
> list for his testing Gnucash-docs package:
> https://packages.debian.org/bookworm/all/gnucash-docs/filelist and for
> stable it's
> https://packages.debian.org/bullseye/all/gnucash-docs/filelistNote that
> stable has the docbook docs and testing doesn't. Might we have caused this
> with our cmake changes?
> 
> Regards,
> John Ralls
> 
> .
> 
> > On Sep 7, 2022, at 12:48 AM, Geert Janssens 
> > wrote:> 
> > Op dinsdag 6 september 2022 19:00:47 CEST schreef Frank H. Ellenberger:
> > > Am 06.09.22 um 06:01 schrieb john:
> > > >> On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger
> > > >>  wrote:
> > > >> 
> > > >> Hi,
> > > >> 
> > > >> Am 05.09.22 um 22:27 schrieb Geert Janssens:
> > > >>> Op maandag 5 september 2022 19:09:06 CEST schreef john:
> > > >>>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612
> > > >>>> 
> > > >>>> I discovered while researching this that yelp v.42 just dropped
> > > >>>> support
> > > >>>> for
___
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] help: vs. ghelp: was: Problems upgrading to 4.8a

[Geert Janssens]

Op dinsdag 6 september 2022 19:00:47 CEST schreef Frank H. Ellenberger:
> Am 06.09.22 um 06:01 schrieb john:
> >> On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger
> >>  wrote:
> >> 
> >> Hi,
> >> 
> >> Am 05.09.22 um 22:27 schrieb Geert Janssens:
> >>> Op maandag 5 september 2022 19:09:06 CEST schreef john:
> >>>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612
> >>>> 
> >>>> I discovered while researching this that yelp v.42 just dropped support
> >>>> for
> >>>> the ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to
> >>>> find the GnuCash docs
> >>> 
> >>> I'm surprised the help: scheme finds the documentation in the old ghelp
> >>> locations, but that's good news really.
> >>> I think we best add this in for gnucash 4.12 then, and conditional on
> >>> the yelp version.
> >> 
> >> Why conditional, IIRC help: is defined in yelp for about a decade.
> > 
> > Because yelp v3.x (and maybe v40 and v41, I didn't have those handy to
> > test) can't find the GnuCash docs in /usr/share/docs/gnucash-docs with
> > help: so we have to use ghelp: on distros that are still shipping older
> > versions of yelp.
> > 
> > Regards,
> > John Ralls
> 
>  From https://gitlab.gnome.org/GNOME/yelp/-/blob/master/NEWS
> 
>  > Changes in 2.31.5:
>  > --
>  > * New "Read Later" feature
>  > * Support for proposed XDG help: URI scheme
> 
> They should find /usr/share/help/{lang}/…
> 
> Why do you want to unstall into /usr/share/docs/?
> Also ghelp: did not recognitze that.
> It used /usr/share/gnome/help/…
> 
> Regards
> Frank

I've explained the difference in my other reply. I think this is a bug in 
ubuntu packaging; 
they seem to ship our html format and no longer our docbook format.

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] Problems upgrading to 4.8a

[Geert Janssens]

Phill,

The values you set for GNC_DATA_HOME and GNC_CONFIG_HOME are the defaults when 
these variables are not set. So there's no need to explicitly set them, only if 
you want to 
override the default values.

It's normal that there's nothing in GNC_CONFIG_HOME. GnuCash will never write 
files in that 
directory itself, but it will look for user generated config files in there 
(log.conf or config-
user.scm currently).

Next, I'm not sure we are talking about the same thing really when we refer to 
"data files". To 
avoid further confusion I'll define a few things first:

"Data files" are the ones containing your actual accounting data. These files 
normally have 
file extension ".gnucash". If you have these files from the 1.x period they may 
also have no 
extension at all or the ".xacc" extension.

"Backup files" are autogenerated by gnucash and - as the name suggests - 
contain backups 
of your accounting data. They are generated in the same directory as your "Data 
file" and 
have as file name
..gnucash

"Log files" in this context are also auto generated by gnucash and contain a 
transaction log. 
That is it logs all changes made to transactions in chronological order between 
file saves. 
They can be used to replay such changes on top of a backup file to restore lost 
data. They are 
also generated in the same directory as the "Data files" and have as file name
..log

"Metadata files" or "state files" contain non-accounting data. That is it will 
record per "Data 
file" which windows and tabs you had open last time you were working with that 
"Data file", 
it will also remember window positions and sizes, the options for reports that 
were still open 
and so on. There is exactly one "Metadata file" per "Data file" and these will 
be stored in
GNC_DATA_HOME/books. The name of such a file will be
.gcm

"Saved reports" is a bit of an outlier. It is a single file that contains all 
"Saved report 
configurations" you have created in gnucash. For historical reasons this file 
is shared by all 
your "Data files". It is found in GNC_DATA_HOME and is called 
saved-reports-


With those defined, let's turn back to the migration. I'm surprised your 
DOT_GNUCASH_DIR 
is empty. GnuCash will only *copy* files during migration, not move. So even in 
the case of a 
successful migration, the original files should have still been in 
DOT_GNUCASH_DIR. I'd 
expect at least a populated books directory and a saved-reports file, unless 
you never 
created custom report configurations.

I also quickly checked and found the migration code is slightly dumb in that it 
will copy *all* 
files in DOT_GNUCASH_DIR. That will include your data files, backup files and 
log files if you 
effectively had stored them. But that leads to a very tricky situation 
unfortunately: without 
explicit action, gnucash would continue automatically open your data file from 
the 
DOT_GNUCASH_DIR directory while you might believe that after migration the 
files should be 
loaded from GNC_DATA_HOME. I think you have more or less solved this by moving 
the data 
file (and log and backup files) to $HOME/Documents/gnucash. But I just wanted 
to point this 
out to be sure you're not inadvertently get caught by this confusion.

As for the .gcm file sizes: these files hold the state of your windows, tabs 
open reports and so 
on. I presume you had many more open last time you ran gnucash with the old 
.gcm files in 
place. Rerunning gnucash without a .gcm file is like a reset of your state 
information. It will 
only open single account hierarchy page and unless you reopened all tabs and 
reports 
before closing like you had before that would explain why the old one is much 
bigger.

A few final remarks:
* You never mentioned this, but normally gnucash would pop up a message when it 
has 
attempted this migration. Did you actually get this message ?
* You mentioned you were migrating from gnucash 1.x. Was that really the 
previous version 
of gnucash you ran on your system, or just that the data file you now opened 
was last 
opened with gnucash 1.x ? Somewhere in the 2.x series we switched backends for 
these 
preferences (from the old GConf to the newer DConf). Migration between these 
two 
backends has been done somewhere between 2.x and 3.x, but that migration code 
is no 
longer present in gnucash 4.x. So if you really never ran gnucash 2.x and 3.x, 
this means all 
your preferences have been reset to default. In that case you probably want to 
go through 
your preferences again in "Edit->Preferences" to check if they are still as you 
want them to 
be.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved Reports Location Question

[Geert Janssens]

Op dinsdag 6 september 2022 06:13:45 CEST schreef Adrien Monteleone:
> I'm pretty sure those locations are hard coded.
> 
They are not :)

> It might be worth investigating the Windows equivalent of a symbolic link.
> 
> Regards,
> Adrien
> 
> On 9/5/22 8:22 PM, butterands...@gmail.com wrote:
> > In the C:\Program Files (x86)\gnucash\etc directory, in the gnucash
> > subdirectory, where there is an "enviroment" file, I added an
> > "environment.local" file with the following content:
> > 
> > GNC_DATA_HOME=c:\users\butte\dropbox\gnucash
> > 
> > I then opened up gnucash, but the saved reports are still not pointing to
> > that location.

The contents of that file should be

[Variables]
GNC_DATA_HOME=c:\users\butte\dropbox\gnucash

You were probably only missing the "Variables" group header.
A few suggestions however:
1. I presume your data file is also in c:\users\butte\dropbox\gnucash ?
In that case it would be better to make a subdirectory for the gnucash meta 
data (it can 
simply be c:\users\butte\dropbox\gnucash\data) and point GNC_DATA_HOME to that. 
So the 
line in environment.local would become
GNC_DATA_HOME=c:\users\butte\dropbox\gnucash\data

2. Besides GNC_DATA_HOME there is also directory GNC_CONFIG_HOME. On Windows 
this 
special variable typically points to the same location. So if you want to 
relocate the former, 
you probably also want to relocate the latter. For that add a second line in 
environment.local 
with the following 
GNC_CONFIG_HOME=c:\users\butte\dropbox\gnucash\data


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.


___
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] Problems upgrading to 4.8a

[Geert Janssens]

Op maandag 5 september 2022 22:38:55 CEST schreef Phil Wolff via gnucash-user:
>David ~
> 
>[1]https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DI
>R: "When moving from GnuCash 2.6 to 3.x or above, GnuCash will
>automatically try to migrate all data from DOT_GNUCASH_DIR to their
>respective new locations. After mitgration, GnuCash 3.0 or above should
>never use DOT_GNUCASH_DIR again."
>For my Linux system, DOT_GNUCASH_DIR is $HOME/.gnucash, and my data
>file and all associated *.log files are there. Since my previous
>GnuCash version was 1.something, is it reasonable to assume that this
>migration was not even attempted?
> 
I didn't want to bring this up earlier. However $HOME/.gnucash has never been 
the place to 
store your data files, though older versions of gnucash didn't prevent you from 
doing so or 
even suggested that directory by default unfortunately. The DOT_GNUCASH_DIR is 
meant to 
be used by gnucash to store internal state, not your accounting data.

Having said all that, you can probably continue to work like this though I 
would recommend 
to move your actual data files to a more traditional location like 
$HOME/Documents/gnucash 
(replace gnucash with anything you like - I have only added it because gnucash 
creates a lot 
of log and backup files next to your actual data file and you may want to keep 
those from 
cluttering your Documents directory).

Now back to your question: gnucash will also attempt to migrate state 
information for older 
gnucash books (that information is actually not stored in the book files 
themselves). It will 
however only attempt to do so if special directory GNC_DATA_HOME doesn't exist 
yet. If there 
was a failure to run the migration that should have been logged in the gnucash 
trace file 
that was generated during the first run of the newer gnucash. You can always 
try to 
reproduce this by temporarily moving GNC_DATA_HOME out of the way, and run 
gnucash.

Another sidenote (though perhaps that has been the topic of another thread), we 
generally 
don't support an upgrade from gnucash 1.something to 4.x. We do support 
upgrades from 
1.6.x->1.8.x->2.0.x->2.2.x->2.4.x->2.6.x->3.x->4.x

If you skip all the steps in between, you may have some odd issues during 
upgrade, though I 
think your data itself should be fine.

Regards,

Geert

>~ Phil
> 
>On 9/3/22 15:14, David Cousens wrote:
> 
> Phil,
> 
> The installation of the GnuCash help and Tutorial and concepts guide is a
> separate download and installation from the installation of the program and
> is available under a separate link in the panels on the left on the GNuCash
> webpage i.e. [2]https://gnucash.org/docs.phtml .  They should also be able
> to be install ed
> from Ubuntu's package manager. Not sure about the scheduled transactions - I
> would expect them to be stored in the book but they may be stored in the
> user preference information. This wiki
> page [3]https://wiki.gnucash.org/wiki/Configuration_Locations has
> information on where they are stored and you may need to copy them from a
> backup of your old system.
> 
> David Cousens
> 
> References
> 
>1. https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR
>2. https://gnucash.org/docs.phtml
>3. https://wiki.gnucash.org/wiki/Configuration_Locations
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problems upgrading to 4.8a

[Geert Janssens]

Op dinsdag 6 september 2022 06:01:00 CEST schreef john:
> > On Sep 5, 2022, at 2:01 PM, Frank H. Ellenberger
> >  wrote:
> > 
> > Hi,
> > 
> > Am 05.09.22 um 22:27 schrieb Geert Janssens:
> >> Op maandag 5 september 2022 19:09:06 CEST schreef john:
> >>> This is https://bugs.gnucash.org/show_bug.cgi?id=798612
> >>> 
> >>> I discovered while researching this that yelp v.42 just dropped support
> >>> for
> >>> the ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to
> >>> find the GnuCash docs
> >> 
> >> I'm surprised the help: scheme finds the documentation in the old ghelp
> >> locations, but that's good news really.
> >> I think we best add this in for gnucash 4.12 then, and conditional on the
> >> yelp version.
> > 
> > Why conditional, IIRC help: is defined in yelp for about a decade.
> 
> Because yelp v3.x (and maybe v40 and v41, I didn't have those handy to test)
> can't find the GnuCash docs in /usr/share/docs/gnucash-docs with help: so
> we have to use ghelp: on distros that are still shipping older versions of
> yelp.
> 
The intention is correct however the message is slightly confusing with respect 
to the 
directories involved.
Officially "ghelp:" looks for documentation books in
/usr/share/gnome/help///
"help:" on the other hand will look for books in
/usr/share/help///
In both cases we provide the documentation in docbook format (albeit "help:" 
has a new 
requirement for the name of the initial page to load - it has to be 
index.docbook for our 
purpose).

The document Phil pointed at in
/usr/share/docs/gnucash-docs(-lang?)/ is where our build scripts will store the 
html target. 
This has never been used by yelp.


Now to confirm what John said, versions of yelp before v42 (I tested on v41 
just now) won't 
search for our documents in
/usr/share/gnome/help///
when you use the "help:" schema. They will only look in
/usr/share/help///
It was news to me that yelp v42 does look in both directories (I currently 
don't have a distro 
installed with the version of yelp).

I agreed with John's suggestion to make the choice conditional on the yelp 
version as this 
entails the least amount of work. But backporting the whole of my xdg branch to 
maint is 
certainly possible as well. I don't think there are supported versions of yelp 
on any distro we 
care about that doesn't know the "help:" schema.

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] Problems upgrading to 4.8a

[Geert Janssens]

Op maandag 5 september 2022 19:09:06 CEST schreef john:
> This is https://bugs.gnucash.org/show_bug.cgi?id=798612
> 
> I discovered while researching this that yelp v.42 just dropped support for
> the ghelp: scheme. help:gnucash-help and help:gnucash-guide are able to
> find the GnuCash docs
I'm surprised the help: scheme finds the documentation in the old ghelp 
locations, 
but that's good news really.

I think we best add this in for gnucash 4.12 then, and conditional on the yelp 
version.

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] Problems upgrading to 4.8a

[Geert Janssens]

Hi Phil,

My response was not for flatpak. It's how the gnucash-docs build scripts 
(written by the 
gnucash developers) currently install things. And on Fedora 36 for example that 
is still the 
case.

The documentation links you are listing are the html versions of our 
documentation and is 
not what is presented when invoking "Tutorial" or "Contents" from the GnuCash 
menus. 
GnuCash will look for the docbook version of the documentation, which at this 
point is still 
installed in /usr/share/gnome/help/C/gnucash-guide and 
/usr/shar/gnome/help/C/gnucash-
help. (Well, pedantically it will ask yelp to look there by means of the 
"ghelp:xyz" construct, 
but yelp dropped support for that construct in version 42).

I don't know what the Ubuntu packager for our documentation has decided on. But 
if 
Ubuntu only ships the html version of the gnucash documentation, I consider 
that a bug in 
that distribution. There are a few possible ways the Ubuntu packager could 
solve this:
* either also patch the gnucash package to look for the html version of the 
documentation
* revert the change in yelp that drops support for the "ghelp" search 
qualifier. Considering 
gnucash is probably the last application in the Gnome ecosystem to still depend 
on this, it's 
unlikely Ubuntu would go that route.
* backport the patchset from the master branch in the gnucash and gnucash-docs 
repositories that rearrange our documentation output to work with yelp's "help" 
search 
qualifier. That way gnucash will be able to present the documentation again as 
you were 
used to in Ubuntu 20.04.

I think the last option would be the most future proof one.

Regards,

Geert


Op maandag 5 september 2022 17:01:22 CEST schreef Phil Wolff via gnucash-user:
> Geert ~
> 
> Thanks for responding!
> That may be true for a Flatpak installation, but mine is what GNC calls
> "pristine," and I've found the documents at
> - file:///usr/share/doc/gnucash-docs/gnucash-guide-en/index.html
> - file:///usr/share/doc/gnucash-docs/gnucash-help-en/help.html
> 
> ~ Phil
> 
> On 9/5/22 00:46, Geert Janssens wrote:
> > Hi Phil,
> > 
> > Regarding the documentation, it seems like Ubuntu 22.04.1 ships a newer
> > help viewer that's not compatible with where GnuCash stores its guide and
> > manual on disk. This has been fixed for the future GnuCash 5.0 but not
> > for the current 4.x series.
> > 
> > As temporary workarounds you could either
> > - browse the documentation online (via the gnucash website) or
> > - load the documentation from the command line using one of these commands
> > 
> >yelp /usr/share/gnome/help/C/gnucash-guide/gnucash-guide.xml
> >yelp /usr/share/gnome/help/C/gnucash-help/gnucash-help.xml
> > 
> > Regards,
> > 
> > Geert
> > 
> > Op zondag 4 september 2022 00:14:09 CEST schreef David Cousens:
> >> Phil,
> >> 
> >> The installation of the GnuCash help and Tutorial and concepts guide is a
> >> separate download and installation from the installation of the program
> >> and
> >> is available under a separate link in the panels on the left on the
> >> GNuCash
> >> webpage i.e. https://gnucash.org/docs.phtml .  They should also be able
> >> to
___
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] Problems upgrading to 4.8a

[Geert Janssens]

Hi Phil,

Regarding the documentation, it seems like Ubuntu 22.04.1 ships a newer help 
viewer that's 
not compatible with where GnuCash stores its guide and manual on disk. This has 
been fixed 
for the future GnuCash 5.0 but not for the current 4.x series.

As temporary workarounds you could either
- browse the documentation online (via the gnucash website) or
- load the documentation from the command line using one of these commands

  yelp /usr/share/gnome/help/C/gnucash-guide/gnucash-guide.xml
  yelp /usr/share/gnome/help/C/gnucash-help/gnucash-help.xml

Regards,

Geert

Op zondag 4 september 2022 00:14:09 CEST schreef David Cousens:
> Phil,
> 
> The installation of the GnuCash help and Tutorial and concepts guide is a
> separate download and installation from the installation of the program and
> is available under a separate link in the panels on the left on the GNuCash
> webpage i.e. https://gnucash.org/docs.phtml .  They should also be able to
> be installed from Ubuntu's package manager. Not sure about the scheduled
> transactions - I would expect them to be stored in the book but they may be
> stored in the user preference information. This wiki
> page https://wiki.gnucash.org/wiki/Configuration_Locations has information
> on where they are stored and you may need to copy them from a backup of
> your old system.
> 
> David Cousens
> 
> On Sat, 2022-09-03 at 12:21 -0700, Phil Wolff via gnucash-user wrote:
> >I was running Ubuntu 20.04.4 and whatever GnuCash version was available
> >in that release, and all was well. Then, around the middle of August
> >when 22.04.1 became available, I upgraded and GnuCash was updated to
> >4.8a. Clicking the desktop icon, which used to present my database
> >page, now opens a largely empty window titled "Unsaved Book - GnuCash."
> >Selecting Tutorial or Contents in the Help menu either does nothing
> >visible or pops up a window saying, "Document Not Found. The URI
> >‘[1]ghelp:gnucash-guide’ does not point to a valid page." I eventually
> >determined that I could access my data by selecting the "File/Open…"
> >menu item and navigating to the data file in the .gnucash folder of my
> >home directory. Although sub-optimal, this worked for me until
> >September 1 arrived and none of my first-of-the-month scheduled
> >transactions were posted. This suggests that something vital that
> >needed to happen during the move from the older version of GnuCash to
> >4.8a ... didn't. Anyone have any ideas? Any help will be greatly
> >appreciated!
> > 
> > References
> > 
> >1. ghelp:gnucash-guide’
> > ___
> > 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] Fwd: Re: Saved Report Configurations Missing After Upgrade to v3

[Geert Janssens]

Oops, sorry David!

Op zondag 28 augustus 2022 23:06:46 CEST schreef David T. via gnucash-user:
> Forwarding to the list...
> 
> 
>  Original Message ----
> From: Geert Janssens 
> Sent: August 28, 2022 11:44:00 PM GMT+03:00
> To: "David T." 
> Subject: Re: [GNC] Saved Report Configurations Missing After Upgrade to v3
> 
> Hi Neville,
> 
> You have successfully replied to the mailing list so all users will be able
> to see your message now.
> 
> I do remember that old conversation, which was about an upgrade helper
> script that should run the first time you execute gnucash 3.x. For some
> reason this did not always happen on Windows. To this date I still don't
> know why that is.
> 
> As a workaround you could also perform these upgrade steps manually by
> moving some state files and the saved report configurations file to their
> respective new locations. You seem to refer to the saved report
> configurations file and I assume you copied it to its new location based on
> the conversation that happened there. That should indeed get you back your
> saved reports in 3.x.
> 
> There are/were more files in the .gnucash directory that saved state for all
> open windows and tabs that should have been migrated/upgraded. Bus as you
> are reading this older conversation I presume they were not copied either.
> They are less important though. And certainly not now any more that you
> have been using gnucash 3.x already. No doubt you have already reopened
> registers and reports to you likings.
> 
> Regards,
> 
> Geert
> 
> Op dinsdag 23 augustus 2022 13:02:51 CEST schreef David T. via gnucash-user:
> > Neville,
> > 
> > You've responded to a thread from four years ago, referencing a problem
> > with upgrading from version 2.4 to version 3.0 (on Windows, I believe).
> > Gnucash is now up to version 4.11, so whatever problem you've been having
> > is far in most users' rear view mirrors. Geert probably remembers the
> > issue to which you refer, but that's because Geert is Geert.
> > 
> > You might choose to follow an upgrade process and see whether your problem
> > continues to exist in 4.11.
> > 
> > David T.
> > 
> > On August 23, 2022 12:07:25 PM GMT+03:00, Neville Young 
> >  
wrote:
> > >Hi Geert
> > >
> > >
> > >
> > >I want to respond to the latest message Thu Jun 7 11:01:45 EDT 2018 to
> > >confirm that using the 2.4 transaction report does work.
> > >
> > >
> > >
> > >How do I respond to the thread for all users to see. I have read the
> > >'more
> > >information' but am none the wiser.
> > >
> > >
> > >
> > >Cheers - Neville
___
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] Adding a new currency

[Geert Janssens]

Op vrijdag 8 juli 2022 14:52:58 CEST schreef Esteban Maringolo:
> But is the list of currencies hardcoded? Isn't it in some table?
> 
It's in an xml file. If you self-build, you could add your own currencies in 
that file 
and have extra currencies. A patch to add these extra currencies will only be 
accepted in the gnucash code base though if the extra currencies are ISO-4217.

To have anything in vanilla gnucash, the user interface and the data store 
format 
have to be changed in order to be able to clearly distinguish ISO currencies 
from 
custom ones. That's quite a bit of work :)

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Adding a new currency

[Geert Janssens]

Op vrijdag 8 juli 2022 10:18:51 CEST schreef Peter West:
> So cryptocurrencies will never be supported currencies, because
> cryptocurrencies will never be part of ISO-4217.
> 

At some point I proposed to add code to allow non-ISO-4217 currencies. While 
not formally 
correct this could be helpful for simple personal accounting. Such alternate 
currency group 
could also have been used to manage crypto currencies.

Unfortunately I don't have time left to implement this and I don't think any of 
the other 
active devs has it anywhere on their priority list.

So "never" ? Depends. For to to have any chance though it will require someone 
to step up 
and implement this in a way that fits the gnucash design and concepts.

Regards,

Geert

> —
> Peter West
> p...@pbw.id.au
> “And the rain fell, and the floods came, and the winds blew and beat against
> that house, and it fell, and great was the fall of it.”
> > On 8 Jul 2022, at 2:51 am, john  wrote:
> >> On Jul 7, 2022, at 9:23 AM, Esteban Maringolo 
> >> wrote:
> >> 
> >> Hi,
> >> 
> >> Is it possible to manually add a new currency to the list of currencies?
> >> 
> >> I will take care of updating the exchange rate.
> > 
> > No. Currency in GnuCash is defined as "currencies recognized by ISO-4217".
> > Everything else is a commodity.
> > 
> > Regards,
> > John Ralls
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> > 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Invoice showing balance due

[Geert Janssens]

Op donderdag 2 juni 2022 18:05:13 CEST schreef Derek Atkins:
> On Thu, June 2, 2022 11:49 am, David Burleigh wrote:
> > On Thu, 2022-06-02 at 11:44 -0400, Derek Atkins wrote:
> [snip]
> 
> >> So you're not actually telling GnuCash to *add* existing credits.
> >> You need to do that so GnuCash knows you want to apply them to *this*
> >> invoice (instead of waiting to apply them to another invoice).
> >> 
> >> Do that, and then turn on "Show Payments" in the report options.
> >> 
> >> -derek
> > 
> > But how do you tell it to add existing credits to a new invoice? I
> > don't see that option anywhere in the interface.
> 
> After you post you need to Process Payment to attach the credit.
> Unfortunately GnuCash no longer auto-applies credits.

I thought that was still an option. But perhaps disabled by default ?

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.