GnuCash 3.1 released
The GnuCash development team proudly announces GnuCash 3.1, the second release
in the 3.x stable 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 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
* 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.
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.
Documentation changes:
* 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.
The SHA256 Hashes for the downloadable files are:
48f72fb3bc2d92ca23e5a26277ddd6e6311b304c84a1a80b72ac8dc2dfe54edc
gnucash-3.1.tar.bz2
90d849fb900613ea962b1ea9cc7e5d313e8e4c6d1218dacc3425e1bb57201471
gnucash-3.1.tar.gz
699070d8e895e80f1d1042b506dfe38be1707493eeea856987e5b04e198bf5e2
gnucash-3.1.setup.exe
5eeb24f4578247896e24e82ca77b5d4630c2cba3b0b4b138cf4aee1187c8a0ff
Gnucash-Intel-3.1-2.dmg
52852ed90ccdf27b76deb1b4095b9e457c807c5598a2eea31e00560bb0c3531c
gnucash-docs-3.1.tar.gz
Getting GnuCash for Windows and MacOS
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.
SourceForge:
Download GnuCash for Win32:
https://downloads.sourceforge.net/sourceforge/gnucash/gnucash-3.1.setup.exe
Download GnuCash for Mac-Intel:
https://downloads.sourceforge.net/sourceforge/gnucash/Gnucash-Intel-3.1-1.dmg
Github
Download GnuCash for Win32:
https://github.com/Gnucash/gnucash/releases/download/3.1/gnucash-3.1.setup.exe
Download GnuCash for Mac-Intel:
https://github.com/Gnucash/gnucash/releases/download/3.1/Gnucash-Intel-3.1-1.dmg
Getting GnuCash as source code
If you want to compile GnuCash 3.1 for yourself, the source code can be
downloaded from:
Sourceforge:
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-3.1.tar.bz2
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-3.1.tar.gz
Github:
https://github.com/Gnucash/gnucash/releases/download/3.1/gnucash-3.1.tar.bz2
https://github.com/Gnucash/gnucash/releases/download/3.1/gnucash-3.1.tar.gz
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: git clone
https://github.com/Gnucash/gnucash.
Please consult the README.dependencies file in the sources for the required
dependencies and versions needed to build GnuCash from source. Additional
information on building GnuCash may be found at
https://wiki.gnucash.org/wiki/Building.
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.
If you want to compile the GnuCash Documentation 3.1 for yourself, the source
code can be downloaded from:
Sourceforge:
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-docs-3.1.tar.gz
GitHub:
https://github.com/Gnucash/gnucash/releases/download/3.1/gnucash-docs-3.1.tar.gz
You can also checkout the sources directly from the git repository as
described at https://wiki.gnucash.org/wiki/Git.
Detailed instructions for building GnuCash may be found at
https://wiki.gnucash.org/wiki/Building and for the Documentation at
https://wiki.gnucash.org/wiki/Initializing_Documentation_Build_Environment.
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.