Java.lang.NullPointerException
I am trying to export from Quicken and importing to Moneydance but I get a "java.lang.NullPointerException" error and can go no further
Any suggestions so I can transfer multiple years of Quicken to Moneydance?
Thanks
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 Ian O on 02 Nov, 2016 08:20 AM
Hi Rick,
Sorry to hear you are encountering issues. Can you let me know the steps you are taking to import your data?
When importing your data, if the QIF file format is available to you when exporting from Quicken, you should follow these steps. In particular make sure you specify to Import into a new account rather than an existing account. And you set the source to "From another program".
It is highly recommended to export all Quicken data into a single QIF file, as doing so makes the import process much smoother. Please use the option in Quicken to export "all accounts" if available. The one exception to this is if you have accounts in more than one currency - if thats the case, then you can follow these steps to import multiple QIF files.
I hope this information is helpful. Please let me know if you have any questions or if I can be of further assistance.
Ian O
Infinite Kind Support
2 Posted by Rick on 04 Nov, 2016 12:24 AM
Ian
I exported my entire Quicken files as one file QIF, but as I said in my query, I received the “java.lang.NullPointerException” error message when I attempted to import it as a new account as per instructions on Moneydance site.
I have no accounts in currency other than US$.
Thanks
Rick
3 Posted by Grynn on 05 Nov, 2016 12:39 AM
I'm experiencing the exact same error. I downloaded MoneyDance tonight and tried to import my QIF file from Quicken 2014. I also only have US currency.
Awaiting further suggestion on resolving the issue.
4 Posted by Patricia Wong on 07 Nov, 2016 03:52 PM
To echo what others have said in this thread, I too have just downloaded Moneydance and was trying to import Quicken data.
Here are the steps I took:
I opened up MD and was presented with the three options: Create a new account set, Import new account set, and Get help with Moneydance. I selected option 2 (import new account set).
I was then presented with a dialog box where I find and then select my QIF file to import. (My QIF file contains all accounts)
Once I select that file, I'm immediately presented with the the dialog box:
Error reading file:
java.lang.NullPointerException
and can go no further.
My QIF file was created from Quicken 2017 Premier, if that makes any difference. I might also add that if this problem cannot be resolved, I will be forced to ask for a refund, as I have a lot of data to import from Quicken and do not wish to import it all manually.
5 Posted by dwg on 07 Nov, 2016 07:52 PM
I have found this post in another thread, perhaps you can try this approach:
"Are you trying to import this data via the Moneydance Welcome Window. We have had reports that the current build of Moneydance encounters difficulty when trying to import from the Welcome Screen, the developers are working to rectify this.
In the meantime, can you select 'Create a new account set' and then create a new blank data set. Once the blank data set has opened, can you navigate to File --> Import and attempt to import your QIF file this way?"
6 Posted by Patricia Wong on 07 Nov, 2016 11:34 PM
OK, I did what you suggested. Unfortunately, the balances on a couple of my accounts are way off when I import data the way you suggested. I'm just trying to figure out if there's an easy way to find out what's wrong and to fix it.
7 Posted by Patricia Wong on 08 Nov, 2016 02:49 AM
One (hopefully) final update on my import experience:
As I said previously, the balances were way off on a couple of accounts after importing my data. What I found on one of the accounts was that quite a few transactions were entered twice during the import process. Those transactions were transfers to another account. I simply located those duplicates and deleted them.
On the other account whose balance was messed up, I found one transaction that was a transfer from another account which had a negative amount and should have been a positive amount, so I manually corrected that.
Conclusion: There seems to be a problem with import data that involves transfers to/from another account. Other than that, the remaining data imported correctly.
Thanks for your help. I'm now in business!
8 Posted by dwg on 08 Nov, 2016 06:22 AM
Patricia,
The problem with Duplicate transaction on transfers is something that can occur. At the heart of the problem is that there is no transaction ID or similar in the QIF specification, thus there is nothing that can be used to positively identify duplicates.
This makes it very difficult for the import to be absolutely certain when to ignore data, sometimes you get better results when importing as a single file yet on other occasions it seems to work better when you import one account at a time, different versions of Quicken will also produce QIF files with subtle differences.
Unfortunately QIF is one of the few formats that are available to work with, and one of the few formats aimed specifically at financial data.
Fortunately migration is a one time exercise.
9 Posted by jamesyel on 08 Nov, 2016 10:04 PM
Interesting discussion.
About two months ago I imported 10 accounts and three years of data from Quicken Windows 2016. The actual import went smoothly but organizing the imported data took a bit of time and patience.
I had a number of duplicate transactions (mostly transfers between accounts) and a number of transaction categories to update. I found three features to be indispensable during the process ....
1. The Search feature (upper right hand corner) to find duplicates.
2. The Bulk Change feature (select several transactions and right click) to bulk change a number of transactions.
3. The ability to set an initial Account balance if the import needs fine tuning. Select an Account and then click Account > Edit Account > Initial Balance.
Bottom line for me ... organizing the import took some effort but the switch to MoneyDance Windows seems to be well worth the effort.
10 Posted by dwg on 08 Nov, 2016 11:14 PM
FWIW The Find and Replace extension can also be really useful.
System closed this discussion on 07 Feb, 2017 11:20 PM.