[GNC] Canceling QIF Import Erases ALL Transactions

2020-03-21 Thread Eric H. Bowen via gnucash-user 
Yesterday I ran into this...I was attempting a .QIF import of 
transactions from my credit card company. The import seemed to progress 
normally, up until the "Match Transactions" stage. When it got there, 
every single one of the transactions which I had entered over the past 
2+ years appeared in the list. I hit the cancel button in the requester, 
got the "busy" icon...and when Gnucash resumed, about ten minutes later, 
every one of my transactions in every account had vanished (with the 
sole exceptions of customer invoices and vendor bills)!


I did have a fairly recent backup file available, so I restored to that 
and tried the import again. The same thing happened a second time.


My NAS keeps track of file history and automatically saves the most 
recent versions every twenty minutes or so, so I do have versions from 
before and after the failed import saved (to a new file under a new 
name) as well as all of my log files. At the time of the import I was 
running Build ID: 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt 
machine with AMD FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard 
and using the SQLite3 backend.


I opened a Bugzilla account and reported this (Bug 797651), but as 
reconstructing this may mean sharing my personal financial data I 
restricted the view access to the developer list. I have reconstructed 
my working account file from my backup, so there's been no loss of 
critical data. I'm sharing this for visibility and to ask if there is 
any additional information I should provide in the bug report to 
facilitate a permanent resolution to this problem. Thanks for any 
adviceEric.


___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Canceling QIF Import Erases ALL Transactions

2020-03-21 Thread John Ralls 



> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user 
>  wrote:
> 
> Yesterday I ran into this...I was attempting a .QIF import of transactions 
> from my credit card company. The import seemed to progress normally, up until 
> the "Match Transactions" stage. When it got there, every single one of the 
> transactions which I had entered over the past 2+ years appeared in the list. 
> I hit the cancel button in the requester, got the "busy" icon...and when 
> Gnucash resumed, about ten minutes later, every one of my transactions in 
> every account had vanished (with the sole exceptions of customer invoices and 
> vendor bills)!
> 
> I did have a fairly recent backup file available, so I restored to that and 
> tried the import again. The same thing happened a second time.
> 
> My NAS keeps track of file history and automatically saves the most recent 
> versions every twenty minutes or so, so I do have versions from before and 
> after the failed import saved (to a new file under a new name) as well as all 
> of my log files. At the time of the import I was running Build ID: 
> 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt machine with AMD 
> FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard and using the SQLite3 
> backend.
> 
> I opened a Bugzilla account and reported this (Bug 797651), but as 
> reconstructing this may mean sharing my personal financial data I restricted 
> the view access to the developer list. I have reconstructed my working 
> account file from my backup, so there's been no loss of critical data. I'm 
> sharing this for visibility and to ask if there is any additional information 
> I should provide in the bug report to facilitate a permanent resolution to 
> this problem. Thanks for any adviceEric.

Chris has already responded to you on the bug report and will ask there for any 
additional information he needs.

A general note: I wouldn't trust the view access settings to protect anything, 
it's at best security-by-obscurity. If one of us decides he needs to look at 
your book he'll provide a direct email address to send it to.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Canceling QIF Import Erases ALL Transactions

2020-03-21 Thread Eric H. Bowen via gnucash-user 
I understand about security; I'm going to upload my GPG public key to
the bug report (and it should be attached to this email reply) and I ask
that any request which may involve personal data be encrypted
accordingly both ways.


Eric H. Bowen
e...@ehbowen.net 
On 3/21/2020 11:20 AM, John Ralls wrote:
>
>> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user 
>>  wrote:
>>
>> Yesterday I ran into this...I was attempting a .QIF import of transactions 
>> from my credit card company. The import seemed to progress normally, up 
>> until the "Match Transactions" stage. When it got there, every single one of 
>> the transactions which I had entered over the past 2+ years appeared in the 
>> list. I hit the cancel button in the requester, got the "busy" icon...and 
>> when Gnucash resumed, about ten minutes later, every one of my transactions 
>> in every account had vanished (with the sole exceptions of customer invoices 
>> and vendor bills)!
>>
>> I did have a fairly recent backup file available, so I restored to that and 
>> tried the import again. The same thing happened a second time.
>>
>> My NAS keeps track of file history and automatically saves the most recent 
>> versions every twenty minutes or so, so I do have versions from before and 
>> after the failed import saved (to a new file under a new name) as well as 
>> all of my log files. At the time of the import I was running Build ID: 
>> 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt machine with AMD 
>> FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard and using the SQLite3 
>> backend.
>>
>> I opened a Bugzilla account and reported this (Bug 797651), but as 
>> reconstructing this may mean sharing my personal financial data I restricted 
>> the view access to the developer list. I have reconstructed my working 
>> account file from my backup, so there's been no loss of critical data. I'm 
>> sharing this for visibility and to ask if there is any additional 
>> information I should provide in the bug report to facilitate a permanent 
>> resolution to this problem. Thanks for any adviceEric.
> Chris has already responded to you on the bug report and will ask there for 
> any additional information he needs.
>
> A general note: I wouldn't trust the view access settings to protect 
> anything, it's at best security-by-obscurity. If one of us decides he needs 
> to look at your book he'll provide a direct email address to send it to.
>
> Regards,
> John Ralls
>


0x0FC9F7C5EEE79F42.asc
Description: application/pgp-keys


smime.p7s
Description: S/MIME Cryptographic Signature
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Canceling QIF Import Erases ALL Transactions

2020-03-21 Thread David Carlson 
Eric,

You just published your GPG public key to the entire user group.



