0x81020014 One or more of the field types are not set properly. Go to the list settings page to remove these fields.
In sharepoint, when I try to update the list, I get the error:
0x81020014One or more field types are not installed properly. Go to the list settings page to delete these fields.
Caml is generated:
<Batch PreCalc='TRUE' OnError='Continue'>
<Method ID='1' Cmd='Update'>
<Field Name='ID'>4</Field>
<Field Name='Flagged'>False</Field>
</Method>
</Batch>
When I run Caml from U2U it works fine and the field is updated. When I debug my code in VS, I get the above error.
The code that creates and calls the package is below:
var ws = new com.freud.intranet.lists.Lists {
Url = WebServiceHelper.wsContactsList,
Credentials = WebServiceHelper.AdminCredentials
};
var batch = "<Batch PreCalc='TRUE' OnError='Continue'><Method ID='1' cmd='Update'><Field Name='ID'>" + contactID
+ "</Field><Field Name='Flagged'>" + flag + "</Field></Method></Batch>";
var document = new XmlDocument();
var stringReader = new StringReader(batch);
var xmlReader = XmlReader.Create(stringReader);
var node = document.ReadNode(xmlReader);
ws.UpdateListItems("Master Contact Joining Table", node);
Why does the camera work in U2U and not VS?
From Googling, the problem might be that I am not using intrnal names, but it works in U2U, so I am confused.
source to share
The trick for working with a list is to locate the web service correctly, have the URL in the specified web service set to the correct location, and use the field names as defined in the list.
private void ReadTaskandAddtask()
{
try
{
tcfifsharepoint.Lists listServiceBase = new tcfifsharepoint.Lists();
// SharePoint Web Serices require authentication
listServiceBase.Credentials = System.Net.CredentialCache.DefaultCredentials;
listServiceBase.Url = "http://SPServer/Site/_vti_Bin/lists.asmx";
String newIssueTitle = "Programmatically added issue 3";
String listGUID = "FC519894-509A-4B66-861E-2813DDE14F46";
String activeItemViewGUID = "C93FFC02-368B-4D06-A8AE-3A3BA52F4F0C";
listGUID = "{FC519894-509A-4B66-861E-2813DDE14F46}";
activeItemViewGUID = "{DCF35B63-F85C-463B-B1A1-716B4CF705C5}";
// first check if item is already in the list
XmlNode activeItemData = listServiceBase.GetListItems(listGUID, activeItemViewGUID, null, null, "", null, "");
if (!activeItemData.InnerXml.Contains(newIssueTitle))
{
//*********************This is Working *********************************
StringBuilder sb_method = new StringBuilder();
sb_method.Append("<Method ID=\"1\" Cmd=\"New\">");
sb_method.Append("<Field Name=\"Title\">Some Title 14</Field>");
sb_method.Append("<Field Name=\"AssignedTo\">Name to assign</Field>");
sb_method.Append("<Field Name=\"Status\">In Progress</Field>");
sb_method.Append("<Field Name=\"Priority\">(3) Low</Field>");
sb_method.Append("<Field Name=\"DueDate\">");
sb_method.Append(DateTime.Parse(DateTime.Now.ToString()).ToString("yyyy-MM-ddTHH:mm:ssZ"));
sb_method.Append("</Field>");
sb_method.Append("<Field Name=\"PercentComplete\">.34</Field>");
sb_method.Append("<Field Name=\"Body\">Something entered into the description field.</Field>");
sb_method.Append("<Field Name=\"Author\">Your Author</Field>");
sb_method.Append("<Field Name=\"Editor\">This is Modified By</Field>");
sb_method.Append("</Method>");
XmlDocument x_doc = new XmlDocument();
XmlElement xe_batch = x_doc.CreateElement("Batch");
xe_batch.SetAttribute("OnError", "Return");
xe_batch.InnerXml = sb_method.ToString();
XmlNode xn_return = listServiceBase.UpdateListItems("Task List Name", xe_batch);
}
catch (Exception e)
{
string sMessage = e.Message;
}
}
You can see the internal names used for list items (columns) in a SharePoint list by going to Settings and choosing List Options. Once in the list settings, click on the column and then browse the URL to see "Field = Name". This is the name you should use when creating your fields.
Alternatively, you can try opening SharePoint Designer and peeking into any list form or view.
If you hunt for a bit, you will find the list GUID, View GUID and follow all the columns of the list. The SPD is especially useful when looking up list items using GetListItems and you need to parse the XML using "ows_" + ColumnName.