In article <m3itt013ks4gdk02smabflghjra4o1gbs2[at]4ax.com> ,
Cal Learner-- MVP <via_newsgroup[at]please.tnx> wrote:
- quote -

Cal, Thanks for working on this issue. Yes, there might be something
wrong with my site. But in any case, my conversion utility is
finished. If anyone wants it, I'll send the source code (it is
written in ANSI C). I'm calling it qifq2m.
--
David Arnstein
arnstein+usenet[at]pobox.com

In microsoft.public.money, David Arnstein wrote:

- quote -

I created a test file which I described below. I imported it as a
statement from my bank into a bank account into a Money 2005 file.
The transactions came in. Some tests use slashes, and some use
apostrophes. The following were the results in Money 2005, sorted
by the interpreted date. The Num in QIF is both the sequence number
in the QIF and the check number field of the QIF. They were not
exactly what I had anticipated, but they were all accepted:

Num in QIF Interpreted Date Year in QIF

7 01/15/1951 Date Specified: /1951
4 01/15/98 Date Specified: /98
5 01/15/98 Date Specified: '98
1 01/15/00 Date Specified: '00
8 01/15/33 Date Specified: '33
2 01/15/50 Date Specified: /50
3 01/15/50 Date Specified: '50
6 01/15/51 Date Specified: /2051


You might want to paste the header and a sample problem transaction
or two into a reply. There may be something other than the
apostrophe going on.




- quote -

===========Begin DateTest.qif====================================
!Type:Bank
D01/15'00
CX
MTest date '00
T-1.00
N0001
PTest Payee '00
^
D01/15/50
CX
MTest date /50
T-1.00
N0002
PTest Payee /50
^
D01/15'50
CX
MTest date '50
T-1.00
N0003
PTest Payee '50
^
D01/15/98
CX
MTest date /98
T-1.00
N0004
PTest Payee /98
^
D01/15'98
CX
MTest date '98
T-1.00
N0005
PTest Payee '98
^
D01/15/2051
CX
MTest date /2051
T-1.00
N0006
PTest Payee /2051
^
D01/15/1951
CX
MTest date /1951
T-1.00
N0007
PTest Payee /1951
^
D01/15'33
CX
MTest date '33
T-1.00
N0008
PTest Payee '33
^
===========End DateTest.qif====================================

Check out (google) a program called MT2OFX. It may not have the exact
conversion you are looking for, but you can talk to the author at
mt2ofx[at]xs4all.nl and see what it would take to do it.

...ken...


"David Arnstein" <arnstein[at]panix.com> wrote in message
news:crk7rl$q4h$1[at]panix2.panix.com...
- quote -

I use QIF files to transfer data from Quicken to Money.

I find that Quicken 2005 and Microsoft Money 2005 use slightly different
QIF files. In particular, Quicken writes dates in its QIF files that
feature apostrophes (') in the "year" field. Money does not use
apostrophes.

The odd thing is that Money was successfully reading the QIF files
generated by Quicken. Sometime around January 1, things stopped working.
I can import a QIF file from Quicken into Money, but Money won't assign
dates to any of the imported transactions.

I plan to write a translation program to modify QIF files. I would like
to know if anyone else has seen this problem. Also, has anyone else
found a QIF file conversion program. I'd rather use an existing program
than write one myself.
--
David Arnstein
arnstein+usenet[at]pobox.com