./finance/gnucash, Personal or business finance management program

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 3.3, Package name: gnucash-3.3, Maintainer: wiz

GnuCash is a personal finance manager. A check-book like register
GUI allows you to enter and track bank accounts, stocks, income
and even currency trades. A full set of reports allow you to see
the state of your finances. The interface is designed to be simple
and easy to use, but is backed with double-entry accounting principles
to ensure balanced books. Features include:
- An easy-to-use interface.
- Scheduled Transactions
- Mortgage & Loan Repayment Druid
- Small Business Accounting Features
- OFX and Quicken File Import and HBCI Support
- Reconcile window with running reconciled and cleared balances
- Stock/Mutual Fund Portfolios
- Get Stock & Mutual Fund quotes from various web sites
- Reports
- Multiple Currencies & Currency Trading, Multi-Currency Handling
- Chart of Accounts
- Split Transactions
- Double Entry
- General Ledger
- International date handling, many different translations.

Required to run:
[sysutils/desktop-file-utils] [textproc/libxml2] [textproc/libxslt] [textproc/icu] [finance/p5-Finance-Quote] [finance/libofx] [graphics/hicolor-icon-theme] [lang/perl5] [devel/glib2] [devel/boost-libs] [devel/py-readline] [devel/p5-Date-Manip] [x11/gtkmm] [www/webkit-gtk] [databases/libdbi] [graphics/gdk-pixbuf2] [devel/dconf] [x11/gtk3] [devel/swig2] [lang/guile22] [devel/guile22-slib] [lang/python37]

Required to build:
[pkgtools/x11-links] [devel/boost-headers] [devel/gperf] [x11/xcb-proto] [devel/googletest] [databases/libdbi-driver-sqlite3] [x11/fixesproto4] [pkgtools/cwrappers] [lang/gcc5] [x11/xorgproto]

Package options: libdbi, libofx, python

Master sites:

SHA1: 6add3c53258f059e1a667c32d0ff858be956bf0c
RMD160: 0ad1a6b4cd5b53b7487e238c15cc1c29f53545df
Filesize: 13125.696 KB

Version history: (Expand)

CVS history: (Expand)

   2018-10-01 01:47:32 by Thomas Klausner | Files touched by this commit (4) | Package updated
Log message:
gnucash: update to 3.3.

Between 3.2 and 3.3, the following bugfixes were accomplished:

	• Bug 771667 - Different warnings when changing reconciled splits vs. splits \ 
linked to reconciled splits.
	• Bug 784420 - "Save changes on closing" window waits 2^32 seconds \ 
when "Time to wait for answer" is set 0.
	• Bug 786708 - GnuCash won't load currency fractions larger than 1000000. \ 
Also create larger fractions for the account dialog.
	• Bug 787439 - Segmentation Fault in Transfer dialog after clearing Date \ 
field and pressing escape.
	• Bug 789594 - Unable to overwrite sqlite3 database file.
	• Bug 792446 - Mixed languages in error dialog.
	• Bug 794526 - Python bindings can't find loadable modules.
	• Bug 794755 - Commodity Register displays fractional prices.
	• Bug 794870 - If no book is opened, gnucash still asks if the user wants to \ 
save changes when opening a file.
	• Bug 795821 - GnuCash could not obtain the lock for \ 
	• Bug 796054 - Unposting and reposting invoice doubles amounts.
	• Bug 796137 - query.search_for outputs critical qof.object errors and \ 
prevents queries being run.
	• Bug 796248 - Editing Scheduled Transaction.
	• Bug 796474 - Segmentation fault while setting up online banking.
	• Bug 796509 - Saved reports don't respect *some* 'Edit report options'.
	• Bug 796579 - Cannot go forward with empty duplicates screen.
	• Bug 796665 - Backspace Key Inoperable After Ctrl+V.
	• Bug 796669 - Dark Theme Text Colors Hard to Read.
	• Bug 796724 - Can't overwrite gnucash DB on MariaDB.
	• Bug 796725 - 4 of 6 Date Posted options fail to return matching transactions.
	• Bug 796734 - Auto-complete entry not highlighting to allow for incremental \ 
	• Bug 796737 - Patch to restore gncmod-python.c.
	• Bug 796739 - Toolbar buttons have no labels.
	• Bug 796751 - reconcile window usability - R column should be next to Amount.
	• Bug 796755 - buggy window handling at startup.
	• Bug 796756 - OFX import fails to recognize associated income accounts.
	• Bug 796759 - --add-price-quotes leaves a lock on the file.
	• Bug 796762 - Scrollbar partially hides the delete button in the Saved \ 
