How to use Qdabra's InfoPath to SharePoint List Tool - Jo-Anne Alfafara Sign in | Join | Help in Jo-Anne Alfafara Tutorials (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads This Blog Home Syndication RSS Atom Comments RSS Recent Posts DBXL and SharePoint Document Sets Forms with code? Use Content Type mapping in DBXL! Prevent Shredding Errors using Conditional Shredding Retrieve Images and Files from DBXL using Web Service URL Dynamic SharePoint List Submit with Content Types Tags active directory ADWS browser-enabled content type mapping DBXL form code InfoPath IPFS Archives June 2012 (1) March 2012 (2) June 2011 (1) March 2011 (1) October 2010 (3) September 2009 (1) July 2009 (2) May 2009 (1) April 2009 (1) February 2009 (1) Jo-Anne Alfafara How to use Qdabra's InfoPath to SharePoint List Tool Wondering why you can't publish your InfoPath form to a SharePoint custom list? This is a limitation of both InfoPath and SharePoint - you can only publish forms to a form library/document library but not to a custom list. Submitting data to a custom list requires the use of content types – which is a long process. We find that many users experience this problem, so Qdabra provides a quick and easy solution. Qdabra’s InfoPath to SharePoint List Tool allows you to quickly import any InfoPath form XML file to a SharePoint list, creating a list item with data from specified fields in the form. INSTALLATION AND SETUP Run the Qdabra InfoPath to SharePoint List Tool executable file. Click Next and enter the path to the folder where you want to install InfoPath to SharePoint List Tool. Click Next twice to finish the installation. A blank command line will show up and indicates that the install is successful. Click Close in the installation wizard. Go to the folder where you placed the installation and open the Qdabra InfoPath to SharePoint List Tool template. For the purposes of this tutorial, we will use the sample SharePoint list below. Note that the columns were manually added in the list. The SharePoint list still has no documents. We will use the InfoPath to SharePoint List Tool to populate the fields with InfoPath XML files. HOW TO DEFINE THE MAPPING Click on the Define Mapping tab. In the Source XSN field, attach the InfoPath template file that you want to use in the SharePoint list. In the Target SharePoint Site URL, enter your SharePoint URL. If you are working on your root site, the URL should only be the SharePoint root site and should not include the list name (e.g. http://<servername>). If you are using a SharePoint subsite, the URL should be in http://<servername>/sites/<sitename> format. Supported Formats: SharePoint Root site: http://<servername>/ http://<servername> http://<servername>/default.aspx SharePoint sub site: http://<servername>/sites/<sitename>/ http://<servername>/sites/<sitename> http://<servername>/sites/<sitename>/default.aspx Click on Get SharePoint Lists button . You will notice that the SharePoint Lists dropdown is now populated with your current SharePoint lists. Now select the SharePoint list where you want to map your form to and click on Extract Schemas button. MAPPING USING NON-REPEATING DATA If you’re mapping data from non-repeating fields, do not check Data is from repeating group box. Then proceed to the steps below: In the Mapping Definition section, insert a row to add a new mapping. Then click on the small browse icon to the right of the Form Field. This will bring up your form’s schema displayed in the task pane. Expand the form's schema in the task pane. In the Schema Tree, double click the field that you want to be displayed in your SharePoint list. The form will then get the XPath value of the selected field. Select the SharePoint Column where you want to map the form field. Repeat the previous steps to select the fields that you want to display in your SharePoint list until all are mapped to your SharePoint columns. MAPPING USING REPEATING DATA If you wish to import repeating data, simply check Data is from repeating group box. Click on the small browse icon to browse for the repeating group. Expand the form’s schema in the task pane. In the Schema Tree, double click the repeating group that you want to use. The form will then get the XPath value of the selected group. Finally, select all the fields that you want to display in your SharePoint list: IMPORT INFOPATH XML FILES After defining the SharePoint mapping, click on Import Forms tab. You'll see that our Target SharePoint List URL is already specified in the field. Below are the following options on how you can import your XML files: a. Click on the File to Import attachment field and attach your InfoPath XML file. OR b. Click on Browse button for the folder path that contains your XML files. This function allows you to bulk import your files fast and easy. Note that you will only be allowed to select one from the two options. If you selected repeating data from the Define Mapping tab, select an XML file with repeating data. Otherwise, select an XML file with a single row of data. Now click on Import button. A confirmation mesage will be displayed informing you that the import succeeded. (In this case, we used the Folder Path option so we can bulk import the XML files.) That's it – your InfoPath XML files are now imported to your SharePoint list! SAVE AS QRULES MAPPING In Define Mapping tab, you’ll notice the Save As qRules Mapping button displayed at the bottom. If you are not using qRules 2.0, you may ignore this function. Otherwise, when you click it, it should save a file with a default name of mapping.xml. The button is intended to use after you have mapped your form fields to your SharePoint columns, so make sure to complete the mappings prior to clicking the button. Please refer to qRules 2.0 User Guide on how to use the mapping file with qRules commands. NOTES: This is a one time operation. Once the XML is uploaded to SharePoint, you cannot use the mapping in this tool to edit the form in SharePoint. If you open the form in Design Mode and Preview, you might get a Visual Basic/C# error. Just click Ignore to get rid of the error. The Title and Attachment columns are included as default items in the SharePoint column dropdown. After importing the file(s), the Title column value by default is (no title), you can modify the default value by going through your SharePoint settings. This will serve as the link for you to open your form in the SharePoint List. If you opt to save the form itself while the mapping is already in place, you will see the GUID(ID) of the SharePoint list displayed as value in the SharePoint Lists dropdown the next time you open the form. The workaround is to click Get SharePoint Lists button and this will swap in the SharePoint List friendly name. Your selection will be kept and you can start importing your XML files again. Qdabra's InfoPath to SharePoint List Tool is available for purchase at Qdabra.com. Published Apr 04 2009, 11:58 AM by Jo-Anne Alfafara Comments Links (4/5/2009) « Steve Pietrek - Everything SharePoint and Office said: Pingback from Links (4/5/2009) « Steve Pietrek - Everything SharePoint and Office April 5, 2009 9:46 AM tgfo62 said: will this work to create list items for a repeating table from one form? June 8, 2009 1:00 PM Patrick Halstead said: Hi Tammi, Currently, the tool will not do this. It can either upload a single form, or a folder of forms. There is a feature request to enhance it as you have requested but we don't expect to have that done for a month or so. Thanks! June 9, 2009 3:49 PM Hilary Stoupa said: qRules 2.0 is here, and it has a whole host of cool new commands. One of the real superstars is SubmitToSharePointList November 18, 2009 3:00 PM Hilary Stoupa said: qRules 2.0 is here, and it has a whole host of cool new commands. One of the real superstars is SubmitToSharePointList December 23, 2009 5:35 PM rimonabantexcellence site title said: Pingback from rimonabantexcellence site title June 13, 2013 11:09 PM Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
a. Click on the File to Import attachment field and attach your InfoPath XML file.
OR
b. Click on Browse button for the folder path that contains your XML files. This function allows you to bulk import your files fast and easy.
Pingback from Links (4/5/2009) « Steve Pietrek - Everything SharePoint and Office
will this work to create list items for a repeating table from one form?
Hi Tammi,
Currently, the tool will not do this. It can either upload a single form, or a folder of forms. There is a feature request to enhance it as you have requested but we don't expect to have that done for a month or so.
Thanks!
qRules 2.0 is here, and it has a whole host of cool new commands. One of the real superstars is SubmitToSharePointList
Pingback from rimonabantexcellence site title