Import QIF Fails - Moneydance appears not to respond
I am attempting to import a long-term Quicken file (QIF) into
Moneydance to evaluate and possibly switch. Details:
Exporting from Quicken Mac 13.0.2 - R3; I have exported all data
(going back to 1993) into a single QIF file, which is 2.4 MB in
size.
Importing to Moneydance Vr 2010r2 (735).
I have selected Import to: New Account, File Source: From another program, and checked Import Account Info Only option, but when I select OK, nothing seems to happen. I have left the application to work for an extended period of time with no apparent activity. Eventually - after a period of time ranging from 5 minutes to 30 minutes - I have had to use the Finder to force quit the application, which is shown as "not responding".
I'd love to jettison this old software, and I've heard nothing good about Quicken Essentials, so I was hoping Moneydance will be a viable alternative, but first I must get my activity imported to find out.
Any suggestions?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Ben Spencer on May 07, 2010 @ 07:23 PM
I might be the case that the java virtual machine is runing out of memory during the import. We have increased the amount of memory allocated to the JVM at startup in the latest preview version. You can download it from the link below:
http://moneydance.com/trac/wiki/Moneydance2010Beta
Drag your current Moneydance app to the trash and download the new one.
Ben Spencer
Moneydance Support
2 Posted by Fred Weiner on Jan 28, 2011 @ 05:56 PM
I have a near identical problem. Using MD v. 2010r3(751) on Mac OS X v. 10.6.6. Java v. 1.6.0_22. Attempting to import a smallish QIF (partial export from a Quicken 2007 Mac account), following instructions to the letter, Moneydance sits and appears to do nothing. Here's the console output: trying import: java.awt.dnd.DropTargetContext$TransferableProxy@1ff8de3
I'm aching to abandon Quicken for this program, but its import/export functions seem buggy, the reports are not as detailed or configurable, but that is a matter for another discussion.
FW.
3 Posted by bkmi on Jan 28, 2011 @ 06:07 PM
To be honest, I ultimately gave up. I did get my file imported, if I remember correctly, but there were so many adjustments I'd have had to make that I bailed.
I did try Quicken Essentials - it's a pile of, well, don't bother if you need anything resembling a good financial package. I've clung to my old Quicken 2004 until now.
I'm currently investigating iBank, and may go with it, but I'll miss the old Quicken's speed and familiarity. But, sticking with it has meant that I couldn't update to Snow Leopard (I think) and all it brings to the table.
4 Posted by Ben Spencer on Jan 28, 2011 @ 07:31 PM
I am afraid that the various mac versions of Quicken do not produce QIF files in the same way that the Window version of Quicken does. To the extent that it is even a non trivial issue moving from the mac version of Quicken to the Windows version of Quicken. I am afraid that due to the QIF files produced by macs not being consistent with the Windows version there is a significant amount of manual cleaning up that needs to be done after import a QIF for Quicken for mac (particularly if there are investment accounts involved).
I am sorry that Moneydance did not meet your needs.
Sincerely
Ben Spencer
Moneydance Support
5 Posted by Fred Weiner on Jan 29, 2011 @ 02:32 AM
On Fri, Jan 28, 2011 at 12:31 PM, Ben Spencer <
[email blocked]<tender%[email blocked]>
> wrote:
> I am afraid that the various mac versions of Quicken do not produce QIF
> files in the same way that the Window version of Quicken does. To the extent
> that it is even a non trivial issue moving from the mac version of Quicken
> to the Windows version of Quicken. I am afraid that due to the QIF files
> produced by macs not being consistent with the Windows version there is a
> significant amount of manual cleaning up that needs to be done after import
> a QIF for Quicken for mac (particularly if there are investment accounts
> involved).
>
> I am sorry that Moneydance did not meet your needs.
>
Wait a minute. You did not even address the issue I have written about, or
at least I don't understand that you did. The issue is that attempting to
import a QIF from Quicken Mac 2007 results in--nothing happening. I sent
along the console message, "trying import:
java.awt.dnd.DropTargetContext$TransferableProxy@1ff8de3," which indicates
to me it has to do with java, but is otherwise incomprehensible. Someone in
your department should be able to understand it and supply a more specific
answer than you have. I have not given up on Moneydance, but your response
pushes me a little bit in that direction because it did not directly address
my issue. Are you saying that you at Moneydance are giving up on Quicken/Mac
users altogether?
Fred Weiner
6 Posted by bkmi on Jan 29, 2011 @ 03:03 AM
Well, Fred, what I take away from Ben's response is that - even though Moneydance is pitched as a Mac application, in addition to Windows and Linux - transferring data from various versions of Quicken/Mac is just too problematic for them to work through effectively. While Moneydance may be an acceptable (maybe very good) app for someone just starting out, it appears to not be very good for someone like you and me who have a history in Quicken they'd like to preserve.
My Quicken data goes back to 1993, and originated on a Windows machine. I made the conversion to the Mac platform in 2004 (it went very smoothly, I might add). I actually have no problems/issues with continuing to use my current Quicken 2004, except that I believe I'm stuck at OS X 10.5 if I don't convert. It's my understanding that Q-04 won't run under 10.6, even with Rosetta (I'd sure like confirmation/clarity on that!). My Snow Leopard DVD just sits on my desk mocking me - I'd hate to install it and find out I'm hosed, and have to go back.
7 Posted by Fred Weiner on Jan 29, 2011 @ 03:53 AM
On Fri, Jan 28, 2011 at 8:03 PM, bkmi <
[email blocked]<tender%[email blocked]>
> wrote:
> My Quicken data goes back to 1993, and originated on a Windows machine. I
> made the conversion to the Mac platform in 2004 (it went very smoothly, I
> might add). I actually have no problems/issues with continuing to use my
> current Quicken 2004, except that I believe I'm stuck at OS X 10.5 if I
> don't convert. It's my understanding that Q-04 won't run under 10.6, even
> with Rosetta (I'd sure like confirmation/clarity on that!). My Snow Leopard
> DVD just sits on my desk mocking me - I'd hate to install it and find out
> I'm hosed, and have to go back.
I have Quicken for Mac 2007 and it works fine on Snow Leopard. Try
converting to 2007 and it should work, though you may have to buy 2007 or
find a used copy somewhere.
8 Posted by Ben Spencer on Jan 29, 2011 @ 03:03 PM
Hi Fred
I am sorry I did not fully respond to your question.
The error message "trying import: java.awt.dnd.DropTargetContext$***@1ff8de3" is related to the use of drag and drop with the mouse. Are you trying to import your QIF file either by dragging it onto the Moneydance program icon or dragging it into the running Moneydance program? If either of these are the case could you instead run Moneydance, create a new blank data file and select File->Import QIF... and then browse to your data file.
Is the error message your got the entirety of the out put of the Console Window? If not could you paste everything that is in the console window to this discussion.
Sincerely
Ben Spencer
Moneydance Support
9 Posted by Fred Weiner on Jan 29, 2011 @ 03:39 PM
On Sat, Jan 29, 2011 at 8:04 AM, Ben Spencer <
[email blocked]<tender%[email blocked]>
> wrote:
> Are you trying to import your QIF file either by dragging it onto the
> Moneydance program icon or dragging it into the running Moneydance program?
> If either of these are the case could you instead run Moneydance, create a
> new blank data file and select File->Import QIF... and then browse to your
> data file.
>
> Is the error message your got the entirety of the out put of the Console
> Window? If not could you paste everything that is in the console window to
> this discussion.
>
Hey Ben.
Dragging into MD was indeed one of the ways I tried to import a QIF created
by Quicken/Mac 2007. Also by the method of going through the prompts
following the "Import" menu. Neither of which resulted in any data transfer
that could be found. Your suggestion about creating a blank data file and
importing to that worked--up to a point: the categories were not imported
accurately. What I wanted to accomplish, in this period of evaluation, is to
enter monthly data into Quicken and export just that set of entries to a QIF
(Quicken allows this); then, import it to the parallel account in
Moneydance, to save double entry aggravation. Now, with your help, I have a
successful (if not entirely complete and accurate) import, but to a
different data file than where I want the data to be. Is there a way, now,
to bring that data into the account I want it to be in (after fixing the
categories)?
Here's the latest complete console output, and , by the way, the last one I
sent was in fact the complete output.
Starting Moneydance 2010r3 (751)
Settings Folder: /Users/DrFred/.moneydance
OS: Mac OS X 10.6.6 i386
Java: 1.6.0_22 (Apple Inc.)
merging old downloaded txns
setStatus(Loading File, 1.0)
setStatus(, 0.0)
I appreciate your help. I want to use Moneydance if I can make it work.
Fred Weiner
10 Posted by Ben Spencer on Jan 29, 2011 @ 04:16 PM
When you say "the categories were not imported accurately." can you be more specific? Did the categories import at all? If not can you make sure that you are checking the "From another program" option on the QIF import window.
The method of importing transactions one month at a time is going to be fine. However you must set the option to "Import to: New Account" each time you import a file. If you set the "Import to: Existing account" option all of the transactions in the the QIF file will be imported into the same existing account. When you select the "Import to: New Account" option if an account already exists with the same name as the name used in the QIF file the transactions will be imported into that account.
I suspect that the problem you are having when trying to import into the existing .md file rather than the blank .md file is that you are setting the "Import to: Existing account" option and are putting all the transactions in the same account. Please try importing the QIF file into the correct .md file with the "Import to: New Account" option and the "From another program" option set on the QIF import window.
It may be necessary to rename the existing accounts in your .md file to match then names used in the QIF file.
Ben Spencer
11 Posted by Fred Weiner on Jan 29, 2011 @ 10:05 PM
Ben, I've solved it. Dragged you through some in the process[?]: I was not
EXPORTING from Quicken properly. When I figured that out, then imported the
QIF into my current, existing, account file, MD brought it all right in
complete with accurate categories. It is not necessary to import into a new
account. It works. So far. I would say that I should RTMS, but I have, and
refer to it, and it's not very good. But the program seems to be, once the
user gets his head straight. FW.
On Sat, Jan 29, 2011 at 9:16 AM, Ben Spencer <
[email blocked]<tender%[email blocked]>
> wrote:
12 Posted by Angie Rauscher on Jan 30, 2011 @ 12:40 AM
Fred,
I'm so glad it's working now, and that you figured it out! And you're right about our user guide, we're working on it now and look forward to creating an even better experience for our users!
Thanks for sticking with it, and please let me know if I can be of further assistance,
Angie Rauscher
Moneydance Support
Angie Rauscher closed this discussion on Jan 30, 2011 @ 12:40 AM.