Quicken Windows QIF export and date error

[Jaysen]

i finally broke down and decided to make myself cry. So I exported a
quicken (windows) account to a qif file and decided to run the import.
I get the date format error. I tried a few iterations, but can't
figure out the right combo. I was a little paranoid to just start
using regex in the formant field not knowing what it might do. Here
are the specs.

qicken home & business 2007 on XP
qif files show date line as D1/ 2' 6

Representative entry:

D1/ 2' 6
U-44.07
T-44.07
CX
PHome Depot
MJan 2 7:39 Pm #065070 THE HOME DEPOT 1264 VICTOR NY
LHousehold:Repair


Ideas?

Jaysen

[Jaysen]

Tried the explicit "for mac" export. Same format. I sure hope this
means that I can't import the old data. Then I won't have look at it
at all over the next week.

Jaysen

[Jaysen]

I am not the sharpest knife in the block, but here is a quick hack.

1. Open a term window
2. cd to the qif file
3. type the following replace NAME with the name of your file
perl -pe "s/(D.*?)\'/\$i\//" < NAME.qif > NAME-post.qif
4. Now import NAME-post.qif

Problem solved. Well, not really. Now I have to actually look at all
this stuff. Darn it!

Jaysen

[Kevin Hoctor]

Hi Jaysen,

I'll make sure MoneyWell can handle this date format in the 1.4.2
patch. I'm amazed that Quicken is breaking its own rules on formatting
dates in QIF files. That short format doesn't even make sense to me at
all. You should be able to test this patch within the next week.

Peace,

Kevin Hoctor
ke...@nothirst.com
No Thirst Software LLC
http://nothirst.com
http://kevinhoctor.blogspot.com

[Jaysen]

I am pretty comfy with perl and regex so I am all set for my personal
needs. I would be more than happy to help you test the patch though.

I did check my banks QIF download and it is the same. They do support
[OQ]FX which is what I normally use. They do distinguish between
"pre-04" and current versions.

Like I said, I am more than willing to help you with testing.

Jaysen

[jonphipps]

Hi Kevin,

I have data in Win Quicken going back to 1990 and in my QIF exports it
looks like the change in date format is to distinguish between 19xx
and 20xx years, since the export only supports a 2-digit year -- 19xx
years are formatted using m/d/yy instead of m/d' y.

I've decided that it's silly to go back that far with MW, but if you
need someone to test with a very large volume of creaky, cranky old
data (>100,000 transactions) just let me know.

And just for the record, I've tried to get my data out of Quicken for
several years now and Moneywell is the first program I've come across
that actually is able to handle it (so far -- I'm only about 1/3 done,
but I'm confident).

Thanks!
Jon Phipps

On Dec 24, 8:58 am, Kevin Hoctor <ke...@nothirst.com> wrote:

[Kevin Hoctor]

On Dec 24, 2008, at 5:12 PM, jonphipps wrote:

> I have data in Win Quicken going back to 1990 and in my QIF exports it
> looks like the change in date format is to distinguish between 19xx
> and 20xx years, since the export only supports a 2-digit year -- 19xx
> years are formatted using m/d/yy instead of m/d' y.
>

Hi Jon,

I'm determined to figure out why Quicken for Windows insists on using
that lame format for dates in QIF files. It's driving me crazy.

> I've decided that it's silly to go back that far with MW, but if you
> need someone to test with a very large volume of creaky, cranky old
> data (>100,000 transactions) just let me know.
>

Wow. I thought I had a ton with over 12,000 transactions in my file
(of course that's only back to January 2004, I didn't want more than
that). I'll let you know if I want MoneyWell abused. ;-)

> And just for the record, I've tried to get my data out of Quicken for
> several years now and Moneywell is the first program I've come across
> that actually is able to handle it (so far -- I'm only about 1/3 done,
> but I'm confident).

Thanks. I was very concerned that MoneyWell could read my Quicken data
so the QIF import has been refined several times over. Let me know if
you find any glitches.

Peace,

Kevin Hoctor
ke...@nothirst.com