For anyone not watching this bug on Bugzilla and using sqlite, there is
potential data loss involved when moving between sqlite and XML formats. Please
see the bug for more info. (reported earlier in the thread)
Regards,
Adrien
> On May 23, 2018, at 5:54 PM, Randy Orrison
Thanks for telling me what to look for: I've used DB Browser for SQLite (
http://sqlitebrowser.org/) and there are plenty of records in the slots
table with name=notes. Looks like it's just a display issue, so I'll hope
they re-appear when the bug is fixed.
Randy
On 23 May 2018 at 23:39, Adrien
For that sqlite search, look at the ‘slots’ table, specifically find all rows
that have ’notes’ as the ’name’ value and then look at the ’string_val’ field
for the actual note text.
The following query would return all data in a row that contained a note with
actual text. (but not return rows
First, be sure to view the newer file with an sqlite viewer and verify the
notes are indeed missing. There are several free viewers around the web,
including a Firefox plugin if that’s what you use.(not sure if Chrome/Chromium
has one)
If they are indeed gone, short of figuring out how to pull
Hi,
Thanks for the confirmation. I have created bug
https://bugzilla.gnome.org/show_bug.cgi?id=796369.
Unfortunately, saving as XML and reopening the file did not restore any of
my missing notes. Newly created notes in the XML file are being saved and
display correctly after re-opening the
Randy,
The good news is that your notes are probably still there.
But you did find a bug.
I was using sqlite3 before the 3.x jump and I’ve been testing it back and forth
with XML but there are still some show stoppers for me. (this would be a new
one on the list) So I had an sqlite3 copy of
I've just noticed in Version 3.1 that all my Notes have vanished from the
register. I use GnuCash with the register set to Basic Ledger and Double
Line Mode, so I always see the Description and Notes fields. I've noticed
today that all of the Notes fields are blank, including some that I know
