Re: [GNC] Changing account tree on large database

2019-05-08 Thread Adrien Monteleone
If you need a site up quickly as a local install, check out TurnKeyLinux. They have server appliances you can download and install in a VM or even just open in a VM skipping the installation part. They also have cloud images for the various major cloud providers if that is your preference. I

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
I used Sqlite and Python for a project a few years ago. SQLite was great, including a few third-party viewers. The Python binding was a bit much to comfortably wrap my brain around as fast as I wanted to. I was learning Python, SQL, and re-learning HTML forms and static-state programming, all at

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
I wish I'd thought of a separate account for what we owe her / she owes us earlier, sigh, and one for our son to keep things even. I didn't record things consistently because no method felt "right", and some is on a separate spreadsheet. The current plan is print out anything that affects her and

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
Very happy about the reports and tags. Yes, I always take backups (and backups of backups). Dad used to design hardware for telephone switching systems that absolutely had to work, and Mom was an inaugural member of the 8-hours-lost club with 5-1/4 floppies. The first computer I bought for myself

Re: [GNC] Changing account tree on large database

2019-05-07 Thread Cricket Onebit
Yep, that's my plan. Quicken has a bulk-edit feature that I'll make good use of. When I get around to it. Too many emergency late nights last week to tackle something I need to be awake for. For now, I've decided to do the urgent report in Quicken, then worry about the conversion. I'd hoped to do

Re: [GNC] Changing account tree on large database

2019-04-27 Thread D via gnucash-user
Good points, Greg. I believe that echoes what the wiki says on the subject. David On April 27, 2019, at 8:01 PM, Greg Feneis wrote: Alternatively, Cricket, instead of exporting from Quicken, then arranging things as you like, then importing to GnuCash, or some variation of that, you could make

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 9:49 PM, Cricket Onebit > wrote: > > On Fri, 26 Apr 2019 at 22:14, Tommy Trussell > wrote: > >> >> On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit >> wrote: >> >>> The speed thing is disappointing. I thought 3.5 fixed that, but maybe not >>> enough. I planned to save

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 8:49 PM, Cricket Onebit > wrote: > > > > (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not using > the SQL just yet. Several posts on this list say otherwise. Out of date > manual, or optimistic / lucky users?) There was some display issue with

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 4:28 PM, Cricket Onebit > wrote: > > > > Also, for this particular example, I’d opt for tags for each kid instead of > accounts, see below about Cars. > > I didn't think GNUCash supported tags. I plan to use #tagone in a text field. > That's one of the things I need

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Greg Feneis
Alternatively, Cricket, instead of exporting from Quicken, then arranging things as you like, then importing to GnuCash, or some variation of that, you could make a copy of your Quicken working file and from within Quicken, arrange things as you like with a mind toward exporting to GnuCash, then

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Liz
On Fri, 26 Apr 2019 21:49:12 -0400 Cricket Onebit wrote: > The speed thing is disappointing. I thought 3.5 fixed that, but maybe > not enough. I planned to save as XML to get going, since the docs say > it's more stable, then try SQLite. I found that 3.4 has greatly improved load and save

Re: [GNC] Changing account tree on large database

