CVS commit: pkgsrc/finance/gnucash

["Thomas Klausner" <wiz%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   wiz
Date:           Mon Apr 30 06:06:07 UTC 2018

Modified Files:
        pkgsrc/finance/gnucash: Makefile PLIST distinfo

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
                 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.

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
        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 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.


To generate a diff of this commit:
cvs rdiff -u -r1.258 -r1.259 pkgsrc/finance/gnucash/Makefile
cvs rdiff -u -r1.66 -r1.67 pkgsrc/finance/gnucash/PLIST
cvs rdiff -u -r1.85 -r1.86 pkgsrc/finance/gnucash/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/finance/gnucash/Makefile
diff -u pkgsrc/finance/gnucash/Makefile:1.258 pkgsrc/finance/gnucash/Makefile:1.259
--- pkgsrc/finance/gnucash/Makefile:1.258       Sun Apr 29 21:31:35 2018
+++ pkgsrc/finance/gnucash/Makefile     Mon Apr 30 06:06:07 2018
@@ -1,15 +1,9 @@
-# $NetBSD: Makefile,v 1.258 2018/04/29 21:31:35 adam Exp $
+# $NetBSD: Makefile,v 1.259 2018/04/30 06:06:07 wiz Exp $
 
-DISTNAME=              gnucash-3.0
-PKGREVISION=           3
+DISTNAME=              gnucash-3.1
 CATEGORIES=            finance
 MASTER_SITES=          ${MASTER_SITE_SOURCEFORGE:=gnucash/}
 EXTRACT_SUFX=          .tar.bz2
-# take copy mirrored on ftp.NetBSD.org for devel/googletest
-# for better DISTNAME
-# depending on googletest package is not sufficient since not all
-# files that are used are installed
-DISTFILES=             ${DISTNAME}${EXTRACT_SUFX} googletest-1.8.0.tar.gz
 
 MAINTAINER=            wiz%NetBSD.org@localhost
 HOMEPAGE=              http://www.gnucash.org/
@@ -31,14 +25,14 @@ USE_TOOLS+=         perl:run pkg-config
 # remove when using ninja
 USE_TOOLS+=            gmake
 
+# build failure in test-tx_import and a couple test failures
+# https://bugzilla.gnome.org/show_bug.cgi?id=795251
 TEST_TARGET=           check
 
 LDFLAGS+=              ${COMPILER_RPATH_FLAG}${PREFIX}/lib/gnucash
 CXXFLAGS+=             -Wno-deprecated-declarations
 
 MAKE_ENV+=             GUILE_AUTO_COMPILE=0
-CMAKE_ARGS+=           -DGMOCK_ROOT=${WRKDIR}/googletest-release-1.8.0/googlemock
-CMAKE_ARGS+=           -DGTEST_ROOT=${WRKDIR}/googletest-release-1.8.0/googletest
 CMAKE_ARGS+=           -DWITH_AQBANKING=OFF
 CMAKE_ARGS+=           -DPERL_EXECUTABLE=${PERL5}
 CMAKE_ARGS+=           -DCOMPILE_GSCHEMAS=OFF
@@ -72,6 +66,7 @@ BUILDLINK_API_DEPENDS.glib2+= glib2>=2.4
 BUILDLINK_API_DEPENDS.boost-headers+=   boost-headers>=1.64.0nb3
 .include "../../devel/boost-headers/buildlink3.mk"
 .include "../../devel/boost-libs/buildlink3.mk"
+.include "../../devel/googletest/buildlink3.mk"
 .include "../../devel/swig2/buildlink3.mk"
 .include "../../graphics/hicolor-icon-theme/buildlink3.mk"
 .include "../../graphics/gdk-pixbuf2/buildlink3.mk"

Index: pkgsrc/finance/gnucash/PLIST
diff -u pkgsrc/finance/gnucash/PLIST:1.66 pkgsrc/finance/gnucash/PLIST:1.67
--- pkgsrc/finance/gnucash/PLIST:1.66   Mon Apr  9 08:47:35 2018
+++ pkgsrc/finance/gnucash/PLIST        Mon Apr 30 06:06:07 2018
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.66 2018/04/09 08:47:35 wiz Exp $
+@comment $NetBSD: PLIST,v 1.67 2018/04/30 06:06:07 wiz Exp $
 bin/gnc-fq-check
 bin/gnc-fq-dump
 bin/gnc-fq-helper
@@ -369,7 +369,6 @@ lib/gnucash/scm/ccache/2.2/html-acct-tab
 lib/gnucash/scm/ccache/2.2/html-barchart.go
 lib/gnucash/scm/ccache/2.2/html-document.go
 lib/gnucash/scm/ccache/2.2/html-fonts.go
-lib/gnucash/scm/ccache/2.2/html-jqplot.go
 lib/gnucash/scm/ccache/2.2/html-linechart.go
 lib/gnucash/scm/ccache/2.2/html-piechart.go
 lib/gnucash/scm/ccache/2.2/html-scatter.go
@@ -1134,7 +1133,6 @@ share/gnucash/scm/html-acct-table.scm
 share/gnucash/scm/html-barchart.scm
 share/gnucash/scm/html-document.scm
 share/gnucash/scm/html-fonts.scm
-share/gnucash/scm/html-jqplot.scm
 share/gnucash/scm/html-linechart.scm
 share/gnucash/scm/html-piechart.scm
 share/gnucash/scm/html-scatter.scm

Index: pkgsrc/finance/gnucash/distinfo
diff -u pkgsrc/finance/gnucash/distinfo:1.85 pkgsrc/finance/gnucash/distinfo:1.86
--- pkgsrc/finance/gnucash/distinfo:1.85        Mon Apr  9 08:47:35 2018
+++ pkgsrc/finance/gnucash/distinfo     Mon Apr 30 06:06:07 2018
@@ -1,10 +1,6 @@
-$NetBSD: distinfo,v 1.85 2018/04/09 08:47:35 wiz Exp $
+$NetBSD: distinfo,v 1.86 2018/04/30 06:06:07 wiz Exp $
 
-SHA1 (gnucash-3.0.tar.bz2) = a575e853668b93b34dcd94f0ef0d1fee25b0165f
-RMD160 (gnucash-3.0.tar.bz2) = d25619d60034fa411cbc58b4ffe0ac1a807f5f12
-SHA512 (gnucash-3.0.tar.bz2) = 5ec13b8abe1520a7e614ceeca4c41d5dba3ebae4ec965918584963022ceb5cb3b85862289a85a72767db74a0c735214a78342a53c37e6da939ff850538174a87
-Size (gnucash-3.0.tar.bz2) = 13366724 bytes
-SHA1 (googletest-1.8.0.tar.gz) = e7e646a6204638fe8e87e165292b8dd9cd4c36ed
-RMD160 (googletest-1.8.0.tar.gz) = b0a9e48874df3291a261ed85a0c0a4d677b01dc1
-SHA512 (googletest-1.8.0.tar.gz) = 1dbece324473e53a83a60601b02c92c089f5d314761351974e097b2cf4d24af4296f9eb8653b6b03b1e363d9c5f793897acae1f0c7ac40149216035c4d395d9d
-Size (googletest-1.8.0.tar.gz) = 1281617 bytes
+SHA1 (gnucash-3.1.tar.bz2) = db4e266337ef83eae451d284cb21482db5406f4a
+RMD160 (gnucash-3.1.tar.bz2) = 706d574f6050c49e08ff5bd9300fc416050ed976
+SHA512 (gnucash-3.1.tar.bz2) = 1ca28c042e8d1a25ea29cba73a3f694b40b4db3bbb90a42c0b4d3a6b41cc63e42152406fd95bef6328d382a7ede2d9848486653f704595b24d6bbfafd3451c0c
+Size (gnucash-3.1.tar.bz2) = 13374489 bytes