importing csv files
hi,
I upgraded to the new version because I changed laptops. I was used to the old csv importing tool. the new version doesn't recognize my csv files and does not import the first line. I try to delete the "1" where header line is mentioned, but it doesn't save that default. please help,
regards
martin
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
Support Staff 1 Posted by Maddy on 05 Aug, 2021 03:18 PM
Hi Martin,
We are sorry to hear about the problem you have encountered.
Which version and build of Moneydance are you using?
To check, open Moneydance and select Help --> About Moneydance (or Moneydance --> About Moneydance on a Mac) where the version and build number will be displayed.
Can you let me know which operating system you're running on your computer/s?
Have you tried following the steps outlined in this article of the Knowledge Base?
Also, please could you confirm which bank do you download your data from?
Is CSV the only format available?
--
Maddy, Infinite Kind Support
2 Posted by aon on 05 Aug, 2021 04:36 PM
Hi,
Build is: 2021.1. (3069)
I am running Big Sur. 11.2.1
Unluckily my bank only offers CSV downloads like the one attached
Greetings
martin
Martin Kühnl
Hauptstraße 5
3381 Gollilng an der Erlauf
Austria
3 Posted by -Kevin N. on 05 Aug, 2021 05:41 PM
Hi Martin,
I was able to successfully import your bank's CSV file using Moneydance's CSV Importer extension. (Menu bar > Extensions > Manage Extensions > CSV Importer)
Take a look at the screenshot and let me know if it looks OK to you. (the Date format may be different than yours)
Give the CSV Importer a try. If you need help setting up the extension, let me know and I'll try to walk you through it.
I noticed in your bank's CSV file a BOM (Byte Order Mark) in front of the Date in the first row. This is likely the cause of the first row being ignored. I used the Date in the third column of the CSV file in my import.
-Kevin N. (not a member of MD support)
4 Posted by aon on 06 Aug, 2021 01:34 PM
Hi kevin,
Thank you for your answer; alas, there seems to be a problem with my version of the csv importer. I cannot set up the extension.
greetings
martin
Hauptstraße 5
3381 Gollilng an der Erlauf
Austria
5 Posted by -Kevin N. on 06 Aug, 2021 02:12 PM
Hi Martin,
I'll assume that you have the CSV Importer extension installed.
Download a CSV file from your bank to your 'Downloads' folder.
We'll need to start by creating a custom file reader designed to import the data from your bank. You will only need to do this once per bank.
From the Moneydance Menu bar, go to Extensions > Import File.
When the main screen of the CSV Importer opens, click the 'Maintain Custom File Readers' button.
In the resulting window, set up the custom reader per my screenshot.
For the 'Reader Name' you can, of course, name the reader whatever is informative to you. I chose 'Martins Bank'. Enter the desired name and click the 'Add' button. The name that you just entered should now be listed in the 'List of Readers' section.
Leave the 'Filename Matcher' field as is.
Continue by making sure to enter the proper Date Format: dd.MM.yyyy
Number of Header Lines: 0
Number of Footer Lines: 0
CSV Field Separator: ; (semi-colon)
File Encoding: UTF-8
Decimal Sign: , (comma)
Set Fields 1 ~ 5 as indicated in the screenshot.
When you've completed setting up the custom reader, click 'Save' and 'Done'.
(Back at the main screen of the CSV Importer)
Make sure that the proper File Reader is selected (for when you have more than one Custom Reader)
You should then be able to click the 'Find Import File(s) for this Reader' button. ('Find Import File(s)...' looks for a CSV file in your 'Downloads' folder) If clicking that button does not populate the 'File' field then click the [...] button to navigate to your CSV file.
Make sure that the proper 'Import to Account' option is selected to import the file into.
For the 'Import Transaction As' option, select the 'Regular' option. You can experiment with that and see which option serves you best. The 'Online' option seems to include a Category field.
Look things over, make sure everything is correct.
Click, the 'Preview Import' button.
A preview window will open. Provided there are no 'red' or 'yellow' flagged txns listed in the preview, you can go ahead and click the 'Process' button.
The first time that you run the CSV Importer, there may be some informational message that pops up. I forget exactly what it reads but you should look that over. You'll then receive a message indicating the number of imported items as well as other information relevant to the imported txn(s).
That should do it.
I realize that written out like this it looks to be a very complex means of importing your data but as you'll see, it's really not so bad once the custom reader is set up.
Let me know how it works out for you. OK?
-Kevin N. (not a member of MD support)
6 Posted by aon on 06 Aug, 2021 02:33 PM
Hi,
I did everything like described and get a yellow „date“ when clicking on „preview“
Martin
Martin Kühnl
Hauptstraße 5
3381 Gollilng an der Erlauf
Austria
7 Posted by aon on 06 Aug, 2021 02:36 PM
It works now, I changed the date format had the underlines instead of the points,
Thanks you very much!!!!!
Martin
Martin Kühnl
Hauptstraße 5
3381 Gollilng an der Erlauf
Austria
8 Posted by -Kevin N. on 06 Aug, 2021 02:46 PM
Hi Martin,
You're welcome.
I'm glad to hear that you were able to get things sorted.
Thank you for reporting back with your results.
-Kevin N. (not a member of MD support)
Maddy closed this discussion on 06 Aug, 2021 02:48 PM.