Report Configurations window.
	• Bug 796766 - Credit note creating 'imbalance' with wrong entries.
	• Bug 796777 - CVE-2008-1391: Integer overflow in included strfmon function.
	• Bug 796788 - Strange behaviour in options of multicolumn report.
	• Bug 796792 - SaveAs Overwrite dialogue in background and not visible.
	• Bug 796812 - gnc_date_cell_get_date and gnc_date_cell_get_date_gdate have \ 
different date validation behaviour.
	• Bug 796813 - Date validation inconsistent.
	• Bug 796814 - Changing a book's read-only threshold doesn't immediately \ 
affect open registers.
	• Bug 796816 - Notes field in Duplicate Invoice dialogue is 'read-only'.
	• Bug 796819 - Bad icon with Spanish localization.
	• Bug 796820 - References to 'Gnome Bugzilla' should be changed to 'GnuCash \ 
	• Bug 796833 - Excel csv Format misprocessed.
	• Bug 796839 - Find transaction won't filter on Date Posted.
	• Bug 796858 - TypeError: in method 'qof_query_int32_predicate', argument 2 \ 
of type 'gint32' on gnucash.gnucash_core.QueryInt32Predicate.
   2018-08-22 11:48:07 by Thomas Klausner | Files touched by this commit (3558)
Log message:
Recursive bump for perl5-5.28.0
   2018-08-20 13:43:42 by Thomas Klausner | Files touched by this commit (2)
Log message:
gnucash: disable -Werror to fix build with latest boost

Idea from adam@, thanks!
   2018-08-16 20:55:17 by Adam Ciarcinski | Files touched by this commit (653) | Package updated
Log message:
revbump after boost-libs update
   2018-07-20 05:34:33 by Ryo ONODERA | Files touched by this commit (705)
Log message:
Recursive revbump from textproc/icu-62.1
   2018-06-25 10:02:36 by Thomas Klausner | Files touched by this commit (3) | Package updated
Log message:
gnucash: update to 3.2.

Between 3.0 and 3.2, the following bugfixes were accomplished:

	• Bug 787401 - Test Report System - Report Definition.
	• Bug 794617 - Can't compile with -DWITH_GNUCASH=NO due to scm-gnome-utils.
	• Bug 795101 - Scroll Bar in Reconcile Window Floats in and covers the check \ 
	• Bug 795247 - datepicker broken in Persian. GnuCash passes dates as integer \ 
y/m/d without using locale-specific formats, so we need to strip out 'E' and 'O' \ 
from the format when scanning dates or determining separators in gnc-date. None \ 
of '-', 'E', or 'O' are supported by boost (and '-' causes errors), so strip \ 
them out from formatters in gnc-datetime as well.
	• Bug 795253 - Have problems input Chinese.
	• Bug 795272 - QIF importer causes application crash if action is invalid.
	• Bug 795276 - Invalid date on price stops file from being parsed.
	• Bug 795362 - Special variable "i" not parsed in function calls. \ 
Due to balance tests with insane random values.
	• Bug 795471 - Impossible to Edit Budget Unless Maximized.
	• Bug 795519 - Credit card payment after reconciliation.
	• Bug 795666 - Backslash '\' in Description field spoils CSV Import without \ 
helpful error message.
	• Bug 795831 - When read only threshold set, dates are silently changed. \ 
Display a message box informing the user of the change.
	• Bug 795944 - Cannot store change to Business Suppliers data.
	• Bug 796079 - Repeatable Crash in Tax Report Options.
	• Bug 796081 - Tax Schedule Report - An error occurred while running the report.
	• Bug 796083 - Reconcile Selection Doesn't Work Anymore.
	• Bug 796117 - Connecting 3.1 to an existing mysql db drops all data. Provide \ 
a backup recovery function that instead of dropping primaries and restoring \ 
backups merges the primaries and backups. This should handle a worst-case \ 
safe-save failure where the backup tables don't have a complete set of rows for \ 
some reason.
	• Bug 796256 - Main Window stays hidden when starting after closing main \ 
window while minimized.
	• Bug 796369 - Notes lost or perhaps just not displaying when using SQLite \ 
