<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Ok, sorry, I'm not very good at this mail list stuff, never really
used them. I'm used to Forums. :) As a follow up, with the new
version, it imported 10x better. I still had some cleanup work, but
actually only a little. I also couldn't change the Account from one
currency to another. I opened the .kmy file with a text editor,
found the right account, and changed it from USD to PEN, and all
worked great! They were re-imported as PEN currency, so I didn't
have to worry about the exchange rate! :) Some fanangling, but in
the end all worked great, I'm happy as a lark. Case closed,
everything solved.<br>
<br>
@Allan indeed those were duplicated, but it was pretty easy to
remove them in my 'checking' account, because they were the only
things NOT reconciled :). So I filtered things that weren't marked,
and deleted up to the recent date, and hand picked through them.
Really pleased!<br>
<br>
Shane<br>
<br>
On 11/03/2011 02:23 PM, <a class="moz-txt-link-abbreviated" href="mailto:kmymoney-request@kde.org">kmymoney-request@kde.org</a> wrote:
<blockquote cite="mid:mailman.1007.1320348215.6608.kmymoney@kde.org"
type="cite">
<pre wrap="">Send KMyMoney mailing list submissions to
<a class="moz-txt-link-abbreviated" href="mailto:kmymoney@kde.org">kmymoney@kde.org</a>
To subscribe or unsubscribe via the World Wide Web, visit
<a class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/kmymoney">https://mail.kde.org/mailman/listinfo/kmymoney</a>
or, via email, send a message with subject or body 'help' to
<a class="moz-txt-link-abbreviated" href="mailto:kmymoney-request@kde.org">kmymoney-request@kde.org</a>
You can reach the person managing the list at
<a class="moz-txt-link-abbreviated" href="mailto:kmymoney-owner@kde.org">kmymoney-owner@kde.org</a>
When replying, please edit your Subject line so it is more specific
than "Re: Contents of KMyMoney digest..."
Today's Topics:
1. Re: Import from MoneyDance (aga)
2. Re: Import from MoneyDance (Shane Rice)
----------------------------------------------------------------------
Message: 1
Date: Thu, 3 Nov 2011 17:58:36 +0000
From: aga <a class="moz-txt-link-rfc2396E" href="mailto:agander93@gmail.com"><agander93@gmail.com></a>
To: <a class="moz-txt-link-abbreviated" href="mailto:kmymoney@kde.org">kmymoney@kde.org</a>
Subject: Re: [Kmymoney] Import from MoneyDance
Message-ID: <20111103175836.1062d27e@giga>
Content-Type: text/plain; charset=US-ASCII
On Thu, 03 Nov 2011 09:26:45 -0500
Shane Rice <a class="moz-txt-link-rfc2396E" href="mailto:shane2peru@gmail.com"><shane2peru@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Right, I did try that. I created a Soles cash account with the
currency set as PEN, however when I import, because the account is
tied to another account (via transfers) it imports it as US $. I
pull money from the ATM, and enter it as a 'transfer' from bank
account to Cash Soles account with the transfer rate. Example, if I
pull $5 from the bank it get's converted to PEN in Moneydance, and
shows 13.5 PEN. So when that get's imported, it shows both as US$
and really makes a mess of things. I appreciate the help!
Shane
</pre>
</blockquote>
<pre wrap="">
As I understand it, you are importing two interlinked accounts. It may
be irrelevant, but are you importing both accounts in the same file?
If so, it may be that coming across the same transaction twice is
causing the problem, so try one at a time and see if that helps or
makes clearer where things go wrong.
A suggestion on wikipedia for dealing with such transfers, although not
involving different currencies, is to edit the file.
"When editing the QIF file, check for any transaction Category (the
field starting with 'L') for an account name contained in brackets,
such as [Checking Account]. The brackets reference another quicken
account, and if left in place will post a transaction in that account
in addition to the account being imported to, with potentially
troublesome results. Avoid this by removing the text including the
brackets and replacing with another category if desired. The only
exception to this is an opening balance transaction, identified by
'Opening Balance' in the 'P' field (POpening Balance). In this case,
the brackets need to be left in place, and the account name between the
brackets must exactly match the account name in the 'N' field."
Allan
</pre>
<blockquote type="cite">
<pre wrap="">
On 11/03/2011 09:22 AM, Thomas Baumgart wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
on Thursday 03 November 2011 15:12:25 Shane Rice wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I'm finally switching over. I have a few questions. 1. I wasn't
able to figure out a way to import my data from MoneyDance. I
work with 2 different currencies all the time. My primary
currency is the US Dollar, and should be my base. However I work
daily with PEN (Pervian Nuevo Sole). That is why importing was so
difficult. Does anyone know of a way to import multiple
currencies? I also can export to qif individually. So every
account can be exported. So I exported all the US Dollar
accounts, then I can export the PEN account (a cash account)
however I can't import the PEN into KmyMoney. Any ideas??? Every
time it imports it imports as $, not PEN.
</pre>
</blockquote>
<pre wrap="">What happens if you create the cash account before you import to it
and select PEN to be the currency it is denominated in? Since QIF
does not transport any currency information it should import the
data w/o problem. Make sure to have a conversion rate entered into
KMyMoney which covers the past. Otherwise, the categories go a bit
crazy. YMMV
--
___________________
Serving the King,
Shane D. Rice
<a class="moz-txt-link-abbreviated" href="http://www.Rices2Peru.com">www.Rices2Peru.com</a> <a class="moz-txt-link-rfc2396E" href="http://www.rices2peru.com"><http://www.rices2peru.com></a>
<a class="moz-txt-link-abbreviated" href="http://www.ReinaValeraGomez.com">www.ReinaValeraGomez.com</a> <a class="moz-txt-link-rfc2396E" href="http://www.reinavaleragomez.com"><http://www.reinavaleragomez.com></a>
Romans 12:1-2
</pre>
</blockquote>
</blockquote>
<pre wrap="">
------------------------------
Message: 2
Date: Thu, 03 Nov 2011 14:23:13 -0500
From: Shane Rice <a class="moz-txt-link-rfc2396E" href="mailto:shane2peru@gmail.com"><shane2peru@gmail.com></a>
To: Thomas Baumgart <a class="moz-txt-link-rfc2396E" href="mailto:thb@net-bembel.de"><thb@net-bembel.de></a>
Cc: <a class="moz-txt-link-abbreviated" href="mailto:kmymoney@kde.org">kmymoney@kde.org</a>
Subject: Re: [Kmymoney] Import from MoneyDance
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:4EB2EA21.3010001@gmail.com"><4EB2EA21.3010001@gmail.com></a>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
Ok, upgraded KmyMoney to 4.6, and now everything imports much better.
Still have to tinker with it to get it correct, but seems using the
older version didn't import as nicely. So this seems to be working
better now! Thanks!!!
Shane
On 11/03/2011 09:22 AM, Thomas Baumgart wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi,
on Thursday 03 November 2011 15:12:25 Shane Rice wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I'm finally switching over. I have a few questions. 1. I wasn't able
to figure out a way to import my data from MoneyDance. I work with 2
different currencies all the time. My primary currency is the US
Dollar, and should be my base. However I work daily with PEN (Pervian
Nuevo Sole). That is why importing was so difficult. Does anyone know
of a way to import multiple currencies? I also can export to qif
individually. So every account can be exported. So I exported all the
US Dollar accounts, then I can export the PEN account (a cash account)
however I can't import the PEN into KmyMoney. Any ideas??? Every time
it imports it imports as $, not PEN.
</pre>
</blockquote>
<pre wrap="">What happens if you create the cash account before you import to it and select
PEN to be the currency it is denominated in? Since QIF does not transport any
currency information it should import the data w/o problem. Make sure to
have a conversion rate entered into KMyMoney which covers the past. Otherwise,
the categories go a bit crazy. YMMV
--
___________________
Serving the King,
Shane D. Rice
<a class="moz-txt-link-abbreviated" href="http://www.Rices2Peru.com">www.Rices2Peru.com</a> <a class="moz-txt-link-rfc2396E" href="http://www.rices2peru.com"><http://www.rices2peru.com></a>
<a class="moz-txt-link-abbreviated" href="http://www.ReinaValeraGomez.com">www.ReinaValeraGomez.com</a> <a class="moz-txt-link-rfc2396E" href="http://www.reinavaleragomez.com"><http://www.reinavaleragomez.com></a>
Romans 12:1-2
</pre>
</blockquote>
<pre wrap="">-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.html"><http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.html></a>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PERUFlag.gif
Type: image/gif
Size: 20802 bytes
Desc: not available
URL: <a class="moz-txt-link-rfc2396E" href="http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.gif"><http://mail.kde.org/pipermail/kmymoney/attachments/20111103/16976f32/attachment.gif></a>
------------------------------
_______________________________________________
KMyMoney mailing list
<a class="moz-txt-link-abbreviated" href="mailto:KMyMoney@kde.org">KMyMoney@kde.org</a>
<a class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/kmymoney">https://mail.kde.org/mailman/listinfo/kmymoney</a>
End of KMyMoney Digest, Vol 16, Issue 3
***************************************
</pre>
<div class="moz-signature">-- <br>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="content-type">
<title>Simple Signature</title>
___________________<br>
Serving the King,<br>
<big style="font-weight: bold;"><span style="color: rgb(51, 51,
255); font-family: URW Chancery L;">Shane
D. Rice</span></big><br>
<a href="http://www.rices2peru.com" target="_blank">www.Rices2Peru.com</a><br>
<a href="http://www.reinavaleragomez.com">www.ReinaValeraGomez.com</a><br>
Romans 12:1-2<br>
<img style="width: 84px; height: 57px;" alt=""
src="cid:part1.03070205.01010407@gmail.com">
</div>
</blockquote>
</body>
</html>