Known issues
Average 2.50 Votes: 2

Loading ...

15/03/2010 15 comments

We are experiencing some difficulties importing certain Date fields due to incompatibility of date formats. We expect to have a patch by today.

CSV to QIF bug, correct, error, fix, problem

Comments

Leave a comment Trackback

Written by admin on 18/03/2010.

Fixed bug with incompatible dates. Please let us know if there is any problem converting your CSV files.
Written by Ron on 20/03/2010.

It’s working great now, thanks and keep up the good work.
Written by Drew on 24/03/2010.

MM/DD/YYYY is not working properly. Seems like it is always DD/MM/YYYY
Written by admin on 24/03/2010.

Can you please tell me:
1-What is your operation System: (Windows/Mac, etc)
2-What is your System Time Format? (Example)
3-Are you using Ms Money or Quicken?
4-Could you open the CSV file in the Notepad and check the date format?

Thanks,
Marcelo
Written by drewrosenberg on 24/03/2010.

OS: Windows XP
Time format: English (US)
Software: GnuCash
line from csv file: 3/22/2010,Target,31.52,31.52,Groceries

The last time I used your site was 3/8 and it worked then. This problem has been introduced since then.
Written by admin on 02/04/2010.

Fixed.

Now CSV to QIF recognizes the following Date formats:

DD/MM/YY i.e. 15/01/99 or 15/01/1999 or 15 Jan 1999
MM/DD/YY i.e. 01/15/99 or 01/15/1999 or Jan 15 1999
YY/MM/DD i.e. 99/01/15 or 1999/01/15 or 1999 Jan 15
Written by drewrosenberg on 05/04/2010.

Thanks! I like the new features and everything seems to be working except for one thing. If you are using MM/DD/YYYY and the date format matches DD/MM/YYYY it seems to default to that format.

Example: 3/01/2010 will turn into January 3rd, 2010. However, 3/13/2010 seems to work fine.
Written by Webmaster on 06/04/2010.

Got it fixed. Try it again and let me know how it goes.

The Problem was that the script would recognize the input format and export using the format chosen by the user. This way, any format of date could be imported automatically. But this would cause problems like the one you mentioned, with dates that could be validated either ways.

With this fix, it won’t be possible to import a file with format like DD/MM/YY and export as MM/DD/YY. The input and output will have to be the same format.

Future implementation: When the user maps a content as Date, show a box where the user will be able to choose Input format, output format (if different from input format).
Written by Irene on 22/10/2010.

Hi!

I can’t make this work with downloads from my bank without editing the format of the date manually. Could you maybe make it understand DD.MM.YYYY format?

Thanks!
Written by Clint Redwood on 15/01/2011.

Hi!

My CSV has separate columns for debits and credits, and so I mapped the credits to VALUE and the debits to VALUE-. The debits have worked, but the credits have been imported with no value. In addition, when I checked ignore value=0 it ignored every line, so I suspect that the two are related.

Otherwise, this is a really good tool, and will be lifesaving now my bank doesn’t export anything but CSVs.

Yours,

Clint Redwood.
Written by Webmaster on 17/01/2011.

We have good news. This week we will be releasing a new version that will cover many user suggestions including two new fields for Credit/Debit.
Written by Clint Redwood on 21/01/2011.

Fantastic! I certainly was in luck as the new version has worked perfectly.
Written by Joe on 26/01/2011.

The CSV interpreter is wrong

According to the CSV file format specification. Anything wrapped in “” will be interpreted as a single column. (So ” ,,,,,”,a is 2 columns not 7)

And double quotes within quotes (embedded quotes) are interpreted as quotes within the column. “Hello, “world”" would be => Hello, “world”

For quick break down see:
http://en.wikipedia.org/wiki/Comma-separated_values

Or see full specification:
http://tools.ietf.org/html/rfc4180
Written by Webmaster on 26/01/2011.

Thanks for your comments, we will investigate the problem.
Meanwhile could you please send a sample of your file? You can send a couple of lines via contact form. This will help us to identify the problem and test.
Written by Terry on 07/02/2011.

I have donation data to import to Quicken. I’m having a hard time getting any format that will allow me to assign a budget category and a tag to each transaction. Do you support these fields?

Example:

Account: Ministry Income:Online
tag: d_name

These are in columns in the CSV but they never show up when I upload the CSV. I can format the CSV any way I like since I’m the author.