backend. This bug caused data loss if you saved your SQLite3 database to a \ 
different file or database. The problem is that in SQLite3 (though not in MySQL \ 
or PgSQL) the subquery ((SELECT DISTINCT guid FROM transactions)) (note the \ 
double parentheses) returns only the first guid in the subquery's results. Some \ 
transactions are loaded by special queries and those queries are also used to \ 
retrieve the transaction's slots so they weren't affected.
	• Bug 796398 - Restrict accelerator keys to valid date range.
	• Bug 796409 - Incorrect Current Value for Stocks. Missed calculating the \ 
value in the register summary bar.
	• Bug 796423 - Cannot Input Chinese, seems does not work with other IME too. \ 
Toggles not in view with all rows selected weren't being redrawn.
	• Bug 796484 - csv import: iostream error. Unfortunately it turns out that we \ 
can't use filestreams because they can't take path arguments containing Unicode \ 
on Windows.
	• Bug 796527 - invalid currency on scheduled transactions.
		• Don't even check for price/exchange rate on template transactions, there's \ 
no point.
		• Check all split commodities are valid, abort transaction creation if not.
		• If the template transaction's currency isn't used by any of the splits set \ 
the new transaction's currency to the first-found currency if there is one, \ 
otherwise to the first-found commodity.
	• Bug 796537 - Transaction Report cannot sort by "num".
	• Bug 796586 - QIF import incorrectly converts unicode characters from UTF8 \ 
encoded file.
	• Bug 796595 - QIF Import Select Account button to add a new account is \ 
labled gnc-account-new but should be New.
	• Bug 796600 - stock split cash-in-lieu income/asset labels backwards.
	• Bug 796614 - Reconciliation report contains incorrect transactions.
	• Bug 796638 - configuration not properly saved for CSV transactions import form.
The Following fixes and improvemts were not associated with bug reports:

	• Transaction report improvements:
		• Performance: Do all filtering ops before sorting.
		• Move the options summary before the subtotals table.
		• New unit tests
		• Enable computing averages in subtotal grid.
		• Generate the subtotal grid only if the primary sort key enables subtotals.
		• Fix subtotal grid to support multiple commodities.
		• New filters.
		• Much cleaning and refactoring of the internals.
	• Cache the num-split-action book option to avoid thousands of KVP queries \ 
for the same value when loading a register.
	• Create a static string for book option KVPs to save an extra malloc/free on \ 
old compilers without small-string optimization.
	• Add tooltip support for register cells.
	• New unit tests for the balance sheet report and invoices.
	• Consolidate charting code into a single module.
	• Removed an incomplete and abandoned C implementation of QIF import.
	• Restored libsecret support that had been left out of CMake.
	• Replace old-style html style attributes with css.
	• Modify emitted html to be parseable by the Guile SXML module for testing.
	• Remove support for long-gone gtkhtml renderer.
	• Clean up code generating html tables.
	• Ensure full precision of doubles is saved to SQL. std::iostream's \ 
operator<<(double) uses only 6 digits of precision by default.
	• Make float database operations more consistent, working around \ 
dbd-sqlite3's failure to support doubles (dbd-sqlite3, not sqlite3 itself).
	• Prevent crash in gnc-tree-view.c: When getting information from the state \ 
file, protect against the key not having a '_' which is used to split the \ 
	• Add the full account name to the saved register settings If you need to \ 
delete the layout for a register in the settings file, the only thing \ 
identifying it is the account guid. To make it easier for humans, add the full \ 
account name also.
	• When register pages are restored it uses the full account name. When \ 
register pages are restored, the account is found from the full name so if the \ 
separator changes it will fail. Instead, also save the account guid and use that \ 
as default to find the account falling back to the full name.
	• Fix misplaced try block that caused unhandled exception if year out of range.
	• Fix permanent storage of vendor details: Since the data types did not match \ 
for the billterms and taxtable, those references/guids were not saved to the \ 
	• Update invoice reports to use totals calculate by gncInvoice. This should \ 
give a consistent representation of invoice data across the application.
	• Ensure gncEntry rounding is consistent. Internally calculated values in the \ 
entry are never rounded. Consumers of gncEntry's calculated values can request \ 
them either rounded or not. Next use a pragmatical approach for calculating \ 
values on invoices based on the entry values: do the rounding such that we never \ 
create an unbalanced transaction while posting. That means:
		• round each entry's net value before summing them in net total
		• accumulate all tax totals on invoice level per tax account before rounding
