Transferring data from InfoPath 2007 form to 2010 form

Last post 04-19-2013 06:41 AM by ErnestoM. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

04-18-2013 01:29 PM

GloriaH
Joined on 02-01-2012
Posts 3

Transferring data from InfoPath 2007 form to 2010 form

Reply Contact

We have an InfoPath 2007 form with a large number of columns, because InfoPath 2007 does not support Multiple-Selection List Box in a browser-enabled form and we had to create a separate field for each choice. Now we want to redesign the form in InfoPath 2010. For example, if the old form has 10 questions with 8 choices each, there is a total of 80 promoted columns. While in the new form there will only be 10 promoted columns.

Is there a way to transfer the data from the old form to the new one? Since the 2007 form has 80 fields and the 2010 form only has 10, do I have to export the data from the 2007 form to Excel, and combine the data for each question? And then how can I import these data to the 2010 form? If 50 users have submitted the old form, I want to be able to create 50 forms in the new library, with each form displaying the data for a specific user.

04-19-2013 06:41 AM In reply to

ErnestoM
Joined on 08-27-2007
Posts 3,320

Re: Transferring data from InfoPath 2007 form to 2010 form

Mark as Not Answer Mark as Answer ...

Reply Contact

This might be possible to achieve with xslt tranform. qRules includes a command to achieve this, or it can be done using custom code.

If you export the data to Excel and massage it there, you can then import it into InfoPath using the Excel to XML tool.

Bottom line is: there's no easy answer here. It's going to take a bit of work to achieve the migration.

If you'd like Qdabra to help you out, let us know via Qdabra.com. Good luck!

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

Page 1 of 1 (2 items)

InfoPath Dev