joshua655 / mdcsvimporter

Automatically exported from code.google.com/p/mdcsvimporter
GNU Lesser General Public License v3.0
0 stars 0 forks source link

Wells Fargo CSVs #5

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Jovanovic:
I have heard your call for additional CSV formats and would like to submit 
one from Wells Fargo.

I will be happy to perform testing for you of this format.

BTW:
Wells Fargo's website has description fields that are much longer than the 
32 characters allowed by the QFX/OFX format.  The whole field is available 
in the CSV downloads but, as you noted, the MoneyDance Text File Importer 
does not bring the items in as tranactions that can be accepted/merged.

Please note the following:
  The file is not provided with column headers
  All column entries are surrounded by quotes which need to be stripped
  The third column always contains a "*" and can be ignored
  The fifth column contains the description which appears to be up to 128 
characters.

Thank you for your help.

- Brad

Original issue reported on code.google.com by Fuzzy.Ch...@gmail.com on 15 Mar 2010 at 3:55

Attachments:

GoogleCodeExporter commented 9 years ago

Hi,

Sorry for not responding earlier. I am rather busy at the moment. I think I 
will be
able to check this out in few days.

Miki.

Original comment by Jovanovi...@gmail.com on 23 Mar 2010 at 8:45

GoogleCodeExporter commented 9 years ago
Finally had some time to work on this. Here is the proposed fix. I need you to 
test
it a bit. If you approve I will release it. 

One small thing, when trying to detect the format, I check that the first 
column is a
date, second amount, third has to be the star, fourth is ignored and the fifth 
is
assumed to be free form description. If any of these are not followed, reader 
will
not recognize the format. I try to be as strict as possible, because I believe 
its
better to be safe then sorry. If you need any changes to the format, please 
tell me.

Regards,
Miki.

Original comment by Jovanovi...@gmail.com on 8 Apr 2010 at 11:45

Attachments:

GoogleCodeExporter commented 9 years ago
Miki:
It works perfectly!  So much easier than the "Text File Importer" and manual 
merging 
I was doing before.  It even saves me the step of having to manually strip the 
quotes with a text editor.

Thank you so much for your help.

- Brad

Original comment by Fuzzy.Ch...@gmail.com on 14 Apr 2010 at 5:55

GoogleCodeExporter commented 9 years ago
Good to hear! I'll make this part of a release soon.

Miki.

Original comment by Jovanovi...@gmail.com on 14 Apr 2010 at 5:08