Hi Thomas,
On Tuesday 18 January 2011 23:22:34 you wrote:
> Hi,
>
> on Tuesday 18 January 2011 12:21:01 Peter wrote:
> > Hi,
> >
> > On Tuesday 18 January 2011 20:37:01 Peter wrote:
> > > Hi,
> > >
> > > On Tuesday 18 January 2011 01:56:06 you wrote:
> > > > Hi,
> > > >
> > > > on Monday 17 January 2011 15:26:36 Peter wrote:
> > > > > On Tuesday 18 January 2011 00:18:52 allan wrote:
> > > > > > On 17/01/11 12:58, Peter wrote:
> > > > > > > Hi,
> > > > > > >
> > > > > > > Have just imported an account (QIF file), and noticed the
> > > > > > > balance was huge. Checked the input QIF file, to the exported
> > > > > > > KMM QIF file, and noticed the amounts have been multiplied by
> > > > > > > a factor of 100.
> > > > > > >
> > > > > > > Example for one trans ...
> > > > > > >
> > > > > > > Input
> > > > > > >
> > > > > > > D06/13/97
> > > > > > > T-33.42
> > > > > > > PDirect Dial
> > > > > > > LAutomobile:Maintenance
> > > > > > > ^
> > > > > > >
> > > > > > > Output
> > > > > > >
> > > > > > > D06/13/97
> > > > > > > T-3,342.00
> > > > > > > PDirect Dial
> > > > > > > LAutomobile:Maintenance
> > > > > > > ^
> > > > > > >
> > > > > > > Naturally, I didn't save the file in KMM. Are there some
> > > > > > > settings for amount ? Surely, a decimal point is a decimal
> > > > > > > point.
> > > > > > >
> > > > > > > Regards,
> > > > > > >
> > > > > > > Peter
> > > > > >
> > > > > > I'm not 100% certain it's still in use, but check Tools/QIF
> > > > > > Profile Editor/ Amounts tab, in case the separators are
> > > > > > incorrectly set.
> > > > >
> > > > > There is no seperator option in the version I'm using.
> > > >
> > > > Yes, it's all automagic now. Your QIF file needs a "!Type:xxx" record
> > > > somewhere at the beginning for the automatic detection of the decimal
> > > > symbol to work properly.
> > >
> > > Imported the QIF file, it said it loaded so many trans, payees, etc,
> > > but showed no extra details in _that_ account. I saved the KMM file,
> > > still nothing appears ??
> > >
> > > This was the first record ...
> > >
> > > !Type:CCard
> > > D06/09/97
> > > T-876.54
> > > CX
> > > POpening Balance
> > > L[ANZ VISA]
> > > ^
> > >
> > > Will recover from backup. have even run a report on that account, it
> > > still only shows the trans that were there prior to import ??
> >
> > I copied the KMM files, before and after the import. Renamed to .gz, used
> > gunzip, and then ran Beyond Compare to view the XML files. certainly
> > there
> >
> > is considerable data after the import, ....BUT it seems KMM has created
> > a 'new' account, whereas this account was already present. So, .. maybe
> > that is why I can't 'see' the transactions in the 'ANZ VISA' account.
> >
> > I checked this a bit in the XML file/s. Followed up one transaction,
> > noted
> >
> > the account number, then searched for that account number, and it is
> > there in all the trans, ..PLUS it is there as a 'new' account. Seems
> > it is trying to setup the 'same' account as an asset, when it was
> > already in KMM as a liability acount.
> >
> > See this trans ...........
> >
> > <ACCOUNT parentaccount="AStd::Asset" lastmodified="2011-01-18"
> > lastreconciled="" institution="" number="" opened="2011-01-18"
> >
> > currency="AUD" type="1" id="A000489" name="ANZ VISA"
> > description="Autogenerated by QIF importer" />
> >
> > and '489' is the number attached to all the trans, if I view the XML of
> > the KMM file, after the import.
>
> Thanks for the in depth analysis. This I think helped a lot to isolate the
> problem. I made a change in SVN trunk. If you build from it, simply update.
> If you build from source, then
> http://websvn.kde.org/trunk/extragear/office/kmymoney/kmymoney/converter/my
> moneyqifreader.cpp?r1=1215354&r2=1215353&pathrev=1215354 contains
> information about the change.
Thank you VERY much for fixing this. I'm running Ubuntu 10.04 and KMM 1.0.4 and
KDE 3.5.10 , and have no experience with building from source or updating,
etc, I only get .deb updates via Synaptic.
> Let me know, if that solves the problem so that I can backport it into the
> stable branch.
Sorry, I will have to wait until Clay or someone has a Ubuntu update (64 bit
actually).
> Thanks for all your help on this.
No worries, sorry I can't test the update (yet).
Thanks,
Peter
|