Update Secondary Data Source

[chrispragash]

Hello All,

I have an infoPath form that uses an XML file as a secondary data
source for all its drop down values and lookups. I need a mechanism to
dynamically update these look values. I have a web service that
downloads an XML file which has updated values to the local machine.
How do I change the values in the secondary Datasource file and persist
the changes. Any ideas or thoughts would be really helpful.

Thanks,
Chris

 

[Nic Roche]

Hi Chris,

Any ideas or thoughts would be really helpful.

My solution is unconventional and may not suit you.

I manage my secondary datasources from a HTM page in the taskpane.

Its a simple SELECT element with the secondary datasource names and a
"Manage" button.
Click on the manage button and a modal dialog appears with "Add", "Edit",
"Delete", "MoveUp", "MoveDown", "OK" and "Cancel".
If the "OK" button is clicked the returnValue of the modal dialog is the XML
DOMDocument.
Heres the catch:
I wrote an ActiveX component (loaded with the taskpane HTML) that updates
the XML.

The main form has ellipsis button on all secondary datasources to "Manage"
them.
These buttons call the same code in the taskpane and updates the main form
with the new values (on "OK").

The InfoPath application I wrote using this process is a TestCase Manager
that uses secondary datasources for:
Area, Author, Bug, IEVersion, Level, OSVersion, Status, and Tester.


Regards

Nic Roche