Converting XML data into a format which can be opened in Quicken and Money


M

Milan Tandon

I have some data in XML format and I want to convert it into a format
which can be opened in Quicken and Money. Specifically I would need to
know what is the format that would be recognized by Quicken and Money
and how to convert my XML data into that format.
Basically my requirment is that I have some data in XML format and I
want to open it in Quicken and Money.
 
Ad

Advertisements

J

John Pollard

Milan said:
I have some data in XML format and I want to convert it into a
format which can be opened in Quicken and Money. Specifically I
would need to know what is the format that would be recognized
by Quicken and Money and how to convert my XML data into that
format.
Basically my requirment is that I have some data in XML format
and I want to open it in Quicken and Money.
You will have to be more specific about what type of data and
what version of Quicken.
 
M

Milan Tandon

It is a transaction history data for an account which is available in
xml format and version is Quuicken 2004 or above.
 
J

John Pollard

Milan said:
It is a transaction history data for an account which is
available in
xml format and version is Quuicken 2004 or above.
Q2004 still accepts QIF file imports (and so does Money, I
believe), so my guess is that is the most likely candidate
format. (If you use a version of Quicken later than Q2004, QIF
file imports will be extremely limited; only a few of the less
used account types will still be able to import from QIF).

As far as getting from XML to QIF, that is an area that I can
not be of much help there. I notice mention of XML to QIF
conversions on the web, though most of the ones I saw seemed to
be for the mac and sounded related to gnucash (not sure why the
latter would matter since XML should be pretty universal).

I do note that "monthtwosys", the makers of "The Financial File
Converter" which can convert delimited files to QIF, appears to
be beta testing an OFX to QIF conversion; perhaps they can be of
help.

http://www.monthtwosys.co.uk/TFFC.htm

TFFC costs around $20 US.

And if you are already able to convert from XML to any delimited
file that can be read by Excel, you can use the free XL2QIF
macro found here

http://xl2qif.chez.tiscali.fr/xl2qif_en.php

to convert Excel data to QIF.
 
M

Milan Tandon

My requirement is to convert transaction history available to me in
XML format into a format which can be directly opened into Quicken or
into a format which can be directly opened into Money. Please note
that I need to do all this transaformation at runtime.

Follwoing are the approaches which I'm thinking of though I'm not sure
how feasible are they(if at all they are possible):

Approach 1 : Convert my XML data into QDF format(for Quicken) or Mny
format(for Money) at the runtime and then open that into Quicken\Money
or save it that file so that I can later open it using Quicken\Money.
If I want to follow this approach I don't know the format of .QDF or
..MNY. Is there any documentation available that tells about the format
of QDF. Though I got the documentation that tells about the format of
QIF (http://www.intuit.com/support/quicken/2004/win/1178.html) but I
couldn't get any documents that speaks about the format of QDF\MNY or
any other format that can be directly opened into Quicken\Money.
If this approach is possible then can anybody has worked on it then
please help.

Approach 2 : Convert my XML data into QIF format then import it into
Quicken or Money. Since I have to do all this at runtime so I would
need the APIs of Quicken or Money (if they are published) using which
we can import that file into Quicken\Money through programming. Is
there any document published on their API's.
 
J

John Pollard

Milan said:
My requirement is to convert transaction history available to
me in
XML format into a format which can be directly opened into
Quicken or
into a format which can be directly opened into Money. Please
note
that I need to do all this transaformation at runtime.

Follwoing are the approaches which I'm thinking of though I'm
not sure
how feasible are they(if at all they are possible):

Approach 1 : Convert my XML data into QDF format(for Quicken)
or Mny
format(for Money) at the runtime and then open that into
Quicken\Money
or save it that file so that I can later open it using
Quicken\Money.
If I want to follow this approach I don't know the format of
.QDF or .MNY. Is there any documentation available that tells
about the format
of QDF. Though I got the documentation that tells about the
format of
QIF (http://www.intuit.com/support/quicken/2004/win/1178.html)
but I
couldn't get any documents that speaks about the format of
QDF\MNY or
any other format that can be directly opened into Quicken\Money.
If this approach is possible then can anybody has worked on it
then
please help.
Approach 2 : Convert my XML data into QIF format then import it
into
Quicken or Money. Since I have to do all this at runtime so I
would
need the APIs of Quicken or Money (if they are published) using
which
we can import that file into Quicken\Money through programming.
Is
there any document published on their API's.
I think you are out of luck on both approaches. I know of no
way to get the format of QDF files nor do I know of any API's
for Quicken. Ask in the Microsoft Money newsgroup for info on
Money.
 
Ad

Advertisements

D

Didier

My requirement is to convert transaction history available to me in
XML format into a format which can be directly opened into Quicken or
into a format which can be directly opened into Money. Please note
that I need to do all this transaformation at runtime.

Follwoing are the approaches which I'm thinking of though I'm not sure
how feasible are they(if at all they are possible):

Approach 1 : Convert my XML data into QDF format(for Quicken) or Mny
format(for Money) at the runtime and then open that into Quicken\Money
or save it that file so that I can later open it using Quicken\Money.
If I want to follow this approach I don't know the format of .QDF or
.MNY. Is there any documentation available that tells about the format
of QDF. Though I got the documentation that tells about the format of
QIF (http://www.intuit.com/support/quicken/2004/win/1178.html) but I
couldn't get any documents that speaks about the format of QDF\MNY or
any other format that can be directly opened into Quicken\Money.
If this approach is possible then can anybody has worked on it then
please help.

Approach 2 : Convert my XML data into QIF format then import it into
Quicken or Money. Since I have to do all this at runtime so I would
need the APIs of Quicken or Money (if they are published) using which
we can import that file into Quicken\Money through programming. Is
there any document published on their API's.
Approach 1: I don't know if it's possible

Approach 2: You can import automatically .qif files into Money and
Quicken as if they were downloaded from the web with a command line:
The default path for Money is:
"C:\Program Files\Microsoft Money\System\mnyimprt.exe" "%1".
The default path for Quicken is:
"C:\Program Files\Quicken\qw.exe" "%1".
Just replace %1 with your filename
 
M

Milan Tandon

Is Microsoft Money going to support QIF format going ahead ? Since
Quicken has stopped support for QIF with Quicken2005 and after, so I
was just wondering whether Money is still going to support it or not.
 
M

Mike B

Milan Tandon said:
Is Microsoft Money going to support QIF format going ahead ? Since
Quicken has stopped support for QIF with Quicken2005 and after, so I
was just wondering whether Money is still going to support it or not.
What surpass my understanding is why you are asking a Money question in a
Quicken group, and moreover, why you are asking a corporate strategy type
question from an assorted bunch of product users. No-one here will have the
faintest idea on what Microsoft's stance re QIF support is or will be.

Mike B
 
Ad

Advertisements

M

Michael J. Budwey

Is Microsoft Money going to support QIF format going ahead ? Since
Quicken has stopped support for QIF with Quicken2005 and after, so I
was just wondering whether Money is still going to support it or not.
I just read a review of Money2005 at pcworld.com. It indicates that
Money2005 does indeed still support .qif imports!
Mike Budwey
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top