text file importer issue
Laurent
Hello
I tried to upload the attached .csv file with the text file importer, but it didn't work.
(I have downloaded the trial version today and want to check everything works properly before buying Moneydance)
Can u plse help?
Best regards
- CM_operations_2013_v3.csv 325 Bytes
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 -Kevin N. on Jul 14, 2013 @ 11:20 PM
Hi Laurent,
Take a look at the attached screenshot and let me know if this looks correct to you
Also let me know what kind of account this is for. Bank or Credit Card.
-Kevin N.
2 Posted by -Kevin N. on Jul 14, 2013 @ 11:40 PM
Hi Laurent,
Let me know if this one is a little better.
-Kevin N.
3 Posted by Laurent on Jul 15, 2013 @ 05:27 AM
hello Kevin
thanks for your swift reply!
your 2nd screenshot looks good to me
(it's a checking / current bank account)
what should I do next?
1. I'd like to upload my historical data (let's say from 01 to 07 2013)
2. Then I need to setup a routine to import my transactions regularly (I'm affraid I will have to upload manually my operations, since my French bank does not allow ofx)
Best regards
4 Posted by -Kevin N. on Jul 15, 2013 @ 12:43 PM
Hi Laurent,
I'm glad to hear that the second screenshot is correct.
To import your data, open the Text File Importer (TFI) and use the following settings:
Screen 1: (see screenshot: Laurent_TFI_Screen_1.jpg)
Browse - navigate to your .CSV file.
Encoding - UTF-8
Click 'Next'.
Screen 2: (see screenshot: Laurent_TFI_Screen_2.jpg)
Account - select the desired account to import the data into.
Fields Delimiter - [ ; ]
Date Format - DMY
Decimal Point - ,
Click 'Next'.
Screen 3: (see screenshot: Laurent_TFI_Screen_3.jpg
Field 1 - Date
Field 2 - Description
Field 3 - Account or Ignore*
Filed 4 - Amount
Field 5 - Memo
Field 6 - Check Number
*Before you click 'Finish'. I want you to realize that doing so will import the rather generic Categories that the bank is supplying which may be different than the Categories that you actually apply to these transactions.
If you are OK with the generic Categories then click 'Finish' to complete the import.
If you would rather not import those generic Categories and will be using your own Categories, then change the 'Field 3' setting from 'Account' to 'Ignore'.
Click 'Finish'.
Post import, you may need to delete the header row (if any) that may have also been imported.
Going forward, the TFI should remember your settings but check them each time you perform an import, just in case.
HTH -Kevin N.
5 Posted by Laurent Simon on Jul 16, 2013 @ 07:39 AM
Hello Kevin
Thank you very much for your inputs: the import worked really well
Starting to really enjoy MoneyDance !
Best Regards
6 Posted by -Kevin N. on Jul 16, 2013 @ 12:24 PM
Hi Laurent,
You're welcome. I'm glad to hear that it worked well.
-Kevin N.
Scott Meehan closed this discussion on Jul 16, 2013 @ 03:56 PM.