tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/59347-cant-import-qif-into-new-file-just-getting-one-recordInfinite Kind: Discussion 2020-05-21T01:40:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/480988562020-02-18T21:11:01Z2020-02-18T21:11:02ZCan't import QIF into new file. Just getting one record<div><p>Running MD v2017.7.1 (1671)</p>
<p>I use MD to track several Chase credit card accounts. Trying to set up new one is failing. I'm downloading transactions into a QIF file and importing that file, but all I get is the first record. I've looked at the file with a raw editor and see that two years of transactions are in there. Also failing with a partial export/import.</p>
<p>What am I missing here?</p></div>Bill Bartontag:infinitekind.tenderapp.com,2009-01-14:Comment/480988562020-02-18T21:32:38Z2020-02-18T21:32:38ZCan't import QIF into new file. Just getting one record<div><p>I'm a fellow user.</p>
<p>I think I may know the cause of your QIF problem. If you post say the first 20 lines of the file it is pretty easy to check.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/480988562020-02-19T01:07:21Z2020-02-19T01:07:22ZCan't import QIF into new file. Just getting one record<div><p>DWG<br>
I'm not comfortable posting part of my credit card transaction download QIF in a public forum. Is there any way you can explain it without that? <br>
I'm just viewing the file using Notepad, but I can see transaction dates ranging over two years. When I import, I just get the first record. I've imported many such files into MD with no issues. <br>
I've re-downloaded the file from Chase several times. I've deleted the account and recreated it. I've deleted the account and tried to let MD create it on the fly during the import. When I create the account and then use the "Download Transactions" option from the "Online" menu, I only get the <em>last</em> record, oddly enough. There are clues here, but I've run out of guesses. <br>
B<br>
------------------------ On Tuesday, February 18, 2020, 03:32:44 PM CST, dwg <a href="mailto:tender+dae81c24f2@tenderapp.com">tender+dae81c24f2@tenderapp.com</a> wrote:</p>
<table>
<tr>
<td></td>
</tr>
</table></div>Bill Bartontag:infinitekind.tenderapp.com,2009-01-14:Comment/480988562020-02-19T05:47:09Z2020-02-19T05:47:09ZCan't import QIF into new file. Just getting one record<div><p>I'm a fellow user.</p>
<p>A QIF transaction file can contain one or more records however each record must be terminated by an End of Record indicator. In the case of QIF files the End of Record indicator is a caret (^) and that needs to sit in character position 1 on a line by itself.</p>
<p>A valid QIF transaction file looks like:</p>
<p>!Type:Bank D03/03/10<br>
T-379.00<br>
PCITY OF SPRINGFIELD<br>
^ D03/04/10<br>
T-20.28<br>
PYOUR LOCAL SUPERMARKET<br>
^ D03/03/10<br>
T-421.35<br>
PSPRINGFIELD WATER UTILITY<br>
^</p>
<p>If a file has only a Caret at the end of the file only the last record will be imported. If there are no carets then many importers will read the End of File indicator as an end of record and also only import the last transaction.</p>
<p>The reason I usually only ask for about 20 lines is not only is it easy to count it only shares about 4 transactions which does not really tell anyone anything but does show the file structure.</p>
<p>Chase is a serial offender in producing malformed QIF files, and from past user comments seems to be unwilling to fix up their bad programming. A better option to QIF is if you can download OFX files.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/480988562020-02-20T01:39:05Z2020-02-20T01:39:05ZCan't import QIF into new file. Just getting one record<div><p>If dwg's advice didn't answer your question, and you'd like further assistance, you can open up a separate private thread to post your question and attach your file. Only you and the support staff will be able to see it. But I agree, we've seen this from Chase before. I'm pretty sure they offer either OFX or QFX downloads as well for most of their accounts, which would be a better choice than the QIF format anyway.</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethan