Excel to InfoPath Tool, Unable to open form from DAAT in order to create template - InfoPath Dev
in

InfoPath Dev

Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

Last post 10-23-2012 02:37 PM by ErnestoM. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 10-22-2012 10:17 AM

    • DC Forms
    • Top 150 Contributor
      Male
    • Joined on 06-14-2012
    • Washington, DC
    • Posts 76

    Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

    I am working from the Qdabra's Excel to InfoPath Tool User Guide last updated on 4/26/2012 11:01 AM. On page 9, Scenario B: Output Directly to DBXL, Step 4 states "Open the original form from DAT, and click File > Save to generate a new, blank form. Save it in the “source” folder with the name template.xml, and close InfoPath."

    When I attempt to open my form from DAAT I get the error "InfoPath cannot open a new form. The form template is trying to access files and settings on your computer. InfoPath cannot grant access to these files and settings because the form template is not fully trusted. For a form to run with full trust, it must be installed or digitally signed with a certificate."

    This is an administrator approved web form published to SharePoint.

    How else can I go about generating the template.xml document?


  • 10-22-2012 03:05 PM In reply to

    Re: Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

    Hi-

    Can you provide more info about the form? I'm curious as to why does it require admin approval in SharePoint, i.e. what's the scenario and how the the form in DBXL is integrated with SharePoint. Is there a SharePoint mapping?

    If you can't open the form from DAT, that's not a good sign. I would suggest we take a step back and address the bigger picture (SharePoint integration) before moving on to using the Excel to XML tool.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 10-23-2012 06:58 AM In reply to

    • DC Forms
    • Top 150 Contributor
      Male
    • Joined on 06-14-2012
    • Washington, DC
    • Posts 76

    Re: Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

    The form includes qRules and, along with other forms, the only way I could get them to function in SharePoint as web enabled forms was to publish them as administrator approved form templates. This was done based on the error message suggestions and several threads on the issue.

    I've changed the form options to "Automatically determine security level (recommended)" and republished to SharePoint and DBXL. The form appears to be working as it was before and I am able to open it from the General tab in DBXL.

    But, the option to save the open form is disabled. See attached image.


  • 10-23-2012 02:37 PM In reply to

    Re: Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

    Hi-

    You can re-enable Save in File > Advanced Form Options. If you want Save to be disabled in the long run, you can disable it after getting the template.xml needed for this process.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


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