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. In microsoft.public.money, Milan Tandon wrote:

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

  3. Milan Tandon

    Milan Tandon Guest


    >-----Original Message-----
    >In microsoft.public.money, Milan Tandon wrote:
    >
    >>
    >>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.
    >
    >.
    >


    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, Microsoft MVP - Money

    Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny
    for UK tips and fixes for MS Money. To send Microsoft your wishes or
    suggestions, use http://register.microsoft.com/mswish/suggestion.asp
    or http://www.microsoft.com/uk/support/money/feedback especially
    if it's a UK specific wish.

    I do not respond to any unsolicited email regarding Money
    "Milan Tandon" <> wrote in message
    news:859501c48558$69dd17d0$...
    >
    >>-----Original Message-----
    >>In microsoft.public.money, Milan Tandon wrote:
    >>
    >>>
    >>>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.
    >>
    >>.
    >>

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

    Guest

    Re: Converting XML data into the format which can be directly openedin Money.

    On Wednesday, 18 August 2004 19:12:19 UTC+1, Milan Tandon wrote:
    > 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
     
    , Jun 17, 2014
    #5
    1. Advertisements

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.
Similar Threads
  1. jjrjr
    Replies:
    1
    Views:
    720
    klunk
    Dec 29, 2006
  2. Milan Tandon
    Replies:
    9
    Views:
    4,314
    Michael J. Budwey
    Aug 19, 2004
  3. Colonel Blip

    Data file can not be opened (Q2004 for Mac)

    Colonel Blip, Dec 9, 2006, in forum: Quicken
    Replies:
    0
    Views:
    452
    Colonel Blip
    Dec 9, 2006
  4. Andre

    RE: Email invoices in PDF format directly from MSOA.

    Andre, Dec 6, 2006, in forum: Microsoft Accounting
    Replies:
    1
    Views:
    511
  5. (db)
    Replies:
    2
    Views:
    534
  6. Troy Hutchison

    RE: Email invoices in PDF format directly from MSOA.

    Troy Hutchison, May 7, 2007, in forum: Microsoft Accounting
    Replies:
    1
    Views:
    659
    DKMortensen
    May 7, 2007
  7. Cliff Fox
    Replies:
    4
    Views:
    643
    Maria
    Aug 19, 2007
  8. Krish
    Replies:
    1
    Views:
    363
    Evan Culver
    Nov 18, 2005
Loading...