KMyMoney

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.

But, is it just this one file that is incorrect, and what version are 
you using?

Also, to clarify, when you refer to the exported KMM QIF file, was that 
produced by KMM?

Allan

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.

> But, is it just this one file that is incorrect, and what version are
> you using?

Yes, just this one file, and KMM version is 1.0.4

> Also, to clarify, when you refer to the exported KMM QIF file, was that
> produced by KMM?

Yes, that's correct.

The input (QIF) file, I must admit, that it was edited (was from M$Money 
originally). Because of the duplicates problem in KMM, I used a compare tool, 
and removed all the duplicate sets of records in the QIF file that was 
imported. This file was checked numerous times, and was okay, ..BUT I did 
remove the 'header', as that account was already present, and had an opening 
balance. That may well have caused the problems, but KMM did ask which account 
I wanted it exported into. I could see the imported trans in KMM, huge 
amounts.

I re-ran the import , but this time, although KMM said all the trans went in 
okay, none appeared. I did an export, and sure enough, no 'extra' trans for 
that account ???

Fortunately, I didn't do a save in KMM, but need to import all these trans 
from the QIF file.

Thanks,

Peter

> Allan
> 
> ---------------------------------------------------------------------------
> --- Protect Your Site and Customers from Malware Attacks
> Learn about various malware tactics and how to avoid them. Understand
> malware threats, the impact they can have on your business, and how you
> can protect your company and customers by using code signing.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> KMyMoney2-user mailing list
> KMyMoney2-user@...
> https://lists.sourceforge.net/lists/listinfo/kmymoney2-user

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.

-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
There are only 10 types of people in the world: those who
understand binary arithmetic and those who don't.
-------------------------------------------------------------

Hi Thomas,

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.

Okay, I will try it again, and make sure there is a "!Type:xxx" record 
somewhere.  

Thanks,

Peter

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  ??

Regards,

Peter

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.

Peter

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/mymoneyqifreader.cpp?r1=1215354&r2=1215353&pathrev=1215354 
contains information about the change.

Let me know, if that solves the problem so that I can backport it into the 
stable branch.

Thanks for all your help on this.


-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
How many programmers does it take to change a
light bulb? None. It's a hardware problem!
-------------------------------------------------------------

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

Hi Thomas,

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.

I wonder if the import would work, if I made the header like this ..

!Type:CCard
D06/09/97
T-876.54
CX
POpening Balance
L[]
^

So, that the header is present, for the decimal places, and no bank/account is 
specified (between the '[' and ']' ) , so KMM will ask for the account to be 
imported in ??

Peter

Hi,

on Wednesday 26 January 2011 04:13:00 Peter wrote:

[...]

> I wonder if the import would work, if I made the header like this ..
> 
> !Type:CCard
> D06/09/97
> T-876.54
> CX
> POpening Balance
> L[]
> ^
> 
> So, that the header is present, for the decimal places, and no bank/account
>  is specified (between the '[' and ']' ) , so KMM will ask for the account
>  to be imported in ??

It might be easier to use the following lead-in:

  !Account
  NANZ VISA
  TCCard
  ^
  !Type:CCard

and don't specify an opening balance transaction but simply add transactions.


p.s. No guarantee that this will work with your version, but you can at least 
try.

-- 

Regards

Thomas Baumgart

GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
-------------------------------------------------------------
It is better to remain silent and be thought a fool,
than to speak, and remove all doubt.
-------------------------------------------------------------

Hi Thomas,

On Wednesday 26 January 2011 19:19:37 Thomas Baumgart wrote:
> Hi,
> 
> on Wednesday 26 January 2011 04:13:00 Peter wrote:
> 
> [...]
> 
> > I wonder if the import would work, if I made the header like this ..
> > 
> > !Type:CCard
> > D06/09/97
> > T-876.54
> > CX
> > POpening Balance
> > L[]
> > ^
> > 
> > So, that the header is present, for the decimal places, and no
> > bank/account
> > 
> >  is specified (between the '[' and ']' ) , so KMM will ask for the
> >  account to be imported in ??
> 
> It might be easier to use the following lead-in:
> 
>   !Account
>   NANZ VISA
>   TCCard
>   ^
>   !Type:CCard
> 
> and don't specify an opening balance transaction but simply add
> transactions.
> 
> 
> p.s. No guarantee that this will work with your version, but you can at
> least try.

