Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-11 Thread cicko
GWB wrote > Unless you are willing to spend some time learning various sql query > and dbase commands and functions, I would stick with SQLite and make > snapshots (if your file system allows it) or frequent backups. I'm also doing this manually with the SQLite backend. I wrote a small Python sc

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-06 Thread GWB
Haven't tested this with the SQLite GnuCash backend, but it is sometimes possible with PostgreSQL to "roll back" to an earlier state before the last transactions, or for that matter, any arbitrary number of transactions before the last one. I haven't used the PostgreSQL backend with GnuCash for so

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-06 Thread Cricket Onebit
That makes sense. I know with some versions of SQL, you can roll-back. I suspect that each of the three versions GNUCash supports does it differently, sigh. If I do use SQL, I'll treat it like my novel. Dated daily backups, and add good title and change log when I make major changes. Not that I ev

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Adrien Monteleone-2 wrote >> On Apr 2, 2019, at 11:59 AM, no_more_quicken < > nospam@ > > wrote: >> >> >> 5. I still haven't quite figured out the reporting framework; my goal is >> to >> generate an "expenses over the last X months grouped by month" report >> (i.e., >> just like the "Expense O

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
Cricket Onebit wrote > Can you explain more about not being able to undo things with the SQL > backend vs XML (or point to more details)? I'm undecided about which > backend. Fully-functional and easy to install and maintain is more > important to me than a few seconds while using, unless those sec

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Cricket Onebit
Thanks for this. I have a similar project in the near future, and was wondering the best order for some things. It looks like the major re-categorization should be done before leaving Quicken. Good to know there's a workaround for the HiDPI bug. Is there a bug report / feature request for bulk a

Re: [GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread Adrien Monteleone
> On Apr 2, 2019, at 11:59 AM, no_more_quicken wrote: > > > 5. I still haven't quite figured out the reporting framework; my goal is to > generate an "expenses over the last X months grouped by month" report (i.e., > just like the "Expense Over Time" built-in chart, but in a table format with >

[GNC] My experience importing 19 years of Quicken data into GnuCash

2019-04-02 Thread no_more_quicken
I've been diligently tracking my personal finances since early 2000. I started with MS Money, then reluctantly switched to Quicken when Money was discontinued. I LOVED MS Money, but I've never really been happy with Quicken. It's hard to pinpoint exaclty why, but some combination of the clunky UI,