tag:infinitekind.tenderapp.com,2009-01-14:/discussions/moneydance-development/513-new-python-qif-import-scriptInfinite Kind: Discussion 2017-11-22T10:27:29Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142013-04-24T23:18:44Z2013-04-24T23:18:44ZNew Python QIF import script.<div><p>Hi Kim,</p>
<p>Thanks for sharing your script! I hope that other users will
find it useful.</p>
<p>Please let us know if we can be of any assistance!</p>
<p>Scott Meehan<br>
Moneydance Support</p></div>Scott Meehantag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142013-04-26T07:35:39Z2013-04-26T07:35:39ZNew Python QIF import script.<div><p>I should point out, the script expects dates format in the QIF
file to be MM-DD-YY. My own bank offers Quicken 1997 (MM-DD-YY) or
2003 ( DD-MM-YY) and I picked 1997. I've no idea if this is
standard or not and as far as I can tell there's no way to detect
which is which in some cases ( 01-01-13, for example). It would
explain, though, why Moneydance gets so upset unless I import
Quicken 2002.</p></div>kim.aldistag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142013-04-26T15:01:54Z2013-04-26T15:01:54ZNew Python QIF import script.<div><p>Hi Kim,</p>
<p>If you were having difficulties with importing the QIF file due
to being a different date format, did you try changing the Date
Format drop down menu when trying to import a QIF file by going to
File -> Import?</p>
<p>Scott Meehan<br>
Moneydance Support</p></div>Scott Meehantag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142013-04-26T15:33:26Z2013-04-26T15:33:26ZNew Python QIF import script.<div><p>Hi Scott,</p>
<p>No but until I wrote this script I hadn't worked out that this
was the problem. I think I might have mentioned it to one of your
support staff a while back but because it worked using a 2002
version file I didn't bother following it up.</p>
<p>I've a feeling this might be a problem at my bank's end. I could
be wrong but I wouldn't have thought a Quicken version change would
include a date format change of this type. But then I'm equally
surprised there's no header flag in the file either. But then I'm
not that familiar with the Quicken format so I could be
mistaken.</p>
<p>I've attached another version of the script. An error crept in
just before I zipped the first one.</p></div>kim.aldistag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142014-03-20T11:02:05Z2017-11-22T10:27:29ZNew Python QIF import script.<div><p>I found that the "other transaction" aka the split does not balance with the parent transaction. After I replaced the line</p>
<pre>
<code> split = SplitTxn( newTns, -tIn.Amount, 0, 1.0, acct2, "", -1, ParentTxn.STATUS_RECONCILING )</code>
</pre>
<p>with</p>
<pre>
<code> split = SplitTxn( newTns, -tIn.Amount, -tIn.Amount, 1.0, acct2, "", -1, ParentTxn.STATUS_RECONCILING )</code>
</pre>
<p>the accounts did balance.</p>
<p>Did I miss something or is this indeed how it should be done?</p></div>jeroen.bruijningtag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142014-09-02T11:53:37Z2014-09-02T11:53:46ZNew Python QIF import script.<div><p>Dear all, did Jeroen's solution solve it?</p>
<p>I have the issue that imported transactions show the right
amount in the account they are assigned to. However when opening
the category, the amount is 0!</p>
<p>Thanks<br>
Michael</p></div>Michaeltag:infinitekind.tenderapp.com,2009-01-14:Comment/265463142014-09-06T10:53:53Z2017-11-22T10:27:29ZNew Python QIF import script.<div><p>Hi Michael,</p>
<p>with me the categories are filled with the correct amounts, as far as I can tell. I tried this by adding a category to the sidebar and looking at the details, which were all there.<br>
Are you viewing the categories in some other way? Or did you change the sample code?</p>
<p>Regards, Jeroen.</p></div>jeroen.bruijning