[GNC] [regression] delete key functionality lost after pasting into a transaction field
Jay Kvam
kvam.jay at gmail.com
Mon Jun 25 11:16:17 EDT 2018
Noticed the following regression since installing 3.2 this morning and have
been able to reproduce it predictably:
After pasting anything into a transaction field—such as description, note,
memo, or value—the delete key no longer works, not only failing to delete
the contents of a field but also triggering a bell as if the user had
attempted to delete an already blank field. This occurs whether or not the
transaction has been saved. The only way to restore delete key
functionality is to close the register and reopen it. That, of course, does
not withstand another paste operation …
Would have reported this as a bug in Bugzilla; however, 3.2 is not yet
available in the Version list, so I’m first posting here.
macOS 10.12.5 “Sierra”
kindly,
Jay
On Mon, Jun 25, 2018 at 6:33 AM, <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Problem with Reports (D)
> 2. GnuCash 3.2 Released (John Ralls)
> 3. Re: CSV to QIF converter for Mobile viking usage reports
> (Bram Mertens)
> 4. Re: Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error (Geert Janssens)
> 5. Problem with Reports (Shelley Salter)
> 6. 3.2 out and no mention here? (randix)
> 7. Re: Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error (Steve Alex)
> 8. Re: 3.2 out and no mention here? (Maf. King)
> 9. Re: Dark theme on Windows (Fross, Michael)
> 10. Re: Dark theme on Windows (Geert Janssens)
> 11. Re: Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error (Geert Janssens)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 24 Jun 2018 21:48:27 -0400
> From: D <sunfish62 at yahoo.com>
> To: Shelley Salter <dalphsea at yahoo.ca>, Gnucash Users
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Problem with Reports
> Message-ID: <32h9luhfw1rmc2mapoy0nswk.1529891307122 at email.android.com>
> Content-Type: text/plain; charset=utf-8
>
> Shelley,
>
> Welcome.
>
> It looks from your example like you have your main accounts in USD, and
> your sub accounts in Canadian dollars. I do not use multiple currencies,
> but I believe that your problem stems from this. Someone who uses multiple
> currencies should be able to give you more specific guidance.
>
> David
>
> On June 24, 2018, at 12:20 PM, Shelley Salter via gnucash-user <
> gnucash-user at gnucash.org> wrote:
>
> Just downloaded the program and thought I would try it out but don't
> understand why the Income Statement is showing Total Revenue and Total
> Expenses as 0?
> Income Statement For Period Covering 01/01/2018 to 12/31/2018
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Revenues Income C$500.00
> $0.00Total Revenue $0.00? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
> ?Expenses Expenses C$50.00 $0.00Total Expenses $0.00Net income for Period
> $0.00
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ------------------------------
>
> Message: 2
> Date: Sun, 24 Jun 2018 20:40:38 -0700
> From: John Ralls <jralls at ceridwen.us>
> To: Gnucash-User <gnucash-user at gnucash.org>
> Cc: gnucash-announce at gnucash.org, gnucash-devel
> <gnucash-devel at gnucash.org>
> Subject: [GNC] GnuCash 3.2 Released
> Message-ID: <BAA61105-5977-4829-A074-38ECCE64F21E at ceridwen.us>
> Content-Type: text/plain; charset=utf-8
>
> The GnuCash development team announces GnuCash 3.2, the second release of
> the 3.x stable release series.
>
> Changes
>
> 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 boxes.
> ? 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 string.
> ? 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 database.
> ? 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
>
> Known Issues
>
> The following are open bug reports new to the 3.x series considered
> significant by the development team:
>
> ? 789594 - Unable to overwrite sqlite3 database file
> ? 791825 - Accounting Period dates (among others) stored with a
> TZ-sensitive time.
> ? 792397 - Incomplete Update to 2.7.x - not all online banking
> data is available.
> ? 793306 - Price is not imported from CSV
> ? 793556 - CSV export/import creates unbalanced transaction for
> fractional price.
> ? 794755 - Commodity Register displays fractional prices
> ? 795383 - Gnucash crashes on import of a 1400-transaction (or
> more) CSV file
> ? 795614 - Unicode handling in amount fields.
> ? 795804 - Extremely slow save
> ? 796054 - Unposting and reposting invoice doubles amounts.
> ? 796084 - Frequent Crashes During Data Entry.
> ? 796100 - Autosave Doesn't Always Work.
> ? 796248 - Editing Scheduled Transaction.
> ? 796474 - Segmentation fault while setting up online banking
> ? 796492 - Wrong calculation of the first occurrence
> ? 796500 - Scalability issue - importing large CSV to large book
> won't finish.
> ? 796520 - Layout overlapping in Income & Expense Chart.
> ? 796537 - Transaction Report cannot sort by "num".
> ? 796579 - Cannot go forward with empty duplicates screen.
> ? 796591 - Crash on keyboard entry in register when not clicking
> or tabbing first.
> ? 796614 - Reconciliation report contains incorrect transactions.
> ? 796656 - GnuCash frequently crashes, usually involving unsaved
> transactions.
>
> Documentation
>
> Concurrent with the release of Gnucash 3.2 we're pleased to also release a
> new version 3.2 of the companion Help and Tutorial and Concepts Guide.
>
> Documentation changes:
>
> ? Bug 796098 - V 3.1 Missing images in Tutorial and Concepts Guide
> in PDF and Online Help pages.
> ? Bug 795980 - Void Reason Has No Visible Purpose.
> 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:
>
> ? 63e5b00c148ed0f7021ebc03e4e70c4a9c549feb3ea49d6c810f2abaaf592452
> gnucash-3.2.tar.bz2
> ? beb028b6933f57a6dad89f0c0a54ffe7b5dd42bbd3f532405f4ffd01cc5eaa5c
> gnucash-3.2.tar.gz
> ? 0e06acfe7a9746eacf5282ba27919625b51c3d51fd548e6a529f78ff759ed70f
> gnucash-3.2.setup.exe
> ? 05e51cf24d0d85b9aef40f90d70ea118ef0cee2dee342af98ca64609524c4b9f
> Gnucash-Intel-3.2-1.dmg
> ? 469a524352a3b0e5308ba68a3c0fac79a501998b29db9c16a714ce879aa9c39c
> gnucash-docs-3.2.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.2.setup.exe
> Download GnuCash for Mac-Intel: https://downloads.sourceforge.
> net/sourceforge/gnucash/Gnucash-Intel-3.2-1.dmg
>
> Github
>
> Download GnuCash for Win32: https://github.com/Gnucash/
> gnucash/releases/download/3.2/gnucash-3.2.setup.exe
> Download GnuCash for Mac-Intel: https://github.com/Gnucash/
> gnucash/releases/download/3.2/Gnucash-Intel-3.2-1.dmg
>
> Getting GnuCash as source code
>
> If you want to compile GnuCash 3.2 for yourself, the source code can be
> downloaded from:
>
> Sourceforge:
> http://downloads.sourceforge.net/sourceforge/gnucash/
> gnucash-3.2.tar.bz2
> http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-3.2.tar.gz
> Github:
> https://github.com/Gnucash/gnucash/releases/download/3.2/
> gnucash-3.2.tar.bz2
> https://github.com/Gnucash/gnucash/releases/download/3.2/
> gnucash-3.2.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.2 for yourself, the
> source code can be downloaded from:
>
> Sourceforge: http://downloads.sourceforge.net/sourceforge/gnucash/
> gnucash-docs-3.2.tar.gz
> GitHub: https://github.com/Gnucash/gnucash/releases/download/3.2/
> gnucash-docs-3.2.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.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 25 Jun 2018 09:22:53 +0200
> From: Bram Mertens <mertensb.mazda at gmail.com>
> To: gti9070h at gmail.com
> Cc: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] CSV to QIF converter for Mobile viking usage
> reports
> Message-ID:
> <CAKxHvy1JyiM4FuaYk53ZyX4wYBH++Z18kzh=tEG3xYhtVqCA8g at mail.
> gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Thanks,
>
> I'll see if I can add it there later today.
>
> Bram
> On Mon, Jun 25, 2018 at 12:45 AM GT-I9070 H <gti9070h at gmail.com> wrote:
> >
> > Hi Bram,
> >
> > It would look better here: https://wiki.gnucash.org/wiki/Published_tools
> >
> > Regards
> >
> > Em dom, 24 de jun de 2018 ?s 12:05, Bram Mertens <
> mertensb.mazda at gmail.com> escreveu:
> >>
> >> Hi,
> >>
> >> I have created a simple python script that creates a QIF file from the
> >> usage report of Mobile Vikings.
> >> Mobile Vikings a Mobile Virtual Network Operator active in Belgium.
> >>
> >> The script and a README are available at
> >> https://gitlab.com/m8ram/vikingcsv2qif .
> >>
> >> The target audience is probably quite small: GnuCash users in Belgium
> >> with an account with this operator but perhaps it can serve as
> >> inspiration for other similar uses.
> >>
> >> Feel free to send me remarks/suggestions and use the code.
> >>
> >> Hope this helps
> >>
> >> Bram
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
>
>
> ------------------------------
>
> Message: 4
> Date: Mon, 25 Jun 2018 10:40:02 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error
> Message-ID: <3076834.kXSsFTP8as at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="us-ascii"
>
> Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
> > I've been trying to set up a procedure where two people can access our
> XML
> > file located on a file server and of course ran into problems and know
> there
> > are other possible problem (file marked open if you loose the network -
> yes
> > I know its single user)
> >
> > My tests last week seemed to work, but I've been cautious. There may be
> > potential problems in that I'm on a Mac and the other user will be on
> > Windows 10. Then the file server is a debian server.
> >
> > I noticed that the Windows version 3.x and I was using 2.6.4. Also
> noticed
> > that the windows version had Postgres option. I download the new version
> > using brew cask wanting to try postgres for my report system,
> >
> > I've been using a procedure for years that now seems broken.
> >
> > I update the main book on a Mac (using xml). A few times a month I do a
> > "Save As" and save off an sqlite3 version in another folder inside my
> > GnuCash folder. I immediately open the xml version and quit.
> >
> > I then run a bash script to backup the folder(rsync) to the debian
> server.
> >
> > The sqlite3 file is used by a Rails server to produce reports I've
> > developed.
> >
> > I figured we'd use a modified procedure in that the updates would use the
> > XML version on the debian server (maybe a script to check dates or see if
> > file is open). I'd also put in a cron task to backup the folder to
> another
> > offsite server.
> >
> > Since I was on the server, when I did my "Save As", it was in the same
> file
> > system. I alway just did the save as over the existing version since its
> > just a read only file ( just confirm overwrite message)
> >
> > When I did that with 3.x, after confirming overwrite, I'd get an error
> > message saying it could complete because of data corruption.
> >
> This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
> If you remove the existing sqlite file before running a Save As, do you
> still
> get the error message about data corruption ?
>
> > Don't know if this is 3.x problem or not. Switched back to 2.6 and it
> > worked, even working on the server version.
> >
> > Before I switched back to 2.6, I did the save as on my mac and copied the
> > file the the server, I haven't verified this but my report system broke.
> I
> > got no errors but a simple checkbook register had a balance but do ledger
> > lines.
>
> We had to make some changes to the database schema that may affect your
> direct
> access to the book.
>
> A few that come to mind:
> - the field format to store dates has changed (affecting many tables)
> - some parts of gnucash now store their slots in flat format instead of
> hierarchically. If you're not using the slots in your custom report, this
> won't affect you
>
> Regards,
>
> Geert
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 25 Jun 2018 10:28:39 +0000 (UTC)
> From: Shelley Salter <dalphsea at yahoo.ca>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Problem with Reports
> Message-ID: <313305940.1903405.1529922519010 at mail.yahoo.com>
> Content-Type: text/plain; charset=UTF-8
>
> Thank you for your help, I did have two currencies and now have fixed the
> problem.Shelley
>
> ------------------------------
>
> Message: 6
> Date: Mon, 25 Jun 2018 03:39:16 -0700 (MST)
> From: randix <butterandsalt at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: [GNC] 3.2 out and no mention here?
> Message-ID: <1529923156592-0.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> or has it been out for a while and i'm just not paying attention?
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 25 Jun 2018 06:20:10 -0500
> From: Steve Alex <salex at mac.com>
> To: Geert Janssens <geert.gnucash at kobaltwit.be>,
> gnucash-user at gnucash.org
> Subject: Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error
> Message-ID: <99E2C808-F118-41ED-9814-D67C94D7DE73 at mac.com>
> Content-Type: text/plain; charset=utf-8
>
>
> > On Jun 25, 2018, at 3:40 AM, Geert Janssens <geert.gnucash at kobaltwit.be>
> wrote:
> >
> > Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
> >> I've been trying to set up a procedure where two people can access our
> XML
> >> file located on a file server and of course ran into problems and know
> there
> >> are other possible problem (file marked open if you loose the network -
> yes
> >> I know its single user)
> >>
> >> My tests last week seemed to work, but I've been cautious. There may be
> >> potential problems in that I'm on a Mac and the other user will be on
> >> Windows 10. Then the file server is a debian server.
> >>
> >> I noticed that the Windows version 3.x and I was using 2.6.4. Also
> noticed
> >> that the windows version had Postgres option. I download the new version
> >> using brew cask wanting to try postgres for my report system,
> >>
> >> I've been using a procedure for years that now seems broken.
> >>
> >> I update the main book on a Mac (using xml). A few times a month I do a
> >> "Save As" and save off an sqlite3 version in another folder inside my
> >> GnuCash folder. I immediately open the xml version and quit.
> >>
> >> I then run a bash script to backup the folder(rsync) to the debian
> server.
> >>
> >> The sqlite3 file is used by a Rails server to produce reports I've
> >> developed.
> >>
> >> I figured we'd use a modified procedure in that the updates would use
> the
> >> XML version on the debian server (maybe a script to check dates or see
> if
> >> file is open). I'd also put in a cron task to backup the folder to
> another
> >> offsite server.
> >>
> >> Since I was on the server, when I did my "Save As", it was in the same
> file
> >> system. I alway just did the save as over the existing version since its
> >> just a read only file ( just confirm overwrite message)
> >>
> >> When I did that with 3.x, after confirming overwrite, I'd get an error
> >> message saying it could complete because of data corruption.
> >>
> > This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
> > If you remove the existing sqlite file before running a Save As, do you
> still
> > get the error message about data corruption ?
>
> I just saw that in the release 3.2 message, then got this reply.
>
> I don?t think so. I think I set a different file name (or different
> folder) and there was no error. I think thats when I discovered my report
> system broke - most likely by the date format change mentioned below.
> >
> >> Don't know if this is 3.x problem or not. Switched back to 2.6 and it
> >> worked, even working on the server version.
> >>
> >> Before I switched back to 2.6, I did the save as on my mac and copied
> the
> >> file the the server, I haven't verified this but my report system
> broke. I
> >> got no errors but a simple checkbook register had a balance but do
> ledger
> >> lines.
> >
> > We had to make some changes to the database schema that may affect your
> direct
> > access to the book.
> >
> > A few that come to mind:
> > - the field format to store dates has changed (affecting many tables)
>
> That is most likely it.
>
> What did dates change to? Just another version of a timestamp (and not
> YYYYMMDDHHMM ? I have lots of code (functions) that is basically taking a
> ruby date and doing something like;
> def self.month_transactions(date)
> month = Vfwcash.yyyymm(date) # just date parser that returns string
> in format YYYYMM
> trans = Tran.where('transactions.post_date BETWEEN ? and
> ?',month+"00",month+"32").order(:post_date,:num)
> end
>
> > - some parts of gnucash now store their slots in flat format instead of
> > hierarchically. If you're not using the slots in your custom report,
> this
> > won?t affect you
>
> Don?t use slots, just Accounts, Splits and Transactions.
>
>
> >
> > Regards,
> >
> > Geert
> >
> >
>
>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 25 Jun 2018 12:25:59 +0100
> From: "Maf. King" <maf at chilwell.net>
> To: gnucash-user at gnucash.org
> Cc: randix <butterandsalt at gmail.com>
> Subject: Re: [GNC] 3.2 out and no mention here?
> Message-ID: <1704239.tq6n5oBUWm at janus>
> Content-Type: text/plain; charset="UTF-8"
>
> On Monday, 25 June 2018 11:39:16 BST randix wrote:
> > or has it been out for a while and i'm just not paying attention?
> >
>
> Announced on the list about 8 hours ago by John Ralls.
>
> (Thanks John & devs!)
>
> Maf.
>
>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Mon, 25 Jun 2018 07:32:12 -0500
> From: "Fross, Michael" <michael at fross.org>
> To: Geert Janssens <geert.gnucash at kobaltwit.be>
> Cc: Gnucash-User <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Dark theme on Windows
> Message-ID:
> <CAMD2Dfv0S6bOxFGeNecdjhZ6NEhTAMthoC1ALwsZHPY4urOqmA at mail.
> gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hello Geert.
>
> This worked for me in Windows (although I used Adwaita-Slim instead of
> Adwaita.)
>
> I prefer the dark themes, but in the registers, the text is black on "dark"
> and very hard to read. I know I can change around the row colors, but I
> don't know how to change the text color. Any idea?
>
> Michael
>
> On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens <
> geert.gnucash at kobaltwit.be>
> wrote:
>
> > I have come across the following combination of settings to enable a
> > default
> > dark theme on linux. Creating a file settings.ini in
> $HOME/.config/gtk-3.0
> > with this contents
> >
> > [Settings]
> > gtk-application-prefer-dark-theme=true
> > gtk-theme-name=Adwaita
> >
> > gives me the default Adwaita-dark theme. I would be interested to know if
> > this
> > also works on Windows (the file should be created in
> > %LOCALAPPDATA%\gtk-3.0
> > instead).
> >
> > If so this could be added to our wiki here:
> > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes
> >
> > Can someone run this experiment and report back ?
> >
> > Thanks,
> >
> > Geert
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> ------------------------------
>
> Message: 10
> Date: Mon, 25 Jun 2018 15:26:19 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: "Fross, Michael" <michael at fross.org>
> Cc: Gnucash-User <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Dark theme on Windows
> Message-ID: <1658695.tl3ZF1Ndiv at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="us-ascii"
>
> Thanks for the followup Michael.
>
> Normally GnuCash should detect a dark theme and adjust text color
> accordingly.
> If it doesn't, that's a bug then. Can you file this in bugzilla ?
>
> Thanks,
>
> Geert
>
> Op maandag 25 juni 2018 14:32:12 CEST schreef Fross, Michael:
> > Hello Geert.
> >
> > This worked for me in Windows (although I used Adwaita-Slim instead of
> > Adwaita.)
> >
> > I prefer the dark themes, but in the registers, the text is black on
> "dark"
> > and very hard to read. I know I can change around the row colors, but I
> > don't know how to change the text color. Any idea?
> >
> > Michael
> >
> > On Sun, Jun 24, 2018 at 5:14 PM, Geert Janssens <
> geert.gnucash at kobaltwit.be>
> > wrote:
> > > I have come across the following combination of settings to enable a
> > > default
> > > dark theme on linux. Creating a file settings.ini in
> $HOME/.config/gtk-3.0
> > > with this contents
> > >
> > > [Settings]
> > > gtk-application-prefer-dark-theme=true
> > > gtk-theme-name=Adwaita
> > >
> > > gives me the default Adwaita-dark theme. I would be interested to know
> if
> > > this
> > > also works on Windows (the file should be created in
> > > %LOCALAPPDATA%\gtk-3.0
> > > instead).
> > >
> > > If so this could be added to our wiki here:
> > > https://wiki.gnucash.org/wiki/GTK3#Dark_Themes
> > >
> > > Can someone run this experiment and report back ?
> > >
> > > Thanks,
> > >
> > > Geert
> > >
> > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
>
>
>
>
>
>
> ------------------------------
>
> Message: 11
> Date: Mon, 25 Jun 2018 15:33:27 +0200
> From: Geert Janssens <geert.gnucash at kobaltwit.be>
> To: Steve Alex <salex at mac.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Upgrade to 3.x Save As (sqlite3) failing with data
> corruption error
> Message-ID: <11773434.ttt3TNkjIO at legolas.kobaltwit.lan>
> Content-Type: text/plain; charset="UTF-8"
>
> Op maandag 25 juni 2018 13:20:10 CEST schreef Steve Alex:
> > > On Jun 25, 2018, at 3:40 AM, Geert Janssens <
> geert.gnucash at kobaltwit.be>
> > > wrote:>
> > > Op maandag 25 juni 2018 01:38:35 CEST schreef salex:
> > >> I've been trying to set up a procedure where two people can access our
> > >> XML
> > >> file located on a file server and of course ran into problems and know
> > >> there are other possible problem (file marked open if you loose the
> > >> network - yes I know its single user)
> > >>
> > >> My tests last week seemed to work, but I've been cautious. There may
> be
> > >> potential problems in that I'm on a Mac and the other user will be on
> > >> Windows 10. Then the file server is a debian server.
> > >>
> > >> I noticed that the Windows version 3.x and I was using 2.6.4. Also
> > >> noticed
> > >> that the windows version had Postgres option. I download the new
> version
> > >> using brew cask wanting to try postgres for my report system,
> > >>
> > >> I've been using a procedure for years that now seems broken.
> > >>
> > >> I update the main book on a Mac (using xml). A few times a month I do
> a
> > >> "Save As" and save off an sqlite3 version in another folder inside my
> > >> GnuCash folder. I immediately open the xml version and quit.
> > >>
> > >> I then run a bash script to backup the folder(rsync) to the debian
> > >> server.
> > >>
> > >> The sqlite3 file is used by a Rails server to produce reports I've
> > >> developed.
> > >>
> > >> I figured we'd use a modified procedure in that the updates would use
> the
> > >> XML version on the debian server (maybe a script to check dates or
> see if
> > >> file is open). I'd also put in a cron task to backup the folder to
> > >> another
> > >> offsite server.
> > >>
> > >> Since I was on the server, when I did my "Save As", it was in the same
> > >> file
> > >> system. I alway just did the save as over the existing version since
> its
> > >> just a read only file ( just confirm overwrite message)
> > >>
> > >> When I did that with 3.x, after confirming overwrite, I'd get an error
> > >> message saying it could complete because of data corruption.
> > >
> > > This sounds like https://bugzilla.gnome.org/show_bug.cgi?id=789594
> > > If you remove the existing sqlite file before running a Save As, do you
> > > still get the error message about data corruption ?
> >
> > I just saw that in the release 3.2 message, then got this reply.
> >
> > I don?t think so. I think I set a different file name (or different
> folder)
> > and there was no error. I think thats when I discovered my report system
> > broke - most likely by the date format change mentioned below.
> > >> Don't know if this is 3.x problem or not. Switched back to 2.6 and it
> > >> worked, even working on the server version.
> > >>
> > >> Before I switched back to 2.6, I did the save as on my mac and copied
> the
> > >> file the the server, I haven't verified this but my report system
> broke.
> > >> I
> > >> got no errors but a simple checkbook register had a balance but do
> ledger
> > >> lines.
> > >
> > > We had to make some changes to the database schema that may affect your
> > > direct access to the book.
> > >
> > > A few that come to mind:
> > > - the field format to store dates has changed (affecting many tables)
> >
> > That is most likely it.
> >
> > What did dates change to? Just another version of a timestamp (and not
> > YYYYMMDDHHMM ? I have lots of code (functions) that is basically taking a
> > ruby date and doing something like; def self.month_transactions(date)
> > month = Vfwcash.yyyymm(date) # just date parser that returns
> string in
> > format YYYYMM trans = Tran.where('transactions.post_date BETWEEN ? and
> > ?',month+"00",month+"32").order(:post_date,:num) end
>
> I believe the change was to
> YYYY-MM-DD HH:MM:SS
> Though I'm not sure. I haven't done this part and I'm not really using the
> SQL
> backends.
>
> Regards,
>
> Geert
>
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 183, Issue 48
> *********************************************
>
More information about the gnucash-user
mailing list