On Sat, Mar 21, 2020 at 11:38 AM Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I understand about security; I'm going to upload my GPG public key to
> the bug report (and it should be attached to this email reply) and I ask
> that any request which may involve personal data be encrypted
> accordingly both ways.
>
>
> Eric H. Bowen
> e...@ehbowen.net 
> On 3/21/2020 11:20 AM, John Ralls wrote:
> >
> >> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >>
> >> Yesterday I ran into this...I was attempting a .QIF import of
> transactions from my credit card company. The import seemed to progress
> normally, up until the "Match Transactions" stage. When it got there, every
> single one of the transactions which I had entered over the past 2+ years
> appeared in the list. I hit the cancel button in the requester, got the
> "busy" icon...and when Gnucash resumed, about ten minutes later, every one
> of my transactions in every account had vanished (with the sole exceptions
> of customer invoices and vendor bills)!
> >>
> >> I did have a fairly recent backup file available, so I restored to that
> and tried the import again. The same thing happened a second time.
> >>
> >> My NAS keeps track of file history and automatically saves the most
> recent versions every twenty minutes or so, so I do have versions from
> before and after the failed import saved (to a new file under a new name)
> as well as all of my log files. At the time of the import I was running
> Build ID: 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt machine
> with AMD FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard and using
> the SQLite3 backend.
> >>
> >> I opened a Bugzilla account and reported this (Bug 797651), but as
> reconstructing this may mean sharing my personal financial data I
> restricted the view access to the developer list. I have reconstructed my
> working account file from my backup, so there's been no loss of critical
> data. I'm sharing this for visibility and to ask if there is any additional
> information I should provide in the bug report to facilitate a permanent
> resolution to this problem. Thanks for any adviceEric.
> > Chris has already responded to you on the bug report and will ask there
> for any additional information he needs.
> >
> > A general note: I wouldn't trust the view access settings to protect
> anything, it's at best security-by-obscurity. If one of us decides he needs
> to look at your book he'll provide a direct email address to send it to.
> >
> > Regards,
> > John Ralls
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Canceling QIF Import Erases ALL Transactions

2020-03-21 Thread Eric H. Bowen via gnucash-user 


   Isn't that the point of a PUBLIC key?
   Now, of course I'm not going to respond with personal data unless I can
   verify that the requester's address is on a list of known Gnucash
   developers, but anyone is welcome to email me securely. In fact, I
   prefer it.
   Sent via [1]BlackBerry Hub+ Inbox for Android

   From: david.carlson@gmail.com
   Sent: March 21, 2020 12:02 PM
   To: e...@ehbowen.net
   Cc: jra...@ceridwen.us; gnucash-user@gnucash.org
   Subject: Re: [GNC] Canceling QIF Import Erases ALL Transactions

   Eric,
   You just published your GPG public key to the entire user group.
   On Sat, Mar 21, 2020 at 11:38 AM Eric H. Bowen via gnucash-user
   <[2]gnucash-user@gnucash.org> wrote:

 I understand about security; I'm going to upload my GPG public key
 to
 the bug report (and it should be attached to this email reply) and I
 ask
 that any request which may involve personal data be encrypted
 accordingly both ways.
 Eric H. Bowen
 [3]e...@ehbowen.net <mailto:[4]e...@ehbowen.net>
 On 3/21/2020 11:20 AM, John Ralls wrote:
 >
 >> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user
 <[5]gnucash-user@gnucash.org> wrote:
 >>
 >> Yesterday I ran into this...I was attempting a .QIF import of
 transactions from my credit card company. The import seemed to
 progress normally, up until the "Match Transactions" stage. When it
 got there, every single one of the transactions which I had entered
 over the past 2+ years appeared in the list. I hit the cancel button
 in the requester, got the "busy" icon...and when Gnucash resumed,
 about ten minutes later, every one of my transactions in every
 account had vanished (with the sole exceptions of customer invoices
 and vendor bills)!
 >>
 >> I did have a fairly recent backup file available, so I restored
 to that and tried the import again. The same thing happened a second
 time.
 >>
 >> My NAS keeps track of file history and automatically saves the
 most recent versions every twenty minutes or so, so I do have
 versions from before and after the failed import saved (to a new
 file under a new name) as well as all of my log files. At the time
 of the import I was running Build ID: 3.8b+(2019-12-29) on Ubuntu
 18.04.4 LTS in a homebuilt machine with AMD FX-4100 CPU, 8 GB RAM,
 and an ASUS M5A88-M motherboard and using the SQLite3 backend.
 >>
 >> I opened a Bugzilla account and reported this (Bug 797651), but
 as reconstructing this may mean sharing my personal financial data I
 restricted the view access to the developer list. I have
 reconstructed my working account file from my backup, so there's
 been no loss of critical data. I'm sharing this for visibility and
 to ask if there is any additional information I should provide in
 the bug report to facilitate a permanent resolution to this problem.
 Thanks for any adviceEric.
 > Chris has already responded to you on the bug report and will ask
 there for any additional information he needs.
 >
 > A general note: I wouldn't trust the view access settings to
 protect anything, it's at best security-by-obscurity. If one of us
 decides he needs to look at your book he'll provide a direct email
 address to send it to.
 >
 > Regards,
 > John Ralls
 >
 ___
 gnucash-user mailing list
 [6]gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 [7]https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see
 [8]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.

   --
   David Carlson

References

   1. http://play.google.com/store/apps/details?id=com.blackberry.hub
   2. mailto:gnucash-user@gnucash.org
   3. mailto:e...@ehbowen.net
   4. mailto:e...@ehbowen.net
   5. mailto:gnucash-user@gnucash.org
   6. mailto:gnucash-user@gnucash.org
   7. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   8. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list
gnucash-user@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.