Programmatically add event to SharePoint calendar using InfoPa Jsc

Vman92 · Feb 16, 2007

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

S.Y.M. Wong-A-Ton · Feb 18, 2007

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.

Vman92 · Feb 19, 2007

I modified the JScript as follows:

function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now I am getting the following error:

The following error occurred:
Reference to undeclared namespace prefix: 'my'.
File:script.js
Line:11
Unspecified error

I know it has to do with declaring a namespace to reference the secondary
data source. Unfortunately, I am unfamiliar with this. Is this done within
the header of the
JScript?

--
In the absence of genuine leadership, they''''ll listen to anyone who steps
up to the microphone.

S.Y.M. Wong-A-Ton said:
If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

Vman92 said:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Vman92 · Feb 19, 2007

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:
If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

Vman92 said:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

S.Y.M. Wong-A-Ton · Feb 20, 2007

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

Vman92 said:
I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

Vman92 said:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

Vman92 · Feb 20, 2007

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:
I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

Vman92 said:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

S.Y.M. Wong-A-Ton · Feb 21, 2007

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:
Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

Vman92 said:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

Vman92 · Feb 21, 2007

I am listed as owner of the Sharepoint site. So, I do have the appropriate
access level to add list items. I am working with our server team to explore
any type of server error or web service issue.

The field names for the Sharepoint site list are: Title, Location, Start
Time (which includes the date field), End Time (which includes the date
field), Description, All Day Event, Recurrence and Workspace. Are there
certain fields that absolutely must be set? And, I am not sure but I don't
believe I am setting the correct fields within the code below. Don't I have
to set the field names exactly the same as the Sharepoint list?

batch.selectSingleNode ... 'Title', 'Location', 'EventDate', 'EndDate'

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:
The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

S.Y.M. Wong-A-Ton · Feb 22, 2007

You are using SharePoint 2003, are you? I'm not sure if the field names
changed between versions 2003 and 2007, but I doubt it. By the way, what you
see on the screen is not always what is used at the back end, so the field
names might differ; you must look at the names defined in the schema for a
list and use those names instead of the names displayed on the screen. The
field names in the article are the names used in the schema of 2007.

I believe title and start date were mandatory. End date might be too, but
I'm not sure about that. The rest is optional.

I'll have to check whether I still have an InfoPath 2003 / WSS v2
environment set up. If I do, I'll try to test it out for you this weekend.
---
S.Y.M. Wong-A-Ton

Vman92 said:
I am listed as owner of the Sharepoint site. So, I do have the appropriate
access level to add list items. I am working with our server team to explore
any type of server error or web service issue.

The field names for the Sharepoint site list are: Title, Location, Start
Time (which includes the date field), End Time (which includes the date
field), Description, All Day Event, Recurrence and Workspace. Are there
certain fields that absolutely must be set? And, I am not sure but I don't
believe I am setting the correct fields within the code below. Don't I have
to set the field names exactly the same as the Sharepoint list?

batch.selectSingleNode ... 'Title', 'Location', 'EventDate', 'EndDate'

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

S.Y.M. Wong-A-Ton · Feb 23, 2007

It is weekend in my neck of the woods, so as promised, I've looked into the
issue for you.

The good news is that the solution also works with InfoPath 2003 / WSS v2.
The bad news is that the schemas of WSS v2 and WSS v3 differ. I removed the
fAllDayEvent field from the EventCAML and submitted the form, and the item
was added to the calender. With this field included, I get the same results
you got, i.e. nothing is added. The fAllDayEvent field does not exist in the
schema for WSS v2, or at least, I did not see it. The names of the other
fields are the same in both schemas.

Solution: Remove the fAllDayEvent from the EventCAML.xml file. Refresh your
data source by going to Tools > Data Connections, click Modify, click on
Resources button and remove the EventCAML resource file, then browse and add
the EventCAML.xml back into the form. Save the form and try submitting it
again.
---
S.Y.M. Wong-A-Ton

Vman92 said:
I am listed as owner of the Sharepoint site. So, I do have the appropriate
access level to add list items. I am working with our server team to explore
any type of server error or web service issue.

The field names for the Sharepoint site list are: Title, Location, Start
Time (which includes the date field), End Time (which includes the date
field), Description, All Day Event, Recurrence and Workspace. Are there
certain fields that absolutely must be set? And, I am not sure but I don't
believe I am setting the correct fields within the code below. Don't I have
to set the field names exactly the same as the Sharepoint list?

batch.selectSingleNode ... 'Title', 'Location', 'EventDate', 'EndDate'

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

Vman92 · Mar 5, 2007

Checked the schema of the Sharepoint list and it appears that I am trying to
update the correct fields.
Also, saw that you updated the article "programmatically...". So, I rewrote
the InfoPath form using VB and inserted your code. Now I am getting this
error 'Expected statement - File:script.vbs - Line:7 - 
'. I have pasted my code below. Originally the code appeared to have single
quotes ' around the style elements. This appeared to REM them out. So I
changed to double ".

'<namespacesDefinition>
XDocument.DOM.setProperty "SelectionNamespaces",
"xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-03-05T17:24:39"""
'</namespacesDefinition>

Sub CTRL7_5_OnClick(eventObj)


<a name="OLE_LINK2"></a>
<a name="OLE_LINK1">

<code>



Dim root As XPathNavigator = MainDataSource.CreateNavigator()
</code></a>



 
 
<code>' Retrieve the values for the calendar item
</code> 
<code>Dim title As String = root.SelectSingleNode("my:myFields/my:title",
NamespaceManager).Value</code> 
<code>Dim location As String =
root.SelectSingleNode("my:myFields/my:location",NamespaceManager).Value</code> 
<code>Dim startDate As String =
root.SelectSingleNode("my:myFields/my:startDate",NamespaceManager).Value</code> 
<code>Dim startTime As String =
root.SelectSingleNode("my:myFields/my:startTime",NamespaceManager).Value</code> 
<code>Dim endDate As String =
root.SelectSingleNode("my:myFields/my:endDate",NamespaceManager).Value</code> 
<code>Dim endTime As String =
root.SelectSingleNode("my:myFields/my:endTime",NamespaceManager).Value</code> 
 
<code>Dim batch As XPathNavigator =
DataSources("EventCAML").CreateNavigator()</code> 
 
<code>' Set the title
</code>
 
<code>batch.SelectSingleNode("/Batch/Method/Field[@Name='Title']",
_</code> 
NamespaceManager).SetValue(title) 
 
' Set the location
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='Location']",_ 
NamespaceManager).SetValue(location) 
 
' Set the start date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EventDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",startDate,
startTime)) 
 
' Set the end date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EndDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",endDate,
endTime)) 
 
' Submit the item details to the web service to update the
calendar
 
DataConnections("Web Service Submit").Execute()





<o

></o

>

End Sub

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:
The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into
var root = XDocument.DOM;

For each variable declaration, replace "string" by "var".
string title = root.SelectSingleNode(..., ...).Value;
should be changed into
var title = root.selectSingleNode("my:...").text; <= do not use the
NamespaceManager part

XPathNavigator batch = DataSources[...].CreateNavigator();
should be changed into
var batch = XDocument.DataObjects[...].DOM;

batch.SelectSingleNode(...,...).SetValue(title);
should be changed into
batch.selectSingleNode("/Batch/...").text = title; <= do not use the
NamespaceManager part

DataConnections["Web Service Submit"].Execute();
should be changed into
XDocument.DataAdapters["Web Service Submit"].Submit();

If you get stuck, let me know.
---
S.Y.M. Wong-A-Ton

:

I have Infopath 2003 which does not have a C# code option. My user group also
has Infopath 2003 so an upgrade is out of the question. However, I have seen
some amazing code from S.Y.M. Wong A Ton to programmatically update a
Sharepoint calendar from an InfoPath form. Unfortunately, I can only use
Jscript. Does anybody know if there is similiar code in Jscript?

http://enterprise-solutions.swits.n...m-sharepoint-calendar-infopath&c=infopath2007

Click to expand...

Click to expand...

S.Y.M. Wong-A-Ton · Mar 6, 2007

You were almost there; there was no need to switch to VBScript.

Did you
try my last suggestion of removing the fAllDayEvent field from the
EventCAML.xml and "re-adding" it as a data connection? That should have
solved your problems.

The current issue you're having is because you've got HTML code interspersed
with VBScript code. If you copy code off my website, paste it into Notepad
first so that all the formatting is removed, then copy the code from Notepad
and paste it into InfoPath.
---
S.Y.M. Wong-A-Ton

Vman92 said:
Checked the schema of the Sharepoint list and it appears that I am trying to
update the correct fields.
Also, saw that you updated the article "programmatically...". So, I rewrote
the InfoPath form using VB and inserted your code. Now I am getting this
error 'Expected statement - File:script.vbs - Line:7 - 
'. I have pasted my code below. Originally the code appeared to have single
quotes ' around the style elements. This appeared to REM them out. So I
changed to double ".

'<namespacesDefinition>
XDocument.DOM.setProperty "SelectionNamespaces",
"xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-03-05T17:24:39"""
'</namespacesDefinition>

Sub CTRL7_5_OnClick(eventObj)


<a name="OLE_LINK2"></a>
<a name="OLE_LINK1">

<code>



Dim root As XPathNavigator = MainDataSource.CreateNavigator()
</code></a>



 
 
<code>' Retrieve the values for the calendar item
</code> 
<code>Dim title As String = root.SelectSingleNode("my:myFields/my:title",
NamespaceManager).Value</code> 
<code>Dim location As String =
root.SelectSingleNode("my:myFields/my:location",NamespaceManager).Value</code> 
<code>Dim startDate As String =
root.SelectSingleNode("my:myFields/my:startDate",NamespaceManager).Value</code> 
<code>Dim startTime As String =
root.SelectSingleNode("my:myFields/my:startTime",NamespaceManager).Value</code> 
<code>Dim endDate As String =
root.SelectSingleNode("my:myFields/my:endDate",NamespaceManager).Value</code> 
<code>Dim endTime As String =
root.SelectSingleNode("my:myFields/my:endTime",NamespaceManager).Value</code> 
 
<code>Dim batch As XPathNavigator =
DataSources("EventCAML").CreateNavigator()</code> 
 
<code>' Set the title
</code>
 
<code>batch.SelectSingleNode("/Batch/Method/Field[@Name='Title']",
_</code> 
NamespaceManager).SetValue(title) 
 
' Set the location
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='Location']",_ 
NamespaceManager).SetValue(location) 
 
' Set the start date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EventDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",startDate,
startTime)) 
 
' Set the end date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EndDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",endDate,
endTime)) 
 
' Submit the item details to the web service to update the
calendar
 
DataConnections("Web Service Submit").Execute()





<o></o>

End Sub

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

If you download the InfoPath toolkit, you can use C# code. But it should be
possible to use JScript code for this solution. I have not tested it, so you
can convert the code to JScript and test whether it works.

Conversion from C# to JScript shouldn't be too difficult. Here's how:

XPathNavigator root = MainDataSource.CreateNavigator();
should be changed into

Click to expand...

Click to expand...

Vman92 · Mar 6, 2007

Holy Cow. It works. I can't thank you enough for all of your help. This was
something that I have been trying to understand and get working for almost 2
months now. I really apreciate your help.

Sorry I missed your second post on 2/23/2007. That would have saved me some
time. Oh well, I really enjoy learning new stuff and writing code. Now at
least I have a pretty good understanding of the issues. I can start working
on extending the functionality.

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:
You were almost there; there was no need to switch to VBScript. Did you
try my last suggestion of removing the fAllDayEvent field from the
EventCAML.xml and "re-adding" it as a data connection? That should have
solved your problems.

The current issue you're having is because you've got HTML code interspersed
with VBScript code. If you copy code off my website, paste it into Notepad
first so that all the formatting is removed, then copy the code from Notepad
and paste it into InfoPath.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Checked the schema of the Sharepoint list and it appears that I am trying to
update the correct fields.
Also, saw that you updated the article "programmatically...". So, I rewrote
the InfoPath form using VB and inserted your code. Now I am getting this
error 'Expected statement - File:script.vbs - Line:7 - 
'. I have pasted my code below. Originally the code appeared to have single
quotes ' around the style elements. This appeared to REM them out. So I
changed to double ".

'<namespacesDefinition>
XDocument.DOM.setProperty "SelectionNamespaces",
"xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-03-05T17:24:39"""
'</namespacesDefinition>

Sub CTRL7_5_OnClick(eventObj)


<a name="OLE_LINK2"></a>
<a name="OLE_LINK1">

<code>



Dim root As XPathNavigator = MainDataSource.CreateNavigator()
</code></a>



 
 
<code>' Retrieve the values for the calendar item
</code> 
<code>Dim title As String = root.SelectSingleNode("my:myFields/my:title",
NamespaceManager).Value</code> 
<code>Dim location As String =
root.SelectSingleNode("my:myFields/my:location",NamespaceManager).Value</code> 
<code>Dim startDate As String =
root.SelectSingleNode("my:myFields/my:startDate",NamespaceManager).Value</code> 
<code>Dim startTime As String =
root.SelectSingleNode("my:myFields/my:startTime",NamespaceManager).Value</code> 
<code>Dim endDate As String =
root.SelectSingleNode("my:myFields/my:endDate",NamespaceManager).Value</code> 
<code>Dim endTime As String =
root.SelectSingleNode("my:myFields/my:endTime",NamespaceManager).Value</code> 
 
<code>Dim batch As XPathNavigator =
DataSources("EventCAML").CreateNavigator()</code> 
 
<code>' Set the title
</code>
 
<code>batch.SelectSingleNode("/Batch/Method/Field[@Name='Title']",
_</code> 
NamespaceManager).SetValue(title) 
 
' Set the location
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='Location']",_ 
NamespaceManager).SetValue(location) 
 
' Set the start date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EventDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",startDate,
startTime)) 
 
' Set the end date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EndDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",endDate,
endTime)) 
 
' Submit the item details to the web service to update the
calendar
 
DataConnections("Web Service Submit").Execute()





<o></o>

End Sub

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

Now, unfortunately, I am getting the following error which I don't understand.

'XDocument.DataAdapters.Web Service Submit' is null or not an object

File:script.js
Line:49

Click to expand...

Click to expand...

steve · Mar 6, 2007

Checked the schema of the Sharepoint list and it appears that I am trying to
update the correct fields.

how does one check the schema of the SharePoint list?

thanks

steve

S.Y.M. Wong-A-Ton · Mar 7, 2007

No worries. Glad I could help.
---
S.Y.M. Wong-A-Ton

Vman92 said:
Holy Cow. It works. I can't thank you enough for all of your help. This was
something that I have been trying to understand and get working for almost 2
months now. I really apreciate your help.

Sorry I missed your second post on 2/23/2007. That would have saved me some
time. Oh well, I really enjoy learning new stuff and writing code. Now at
least I have a pretty good understanding of the issues. I can start working
on extending the functionality.

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

S.Y.M. Wong-A-Ton said:

You were almost there; there was no need to switch to VBScript. Did you
try my last suggestion of removing the fAllDayEvent field from the
EventCAML.xml and "re-adding" it as a data connection? That should have
solved your problems.

The current issue you're having is because you've got HTML code interspersed
with VBScript code. If you copy code off my website, paste it into Notepad
first so that all the formatting is removed, then copy the code from Notepad
and paste it into InfoPath.
---
S.Y.M. Wong-A-Ton

Vman92 said:

Checked the schema of the Sharepoint list and it appears that I am trying to
update the correct fields.
Also, saw that you updated the article "programmatically...". So, I rewrote
the InfoPath form using VB and inserted your code. Now I am getting this
error 'Expected statement - File:script.vbs - Line:7 - 
'. I have pasted my code below. Originally the code appeared to have single
quotes ' around the style elements. This appeared to REM them out. So I
changed to double ".

'<namespacesDefinition>
XDocument.DOM.setProperty "SelectionNamespaces",
"xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-03-05T17:24:39"""
'</namespacesDefinition>

Sub CTRL7_5_OnClick(eventObj)


<a name="OLE_LINK2"></a>
<a name="OLE_LINK1">

<code>



Dim root As XPathNavigator = MainDataSource.CreateNavigator()
</code></a>



 
 
<code>' Retrieve the values for the calendar item
</code> 
<code>Dim title As String = root.SelectSingleNode("my:myFields/my:title",
NamespaceManager).Value</code> 
<code>Dim location As String =
root.SelectSingleNode("my:myFields/my:location",NamespaceManager).Value</code> 
<code>Dim startDate As String =
root.SelectSingleNode("my:myFields/my:startDate",NamespaceManager).Value</code> 
<code>Dim startTime As String =
root.SelectSingleNode("my:myFields/my:startTime",NamespaceManager).Value</code> 
<code>Dim endDate As String =
root.SelectSingleNode("my:myFields/my:endDate",NamespaceManager).Value</code> 
<code>Dim endTime As String =
root.SelectSingleNode("my:myFields/my:endTime",NamespaceManager).Value</code> 
 
<code>Dim batch As XPathNavigator =
DataSources("EventCAML").CreateNavigator()</code> 
 
<code>' Set the title
</code>
 
<code>batch.SelectSingleNode("/Batch/Method/Field[@Name='Title']",
_</code> 
NamespaceManager).SetValue(title) 
 
' Set the location
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='Location']",_ 
NamespaceManager).SetValue(location) 
 
' Set the start date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EventDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",startDate,
startTime)) 
 
' Set the end date
 
batch.SelectSingleNode("/Batch/Method/Field[@Name='EndDate']",_ 
NamespaceManager).SetValue(String.Format("{0}T{1}Z",endDate,
endTime)) 
 
' Submit the item details to the web service to update the
calendar
 
DataConnections("Web Service Submit").Execute()





<o></o>

End Sub

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

The format looks fine to me. You may be having a security issue. Does the
user account you are using have permission to add items to the list
pertaining to the calendar? Another thing you can do is check whether any
error messages have been logged in the Windows Event Log of the server where
SharePoint is hosted.
---
S.Y.M. Wong-A-Ton

:

Thanks. I think I am almost there. I was going off of #4 where it says to
'Accept the default name for the data connection'. The default name is just
'Submit'. That was what was throwing me off. I changed it to 'Web Service
Submit' and the error has gone away.

I modified the code as you had suggested and the form opens. I fill out the
form and hit the add button and nothing happens. I check the calendar on the
Sharepoint site and nothing appears. If I go onto the form and click add
multiple times in succesion, I can see it accessing a data source. So, it
seems to be trying at least. I just don't know if the data I am attempting to
pass is formatted correctly. For both the startDate and endDate I have the
field formatted as 2001-03-14. And for both the startTime and endTime I have
the field formatted as 9:46:55. The code is shown below:

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate + "T" + startTime + "Z";

// Set the end date
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate + "T" + endTime + "Z";

// Submit the item details to the web service to update the calendar
XDocument.DataAdapters["Web Service Submit"].Submit();
}

--
In the absence of genuine leadership, they''''''''ll listen to anyone who
steps up to the microphone.

:

I found the namespace error a bit strange, since the secondary data source
does not contain any namespaces and the "my" namespace is defined by default
for the main data source. Anyway, well done sorting that out.

Regarding the "is null or not an object error": Did you create a submit data
connection to the web service and named it "Web Service Submit" (step 4)?

I've also spotted some errors in your code, for example:
batch.selectSingleNode("/Batch/Method/Field[@Name='EndDate']").text =
endDate, endTime;

The "endDate,endTime" isn't going to work. The string.Format("{0}T{1}Z",
endDate, endTime) you have to translate as

endDate + "T" + endTime + "Z"
---
S.Y.M. Wong-A-Ton

:

I discovered the problem was that I had deleted the code initially created by
InfoPath in order to see if I could change the language type to C#.
Afterwards I discovered that I could not. Now I have re-created the form and
the InfoPath created code is atop the code behind page.

/*
* This file contains functions for data validation and form-level events.
* Because the functions are referenced in the form definition (.xsf) file,
* it is recommended that you do not modify the name of the function,
* or the name and number of arguments.
*
*/

// The following line is created by Microsoft Office InfoPath to define the
prefixes
// for all the known namespaces in the main XML data file.
// Any modification to the form files made outside of InfoPath
// will not be automatically updated.
//<namespacesDefinition>
XDocument.DOM.setProperty("SelectionNamespaces",
'xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-19T15:10:37"');
//</namespacesDefinition>

//=======
// The following function handler is created by Microsoft Office InfoPath.
// Do not modify the name of the function, or the name and number of
arguments.
//=======
function CTRL7_5::OnClick(eventObj)
{
var root = XDocument.DOM;

// Retrieve the values for the calendar item
var title = root.selectSingleNode("my:myFields/my:title").text;
var location = root.selectSingleNode("my:myFields/my:location").text;
var startDate = root.selectSingleNode("my:myFields/my:startDate").text;
var startTime = root.selectSingleNode("my:myFields/my:startTime").text;
var endDate = root.selectSingleNode("my:myFields/my:endDate").text;
var endTime = root.selectSingleNode("my:myFields/my:endTime").text;

var batch = XDocument.DataObjects["EventCAML"].DOM;

// Set the title
batch.selectSingleNode("/Batch/Method/Field[@Name='Title']").text = title;

// Set the location
batch.selectSingleNode("/Batch/Method/Field[@Name='Location']").text =
location;

// Set the start date
batch.selectSingleNode("/Batch/Method/Field[@Name='EventDate']").text =
startDate, startTime;

// Set the end date

Click to expand...

Click to expand...

S.Y.M. Wong-A-Ton · Mar 19, 2007

This is a great question for the SharePoint guys! Have you tried asking them?

I know of two ways:
1. In code while retrieving a list and debugging its columns. This method
works well if you created your own custom list.
2. By looking at the XML file that defines a schema for a list in one of the
subdirectories of the famous "web server extensions" directory that
SharePoint uses; sorry I do not know the path by heart. This method works
well for standard lists.

buziboy · Mar 29, 2007

Wong,
I've been working with your tutorial 2007 today on MOSS 2007, InfoPath
2007 on a dev server I admin. This is a Forms Services app and I could
really use your help.

It seems like the C# cannot see my data connection, though the spelling is
fine.

Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an
object.
at Orders.FormCode.customSubmit_Clicked(Object sender, ClickedEventArgs e)
at
Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonEventHost.<>c__DisplayClass6.<>c__DisplayClass8.<add_Clicked>b__1()
at
Microsoft.Office.InfoPath.Server.Util.DocumentReliability.InvokeBusinessLogic(Thunk thunk)
at
Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonEventHost.<>c__DisplayClass6.<add_Clicked>b__0(Object sender, ClickedEventArgs e)
at
Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonEventHost.FireClickedEvent(Object sender, ClickedEventArgs args)
at
Microsoft.Office.InfoPath.Server.SolutionLifetime.ButtonFormCode.<>c__DisplayClass2.<>c__DisplayClass5.<Click>b__1()
at
Microsoft.Office.InfoPath.Server.DocumentLifetime.OMExceptionManager.CallFormCodeWithExceptionHandling(UserMessages userMessages, OMCall d)

An entry has been added to the Windows event log of the server.
Log ID:5337

Relevant code:
public void customSubmit_Clicked(object sender, ClickedEventArgs e)
{
// Write your code here.
XPathNavigator root = MainDataSource.CreateNavigator();
string title =
root.SelectSingleNode("my:myFields/my:itemchoice", NamespaceManager).Value;
string orderID = root.SelectSingleNode("my:myFields/my:Title",
NamespaceManager).Value;
string quOrdered =
root.SelectSingleNode("my:myFields/my:itemquantity", NamespaceManager).Value;

XPathNavigator batch =
DataSources["list2CAML"].CreateNavigator(); ÃŸ--------- CHOKES, though this
is accurately named.
// batch.SelectSingleNode("/Batch/Method/Field[@Name='Title']",
NamespaceManager).SetValue(orderID);
// batch.SelectSingleNode("/Batch/Method/Field[@Name='Order
ID']", NamespaceManager).SetValue(orderID);
// batch.SelectSingleNode("/Batch/Method/Field[@Name='Quantity
Ordered']", NamespaceManager).SetValue(quOrdered);

// DataConnections["List2submit"].Execute();

}

CAML file:
<?xml version="1.0" encoding="UTF-8" ?>
<Batch>
<Method ID="1" Cmd="New">
<Field Name="Title"/>
<Field Name="Order_x0020_ID"/>
<Field Name="Quantity_x0020_Ordered"/>
</Method>
</Batch>

Much appreciated.

liam · May 16, 2008

Hi, Please can yo uhelp me ....

I get this error -

System.Security.SecurityException
Request failed.
at Microsoft.Office.InfoPath.MsxmlNavigator.IsValidNode(MsxmlNode test)
at Microsoft.Office.InfoPath.MsxmlNavigator.MoveToFirstChild()
at MS.Internal.Xml.XPath.XPathChildIterator.MoveNext()
at MS.Internal.Xml.XPath.ChildrenQuery.Advance()
at MS.Internal.Xml.XPath.ChildrenQuery.Advance()
at MS.Internal.Xml.XPath.XPathSelectionIterator.MoveNext()
at System.Xml.XPath.XPathNavigator.SelectSingleNode(XPathExpression
expression)
at System.Xml.XPath.XPathNavigator.SelectSingleNode(String xpath,
IXmlNamespaceResolver resolver)
at Cal.FormCode.CTRL7_5_Clicked(Object sender, ClickedEventArgs e)
at
Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
at
Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

I have the correct lists.asmx any everything!
Can you help please???

liam · May 16, 2008

Hi, please can you help

I get this error -

System.Security.SecurityException
Request failed.
at Microsoft.Office.InfoPath.MsxmlNavigator.IsValidNode(MsxmlNode test)
at Microsoft.Office.InfoPath.MsxmlNavigator.MoveToFirstChild()
at MS.Internal.Xml.XPath.XPathChildIterator.MoveNext()
at MS.Internal.Xml.XPath.ChildrenQuery.Advance()
at MS.Internal.Xml.XPath.ChildrenQuery.Advance()
at MS.Internal.Xml.XPath.XPathSelectionIterator.MoveNext()
at System.Xml.XPath.XPathNavigator.SelectSingleNode(XPathExpression
expression)
at System.Xml.XPath.XPathNavigator.SelectSingleNode(String xpath,
IXmlNamespaceResolver resolver)
at Cal.FormCode.CTRL7_5_Clicked(Object sender, ClickedEventArgs e)
at
Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
at
Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

I have the correct lists.asmx and everything
Can you help please???

Error when submitting a new SharePoint Calendar Item	3	Jun 22, 2007
Populating SharePoint custom list from Infopath 2007 repeating tab	0	Feb 4, 2010
Programmatically add an item to a SharePoint list fails	1	Jun 11, 2009
Programmatically Submitting an InfoPath Form to a SharePoint Using	2	Sep 12, 2007
Tip on populating SharePoint list with InfoPath form	3	Mar 9, 2007
Create a recurrence event in a sharepoint calendar list	0	Feb 23, 2010
Duplicated Entry from Reading a SharePoint List	1	Jan 18, 2010
Submiting Data to Custom List	2	Dec 26, 2007

Programmatically add event to SharePoint calendar using InfoPa Jsc

Vman92

S.Y.M. Wong-A-Ton

Vman92

Vman92

S.Y.M. Wong-A-Ton

Vman92

S.Y.M. Wong-A-Ton

Vman92

S.Y.M. Wong-A-Ton

S.Y.M. Wong-A-Ton

Vman92

S.Y.M. Wong-A-Ton

Vman92

steve

S.Y.M. Wong-A-Ton

S.Y.M. Wong-A-Ton

buziboy

liam

liam

Ask a Question

Similar Threads