InfoPath Dev

Is there a way to populate data in an infopath 2007 form from a secondary datasource (in this case a sharepoint list) and then save the form so that the data is available when not connected to the datasource? The idea here is to create "snapshot" of the sharepoint list at a given point in time.

Yes.

 The data you want just needs to be moved into your main data source from the secondary. The main is what gets saved in your XML file.

 Is that easily done?

It depends on the complexity of the data but you can use rulesto set field values from one to the other.

Sometimes code is used for large bulk moves.

I'm trying to copy data from a sharepoint list to a repeating table in an infopath form so that it can be viewed when not connected to the sharepoint list at the click of a button. I've never really done much with infopath before (none with 2007) so any pointers would be appreciated. The following is what I've tried so far. I'm having problems with the current view part. I get an error that says:

"Either the combination of values for the View.SelectNodes call is an invalid selection, or the values are not defined for this view, defined for this view more than once, or not selectable in the view."

 Any idea how to fix or get around this?

public void CTRL20_5_Clicked(object sender, ClickedEventArgs e)
        {
            // Write your code here.

            XPathNavigator rootMain = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:group5", NamespaceManager);
            XPathNavigator rootSecondary = this.DataSources["Universities"].CreateNavigator().SelectSingleNode("/dfs:myFields/dfs:dataFields/dfs:Universities", NamespaceManager);

            // Select nodes in specified XPathNavigator.
            CurrentView.SelectNodes(rootSecondary);


            XPathNodeIterator selectedNodes = CurrentView.GetSelectedNodes();

            XmlWriter writer = rootMain.SelectSingleNode("/my:myFields", NamespaceManager).AppendChild();

            string myNamespace = NamespaceManager.LookupNamespace("my");

            foreach (XPathNavigator selectedNode in selectedNodes)
            {
                writer.WriteStartElement("group6", myNamespace);
                writer.WriteElementString("field3", myNamespace, selectedNode.ToString());
                writer.WriteEndElement();
            }