Re: command line QIF import

2017-10-18 Thread Derek Atkins
John, On Wed, October 18, 2017 12:14 pm, John R. Sowden wrote: > I keep a copy of Gnucash on my computer, in the remote chance that some > of the obvious anti-user issues would be resolved.  I ran it a moment > ago.  I keep a copy of my chart of accounts on line, and the copy I use > is to test

Re: command line QIF import

2017-10-18 Thread John R. Sowden
I keep a copy of Gnucash on my computer, in the remote chance that some of the obvious anti-user issues would be resolved.  I ran it a moment ago.  I keep a copy of my chart of accounts on line, and the copy I use is to test various types of transactions.  The easiest for me is paying the

Re: command line QIF import

2017-10-17 Thread John Ralls
> On Oct 17, 2017, at 8:36 AM, John R. Sowden > wrote: > > It makes sense that users of the Intuit family of products want to leave, due > to some of their business practices; and some desire to use an operating > system that is not founded on enhancing the

Re: command line QIF import

2017-10-17 Thread David Carlson
John R. Sowden, Could you please elaborate on your assertions that 1. "errors, often based on changing amounts (2 debits, etc.,) are hidden from the user." 2. "A 'preference' switch to allow users who are familiar and comfortable with the 'Intuit Way' to continue, vs. those with accounting

Re: command line QIF import

2017-10-17 Thread John R. Sowden
To: Liz, the moderator, and the list: Actually Gnucash seems to strike a strong resemblance to Quicken.  The data entry in the journal mode with no payee in the check or source account entry (from cash, checking, or credit cards), and where the amounts of the entry change in during the data

Re: command line QIF import

2017-10-16 Thread Liz
On Mon, 16 Oct 2017 06:52:17 -0700 (MST) Nelson wrote: > You're getting very defensive here David and your posts are not > contributing to this discussion at all. > > Gnucash is Gnucash. It isn't a Quicken-to-Gnucash project. Yes, we do get many queries about

Re: command line QIF import

2017-10-16 Thread Aaron Laws
On Mon, Oct 16, 2017 at 8:55 AM, Nelson wrote: > > That's why I am saying that having some flags to tuneup the import process > and detailed logging would help a lot. > It sounds like you've identified some areas for improvement. This is a volunteer project, so the

Re: command line QIF import

2017-10-16 Thread Nelson
You're getting very defensive here David and your posts are not contributing to this discussion at all. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: command line QIF import

2017-10-16 Thread David Carlson
Nelson, It sounds to me like you are unwilling make the effort to "shepherd" your data through the import process. Many of us, including David T are trying to tell you that we have succeeded in completing massive imports from Quicken into GnuCash, but we needed to take several steps to plan our

Re: command line QIF import

2017-10-16 Thread Nelson
There are multiple classes of failures and most of them seems to be transfers related. There are the ones a which show up more often: - missing transactions - duplicate transactions - voided transactions (transaction exist but flagged as "void" and has zero amount) - transactions in wrong account

Re: command line QIF import

2017-10-16 Thread David T. via gnucash-user
What do you mean "failed"? They aren't in the gnucash file at all? Or, they import incorrectly?  If the latter, take a look at some of the transactions that failed; is there something in common?  In my Quicken data, it was transactions that had no categories that caused the most problems. Fill

Re: command line QIF import

2017-10-15 Thread David Carlson
I am not a developer, but I can point out that the QIF importer works in several discrete steps where (roughly) it 1. identifies the 'source' account type and name and tries to associate it to an existing account in the data file. If there is more than one 'source' account in the QIF file it

RE: command line QIF import

2017-10-15 Thread Ken Pyzik
Best of luck. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+pyz01=cox@gnucash.org] On Behalf Of Nelson Sent: Sunday, October 15, 2017 1:50 PM To: gnucash-user@gnucash.org Subject: Re: command line QIF import Thank you for your answer David. I am aware that QIF

Re: command line QIF import

2017-10-15 Thread Nelson
Thank you for your answer David. I am aware that QIF is a text file and I can open it in text editor. I have a 235000 lines QIF file created by quicken. Most of the transactions are being imported properly but there are thousands failing as well. I have no way to identify those failed

Re: Re: command line QIF import

2017-10-15 Thread Dave Gillam
I am temporarily away from my email. If urgent, please contact Joe Miller at 210-884-1334 or j...@davegillam.com. Thank You, David On Oct 15, 2017, at 3:20 PM, D via gnucash-user wrote: > Nelson, > > I don't see how a command line interface would help. > >

Re: command line QIF import

2017-10-15 Thread D via gnucash-user
Nelson, I don't see how a command line interface would help. Since QIF is a text file format, you could always just go through the source file with a text editor first to get your data in a ship shape state and *then* do the import. Or, use quicken to edit the transactions first. David On

Re: command line QIF import

2017-10-15 Thread David Carlson
Not sure about more efficient ways to import via QIF, which, by the way, is reasonably efficient when done in small chunks, but another caveat that has not been raised recently is that as the data file grows it takes longer to do the frequent file saves. In Windows each save for my data file

command line QIF import

2017-10-15 Thread Nelson
Hi everyone, I am trying to import about 20 years of Quicken transactions into GnuCash going trough a Quicken QIF export. As many people reported, this is a very painful process and requires endless manual corrections. I was wondering if it would be possible to maybe to do the import from