Re: [GNC-dev] [GNC] GnuCash 5.0 Released

[John Ralls]

Nope, the schema is the same as before.

Regards,
John Ralls


> On Mar 27, 2023, at 9:53 AM, Tim Rohrer  wrote:
> 
> I’ve been working over the past few months on a Python app to help users 
> migrate from Quicken Mac, which will only export csv files. I’m using Piecash 
> for writing the database.
> 
> As I look through this list of note/features, I’m not seeing anything that 
> changes the the book’s sql file structure. 
> 
> Am I missing anything?
> 
> Thank you for your work! I look forward to downloading and experimenting.
> 
> Tim
> 
>> On Mar 26, 2023, at 16:13, John Ralls  wrote:
>> 
>> The GnuCash development team announces GnuCash 5.0.
>> 
>> New Features
>> 
>>   A new Stock Transaction Assistant to guide you through entering most 
>> investment transactions for stocks, bonds, and mutual funds. You can access 
>> it from Actions>Stock Assistant when the focus tab is the Accounts page or a 
>> Stock or Fund account register.
>>   A new Investment Lots report showing a graph of capital gains and losses 
>> in a period by investment lot. Note that if you don't use the View Lots 
>> dialog to manage capital gains and losses this report won't have anything to 
>> show you. Use Reports>Assets & Liabilities>Investment Lots to see the report.
>>   The Online Quotes facility has been completely rewritten and the old 
>> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced 
>> with finance-quote-wrapper. The functions performed by those programs may 
>> now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli 
>> --help for specifics. The perl module requirements have changed with the 
>> rewrite: The new version doesn't need Date::Manip but needs JSON::Parse 
>> instead. gnc-fq-update has been, er, updated to reflect that.
>>   A new tab on the New/Edit Account dialog called More Properties includes 
>> entries to set a high and low limit on an account. That's coupled to a new 
>> column that's available on the Accounts Page, Balance Limit. If you set a 
>> high or low limit and the account balance falls above or below the 
>> respective limit an indicator will be shown in the Balance Limit column.
>>   The description field quickfill in the register now displays a drop-down 
>> list of possible completions instead of just one inline completion.
>>   File import menu items for the MT940, MT942, and DTAUS formats is replaced 
>> with a single Import from AQBanking that supports importing any file format 
>> supported by AQBanking, including the frequently requested CAMT. (Note that 
>> some CAMT profiles are under the XML format.)
>>   The import matcher now permits editing descriptions, notes, and memo 
>> fields in the matcher window before creating the transactions. Right-click 
>> and select from the context menu.
>>   The report generated by the Print Invoice button on the Edit Invoice tab 
>> can now be configured as a book option at the bottom of the Business tab; 
>> this permits selecting a saved configuration of one of the standard invoice 
>> reports. Another option enables a delay, during which a dialog box will 
>> appear enabling the user to select a different report. Note: When saving a 
>> configuration make sure that the invoice number is not set or you'll get 
>> that particular invoice instead of the one that you pressed the button for.
>> 
>> Significant Code Changes
>> Deprecations (will be removed in GnuCash 6.0)
>> 
>>   _ (the alias for gettext. Use G_ instead)
>>   gnc:make-account-list-limited-option
>>   gnc:make-account-list-option
>>   gnc:make-account-sel-limited-option
>>   gnc:make-account-sel-option
>>   gnc:make-budget-option
>>   gnc:make-color-option
>>   gnc:make-commodity-option
>>   gnc:make-complex-boolean-option
>>   gnc:make-counter-format-option
>>   gnc:make-counter-option
>>   gnc:make-currency-option
>>   gnc:make-date-format-option
>>   gnc:make-font-option
>>   gnc:make-internal-option
>>   gnc:make-invoice-option
>>   gnc:make-list-option
>>   gnc:make-multichoice-callback-option
>>   gnc:make-multichoice-option
>>   gnc:make-number-plot-size-option
>>   gnc:make-number-range-option
>>   gnc:make-owner-option
>>   gnc:make-pixmap-option
>>   gnc:make-query-option
>>   gnc:make-radiobutton-option
>>   gnc:make-simple-boolean-option
>>   gnc:make-string-option
>>   gnc:make-taxtable-option
>>   gnc:make-text-option
>>   gnc:option-set-default-value
>>   gnc:option-set-value
>>   gnc:option-setter
>>   gnc:option-value
>>   gnc:register-option
>>   The invoice option to gnc:register-report-create-internal
>> 
>> Report and Book Options
>> 
>>   This major change will affect everyone who has written custom reports in 
>> Guile Scheme.
>>   The report and book options code has been completely rewritten in C++ with 
>> SWIG providing Guile Scheme access for reports. The new design requires 
>> directly registering options with for example 
>> gnc-optiondb-register-string-option instead of calling 
>> gnc:make-string-option 

