tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/61978-importing-microsoft-money-qif-file-hangsInfinite Kind: Discussion 2020-10-09T21:00:26Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/484530272020-07-09T18:39:05Z2020-07-09T18:39:05ZImporting Microsoft Money (qif) file hangs<div><p>Hello,</p>
<p>Can you try resetting your Moneydance preferences and see if that fixes the issue that you're seeing? To do this, you have to rename your config.dict file. If you're using Mac OS X, it should be located at one of these locations within your Home folder:</p>
<p>Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict</p>
<p>or:</p>
<p>Library/Application Support/Moneydance/config.dict</p>
<p>If you have any trouble finding your Home Library folder, open Finder and select Go>Go to Folder> and type in:</p>
<p>~/Library</p>
<p>This should pull up your local Library folder.</p>
<p>If you're using Windows, it should be located at:</p>
<p>C:/Users/(yourusername)/.moneydance/config.dict</p>
<p>If you're using Linux, it should be at:</p>
<p>/home/(yourusername)/.moneydance/config.dict</p>
<p>Once you've found your config.dict file, close Moneydance and rename it (to something like config2.dict, for example), then open Moneydance again and it will appear as though you've just installed Moneydance for the first time, so you'll have to re-enter your license key and may have to locate and open your data set again. If you run into any problems, you can simply close Moneydance and rename the original config.dict file back to config.dict and open Moneydance again to restore your original settings.</p>
<p>If that doesn't work, can you please recreate the situation where the program appears to freeze? Then, after you force quit, <em>but before you restart Moneydance</em>, please find and send me your errlog.txt file. This may contain error messages about what is happening right before the program freezes. If you're using Mac OS X, it should be located at one of these locations within your Home folder:</p>
<p>Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt</p>
<p>or:</p>
<p>Library/Application Support/Moneydance/errlog.txt</p>
<p>If you have any trouble finding your Home Library folder, open Finder and select Go -> Go to Folder and type in:</p>
<p>~/Library</p>
<p>This should pull up your local Library folder.</p>
<p>If you're using Windows, it should be located at:</p>
<p>C:/Users/(yourusername)/.moneydance/errlog.txt</p>
<p>If you're using Linux, it should be located at:</p>
<p>/home/(yourusername)/.moneydance/errlog.txt</p>
<p>Ethan<br>
Infinite Kind Support</p></div>Ethantag:infinitekind.tenderapp.com,2009-01-14:Comment/484530272020-07-09T18:50:11Z2020-07-09T18:51:39ZImporting Microsoft Money (qif) file hangs<div><p>I get a similar problem, maybe two out three times, importing qif files from a Santander bank account. I never have a problem importing ofx files from another bank account. I'll think about about trying Ethan's suggestion :)</p></div>rkmttag:infinitekind.tenderapp.com,2009-01-14:Comment/484530272020-07-10T20:56:02Z2020-07-10T20:56:02ZImporting Microsoft Money (qif) file hangs<div><p>Starting with a new config.dict did not fix the problem. Below is the<br>
errlog.txt. It looks like the problem is the cash back I get every month<br>
using the card. Here's the entry in the qif file that seems to be causing<br>
the problem:</p>
<p>D</p>
<blockquote>
<p>N T11.55 PAmount MYOUR STORE CARD STATEMENT CREDIT ^</p>
</blockquote>
<p>Starting Moneydance 2019.3 (1880) at Fri Jul 10 15:48:08 CDT 2020<br>
Settings Folder: /home/jbodnar/.moneydance<br>
OS: Linux 5.3.0-62-generic amd64<br>
Java: 11.0.2 (Oracle Corporation)<br>
Is in sandbox: false; restricted file access: false<br>
Initializing fonts:<br>
preferred: [[Dialog]] regular: [[SansSerif, Dialog]] mono: [[Gill Sans, Monospaced]] fonts resolved:<br>
default: Dialog:12.0:style0 mono: Gill Sans:12.0:style0 header: Dialog:14.0:style0 register: SansSerif:11.0:style0 registerMinor: Dialog:11.0:style0 reportTitle: SansSerif:32.0:style0 calendarTitle: Dialog:11.0:style0 reportHeader: Dialog:10.0:style0 detailTitle: Dialog:14.0:style0 Initializing fonts:<br>
preferred: [[Dialog]] regular: [[SansSerif, Dialog]] mono: [[Gill Sans, Monospaced]] fonts resolved:<br>
default: Dialog:12.0:style0 mono: Gill Sans:12.0:style0 header: Dialog:14.0:style0 register: SansSerif:11.0:style0 registerMinor: Dialog:11.0:style0 reportTitle: SansSerif:32.0:style0 calendarTitle: Dialog:11.0:style0 reportHeader: Dialog:10.0:style0 detailTitle: Dialog:14.0:style0 opening last file: null<br>
Opening account book: jbodnar<br>
loading dataset: /home/jbodnar/.moneydance/Documents/jbodnar.moneydance<br>
loading with 128 bit encryption key<br>
reading trunk data tiksync/trunk<br>
trunk data loaded (0.936 seconds), checking for incremental updates<br>
loading un-synced txn files...<br>
loading synced txn files...<br>
replacing root: null () with new root: My Finances<br>
(f4ddbaea-1dd4-4204-be35-0106f05e54db dropbox folder should be at /home/jbodnar/Dropbox and exists=true<br>
base sync folder: /home/jbodnar/Dropbox/.moneydancesync<br>
dropbox folder should be at /home/jbodnar/Dropbox and exists=true<br>
base sync folder: /home/jbodnar/Dropbox/.moneydancesync<br>
Imported book: jbodnar root: My Finances<br>
Created account 'Imported Credit Card Account' (CREDIT_CARD)<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []</p>
<blockquote>
<blockquote>
<blockquote>
<blockquote>
<p>added QIF txn: D = 06/07/2020; M = AMAZON DIGITAL SEATTLE WA<br>
Murder on the Orient Express; N = P934200HGEHMQ88FZ; P = Purchase; T = -4.32; 20200607 Purchase -432<br>
added QIF txn: D = 06/15/2020; M = AMAZON RETAIL SEATTLE WA<br>
Bowery Knob Non-Turning Lock,<br>
Schlage F40 BWE 618 Bowery Kno<br>
Schlage F10 BWE 618 Bowery Kno<br>
SHIPPING AND TAX; N =<br>
P934200HTEHM6GQNN; P = Purchase; T = -367.81; 20200615 Purchase -36781<br>
added QIF txn: D = 06/18/2020; M = AMAZON RETAIL SEATTLE WA<br>
Schlage F10 BWE 619 Bowery Pas<br>
Schlage F40 BWE 619 Bowery Pri<br>
SHIPPING AND TAX; N = P934200HVEHM717GB; P = Purchase; T = -199.24;<br>
20200618 Purchase -19924 added QIF txn: D = 06/19/2020; M = AMAZON RETAIL SEATTLE WA<br>
Wellness Complete Health Natur<br>
SHIPPING AND TAX; N = P934200HXEHM6NQ55; P = Purchase; T = -73.79; 20200619 Purchase -7379<br>
added QIF txn: D = 06/21/2020; M = AMAZON RETAIL SEATTLE WA<br>
Amazon.com Refund; N = P934200HYEHM696PJ; P = Return; T = 74.64; 20200621 Return 7464 added QIF txn: D = 06/21/2020; M = AMAZON MARKETPLACE SEATTLE WA<br>
HD Webcam 1080P with Privacy S; N = P934200HYEHMBAJ84; P = Purchase; T = -58.44; 20200621 Purchase -5844<br>
added QIF txn: D = 06/22/2020; M = AMAZON RETAIL SEATTLE WA<br>
Natural Balance Fat Dogs Low C<br>
SHIPPING AND TAX; N = P934200HZEHM6HQ1W; P = Purchase; T = -53.57; 20200622 Purchase -5357<br>
added QIF txn: D = 06/22/2020; M = AMAZON RETAIL SEATTLE WA<br>
InPlace Shelving 0191406 Float<br>
SHIPPING AND TAX; N = P934200HZEHM6QGV5; P = Purchase; T = -84.42; 20200622 Purchase -8442<br>
added QIF txn: D = 06/22/2020; M = AMAZON RETAIL SEATTLE WA<br>
Amazon.com Refund; N = P934200HZEHM67D90; P = Return; T = 37.32; 20200622 Return 3732 added QIF txn: D = 06/22/2020; M = AMAZON RETAIL SEATTLE WA<br>
Sterno Home GL22720BK, Black P<br>
SHIPPING AND TAX; N = P934200HZEHM70Z7F; P = Purchase; T = -18.56; 20200622 Purchase -1856<br>
added QIF txn: D = 06/23/2020; M = AMAZON RETAIL SEATTLE WA<br>
Amazon.com Refund; N = P934200J0EHM6PNDK; P = Return; T = 37.32; 20200623 Return 3732 added QIF txn: D = 06/25/2020; M = AMAZON RETAIL SEATTLE WA<br>
Amazon.com Refund; N = P934200J1EHM6Y99S; P = Return; T = 218.53; 20200625 Return 21853 added QIF txn: D = 06/27/2020; M = AMAZON RETAIL SEATTLE WA<br>
Schlage F40 BWE 619 Bowery Pri<br>
SHIPPING AND TAX; N = P934200J4EHM644R7; P = Purchase; T = -25.19; 20200627 Purchase -2519<br>
added QIF txn: D = 06/28/2020; M = AUTOMATIC PAYMENT - THANK YOU; N = F934200J400CHGDDA; P = Payment; T = 219.91; 20200628 Payment 21991<br>
added QIF txn: D = 06/29/2020; M = AMAZON RETAIL SEATTLE WA<br>
Schlage F10 BWE 619 Bowery Pas<br>
SHIPPING AND TAX; N = P934200J7EHM6BL1F; P = Purchase; T = -73.86; 20200629 Purchase -7386<br>
added QIF txn: D = 06/30/2020; M = AMAZON RETAIL SEATTLE WA<br>
Kwikset Single Cylinder Deadbo<br>
SHIPPING AND TAX; N = P934200J7EHM6NBMQ; P = Purchase; T = -19.1; 20200630 Purchase -1910<br>
added QIF txn: D = 06/30/2020; M = AMAZON MARKETPLACE SEATTLE WA<br>
Colgate Cavity Protection Toot; N = P934200J7EHMAY3MV; P = Purchase; T = -16.99; 20200630 Purchase -1699<br>
added QIF txn: D = 07/01/2020; M = AMAZON RETAIL SEATTLE WA<br>
Hanes Men's ComfortBlend Max C<br>
SHIPPING AND TAX; N = P934200J8EHM69GE6; P = Purchase; T = -22.72; 20200701 Purchase -2272<br>
added QIF txn: D = 07/01/2020; M = AMAZON MARKETPLACE SEATTLE WA<br>
Major Anti-Diarrheal Loperami; N = P934200J9EHMB5HL7; P = Purchase; T = -13.98; 20200701 Purchase -1398<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a year in the list of date tokens: []<br>
Unable to find a day-of-month value in the list of date tokens: []<br>
added QIF txn: D = ; M = YOUR STORE CARD STATEMENT CREDIT; N = ; P = Amount; T = 11.55; 0 Amount 1155</p>
</blockquote>
</blockquote>
</blockquote>
</blockquote></div>jason