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

Discussion in 'Microsoft Money' started by Milan Tandon, Aug 18, 2004.

  1. Milan Tandon

    Milan Tandon Guest

    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
     
    Milan Tandon, Aug 18, 2004
    #1
    1. Advertisements

  2. 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.
     
    Cal Learner-- MVP, Aug 18, 2004
    #2
    1. Advertisements

  3. Milan Tandon

    Milan Tandon Guest

    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.
     
    Milan Tandon, Aug 18, 2004
    #3
  4. 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.
     
    Glyn Simpson, MVP, Aug 19, 2004
    #4
  5. Milan Tandon

    Guest

    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
     
    , Jun 17, 2014
    #5
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.