Converting Excel data to multiple InfoPath forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jackcroww@gmail.com - 13 Nov 2006 20:55 GMT

I am tasked with finding a way to populate a Forms library with some
legacy data that is kept in an Excel spreadsheet. The mapping seems to
be an easy thing, with one row in the Excel spreadsheet to represent
one InfoPath form. It seemed that finding such a utility would be
child's play.

However, I can't find a single utility to do this. All I want is an
app that will take an Excel spreadsheet and map columns to the "fields"
in an Infopath schema, and generate all the XML files for upload to the
Forms Library. That, or directly create the Infopath forms directly on
the Sharepoint server.

It seems thousands of utilities will aggregate multiple Excel files to
one Infopath form, or create an XML version of an Excel spreadsheet,
but I want one XML file for each row in the source Excel file.

Any suggestions will be GREATLY appreciated.

Reply to this Message

S.Y.M. Wong-A-Ton - 14 Nov 2006 05:35 GMT

I don't think you'll find such a utility; you'll have to program it yourself
or depending on how many rows are in the Excel document, do it manually.

To program it: Create an InfoPath form template based on the Excel columns
and publish it to the SPS library. Fill out the form and save it locally to
have a sample of the XML for the form. Then create a program - you can use
VBA in Excel or program some other application in another programming
language - to loop through all the rows in the Excel spreadsheet and create
the XML for each form based on the contents of each row and the sample XML
for the form template, save the file locally somewhere, and then use the
XMLHTTP object as described in this article
http://support.microsoft.com/?scid=kb;en-us;826993&spid=2515&sid=229 to
upload each form to the SPS library you published your form template to.
---
S.Y.M. Wong-A-Ton

> I am tasked with finding a way to populate a Forms library with some
> legacy data that is kept in an Excel spreadsheet. The mapping seems to
[quoted text clipped - 13 lines]
>
> Any suggestions will be GREATLY appreciated.

Reply to this Message