General

Re: Data Migration from Infopath form to Custom sharepoint list

Patrick Halstead — Tue, 03 Aug 2010 05:15:56 GMT

SharePoint supports promoted properties. Open your form in InfoPAth Designer, go to Tools->Form Options and choose Promoted Properties. Select the values you want to appear in your list. Install Qdabra's qRules with support to map XML to SharePoint lists. Define a mapping that updates one of the existing 250 rows based on some unique ID. Open and submit one of the closed forms to test. After you have them all working, you can continue manually (which probably would take an hour), or you can use the batch tool that comes with qRules to upload lots of XML into lists.

(Disclaimer: Qdabra has provided this free forum to the InfoPath online community since 2003. We don't make any money off of the forum, but we do sell a few tools at very reasonable prices. If you find value in this forum and you want to help support Qdabra while saving cost and time developing your solution, please consider trying out qRules or one of the other accelerators. Discounts are available if you like the free trial and want to send us a 2-3 sentence quote that we can use with your first name on our website. There are hundreds of happy qRules users and we will be releasing new functionality in v2.3 soon. Your purchase today enables you to free upgrades.)

Re: Data Migration from Infopath form to Custom sharepoint list

Potemkine — Mon, 02 Aug 2010 21:51:42 GMT

Hi, you can make a form or an application, to parse all your infopath form it's just a xml file.

After that you can use sharepoint web service to insert all the file you parse to your sharepoint list.

Data Migration from Infopath form to Custom sharepoint list

balaramgutru — Mon, 02 Aug 2010 12:25:19 GMT

Hi,

we have an infopath Request form that contains repeating table to Capture the User input and it will be stored in a form Library.

Now we have created an application(similar to infopath form) that store data in to sharepoint list.

My problem is i need to retrieve the data from 250 forms and place it into sharepoint list.

can anyone pls tell me...