and round before before summing them in a global tax total Hopefully this will \ 
catch a few more rounding issues in this area. A complete solution can only \ 
offered if we allow users to manually correct tax entries. This requires changes \ 
to user interface and data format so that's not going to happen in gnucash 3.x.
	• Use Scheme SRFI-64 test framework for new Scheme unit tests.
	• New compilers (gcc-8.0 and Xcode 9) bring new warnings, so several fixups \ 
to mollify them.
	• Lowercase all cmake commands for better readability.
	• Metadate migration (2.6.x->3.x) fixes for Windows.
	• Ensure timezone is set correctly in FreeBSD.
The following translations are updated: Dutch
   2018-04-30 08:06:07 by Thomas Klausner | Files touched by this commit (3) | Package updated
Log message:
gnucash: update to 3.1.

3.1    - 29 April 2018
The second release of the 3.0 stable series.

The following bugs have been fixed:
    Bug 118391 - Long currency names untranslated
    Bug 769686 - Notes not imported when using update and reconcile in
                 import transactions from CSV
    Bug 772776 - VERY large queries (over 11000 fields in IN clause) slow
                 down GnuCash
    Bug 782144 - git-master - Save Corrupts Data File / Not Open Data File
    Bug 792105 - Startup takes several minutes
    Bug 793461 - Transaction matcher window blank when importing QFX
    Bug 794767 - Dates default to 01/01/1970
    Bug 794916 - Fails to find environment file at startup when installation
                 prefix is '/opt'
    Bug 794936 - 3.0 does not open previously saved sqlite3 files properly
                 - corrupted business data
    Bug 794941 - Both print icons export to pdf
    Bug 794953 - Ellipsize on short tab labels
                 Correct error on when to ellipsize tab labels. Also as this
                 is used in two places separate out this to new function so
                 it is not duplicated.
    Bug 794990 - Double click does not work on saved reports
                 When you double click on the saved report description nothing
                 happens. This was down to a conflict on a couple of call
                 backs and one of them was incorrectly setup.
    Bug 794994 - Display Alphavantage key in full
                 Set the entry to expand so all the space is used to display.
    Bug 795031 - 3.0 Crashes on loading when opening 2.6.19 file
    Bug 795039 - Crash on startup using Technicolor Style sheet in report
    Bug 795040 - GnuCash crashes when searching for a newly created bill
    Bug 795049 - GnuCash 2.6.20-1 (Fedora Linux package) is unable to open
    Bug 795064 - Enable subtotal-only if either sortkeys are dates
                 This will allow 'show subtotals only' if sortkeys are
                 date-types. This allows, for example, prime-sortkey=date,
                 yearly. sec-sortkey=date, monthly.
    Bug 795068 - src/optional/python-bindings missing several files
    Bug 795080 - Some dates reset to 01/01/1970
                 An odd corner case: BST apparently came off of DST at 23:00
                 26 Oct 2014, so midnight that day was ambiguous about being
                 DST or not; that causes the local_date_time constructor to
                 throw in spite of the tm.is_dst element being 0 (meaning pick
                 standard time). Instead of just failing in that case, try
                 constructing a local_date_time three hours later then adjust
                 it back three hours. If *that* doesn't work then throw a
                 std::invalid argument.
    Bug 795082 - CSV import crashes if a transaction's 'Account' field is
                 empty and no default Account set
    Bug 795101 - Scrollbar floats and covers toggle buttons
                 When the scrollbar appears for the reconcile windows it can
                 float above the reconcile toggle button which make it
                 difficult to toggle. Move this column to the start which has
                 the advantage of aligning the amount column above the Total
    Bug 795142 - Unable to enter account codes in business sheets
                 In Bills, Invoices and Expense vouchers you can not enter an
                 account code in an account field like you can on a normal
                 register, enable this.
    Bug 795155 - CSV import does not distinguish between deposit and withdrawal
    Bug 795347 - Australian (GMT+10) OFX transactions imported have previous
                 days date
    Bug 795377 - Reads and saves Gnucash 2.6.19 XML file, then can't reread
                 it, due to bad date in old file
    Bug 795389 - Hard to see figures in the budget window
                 The budget view had hard coded black for normal values and
                 dark grey for other values. Changed this so normal values
                 are reset to default color and adjusted the grey based on
                 default color for theme.
    Bug 795405 - All Dates in Price Database Off-By-One After 3.0 Upgrade
    Bug 795446 - On Windows there is a blank tip of the day
                 When the tip_of_the_day.list is created a new line is
                 appended to the list file and on Windows this causes a blank
                 tip so remove the adding of the extra line.
    Bug 795471 - Budget window scrolls edited cell out of site
                  When editing cells that have been revealed on the right by
                  scrolling the window snaps back to the left hiding the cell
                  being edited. This may be due to an underlying gtk issue
                  but these changes fix the issue visually.

