[Kmymoney-devel] Re: [Kmymoney2-developer] QIF Importing

[aga]

On Tue, 31 May 2011 10:21:19 -0500
James Duke <duke.james.c at gmail.com> wrote:

> Tried importing complete quicken history including: account list,
> catarories, securities etc.  Program worked on the data for 10 to 15
> minutes and shut down.  Tried 3 times with same results.  Is there a
> file size or record number limit?  File was over 5MB.
> 

Did you get anywhere with my suggestion to run KMM from the command
line?

That's quite a good size, and I don't know what the world record is.
So far as I know, KMM does not impose any size limitation.

Oh, in your previous email, you mentioned an attachment, which didn't
seem to be present.  I'd be interested to see what account types got
duplicated.  I've recently found that having 'Mutual' type accounts can
result in extra accounts.  Also, if, say, you have dividend payments
which get transferred to a checking account, KMM at the moment cannot
connect the two, with the result that, when the checking side is
processed, an additional checking account is created  for the payment,
as it cannot deal with money in investment accounts.  If this is your
problem, try removing the '[' and ']' from the checking account
entries.  That will result in the payment being allocated to a category
instead of an account.  This will still leave a redundant checking
account.  This can be avoided by removing  the related 
"
NStock name here
TStock
^
" record.  I've just tried these steps with my ex-Quicken file and six
accounts were reduced to two.

If you still have a problem, could you perhaps make an extract from your
file, showing the basic structure?  Start from the first 
"
!Clear:AutoSwitch
!Type:Security
" entry and show a few accounts, then skip to the first 
"
!Option:AutoSwitch
!Account
" and again show a few entries.  There will be a lot of these account
records, so just show a few.

Then you'll get !Account......!Type:Invst.... groups.  Again, show a
few of those. Disguise the payment details, as long as they are still
valid.

At the end of this, you should have a mini file which you should be
able to import yourself.  Then send the file to me to look at.

Allan

