To update metadata field, firstly you have to find the exact value of the metadata value.
Update metadata value manually, then use the following script to find the value:
function queryitems(){
var query = "<Query>";
query += "<Where><Eq><FieldRef Name='ContentType' /><Value Type='Text'>Document</Value></Eq></Where></Query>"
$().SPServices({
operation: "GetListItems",
//webURL: window.location.protocol + "//" + window.location.host,
webURL: "https:" + "//" + url,
async: false,
listName: list,
CAMLQueryOptions: "<QueryOptions><ViewAttributes Scope='RecursiveAll' IncludeRootFolder='True' /></QueryOptions>",
CAMLQuery: query,
completefunc: function (xData, Status) {
$(xData.responseXML).SPFilterNode("z:row").each(function() {
var liHtml = "<li>" + $(this).attr("ows_ID") + " : " + $(this).attr("ows_Year") + "</li>";
$("#tasksUL").append(liHtml);
var obj = {
itemid: $(this).attr("ows_ID"),
};
arrayid.push(obj);
});
}
});
}
After get the value, in my case is: 3;#2012, I use the following script to update around 1000 items in a run:
function updateitems(){
var yearvalue="3;#2012";
var update_string = "<Batch OnError='Continue'>";
for (i=0; i<arrayid.length; i++) {
update_string += "<Method ID='"+(i+1)+"' Cmd='Update'>";
update_string += "<Field Name='ID'>"+ arrayid[i].itemid+"</Field>";
update_string += "<Field Name='Year'>"+ yearvalue +"</Field>";
update_string += "</Method>";
}
update_string += "</Batch>";
$().SPServices({
operation: "UpdateListItems",
async: false,
batchCmd: "Update",
listName: list,
updates: update_string,
webURL: "https:" + "//" + url,
completefunc: function (xData, Status) {
var liHtml = "<li>" + xData.responseText + "</li>";
$("#Updated").append(liHtml);
}
});
}
It is great ~~
