cannot import simple CSV file with 3 character date string

joshua655 / mdcsvimporter

Automatically exported from code.google.com/p/mdcsvimporter

GNU Lesser General Public License v3.0

0 stars 0 forks source link

cannot import simple CSV file with 3 character date string #33

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

Using Moneydance 2014.5.  I used standard importers and the import always fails 
with "Unsupported CSV file format".

I also built a custom importer and it also fails.

Error log is attached, along with the sample CSV.

Original issue reported on code.google.com by wmclax...@gmail.com on 25 Oct 2014 at 9:40

Attachments:

GoogleCodeExporter commented 9 years ago

Do get new 16 version from "project home" page. Its better and it shows you 
what fields it parsed your file into if it can. You have to create a custom 
reader. 
Match your date format. It might use java format convention.
If you dont say a field is unneeded, you must supply it.
The drop down with numbers is only used if you want to skip xxx fields. , 
otherwise leave it blank. 
Going off the top of my head as I'm not near my compiter for a couple of days.

Original comment by stashu....@gmail.com on 25 Oct 2014 at 11:56

GoogleCodeExporter commented 9 years ago

Hi. I created a word *.doc file that shows you what to do, with pictures. I use 
LibreOffice. I think the problem is with a Money Dance function I used which is 
not handling Months in dates correctly. Otherwise the rest does work. See my 
attached issue-33.doc

Original comment by stashu....@gmail.com on 12 Nov 2014 at 5:05

Changed title: cannot import simple CSV file with 3 character date string
Changed state: Accepted

Attachments:

issue-33.doc

GoogleCodeExporter commented 9 years ago

Thank you.  I will test it and advise.

Original comment by wmclax...@gmail.com on 12 Nov 2014 at 5:24

GoogleCodeExporter commented 9 years ago

I attached an email. MD says they cannot handle Dec type string dates.
But, I just created mdcsvimporter beta 17 where I handle it by converting Dec 
to 12 then MD will be ok with it. I will be making beta 17 available soon.

Original comment by stashu....@gmail.com on 24 Nov 2014 at 2:21

Changed state: Fixed

Attachments:

[[The Infinite Kind] Re Fwd Re Issue 33 in mdcsvimporter cannot import simple CSV file with 3 character date string.eml](https://storage.googleapis.com/google-code-attachments/mdcsvimporter/issue-33/comment-4/[The Infinite Kind] Re Fwd Re Issue 33 in mdcsvimporter cannot import simple CSV file with 3 character date string.eml)

GoogleCodeExporter commented 9 years ago

I made this fix available as a beta-17.zip download.
It assumes locale.ENGLISH for Dec for now. I will have to
see if people need other languages.

Original comment by stashu....@gmail.com on 24 Nov 2014 at 7:05