Other repairs or enhancements not marked as bugs:
    On Windows the tooltip for saved reports was incorrect
        When the mouse was placed over a saved report description on Windows an
        empty tooltip was displayed. Setup the query tooltip callback so it does
        not display a tooltip for description column.
    Fix crash when loading sql book with posted transactions
    Add ability to recognize and use a pre-compiled libgmock.so.
    html-font: add default font family
        Windows ships with GTK2 in which the default font styles are named
        "Sans" "Sans Bold" "Sans Normal" etc. \ 
There is no "Sans" font in
        Windows; I vote to add a default "Sans-Serif" font-family which is
        valid CSS. This ensures exported reports are shown as intended.
    Several improvements to the Transaction and GST reports.
    csv-impport - Allow empty amount fields
        Treat empty amount fields as 0. This is necessary for example in
        the case the csv import file has both a deposit and a withdrawal
    Remove the set transient parent setting for Reconcile window
        The Reconcile option is already a window so it is not necessary to set
        this value which allows the jump to transaction to work properly.
    Date Format dialog flashes up when file/properties used
        When you select the File/Properties dialog, in the construction of that
        a 'Date Format' dialog flashes up while the date component is moved to
        the properties dialog. Can mainly be seen on Windows so remove the
        visible setting in glade file.
    Prevent throw in gnc-pricedb.
        If a price lookup is given an invalid time64/timespec (i.e. INT64_MAX)
        then just return NULL instead of trying to find the nearest price.
    Set GNC_VCS at build time instead of when making the tarball.
        Because the tarball is always made from a VCS repo.
    If there are no prices in the db, critical errors are flagged
        When dialog transfer is used between two commodities and there are no
        prices in the db a critical error is logged. Test for price object
        being NULL before retrieving the price for the error message.

The following translations are updated: Slovak, Spanish

Known Problems:
    It is not possible to overwrite SQL Databases from within GnuCash, even
        though GnuCash will ask if you want to. Bug 789594
    Several dates, including Accounting Period, are subject to change with
        time zone and daylight-time changes. Bug 791825
    Some HBCI information is not loaded correctly so the first transaction
        download will re-retrieve transactions unless the beginning date is
        set explicitly. Bug 792397.
    The new CSV importer's Price of Shares column doesn't work. Bug 793306
    The new CSV importer's numeric parser can't parse numbers of the form
        x + y/z. Bug 793556.
    Python bindings may not work in some installations because the bindings
        are unable to find the backend modules (libgncmod-backend-dbi and
        libgncmod-backend-xml). Bug 794526
    Get Quotes can be slow if one has a large number of saved prices.
        Bug 794644.
    The Mac localization code can set the wrong encoding for strftime causing
        the register's date picker to label months "Null" in some locales.
        Bug 794807
    On Mac, the File Open dialog will crash if one types anything.
        (This is a Gtk+ bug). Bug 794809
    An open register is not immediately updated when the Since Last Run
        dialog creates transaction splits in the register's account. Bug 794854
    GnuCash asks if one wants to save changes when quitting or opening a file
        even if there's no book open. Bug 794870
    Windows Defender falsly identifies the GnuCash installer as a Trojan.
        Bug 794967
    Some Windows users have trouble using Chinese input methods on the
        Register; other controls work. Bug 795253
    On Microsoft Windows the Tab key does not work in the register if the
        caps-lock key is on. Bug 795294
    GnuCash will crash if one attempts to import a CSV file with more than
        1400 transactions. Bug 795383
    Invalid input into a formula (Debit/Credit) field is inconsistent
        depending on the input. Bug 795614.
   2018-04-29 23:32:09 by Adam Ciarcinski | Files touched by this commit (629) | Package updated
Log message:
revbump for boost-libs update