Re: [GNC-dev] [GNC] GnuCash 5.0 Released

[John Ralls]

Rats. The correct hash and version number is

c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a  
Gnucash-Intel-5.0-1.dmg

I've fixed the release notes and the SourceForge README. Thanks for the report.

Regards,
John Ralls


> On Mar 27, 2023, at 9:28 AM, Peter West via gnucash-user 
>  wrote:
> 
> I have just noticed that the hash given in the release email for
> Gnucash-Intel-5.0-2.dmg
> is the correct hash for
> Gnucash-Intel-5.0-1.dmg
> which is the version which downloads from the first download link for Apple 
> MacOS in the release email. The has I used was the one given for
> Gnucash-Intel-5.0-1.dmg
> on the SourceForge page.
> 
> Hence my confusion.
> 
> —
> Peter West
> p...@pbw.id.au
> When he had said these things, he cried out with a loud voice, “Lazarus, come 
> out.”
> 
> 
> 
>> On 27 Mar 2023, at 9:25 am, Peter West via gnucash-user 
>>  wrote:
>> 
>> The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given 
>> at SourceForge.
>> 
>> $ sha256 Gnucash-Intel-5.0-1.dmg 
>> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
>> Gnucash-Intel-5.0-1.dmg FAIL
>> c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO
>> b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a
>> 
>> 
>> —
>> Peter West
>> p...@pbw.id.au “Rejoice and be glad, for your reward 
>> is great in heaven, for so they persecuted the prophets who were before you.”
>> 
>>> On 27 Mar 2023, at 7:09 am, John Ralls >> > wrote:
>>> 
>>> The GnuCash development team announces GnuCash 5.0.
>>> 
>>> New Features
>>> 
>>>  A new Stock Transaction Assistant to guide you through entering most 
>>> investment transactions for stocks, bonds, and mutual funds. You can access 
>>> it from Actions>Stock Assistant when the focus tab is the Accounts page or 
>>> a Stock or Fund account register.
>>>  A new Investment Lots report showing a graph of capital gains and losses 
>>> in a period by investment lot. Note that if you don't use the View Lots 
>>> dialog to manage capital gains and losses this report won't have anything 
>>> to show you. Use Reports>Assets & Liabilities>Investment Lots to see the 
>>> report.
>>>  The Online Quotes facility has been completely rewritten and the old 
>>> gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced 
>>> with finance-quote-wrapper. The functions performed by those programs may 
>>> now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli 
>>> --help for specifics. The perl module requirements have changed with the 
>>> rewrite: The new version doesn't need Date::Manip but needs JSON::Parse 
>>> instead. gnc-fq-update has been, er, updated to reflect that.
>>>  A new tab on the New/Edit Account dialog called More Properties includes 
>>> entries to set a high and low limit on an account. That's coupled to a new 
>>> column that's available on the Accounts Page, Balance Limit. If you set a 
>>> high or low limit and the account balance falls above or below the 
>>> respective limit an indicator will be shown in the Balance Limit column.
>>>  The description field quickfill in the register now displays a drop-down 
>>> list of possible completions instead of just one inline completion.
>>>  File import menu items for the MT940, MT942, and DTAUS formats is replaced 
>>> with a single Import from AQBanking that supports importing any file format 
>>> supported by AQBanking, including the frequently requested CAMT. (Note that 
>>> some CAMT profiles are under the XML format.)
>>>  The import matcher now permits editing descriptions, notes, and memo 
>>> fields in the matcher window before creating the transactions. Right-click 
>>> and select from the context menu.
>>>  The report generated by the Print Invoice button on the Edit Invoice tab 
>>> can now be configured as a book option at the bottom of the Business tab; 
>>> this permits selecting a saved configuration of one of the standard invoice 
>>> reports. Another option enables a delay, during which a dialog box will 
>>> appear enabling the user to select a different report. Note: When saving a 
>>> configuration make sure that the invoice number is not set or you'll get 
>>> that particular invoice instead of the one that you pressed the button for.
>>> 
>>> Significant Code Changes
>>> Deprecations (will be removed in GnuCash 6.0)
>>> 
>>>  _ (the alias for gettext. Use G_ instead)
>>>  gnc:make-account-list-limited-option
>>>  gnc:make-account-list-option
>>>  gnc:make-account-sel-limited-option
>>>  gnc:make-account-sel-option
>>>  gnc:make-budget-option
>>>  gnc:make-color-option
>>>  gnc:make-commodity-option
>>>  gnc:make-complex-boolean-option
>>>  gnc:make-counter-format-option
>>>  gnc:make-counter-option
>>>  gnc:make-currency-option
>>>  gnc:make-date-format-option
>>>  gnc:make-font-option
>>>  gnc:make-internal-option
>>>  gnc:make-invoice-option
>>>