Upload Data Into SharePoint InfoPath Forms Library

Posted on 2010-03-31
Medium Priority
Last Modified: 2012-05-09
I have a SharePoint forms library that I created to collect information from people within my company.  I utalized info path so I could make fields dynamic and take advantage of many other data validation options it has.  However the one limitation that I see so for is that there is no easy way to import data into the forms.  

If i were in a normal SP list i know i could import information into the list quickly using the datasheet view but the forms library doesn't seem to allow this.

Is there anyway for me to get bulk data into a InfoPath SP Forms Library without creating a new infopath form for each instance?
Question by:PLOperationsSup
1 Comment
LVL 28

Accepted Solution

Clay Fox earned 2000 total points
ID: 29264850
You can create an xml file of the data and then build your forms to possibly import it but this still is a one at a time affair.

The best thing I have seen for automation is www.qdabra.com has a tool to build forms from a spreadsheet and it will make one per row of data very quickly.

So the scenario is run a web report out of a legacy system either once or daily and then save as Excel or csv and process with their tool and it will create and submit the forms to SharePoint automatically.

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question