Add elements to the array, extract elements from the array

Question

Add elements to the array, extract elements from the array

tag, I am currently facing a challenge with transferring multiple attributes from SharePoint list items into an array (only selected items in a view) and then passing that array to a function where I can extract and use these attributes to create new list items in a different list. Essentially, my goal is to copy specific fields from one set of list items to another. The main obstacle I am encountering is figuring out how to properly pack the attributes obtained using the getSelected function and then unpack them within the writeSelected function. Despite investing significant time researching online resources and forums for guidance on this process, I have struggled to find a solution. In the best-case scenario, the results I have achieved thus far return as undefined...

// Retrieving selected items from a view
function getSelected() {
    listName2 = "Customer Locations";
    var Astate, Aname;
    var ctx = SP.ClientContext.get_current();
    var clientContext = new SP.ClientContext(); 
    var targetList = clientContext.get_web().get_lists().getByTitle(listName2);
    var SelectedItems = SP.ListOperation.Selection.getSelectedItems(ctx);
    var items = [];
    for (var i in SelectedItems) {
        var id = SelectedItems[i].id;
        var item = targetList.getItemById(id);
        clientContext.load(item, "A_x0020_State", "A_x0020_Name");
        items.push(item);
    } // End for
    clientContext.executeQueryAsync(function() {
        var results = [];
        for (var i = 0; i < items.length; i++) {
            items.Aname = item.get_item('A_x0020_Name');
            items.Astate = item.get_item('A_x0020_State');
            results.push( {A_name: results[items.Aname], A_state: results[items.Astate]} );
            console.log(results.A_name);
        } //End for
    }, failure); //End ClientContext
} //End getSelected

//Adding selected items to the Sites list in WCAP
function writeSelected(results) {
    listName4 = "Sites";
    for (var k in results) {
        var clientContext = SP.ClientContext.get_current();
        var oList = clientContext.get_web().get_lists().getByTitle(listName4);
        var item = new SP.ListItemCreationInformation();
        var oListItem = oList.addItem(item);
        oListItem.set_item("Link_x0020_ID", fieldValue);
        oListItem.set_item("A_x0020_Name", ???);
        oListItem.set_item("A_x0020_State", ???);
        oListItem.update();
        clientContext.load(oListItem);
        clientContext.executeQueryAsync(success, failure)
    } //End for
} //End writeSelected

javascript arrays sharepoint

Answer 1

Answer №1

For those looking to transfer list items from one list to another, you can utilize the code snippet provided below:

<button type="button" id="copyButton" onclick="copyListItems()">Copy Items</button>  

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
var sourceListName = "Source List Name";
var destinationListName = "Destination List Name";

function copyListItems() {
    // execute function to duplicate all items from source list to destination list
    getSourceListData().then(copyItemsToDestination);
}

function getSourceListData() {
    var deferred = $.Deferred();
    var context = SP.ClientContext.get_current();

    this.sourceListObj = context.get_web().get_lists().getByTitle(sourceListName);
    this.sourceFields = sourceListObj.get_fields();
    this.destinationListObj = context.get_web().get_lists().getByTitle(destinationListName);

    context.load(sourceListObj);
    context.load(sourceFields);
    context.load(destinationListObj);

    var elements = sourceListObj.getItems(SP.CamlQuery.createAllItemsQuery());
    context.load(elements);

    context.executeQueryAsync(
        function () { deferred.resolve(elements); },
        function (sender, args) { deferred.reject(sender, args); }
    );
    return deferred.promise();
}

function logMistake(sender, args) {
    console.log('An error has occurred: ' + args.get_message());
}

function logAchievement(sender, args) {
    console.log('List items successfully copied.');
}

function copyItemsToDestination(items) {
    $.when.apply(items.get_data().forEach(function (srcItem) { transferItem(srcItem); }))
     .then(logAchievement, logMistake);
}

function transferItem(srcItem) {
    var deferred = $.Deferred();
    var context = srcItem.get_context();

    var newListItemInfo = new SP.ListItemCreationInformation();
    var targetListItem = destinationListObj.addItem(newListItemInfo);

    var fieldEnum = sourceFields.getEnumerator();
    while (fieldEnum.moveNext()) {
        var field = fieldEnum.get_current();
        
        if (!field.get_readOnlyField() && 
            field.get_internalName() !== "Attachments" && 
            !field.get_hidden() && 
            field.get_internalName() !== "ContentType") 
        {
            var srcFieldValue = srcItem.get_item(field.get_internalName());
            if (srcFieldValue != null) {
                targetListItem.set_item(field.get_internalName(), srcFieldValue);
            }
        }
    }

    targetListItem.update();
    context.load(targetListItem);

    context.executeQueryAsync(
        function () { deferred.resolve(); },
        function (sender, args) { deferred.reject(sender, args);
    });
    return deferred.promise();
}
</script>

