[Kmymoney] import csv problems

[aga]

On Mon, 27 May 2013 16:04:28 +0200
Gary Kirkpatrick <pegngary at gmail.com> wrote:

> On Mon, May 27, 2013 at 3:52 PM, Gary Kirkpatrick
> <pegngary at gmail.com>wrote:
> 
> >
> >
> > On Mon, May 27, 2013 at 3:23 PM, aga <agander93 at gmail.com> wrote:
> >
> >> On Mon, 27 May 2013 15:13:55 +0200
> >> Gary Kirkpatrick <pegngary at gmail.com> wrote:
> >>
> >> > On Mon, May 27, 2013 at 3:01 PM, aga <agander93 at gmail.com> wrote:
> >> >
> >> > > On Mon, 27 May 2013 14:30:44 +0200
> >> > > Gary Kirkpatrick <pegngary at gmail.com> wrote:
> >> > >
> >> > > > On Mon, May 27, 2013 at 12:44 PM, aga <agander93 at gmail.com>
> >> > > > wrote:
> >> > > >
> >> > > > > On Mon, 27 May 2013 08:59:45 +0100
> >> > > > > Atish Nazir <gomi at littleworld.co.uk> wrote:
> >> > > > >
> >> > > > > > This looks familiar, as a quick experiment can you open
> >> > > > > > your CSV file in a spreadsheet/text editor application
> >> > > > > > and check that every row has the same number of columns.
> >> > > > > >
> >> > > > >
> >> > > > > It's a while ago I fixed that problem, but if Gary is on
> >> > > > > an old rev., that certainly could be it.  Well spotted.
> >> > > > >
> >> > > > > Allan
> >> > > > > ________
> >> > > > >
> >> > > >
> >> > > > There were the same number of columns in every row.  My
> >> > > > version is 4.6.1. Can you send me the link for the version I
> >> > > > should try.
> >> > > > https://launchpad.net/~claydoh/+archive/kmymoney-daily
> >> > > > yielded 4.6.1.  I can not use 13.04 on this system- it is
> >> > > > too slow (a bit better gnome).
> >> > > >
> >> > > > garyk
> >> > >
> >> > > If I'm not mistaken, check
> >> > > https://launchpad.net/ubuntu/precise/i386/kmymoney/4.6.3-1~precise1
> >> > >
> >> > > That refers to a .deb package.
> >> > >
> >> > > Allan
> >> > > ____________________
> >> > >
> >> >
> >> >
> >> > That's a 4.6.3.1 so that should be it.  However I do notfind the
> >> > ppa there. I need the whole thing so I can copy and paste -  I am
> >> > uncertain if I can get it right otherwise.  I tried installing
> >> > the tar but I do not know how unless it opens with software
> >> > center, which is does not.  With the ppa I can do it thru
> >> > software ctr or synaptic.
> >> >
> >> >
> >> > thanks
> >> >
> >> > garyk
> >>
> >> Did you add the PPA to your sources, as per
> >> https://launchpad.net/~claydoh/+archive/kmymoney2-kde4 ?
> >>
> >> Also, check to get the dbug synbols, too.
> >>
> >> Allan
> >> _______________________________________________
> >> KMyMoney mailing list
> >> KMyMoney at kde.org
> >> https://mail.kde.org/mailman/listinfo/kmymoney
> >>
> >
> >
> >
> > This does not tell me very clearly what exactly to add to
> > synaptic.   I had to do some digging and thinking.  Frustration
> > level got high.
> >
> > But here it is:
> >
> > sudo add-apt-repository  ppa:claydoh/kmymoney2-kde4
> >
> > Then sudo apt-get update
> >
> > I installed from Software Center tho snyaptic would be fine.
> > Then from synaptic I added the debug- which you can not do from
> > Software Center so doing the whole thing from Synaptic would be a
> > little easier.
> >
> > Now will try the csv import.
> >
> > thanks!
> >
> >
> > garyk
> >
> 
> 
> 
> Ok got an import.  It complained about the number of columns - not
> sure why since I deleted tons of them that looked empty using Lib
> Office.  I have to get statements to reconcile and for some reason we
> are locked out of the bank right now so that part will wait till
> tomorrow.  Bank accts. are easier for me anyway.
> 
> Apparently there is no update of KMM coming into 12.04, which led to
> all this.
> 
> thanks for everyone's help!
> 
> 
> 
> garyk

It's probably best if you are more specific about the content of
messages.

You shouldn't need to delete columns - just don't select them to be
imported.  You might get a message towards the end of the parameter
selection about missing decimal points.  This may tend to happen with a
bank statement with separate debit and credit columns, where there are
no entries in one of those columns.  It's not an error, but is pointing
to a possible error when you selected those columns.  If you're happy
the column selection is correct, just carry on.  You may also get a
caution if a selected column on a particular row is empty, but that
could be because you haven't deselected a header row.  Again, you have
the option to go back and correct, or to proceed.

When you do finally get a successful import, make sure you click Finish
in the importer plugin, as that will save all your selections for the
future in the profile you selected or created.

Allan