Creating a sharepoint list data archive in InfoPath

M

Michelle

I have a scenario in which I will have temporary workspaces created in
sharepoint. The workspaces will be created dynamically within a
workflow. When the temporary workspace is no longer needed it will be
deleted. The workspace will contain a task list.

When the site is deleted I want to capture the task list data in an
InfoPath form which will then be stored in a form library in another
sharepoint site.

I've managed to create an infopath form that reads from a sharepoint
list, and I've even managed to copy the data from the secondary
datasource to the form's main data source so it will be saved when the
form is saved.

I believe I have an idea as to how to dynamically set the save
location of the form at run time (thanks to another example by Joel
Alley), BUT ...

How do I dynamically set the site/list URL for the Secondary Data
Source that connects to Sharepoint. The URL of the dynamically
created workspace will not be known until runtime. When I try I get
an error that the SiteUrl property is readonly. Example code follows:

SharepointListAdapter SPList =
((SharepointListAdapter)thisXDocument.DataAdapters["List Name"]);
SPList.SiteUrl = "http://server/sites/sitename/temporaryworkspace/";

What I want to do is publish the form to a "central" form templates
team site. A step in the workflow process will "call" the InfoPath
form from the central site to capture the sharepoint list data before
the workflow deletes the site, then save the infopath form to another
"central" form library in another site.

Any ideas?

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top