GnuCash 3.1 Released

The GnuCash development team announces GnuCash 3.1, the second release of the 3.x stable release series.

Changes

Between 3.0 and 3.1, the following bugfixes were accomplished:

• 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 794976 - Context Menu looks like it's from GTK, no GnuCash functions in it.
• 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 MariaDB.
• 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 value.
• 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.

The Following fixes and improvemts were not associated with bug reports:

• 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 column.
• 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 Issues

The following are open bug reports new to the 3.x series considered significant by the development team:

• 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
• The scroll wheel can't be used to switch tabs in the gnucash gui. 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.

Documentation

Concurrent with the release of Gnucash 3.1 we're pleased to also release a new version 3.1 of the companion Help and Tutorial and Concepts Guide.

• Update supported platforms for version 3.x.

Getting GnuCash for Windows and MacOS X

GnuCash is provided for both Microsoft Windows XP® and later and MacOS X 10.9 (Mavericks)® and later in pre-built, all-in-one packages. An installer is provided for Microsoft Windows® while the MacOS X® package is a disk image containing a drag-and-drop application bundle. Links may be found at the top of this announcement.

The SHA256 Hashes for the downloadable files are:

• a1ef66cec3b8b74b7b8bfe791ff12456796a69cc004427e8d9205b6872bdd261  gnucash-3.1.tar.bz2
• bcd2a27ad36f04c2cdb24c86a2e47da1d96c87ee5eff6b35893b33b0b18a53c3  gnucash-3.1.tar.gz
• 426e9a8d0f6542486052733171aa33700da061b0af23101b2b42dac141e6fafe  gnucash-3.1-2.setup.exe
• 777e532a80c8061c352bf518e6948155af5e408b148df381a1e6cd85b13d66e9  Gnucash-Intel-3.1-3.dmg
• 52852ed90ccdf27b76deb1b4095b9e457c807c5598a2eea31e00560bb0c3531c  gnucash-docs-3.1.tar.gz

Getting GnuCash as source code

If you want to compile GnuCash 3.1 for yourself, the source code can be downloaded using the link at the top of this announcement. WARNING Do not try to use the github-generated files labelled "Source Code". They have not been processed with swig and will not build.

You can also checkout the sources directly from this git repository as described here.

To compile GnuCash from the source code by yourself, you will need at least Gtk+ 3.10, Guile 2.0, Boost 1.54, WebKitGtk 2.4, and GoogleTest 1.7.0. In addition you will need SWIG 2.0.10 if compiling from git. Please consult the README.dependencies file in the sources for the exact list of dependencies and versions.

Getting the documentation

The documentation is available at Documentation page of the GnuCash website. The 3.1 documentation can be found under "GnuCash v3 (current stable release)" in multiple languages both for reading online and for download in pdf, epub, and mobi formats. The documentation is included in the MacOS and Windows application bundles.

If you want to compile the GnuCash Documentation 3.1 for yourself, the source code can be downloaded from the link at the top of this notice.

You can also checkout the sources directly from the git repository as described here.

About the Program

GnuCash is a free, open source accounting program released under the GNU General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, Mac OSX and Microsoft Windows. Programming on GnuCash began in 1997, and its first stable release was in 1998.