Okay, thanks, I will try that. I see no date record, so I assume the dates 
loaded from the trans will be of the right format.

Peter

Hi,

On Wednesday 26 January 2011 19:19:37 Thomas Baumgart wrote:
> Hi,
> 
> [SNIP]
> It might be easier to use the following lead-in:
> 
>   !Account
>   NANZ VISA
>   TCCard
>   ^
>   !Type:CCard
> 
> and don't specify an opening balance transaction but simply add
> transactions.
> 
> 
> p.s. No guarantee that this will work with your version, but you can at
> least try.

I made the beginning of the QIF file like this ...

!Account
NANZ  VISA
TCCard
^
!Type:CCard
^

and it seemed to work okay; the closing balance is the same as the a/c closing 
balance from M$ Money.

Just a few things ........... (I have done an export to QIF on that account, 
plus converted KMY files before and after to XML, and then compared the 2 sets 
of files (QIF/QIF and XML/XML)


1.  In some instances, where there was no category on the import QIF file, KMM 
added a category. Here is a trans set on import ..


D03/03/98
T-39.17
POzemail
^
D03/03/98
T-24.00
PInstant Photo Pty Ltd
^
D03/04/98
T18.00
PANZ Bank
^


and here is what the (new) QIF had in it ..


D03/03/98
T-39.17
POzemail
LComputer:Internet Connection
^
D03/03/98
T-24.00
PInstant Photo Pty Ltd
^
D03/04/98
T18.00
PANZ Bank
LBank Charges:Cash Advance Fee
^

There may well have been a category 'Computer:Internet Connection' for the 
payee 'Ozemail' on other trans though, so KMM may be just being 'clever'. It's 
no big deal, as some of the newly added categories _may_ be correct.   :)

-----------------------------------------------------------------------

2.  The date format on the (new) output QIF file was different, but only for 
year 2000.  Here is an input trans ..


D05/08'00
T-0.30
PAustralian Government
LTaxes:FID
^

and the output trans, see the year as '100

D05/08'100
T-0.30
PAustralian Government
LTaxes:FID
^


But, this was only for year 2000, the exported date format for 2001 and prior 
to 2000, was the same as input (e.g. D09/28'01 )

------------------------------------------------------------------------

3.  Other

(i) The trans all appear as yellow, except for those that were 'already 
loaded', by a previous import. I _think_ there is a function to get rid of 
that.

(ii) I noticed one 'split' was missing. the total amount was okay, with memo 
details, but the 3 split trans were missing. yet other splits were there ??

(iii) Noticed memos were added, where a memo was missing on the import, and it 
was a split trans. That is, no memo for total amount trans on input,, so KMM 
enters the memo from the first split trans, and uses that as the memo for the 
total trans (this is okay though, quite clever).

------------------------------------------------------------------

4.  One payee name went strange

i/p

D10/23'02
CX
MTyre - Puncture repair
T-15.00
PAutomobiles Dandenong (Aust) P/L
LAutomobile:Maintenance
^


o/p

D10/23'02
CX
MTyre - Puncture repair
T-15.00
PMobil
LAutomobile:Maintenance
^

Notice the string 'mobile' is in the payee 'Automobiles Dandenong (Aust) P/L'

---------------------------------------------------------------

5.  The XML file compare. Looking at XML files (before and after import

Added 81 payees - ok

Added a sub account under assets 
    <SUBACCOUNT id="A000515" />
although this doesn't appear to be the 'ANZ  VISA' liability a/c as before, as 
that still appears under Liabilities. Can see one sub-acount under Assets that 
I don't think was there before, ... minor problem.  Some trans from M$Money 
may have had a 'sub account' setup between the '[' and the ']' , like a colon 
seperating the two.

All else appears to be okay, basically a whole lot of new transaction sets, 
new sub accounts, new payees, etc, etc.  What I was really looking for in the 
XML file, was to make sure that none of the other accounts were changed in any 
way (bank accounts). That was one reason why I went through the QIF file, and 
'removed' transaction sets that referred to other (bank) accounts, for this 
a/c load, as they were already there from previous imports. This was mainly 
due to the fact that I had a lot of trouble with importing, with the 'trans 
matching' going a bit strange. This was sometime ago, it has no doubt been 
fixed, but better to only add trans that affect this 'ANZ  VISA' account.

Regards,

Peter