Data Connections

Re: Tips for moving between development and production databases?

Graeme — Tue, 21 Oct 2008 06:55:54 GMT

Ah, but I'm talking about the data retrieval connection strings for filling data into list boxes etc. when the form is opened. Sharepoint is not in the picture.

Re: Tips for moving between development and production databases?

chandrakanth — Tue, 21 Oct 2008 06:17:11 GMT

Add a secondary xml(let it be ViewOptions.Xml) to your Infopath form. In the ViewOptions.Xml add a SharePointUrl Node in that node place your sharepoint URL to that node.

for example the viewOptions.XML is:

<ViewOptions>
<sharePointFolderUrl>Local Config</sharePointFolderUrl>
</ViewOptions>

Now get the viewoptions.XMl dom (let the viewoptions.XMl dom be domViewOptions) into your code for getting the SharePoint URL.Use the below code for submitting your infopath form to the sharepoint.

public bool SubmitDataToSharePoint()
  {
string sharePointFolderPath = GetNodeValue(domViewOptions, "/ViewOptions/sharePointFolderUrl");
   try
   {
    DAVAdapter sharePoint = (DAVAdapter)thisXDocument.DataAdapters[submitAdapterName];
    sharePoint.FileName = fileName;
    sharePoint.FolderURL = sharePointFolderPath;
    sharePoint.SubmitData(dataNode);
   }
   catch(Exception ex)
   {
    string sMessage = FAILED_UNKNOWN;

    if(-1 != ex.Message.IndexOf("DAVAdapter"))
     sMessage = FAILED_SUBMIT_SHAREPOINT;
    else if(-1 != ex.Message.IndexOf("validation errors"))
     sMessage = FAILED_SUBMIT_VALIDATION;

    Alert(sMessage);

    return false;
   }
   return true;
  }

Like this you can place all your URL's in the ViewOptions.XML and can use that URl's into your code ,instead of changing the Manifest.xsn everytime.

Re: Tips for moving between development and production databases?

Graeme — Mon, 20 Oct 2008 13:59:06 GMT

Not sure what you mean here. The connection string is stored in the xsn file for each control. How do I replace them all by calling an external file? Can you give an example please?

Re: Tips for moving between development and production databases?

Hari Krishna — Fri, 17 Oct 2008 08:23:14 GMT

Hi,

Add a external resource xml file and store all the connections which has to be set while publishing.

Call the external file which is added in the code. You can make your publishing easy by keeping a file with all the connections given once and it can be used when ever you publish on to Production.

Tips for moving between development and production databases?

Graeme — Thu, 16 Oct 2008 10:03:24 GMT

The only way I have seen so far is to edit the xml in manifest.xsf and replace the server name on all connection strings with the name of the production server before publishing. Surely there is a less stoneage way?