-
Notifications
You must be signed in to change notification settings - Fork 5
Home
==Overview==
[http://moneydance.com/ Moneydance] plug-in to import transactions from CSV files. You can define, simply, on a screen, any number of 'Custom Readers' yourself, one for each Account file. You define the order and fields that will be imported into MD, like Date, Amount, Description, Category, etc... You can ignore fields, and specify that certain fields "Can Be Blank". You can test if a file parses properly, and have it find and list files to import that are tied by file name to a Custom Reader. You can do Regex parsing of csv files for tricky situations. And importantly, it will not import transactions that you previously imported, by doing matching. There is a How To doc you can download with an example of how to define your own custom readers.
- Latest version: only from here - version right in Money Dance is: 15.7.7 at this time, so if you want the latest, get it from here. Remove old version. Restart. Install via 'Add From File'.
The plug-in is still considered BETA, however, it works well for people who have tried it.
It is distributed under GNU LGPL. Among other things this means that it is free, but that the authors cannot take any responsibility for you using this code.
==Downloads are Here Now - google quit allowing new download files==
This extension does not work in Moneydance 2015; just up to MD2014 still. One person made it sound like it will take a little work to make it work in MD2015. I do not have time to change this for a while.
[http://retonews.com/downloads/mdcsvimporter-beta-18.zip mdcsvimporter-beta-18.zip] ([http://retonews.com/downloads/mdcsvimporter-beta-18-count.html download count]) - Dec/31/2014 Fix - Regex parser was not working correctly. It was always using my hardcoded test regex strings :-( Someone tried to use it so I found out. Thanks.
[http://retonews.com/downloads/mdcsvimporter-beta-17.zip mdcsvimporter-beta-17.zip] ([http://retonews.com/downloads/mdcsvimporter-beta-17-count.html download count]) - Nov/23/2014 New Enhancements! - Added:
- filename matcher (regex) for each reader to find files (So now, if you pick a Reader first instead of a file, like say DiscoverCard, then hit 'Find import files for this reader', it will give you a list of files in the drop down that match DiscoverCard filenames like DFS-...csv),
- handle MMM (Dec) date (though only locale.english for now),
- Esc(ape) to close windows,
- mark field that parsed in error in red.
[http://retonews.com/downloads/mdcsvimporter-beta-16.zip mdcsvimporter-beta-16.zip with instructions] ([http://retonews.com/downloads/mdcsvimporter-count.html download count]) - Aug/2/2014 New Enhancements! - Added: Preview window, Add Regex reader, Remove hard-coded internal readers, Turn off automatic testing of readers, Let users test, Fix import to acct bug -
[http://retonews.com/downloads/How-to-use-mdcsvimporter-beta-16.zip Instructions for beta-16]
==Installation==
- This plug-in has been added to the default list of plug-ins right in Moneydance and can be installed right from there.
- You can go to Extensions menu, and choose Manage Extentions, and choose CSV Importer and Install.
- or
- Download the latest plugin from the [http://code.google.com/p/mdcsvimporter/downloads/list Downloads] tab above.
- Unzip to any folder if you get a zip file. Otherwise rename a straight mxt file to plain mdcsvimporter.mxt to use.
- Open Moneydance, open Extensions menu, and choose _Add From File...
- Select the [http://code.google.com/p/mdcsvimporter/wiki/mxt .mxt] file you just unzipped and click Next.
- Click Yes to allow the plug-in to be loaded.
- Inspect the plug-in information and click Finish.
==Usage==
- Download your monthly bills. Make sure you select [http://en.wikipedia.org/wiki/Comma-separated_values CSV file format].
- Open Moneydance, open Extensions and select Import File.
- In the dialog that opens, select the .csv file you downloaded.
- Select account that the transactions should be added to.
- Optionally select "[http://code.google.com/p/mdcsvimporter/wiki/securely_erase_file Securely erase file after processing]" if you wish.
- Click Process.
- If all goes well, dialog will close. Your imported transactions will appear at the bottom of the account view as You have un-recorded downloaded transactions.
==Comments and Help==
To report a bug please use the issues [http://code.google.com/p/mdcsvimporter/issues/list link] above.
All questions and development discussion should be in the [http://groups.google.com/group/mdcsvimporter discussion group].
==Moneydance Support==
Since BETA12, the plug-in should fully support Moneydance 2010 and 2011. January 2013 I successfully imported files into Moneydance 2012.3
==BETA15==
Added more funtionality. Will list when I have time.
==BETA14==
September 2, 2011
ADD: New Custom Readers. This lets users manage multiple reader settings for their own banks. Create configurations for say: Discover card, VISA, private bank, etc... You denote data columns that can be -Payment-, -Deposit-, date, amount, etc... When you choose a file, it will fill out a drop down list of all the readers that match your csv file format by testing your data. You can then select one to use to import your data by.
Stan Towianski
==BETA13==
BETA13 has been released on June 23, 2011. There are no functional changes in the plugin. Only plugin description has been shortened, as a workaround to MoneyDance dialog resizing issue, which meant plugins with long descriptions could not be installed. For detailed changes see [http://code.google.com/p/mdcsvimporter/wiki/ReleaseNotes release notes].