HOW can I Create modified XML output (vanilla XML?) - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

HOW can I Create modified XML output (vanilla XML?)

Last post 09-17-2012 01:31 PM by NICK1081. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-16-2012 06:03 PM

    HOW can I Create modified XML output (vanilla XML?)

     I need to provide XML output from my Info Path to a third party who does not have Info Path but wants the data in XML.

    Is there any way to create a 'customized' XML output file with native Info Path or qRules or anything else ?

    In other words, I need to spit out something as simple as:

    <?xml version="1.0"?>
    <icm>
     <metadata>
      <no></no>
      <type></type>
      <icm_date></icm_date>
      <rr_date></rr_date>
      <rev></rev>
      <closed_date></closed_date>
      <to></to>
      <originator></originator>
      <rel_ecp_pscn></rel_ecp_pscn>
      <rel_js_ipcd></rel_js_ipcd>
      <rel_cp></rel_cp>
      <subject></subject>
     </metadata>
    </icm>

    The data is all in the form record. The native XML output from Info Path is not acceptable to this third party. The group tags and such have to be removed, etc.

    I should mention... I realize that Info Path outputs in XML. The output that Info Path provides is just way more than what is wanted/needed by this other party.. 

    Any suggestions?

    thanks

    DMN
  • 09-17-2012 10:54 AM In reply to

    Re: HOW can I Create modified XML output (vanilla XML?)

    It sounds like your form design may already be quite far along, but in this situation the most natural option would be to create a new form based off this XML format (in the Designer start page, one of the template types is "XML or Schema").  This would preclude you from adding fields to the main data source, but you would be able to use secondary data sources for temporary storage.

    How are you looking to output the produced XML? By saving the files locally, or by submitting the XML to some network destination (web service, etc.)?

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 09-17-2012 01:31 PM In reply to

    Re: HOW can I Create modified XML output (vanilla XML?)

     thanks for the reply !

    the xml output will be sent as a "text file" attachment to an email.we have a private line between the 2 parties involved and a home grown email application that will be used.

    The source file will be saved in a SharePoint forms library in our network environment.

    I just have to produce a generic simplified xml file output for this other company that does not have Infopath.

    In other words, I've got to strip off the...

    <?mso-infoPathSolution solutionVersion="1.0.0.2" productVersion="12.0.0" PIVersion="1.0.0.0" href="file:///C:\Documents%20and%20Settings\m196000\Local%20Settings\Application%20Data\Microsoft\InfoPath\Designer2\97d887c7d11943fd\manifest.xsf" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?><icm xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-09-17T21:17:13" xml:lang="en-us">

     and leave them with:

     <?xml version="1.0" encoding="UTF-8"?>
        <icm_no>test</icm_no>
        <icm_type>test</icm_type>
        <icm_date>test</icm_date>
        <rr_date>test</rr_date>
        <rev_letter>test</rev_letter>
        <rev_date>test</rev_date>
        <closed_date>test</closed_date>
        <to>test</to>
        <originator>test</originator>
        <rel_ecp_pscn>test</rel_ecp_pscn>
        <rel_js_ipcd>test</rel_js_ipcd>
        <rel_cp>test</rel_cp>
        <subject>test</subject>
        <ref>test</ref>
        <encl_message>test</encl_message>
        <approvals>
            <author1>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </author1>
            <author2>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </author2>
            <author3>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </author3>
            <ictl1>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </ictl1>
            <ictl2>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </ictl2>
            <ictl3>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </ictl3>
            <contproc>
                <name>test</name>
                <date>test</date>
                <role>test</role>
            </contproc>
        </approvals>
    </icm>

     

    I realize you're probably laughing at this point because I too realize this seems silly but I've got to give them what they want.

    I could do this manually but i was hoping I could put a button on my form somewhere that would spit this out.

    I'm relatively new to info path so I'll have to play with creating a form in some other fashion... up til now, I've just clicked on Design a form template.. blank.

    I'm going to stop here and go experiment using your suggestion. I would not be able to hold an intelligent conversation passed this point.

    :-)

     THANKS. I'll get back with more questions, I'm sure !

     

    DMN
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.