[Kmymoney] Hello - new and looking for help and advice migrating from MsMoney to KMM

[Peter]

On Wednesday 10 August 2011 21:44:05 you wrote:
> Hi,
> 
> on Wednesday 10 August 2011 13:21:39 Peter wrote:
> > On Wednesday 10 August 2011 20:54:11 Peter wrote:
> > > On Wed, 10 Aug 2011 11:04:33 +0100
> > > 
> > > aga <agander93 at gmail.com> wrote:
> > > > On Wed, 10 Aug 2011 11:22:20 +1000
> > > > 
> > > > Peter <cave at tpg.com.au> wrote:
> > > > > Hello Allan
> > > > > 
> > > > > I have run KMM 4.5.3 on Linux Mint 11 from both the terminal
> > > > > command line and from the start menu and imported the Amex.qif
> > > > > file in each instance with the same results.
> > > > > 
> > > > > I get two accounts, both under the Assets heading,
> > > > > 
> > > > > 1.one showing Amex Gold Card as a checking account (incorrect),
> > > > > with zero balance (correct), and
> > > > > 
> > > > > 2.the other showing Bank of Qld A Account also a checking
> > > > > account (correct), with the direct debit amounts of the Amex Gold
> > > > > Card (as a negative (correct) amount - most likely due to the fact
> > > > > that there is no other balance to offset against - so this would be
> > > > > correct.)
> > > > > 
> > > > > Having now looked at the Amex.qif file with a text editor and seen
> > > > > that the !Type CCard line seems to be correct, should KMM recognise
> > > > > this and import as a Credit Card Liability account?
> > > > > 
> > > > > If it were possible to Edit the import generated Amex Gold Card
> > > > > account and change the type from Checking to Credit Card then
> > > > > perhaps the account would then appear under the Liability heading.
> > > > > 
> > > > > Maybe this is a too simplistic approach to fix the problem??
> > > > > 
> > > > > Regards
> > > > > 
> > > > > Peter
> > > > 
> > > > Hi Peter
> > > > 
> > > > I've just tried again, as it happened on my Mint PC.  Still all looks
> > > > correct.
> > > > 
> > > > I suspect that your accounts may have been set up incorrectly from
> > > > your earlier attempts.  Can you delete both of those accounts (right
> > > > click), when in Accounts view.  You'll need to delete all the
> > > > transactions first.  This may be done in bulk, by selecting all items
> > > > in one of the accounts, then delete.   Then repeat in the other
> > > > account.  If you're not able to delete an account, it will be because
> > > > there are other references to them, possibly in Reports or Schedules,
> > > > if you've got that far yet.
> > > > 
> > > > The credit card account is correctly listed under Liability here.
> > > > I think you're nearly there, at least so far as this issue is
> > > > concerned.
> > > > 
> > > > Allan
> > > 
> > > Hello Alan
> > > 
> > > I have deleted both accounts - no difficulty there- and had also
> > > started the above import with a new clean install of KMM.
> > > 
> > > The accounts button now shows
> > > Liability with no sub accounts and a balance of $0.00 and
> > > Assets with no sub accounts and a balance of $0.00.
> > > 
> > > I must be doing something untoward as I am at a loss to explain how you
> > > can import the file and find it as a Credit Card under Liabilities.
> > > 
> > > Ok - exactly my procedure:
> > > 
> > > Start KMM from the menu
> > > 
> > > Click on file - import - qif, browse for the file and click on it, QIF
> > > profile is Default, Source of QIF is Other Application, then click
> > > Import.
> > > 
> > > Window pops up saying the statement has been processed and the result
> > > is again two Checking accounts under Assets as mentioned above.
> > > 
> > > Is there something I have missed in the above procedure?
> > > 
> > > Regards
> > > 
> > > Peter
> > 
> > Peter,
> > 
> > In my KMM, I have an AMEX account imported from msmoney. It shows 'credit
> > card' under KMM. Here is the header part of the original QIF file from
> > MsMoney..
> > 
> > ----
> > !Type:CCard
> > D11/07'03
> > T0.00
> > CX
> > POpening Balance
> > L[American Express]
> > ^
> > D11/07'03
> > CX
> > etc, etc
> > ---
> > 
> > the exported QIF file from KMM shows ..
> > 
> > -----
> > !Type:Bank
> > D11/07'03
> > T0.00
> > CX
> > POpening Balance
> > L[American Express]
> > ^
> > D11/07'03
> > CX
> > etc,etc
> > ----
> > 
> > but KMM definitely shows it as a credit card under liabilities.
> 
> Maybe just another KMM bug. I admit that QIF export is certainly not the
> strength of KMM.

Thomas,

When I uncompress the KMM data here, my Amex account info is ...

----------
  <ACCOUNT parentaccount="AStd::Liability" lastmodified="2009-06-17" 
lastreconciled="" institution="I000011" number="" opened="2003-11-07" 
currency="AUD" type="4" id="A000462" name="American Express" description="" >
   <KEYVALUEPAIRS>
    <PAIR key="IBAN" value="" />
    <PAIR key="lastStatementDate" value="" />
   </KEYVALUEPAIRS>
  </ACCOUNT>
-----------

Note account type of '4' , which must be a credit card, as my KMM data is 
okay.  Could Peter (the other Peter) uncompress his KMM file, modify the XML to 
account type of '4' , and then compress again to .KMY  ??

... without loss of other data and keeping data integrity intact of course.

Peter