> On Mon, May 30, 2011 at 8:26 AM, aga <agander93 at gmail.com> wrote:
> > On Mon, 30 May 2011 07:58:02 -0500
> > James Duke <duke.james.c at gmail.com> wrote:
> >
> >> Made a full export from quicken of all accounts, categories and
> >> transactions. The QIF file is very large, slightly over 5 MB.  I
> >> have tried the import several times but after working 10/15
> >> minutes the program shuts down and closes.  When I reopen there is
> >> no imported records in the file. Is there a file size or record
> >> limit?
> >>
> >
> > Try starting from the command line and there may be some helpful
> > messages.
> >
> > Allan
> >
> >> -----Original Message-----
> >> From: aga [mailto:agander93 at gmail.com]
> >> Sent: Thursday, May 26, 2011 2:29 PM
> >> To: Duke.James.C at gmail.com
> >> Cc: kmymoney-devel at kde.org;
> >> kmymoney2-developer at lists.sourceforge.net; kmymoney at kde.org
> >> Subject: Re: [Kmymoney2-developer] QIF Importing
> >>
> >> On Thu, 26 May 2011 13:30:32 -0500
> >> James Duke <duke.james.c at gmail.com> wrote:
> >>
> >> > still working - new question: created accounts tied to my
> >> > subcategories from quicken, i.e. if I had transactions in
> >> > "Checking" with a subcategory "C" import created an account
> >> > "Checking/C"?
> >>
> >> Would 'Checking' be an account, or a category?  Did you mean
> >> subcategory "C" or sub-account "C"? Where did the '/' come from?
> >>  Are you able to isolate a transaction causing what you are
> >> seeing, and can you let us see it?  Ideally, the whole file, or at
> >> least the file structure, with unnecessary transactions deleted.
> >>
> >> Oh, and I've changed the subject.
> >>
> >> Thanks
> >>
> >> Allan
> >>
> >> >
> >> > On Wed, May 25, 2011 at 6:16 PM, aga <agander93 at gmail.com> wrote:
> >> > > On Wed, 25 May 2011 12:42:54 -0500
> >> > > James Duke <duke.james.c at gmail.com> wrote:
> >> > >
> >> > >> Have been checking several apps and moneydance has the user
> >> > >> create the accounts ONLY on the "first" import and then import
> >> > >> the transaction. Might work here also.  I am using 4.5.4 for
> >> > >> windows - testing before moving to Ubuntu.  Do I need to
> >> > >> create the accounts before importing?
> >> > >>
> >> > > It depends very much on your file content.  As you probably
> >> > > know, the QIF standard is not, in fact, a 'standard', so all I
> >> > > can suggest is, attempt the import without any accounts
> >> > > created, and let KMM do its best.
> >> > >
> >> > > I've just tested with an old, 134Kb file, and investment,
> >> > > security and checking accounts were all created during the
> >> > > import, plus transactions.  You may need to do some editing of
> >> > > account types, checking to savings sort of thing, and you may
> >> > > find you have accounts you don't need.  If you create accounts
> >> > > beforehand, they may be additional duplication.  As I
> >> > > suggested, if you can, start small.  If you hit anything
> >> > > serious, we'll try to help.
> >> > >
> >> > >> I just want to say thanks - great piece of work and I think
> >> > >> once I get everything setup it will be perfect for all my
> >> > >> needs!!
> >> > >
> >> > > Thanks for that.
> >> > >
> >> > > Allan
> >> > >
> >> > >> On Wed, May 25, 2011 at 11:53 AM, aga <agander93 at gmail.com>
> >> > >> wrote:
> >> > >> > On Wed, 25 May 2011 10:42:23 -0500
> >> > >> > James Duke <duke.james.c at gmail.com> wrote:
> >> > >> >
> >> > >> >> Looking for stratagies for importing large volume of
> >> > >> >> information from quicken 2008.  Have tried it once but
> >> > >> >> single accounts came in as mutliple accounts and VERY
> >> > >> >> confusing. Any how-tos out there? Tried google search and
> >> > >> >> nothing on point.
> >> > >> >>
> >> > >> >> --
> >> > >> >> James Duke
> >> > >> >> **New email address Duke.James.C at gmail.com**
> >> > >> >
> >> > >> > Hi James
> >> > >> >
> >> > >> > There has been an issue with additional accounts being
> >> > >> > created, which, if memory serves me, resulted from a rework
> >> > >> > of the import process to reduce the need for user
> >> > >> > intervention.  I think this was because of a particular
> >> > >> > user's large volume of new accounts to input.
> >> > >> >
> >> > >> > I'm not certain if the issue affects only investment
> >> > >> > accounts, with brokerage accounts being created.  Funnily
> >> > >> > enough, only yesterday, I was working on a qif import
> >> > >> >  problem.  While it was not the intent of the fix, testing
> >> > >> > afterwards confirmed that it may not be necessary to create
> >> > >> > accounts before import. Checking type accounts were created
> >> > >> > automatically for proceeds of sales/receipt of
> >> > >> > dividends/funds for buys, as long as the file names were
> >> > >> > correct in the 'L' records.  That fix will go into the
> >> > >> > development branch, and later into the stable release.
> >> > >> >
> >> > >> > I note that you posted via sourceforge, and wonder if that
> >> > >> > indicates you were trying kmymoney v1.x.  If so, try a v4.5x
> >> > >> > release, as much work has been done recently.  Try to get as
> >> > >> > late a release as possible, as there were some slow
> >> > >> > performance issues prior to 4.5.3.
> >> > >> >
> >> > >> > Could you perhaps try importing just a couple of files of
> >> > >> > checking and investment accounts, and let us know how you
> >> > >> > get on We'll try to help.
> >> > >> >
> >> > >> > Allan
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> > >
> >> > >
> >> >
> >> >
> >> >
> >>
> >
> >
> 
> 
>