tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/475-md2010-unable-to-import-at-allInfinite Kind: Discussion 2018-10-18T13:54:35Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/6917142009-12-08T06:44:04Z2009-12-08T06:44:05ZMD2010 Unable to import ... AT ALL<div><p>Hi; I have used Prospects. the issue here isn't Moneydance. The
problem you have, which I also had, is that Prospects is not
completing an export to QIF correctly or at all.</p>
<p>If you try and import a QIF generated by Prospects to almost any
(I tried quite a few) software you will find nothing happens.</p>
<p>Prospects appears to be dead and unsupported now; which is why I
was pleased to return to Moneydance after using the software
previously.</p>
<p>Dependant on how much data you have in Prospects your only
option may be to re-type into Moneydance by hand.</p></div>Simontag:infinitekind.tenderapp.com,2009-01-14:Comment/6917142009-12-10T04:14:46Z2009-12-10T04:14:46ZMD2010 Unable to import ... AT ALL<div><p>Dave,</p>
<p>I am sorry to say that I have no experience with Prospects, but
if you are comfortable sending us your QIF in a private case we are
happy to look at it and see if we can make some magic happen (which
from the other user's advice seems unlikely).</p>
<p>I'm sorry I can't be of more help, but please let me know if I
can be of further assistance, and thank you for your interest in
Moneydance.</p>
<p>Angie Rauscher<br>
Moneydance Support</p></div>Angie Rauschertag:infinitekind.tenderapp.com,2009-01-14:Comment/6917142009-12-11T17:01:52Z2009-12-11T17:01:55ZMD2010 Unable to import ... AT ALL<div><p>Hi Angie,</p>
<p>I had the same issue as the user above and being a developer
myself I did some quick research and found two main issues with the
Prospect QIF files.</p>
<ol>
<li>
<p>Prospect files are in Unicode (UTF-16 Little-Endian) as reported
by TextWrangler, which Moneydance completely ignores. When
converted to plain ASCII Western (Mac OS Roman) by TextWrangler the
import works fine.</p>
</li>
<li>
<p>There is only one big flaw in the Prospects QIF files and that
is that it has a !Type:Bank header line on every single
transaction. It seems this header line should only be on the first
transaction within a list of transactions. With an original
Prospects QIF file and selecting the "New Account" option on the
Moneydance import dialog you will end up creating a new account for
every single transaction!</p>
</li>
</ol>
<p>You can avoid this problem on by exporting each account on
Prospects on separate QIF files and then importing into Moneydance
onto existing empty accounts. In this case you only need to convert
the Prospects file to ASCII with TextWrangler (which is free), or
any other program of the sort, and it will work, or at least it
does with my account files.</p>
<p>I hope this helps.<br>
Cheers,<br>
Juan</p></div>Juan Colominatag:infinitekind.tenderapp.com,2009-01-14:Comment/6917142009-12-11T20:37:14Z2009-12-11T20:37:15ZMD2010 Unable to import ... AT ALL<div><p>Hi Juan,</p>
<p>Thank you for taking the time to post this solution.</p>
<p>Unfortunately I must not being doing something right, as I have
not yet been able to get this to work.</p>
<p>I downloaded Textwrangler and used it to open my qif file. Then
I went to "Save As" and the ONLY change I made was to the
"Encoding" which I changed to "Western - Mac OS Roman"</p>
<p>I then tried to import the resulting saved file into Moneydance.
I tried both importing it into a "New Account" and also tried into
"an Existing Account (which was empty - no data in it) In both
cases I got the same result ... nothing happened.</p>
<p>Would you mind helping me out and walking me through the process
you used ... in as much step by step detail as you can?</p>
<p>This would be a godsend if I can get it to work!! Thank you
again for your help!!</p>
<p>PS - I tried to attach a screenshot of the changes I made in the
Save As dialog box, just so you could see what I was doing.</p>
<p>Note to Angie .... I've gone ahead and begun setting up new
accounts in Moneydance for going forward, even if I can't import my
old data. I certainly don't want to keep using Prospects knowing
all my data will be permanently "trapped". I am finding Moneydance
2010 to be a great program that looks like it will fit my needs.
Thank you for your offer to help me. If I can't get this to work
with Juan's help ... I may take you up on your offer.</p></div>davegnottatag:infinitekind.tenderapp.com,2009-01-14:Comment/6917142009-12-11T21:45:44Z2009-12-11T21:45:44ZMD2010 Unable to import ... AT ALL<div><p>Hi Dave,</p>
<p>I have tried to enter some options you may have chosen by
mistake to see if I can reproduce your trouble, but regardless of
the options it always imports something, even if wrong, once the
file is in Mac OS Roman. In any case make sure the following
options are as follows:</p>
<p>File Source: From Another Program<br>
Date Format: (whatever matches your QIF file, check the file on
TextWrangler, should be easy to see the date format)<br>
SEE INCLUDED IMAGE</p>
<p>I just tried importing a 1000+ transaction file from Prospects
and although it took a good 5 minutes it imported perfectly, even
with categories and subcategories. When you export from Prospects
try to deactivate the Categories option, they will be imported
anyways from your transactions, and may give less trouble exporting
only the account transactions.</p>
<p>If all these options don't work you may not have any other
option than to send your export file to Moneydance support or to me
(but I can understand you may not want to do that, I
wouldn't!).</p>
<p>A test you may be willing to do is to create a new Prospects
account, add a couple of fake transactions and try to export them
to Moneydance. If that import doesn't work you can send me that
test file and we can see what is the problem. If the test file
works for you then your last resort as I said will be to send the
full transaction file.</p>
<p>Best of luck!<br>
Juan</p></div>Juan Colomina