Re: Store Data for Offline Use

BanGotti — Wed, 04 Apr 2007 17:50:33 GMT

Hello,

I have used the code of the how to:

Allow Offline Use of a SharePoint List by Caching Locally

But I have a problem, when I disconnect my computer, my form uses the same data than the in the first xml file. But when I reconnect it, I have the updated data.

However, logiccaly, when offline, I should see the latest updated data. But it does not, any idea why?

Here is the code (which is the same actually, than in the how to):

try{
// Avoid DOM updates when the document has been digitally signed.
XDocument.DataObjects["MQuestDataIn"].Query();

// Get the ShareList DOM
var oDataIn = XDocument.GetDOM("MQuestDataIn" );

// Setup the Namespaces
oDataIn.setProperty("SelectionNamespaces",'xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:tns="http://tempuri.org/"' );
// Get the local DOM - to does not use namespaces

var oLocalDom = XDocument.GetDOM( "Local Productys" );

// Get a sample cached list node that we will need to clone later
var nSampleProductNode = oLocalDom.selectSingleNode( "/CachedList/Products/Product");

// Remove all of the items from the local copy of the list
oLocalDom.selectNodes( "/CachedList/Products/Product" ).removeAll();

// Loop through all of the items in the Web Service List
var nlSharedItems = oDataIn.selectNodes( "/dfs:myFields/dfs:dataFields/tns:MQuestDataInResponse/tns:MQuestDataInResult/OdsChaudiaires/chaudiaires" );

while( (nSharedItem = nlSharedItems.nextNode() ) != null )
{
// Create a new row from the sample
var nNewLocalCacheRow = nSampleProductNode.cloneNode(true);

  // Set the values
nNewLocalCacheRow.selectSingleNode( "@ID" ).text = nSharedItem.selectSingleNode( "IDTYPECHAUDIAIRE" ).text;
nNewLocalCacheRow.selectSingleNode( "@Name" ).text = nSharedItem.selectSingleNode( "NOMCOMBUSTIBLE" ).text;
nNewLocalCacheRow.selectSingleNode( "@Description" ).text = nSharedItem.selectSingleNode( "NOMCOMBUSTIBLE" ).text;

// Append to to our local cached list
oLocalDom.selectSingleNode( "/CachedList/Products" ).appendChild( nNewLocalCacheRow );

}
}
catch(e)
{

// Uncomment this line for more debug information
//XDocument.UI.Alert( e.description );
// Tell the user that they must be connected to the Internet to use this feature.
XDocument.UI.Alert( "Vous devez être connecté pour avoir la version updatée des données.");
}

Re: Store Data for Offline Use

Vastedge — Thu, 15 Mar 2007 19:15:20 GMT

This code works great except when I have a field that is blank in my SharePoint List. (i.e. Address 2, Address 3, etc.) I get the following error:

TypeError: -2146827864: Object Required

Can anyone help please?

Re: Store Data for Offline Use

Shilpa Pitta — Sat, 02 Dec 2006 05:32:33 GMT

Hi mschmit,
Go through this thread, hope it helps you!
http://infopathdev.com/howto/tutorials/default.aspx?i=3b9d4d677daf4ef18d8e93d0cd188194

Store Data for Offline Use

mschmit — Fri, 01 Dec 2006 21:36:50 GMT

Currently I have a form where I collect data from an sql call and populate a bunch of drop-downs. The issue is that when I take the form offline, the drop-downs don't populate because I don't have access to the database. Hence, I'm trying to figure out how to store the data retrieved in the background xml file. Is this possible? Does anyone have a good example of this? Thanks!

Newbie Questions

Re: Store Data for Offline Use

Re: Store Data for Offline Use

Re: Store Data for Offline Use

Store Data for Offline Use