2019-04-26 Thread David T. via gnucash-user
David, I think a couple of additional points of reference from you would be helpful. What operating system are you experiencing this slow performance? I believe it’s WIndows, but I could be mistaken. The relative performance benchmarks seem to be OS-dependent. I am using MacOS, and while some

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
> > You WILL almost certainly see some strangeness in the imported data > because Quicken doesn't strictly enforce balanced transactions as GnuCash > does. When you're just dealing with a few years, you may find it easy to go > back and fix the odd strange transactions in Quicken, and start the

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Fri, 26 Apr 2019 at 22:14, Tommy Trussell wrote: > > On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit > wrote: > >> The speed thing is disappointing. I thought 3.5 fixed that, but maybe not >> enough. I planned to save as XML to get going, since the docs say it's more >> stable, then try

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 9:13 PM Cricket Onebit wrote: > Somewhere I saw that most people find QIF works better, and that QIF is > similar to CSV. If my version of Quicken won't export to QIF, I'll try CSV. > There are too many variations of CSV for me to trust it entirely. > The QIF import USED

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit wrote: > The speed thing is disappointing. I thought 3.5 fixed that, but maybe not > enough. I planned to save as XML to get going, since the docs say it's more > stable, then try SQLite. > The "standard" XML files are quick enough for me, though

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
Somewhere I saw that most people find QIF works better, and that QIF is similar to CSV. If my version of Quicken won't export to QIF, I'll try CSV. There are too many variations of CSV for me to trust it entirely. I might make one huge QIF, import it and save as GC, then make another QIF just of

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
The speed thing is disappointing. I thought 3.5 fixed that, but maybe not enough. I planned to save as XML to get going, since the docs say it's more stable, then try SQLite. (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not using the SQL just yet. Several posts on this list

Re: [GNC] Changing account tree on large database

2019-04-26 Thread nvsoar
On 04/26/19 16:18, Tommy Trussell wrote: On Fri, Apr 26, 2019 at 4:53 PM David Carlson wrote: Strongly consider only moving one or two years data to GnuCash. I agree. I found that I could import a lot more, but I found I was going crazy trying to make everything look right, which ultimately

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Tommy Trussell
On Fri, Apr 26, 2019 at 4:53 PM David Carlson wrote: > Strongly consider only moving one or two years data to GnuCash. > I agree. I found that I could import a lot more, but I found I was going crazy trying to make everything look right, which ultimately seemed pointless for things like

Re: [GNC] Changing account tree on large database

2019-04-26 Thread David Carlson
Cricket, One more point... Strongly consider only moving one or two years data to GnuCash. When your file gets large you may prefer to have a new file for each year or whatever to keep GnuCash from bogging down and running too slow. It gets worse quickly if you leave a lot of reports and

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
On Thu, 25 Apr 2019 at 17:29, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > I'm preparing to convert 14,000 transactions from Quicken. It's a bit > > overwhelming, and I've put it off for years. > > Sounds like a daunting task. I don’t do such imports, but reading the > various

Re: [GNC] Changing account tree on large database

2019-04-26 Thread Cricket Onebit
That page gave me nightmares when I first read it two years ago. I ran a few tests, then procrastinated. Nothing's difficult, but there's a lot to do. It looks like I should anticipate problems with the matcher for transfers between accounts, and for split transactions. I'll make before/after

Re: [GNC] Changing account tree on large database

2019-04-25 Thread David Cousens
The following bit of the Wiki may be some help: https://wiki.gnucash.org/wiki/Quicken_Migration The documentation on the importer is in need of some improvement and that is underway but not useful yet. There are some additions in the just released 3.5 documentation, mainly to do with the CSV

Re: [GNC] Changing account tree on large database

2019-04-25 Thread Adrien Monteleone
> On Apr 25, 2019, at 3:16 PM, Cricket Onebit > wrote: > > Hello, > > I'm preparing to convert 14,000 transactions from Quicken. It's a bit > overwhelming, and I've put it off for years. Sounds like a daunting task. I don’t do such imports, but reading the various threads over the years,

Re: [GNC] Changing account tree on large database

2019-04-25 Thread David Carlson
Cricket Onebit, I would suggest running an extended test possibly by importing one or two month's data into GnuCash then running both GnuCash and Quicken in parallel for a couple of months. It is easy to start over if you decide to do it a different way. Generally, GnuCash does not have any

[GNC] Changing account tree on large database

2019-04-25 Thread Cricket Onebit
Hello, I'm preparing to convert 14,000 transactions from Quicken. It's a bit overwhelming, and I've put it off for years. 1. Can I move child accounts to other parents, and promote / demote them? I want to make some major changes, mostly Clothes-kid1 to kid1-clothes. It's one more excuse for