Converting XML data into the format which can be directly opened in Money.


M

Milan Tandon

Hi,
Can you please help me in arriving at some technical
solution for my requirement.

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

Following 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 Mny format at the
runtime and then open that into Money or save that file so
that I can later open it using Money. If I want to follow
this approach I don't know the format of .MNY. Is there
any documentation available that tells about the format of
MNY. 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 MNY or any other format that can be directly
opened into Quicken\Money.
If this approach is possible and anybody has worked on it
then please provide some information on it.

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

Thanks & Reagrds
Milan
 
C

Cal Learner-- MVP

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

Select QIF

See how the Open action is performed. That may be sufficient to show
the way you could pass QIF into Money. I don't have information on
mnyimprt.exe beyond that.
 
M

Milan Tandon

-----Original Message-----


Look at Start->Settings->ControlPanel->FolderOptions-
FileTypes

Select QIF

See how the Open action is performed. That may be sufficient to show
the way you could pass QIF into Money. I don't have information on
mnyimprt.exe beyond that.

.
Is Microsoft going to support QIF format going ahead. It
has been heard that Quickn has stopped supporting QIF
format with Quicken2005 and after that. So, just wondering
if Microsoft is still going to support it.
 
G

Glyn Simpson, MVP

I hope not. The UK banks tend to provide one or the other (OFX), and
dropping QIF import would cut off a good proportion of them which wouldn't
be great for MS Money in the UK.
 
S

sam.jones

Hi,
Can you please help me in arriving at some technical
solution for my requirement.

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

Following 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 Mny format at the
runtime and then open that into Money or save that file so
that I can later open it using Money. If I want to follow
this approach I don't know the format of .MNY. Is there
any documentation available that tells about the format of
MNY. 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 MNY or any other format that can be directly
opened into Quicken\Money.
If this approach is possible and anybody has worked on it
then please provide some information on it.

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

Thanks & Reagrds
Milan
Liquid XML Studio has a number of capabilities which will easily allow you to work with your data in xml and validate against most financial schemas.

http://www.liquid-technologies.com/xml-studio.aspx
 

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