Related Links:

Guide on Copying SharePoint List Items Between Lists

Using REST/JSON to Duplicate List Items

Answer 2

For those looking to transfer list items from one list to another, you can utilize the code snippet provided below:

<button type="button" id="copyButton" onclick="copyListItems()">Copy Items</button>  

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
var sourceListName = "Source List Name";
var destinationListName = "Destination List Name";

function copyListItems() {
    // execute function to duplicate all items from source list to destination list
    getSourceListData().then(copyItemsToDestination);
}

function getSourceListData() {
    var deferred = $.Deferred();
    var context = SP.ClientContext.get_current();

    this.sourceListObj = context.get_web().get_lists().getByTitle(sourceListName);
    this.sourceFields = sourceListObj.get_fields();
    this.destinationListObj = context.get_web().get_lists().getByTitle(destinationListName);

    context.load(sourceListObj);
    context.load(sourceFields);
    context.load(destinationListObj);

    var elements = sourceListObj.getItems(SP.CamlQuery.createAllItemsQuery());
    context.load(elements);

    context.executeQueryAsync(
        function () { deferred.resolve(elements); },
        function (sender, args) { deferred.reject(sender, args); }
    );
    return deferred.promise();
}

function logMistake(sender, args) {
    console.log('An error has occurred: ' + args.get_message());
}

function logAchievement(sender, args) {
    console.log('List items successfully copied.');
}

function copyItemsToDestination(items) {
    $.when.apply(items.get_data().forEach(function (srcItem) { transferItem(srcItem); }))
     .then(logAchievement, logMistake);
}

function transferItem(srcItem) {
    var deferred = $.Deferred();
    var context = srcItem.get_context();

    var newListItemInfo = new SP.ListItemCreationInformation();
    var targetListItem = destinationListObj.addItem(newListItemInfo);

    var fieldEnum = sourceFields.getEnumerator();
    while (fieldEnum.moveNext()) {
        var field = fieldEnum.get_current();
        
        if (!field.get_readOnlyField() && 
            field.get_internalName() !== "Attachments" && 
            !field.get_hidden() && 
            field.get_internalName() !== "ContentType") 
        {
            var srcFieldValue = srcItem.get_item(field.get_internalName());
            if (srcFieldValue != null) {
                targetListItem.set_item(field.get_internalName(), srcFieldValue);
            }
        }
    }

    targetListItem.update();
    context.load(targetListItem);

    context.executeQueryAsync(
        function () { deferred.resolve(); },
        function (sender, args) { deferred.reject(sender, args);
    });
    return deferred.promise();
}
</script>

Related Links:

Guide on Copying SharePoint List Items Between Lists

Using REST/JSON to Duplicate List Items

Add elements to the array, extract elements from the array

Answer №1

Similar questions

The error message for ExpressJS states: "Headers cannot be set after they have already been sent."

What is the reason for requiring this to be passed as an Array instead of a String?

How can you alter a property within an array of records retrieved from a Mongoose query?

Can you provide tips on using Ajax to store a cache file?

Guide to uploading a recorded audio file (Blob) to a server using ReactJS

Traversing an array of objects using D3.js

Issue with Many to Many Relation Query in Objection JS, Postgres, and Express Resulting in 'TypeError: Cannot Read Property 'isPartial' of Null' Error

Encountering a problem with the state error while trying to modify an input field during onChange event

Assess html code for Strings that include <% %> tags along with embedded scripts

Some variables are not being properly tracked by Google Analytics

How can you verify the anticipated log output in the midst of a function execution with Jest unit testing?

My method for updating form input properties involves switching the disable attribute from "false" to "true" and vice versa

Is there a way to include multiple web parts that utilize an angularjs module?

extracting key-value pairs from nested arrays in javascript objects

Tips for successfully transferring a JSON object from jQuery to a JavaScript function

How to retrieve controller property from a different Class in AngularJS

Adjust the horizontal position of the background by +/- X pixels

Is there an issue with the real-time update of graphics pixels in Java?

What is the best way to access the current value and name of a textbox in real-time using

Encountering a Mongoose issue while attempting to load model files from a separate Mean.js project using the require function