Click here to Skip to main content
15,885,984 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more: , +
Hi I am new to sharepoint 2010,

I need to help in conversion sharepoint list to pdf and sharepoint list to excel like to make report as documents.

Can you help me out in coding like create the pdf of list once the pdf button is submitted.

Thanks in Advance
Posted
Updated 29-Apr-19 21:31pm
v2
Comments
Bajirao_ 3-Jun-15 9:17am    
Well you can download list as excel by outofbox and iTextSharp.dll for PDF creation. as we know we can create datatable of list. hope this helps.
Karthick_RR 30-Apr-19 3:32am    





var itemStatus ;
function clickMethod() {
var ctx = SP.ClientContext.get_current();
var items = SP.ListOperation.Selection.getSelectedItems(ctx);
var myItems = '';
var i;
for (i in items) {
myItems = items[i].id;
}
//Fetching selected item based on ID
RetrieveListItem(myItems)

}// End of Click method


function RetrieveListItem(itemids)
{

var _ctx = new SP.ClientContext.get_current();
var _List = _ctx.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
var _camlQuery = new SP.CamlQuery();
_camlQuery.set_viewXml("'<View><Query><Where><Eq><FieldRef Name=\'ID\'/><Value Type=\'Number\'>"+itemids+"</Value></Eq></Where></Query></View>'");
this._ItemColl = _List.getItems(_camlQuery);
_ctx.load(_ItemColl);
_ctx.executeQueryAsync
(
Function.createDelegate(this, this.onRetrieveQuerySuccess),
Function.createDelegate(this, this.onRetrieveQueryFailed)
);
}

function onRetrieveQuerySuccess(sender, args)
{
var _ListItemEnumerator = _ItemColl.getEnumerator();
while (_ListItemEnumerator.moveNext())
{
var _ListItem = _ListItemEnumerator.get_current();
var updateitemid = _ListItem.get_id(); // Saving item ID to variable
itemStatus = _ListItem.get_item('Status') // Update column
// Validating column
if (itemStatus == 'Assigned')
{

var _ctx1 = new SP.ClientContext.get_current();
var _List1 = _ctx1.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
this._ListItem1 = _List1.getItemById(updateitemid);
_ListItem1.set_item('Status', 'Pending'); // Pass column and value to update column
_ListItem1.update();// updateing item to list

_ctx1.load(_ListItem1);
_ctx1.executeQueryAsync
(
Function.createDelegate(this, this.onUpdatedQuerySuccess),
Function.createDelegate(this, this.onUpdatedQueryFailed)
);

}
else
{alert("Not assigned")}

}
//alert(_ListItemInfo.toString());
}

function onRetrieveQueryFailed(sender, args)
{
alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
}
function onUpdatedQuerySuccess()
{
alert('Item status updated'); // Update column successful
}

function onUpdatedQueryFailed(sender, args)
{
alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
}
Karthick_RR 8-May-19 6:04am    
view more




//ExecuteOrDelayUntilScriptLoaded(myFunction, "sp.js");

$(window).load(function(){
alert($("table.ms-listviewtable tr.ms-itmhover").length)

$("table.ms-listviewtable tr.ms-itmhover").each(function(){
var Itemrow = $(this).find("td:nth-child(4)")

});
});
Karthick_RR 8-May-19 6:05am    
view more



//ExecuteOrDelayUntilScriptLoaded(myFunction, "sp.js");
$(window).load(function(){
alert($("table.ms-listviewtable tr.ms-itmhover").length)
$("table.ms-listviewtable tr.ms-itmhover").each(function(){
var Itemrow = $(this).find("td:nth-child(4)")
});
});
Karthick_RR 8-May-19 6:06am    

1 solution

<script type="text/javascript" src="https://workspace.wp.siemens.com/sites/LTIDev/LTI/SiteAssets/JS/jquery-2.2.1.min.js"></script>
<input type='button' value='Get Item IDs' onclick="clickMethod();"/>

<br />

<script language="javascript" type="text/javascript">
var itemStatus ;
function clickMethod() {
    var ctx = SP.ClientContext.get_current();
    var items = SP.ListOperation.Selection.getSelectedItems(ctx);
    var myItems = '';
    var i;
    for (i in items) {
        myItems = items[i].id;
    }
    //Fetching selected item based on ID
    RetrieveListItem(myItems)

}// End of Click method


function RetrieveListItem(itemids)
    {

    var _ctx = new SP.ClientContext.get_current();
    var _List = _ctx.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
    var _camlQuery = new SP.CamlQuery();
    _camlQuery.set_viewXml("'<View><Query><Where><Eq><FieldRef Name=\'ID\'/><Value Type=\'Number\'>"+itemids+"</Value></Eq></Where></Query></View>'");
    this._ItemColl = _List.getItems(_camlQuery);
    _ctx.load(_ItemColl);
    _ctx.executeQueryAsync
    (
    Function.createDelegate(this, this.onRetrieveQuerySuccess),
    Function.createDelegate(this, this.onRetrieveQueryFailed)
    );
    }

    function onRetrieveQuerySuccess(sender, args)
    {
        var _ListItemEnumerator = _ItemColl.getEnumerator();
        while (_ListItemEnumerator.moveNext())
        {
        var _ListItem = _ListItemEnumerator.get_current();
        var updateitemid = _ListItem.get_id(); // Saving item ID to variable
        itemStatus = _ListItem.get_item('Status') // Update column
            // Validating column
            if (itemStatus == 'Assigned')
            {

                    var _ctx1 = new SP.ClientContext.get_current();
                    var _List1 = _ctx1.get_web().get_lists().getByTitle("LTI Ticket Incident"); // Enter List name
                    this._ListItem1 = _List1.getItemById(updateitemid);
                    _ListItem1.set_item('Status', 'Pending'); // Pass column and value to update column
                    _ListItem1.update();// updateing item to list

                    _ctx1.load(_ListItem1);
                    _ctx1.executeQueryAsync
                    (
                    Function.createDelegate(this, this.onUpdatedQuerySuccess),
                    Function.createDelegate(this, this.onUpdatedQueryFailed)
                    );

            }
            else
            {alert("Not assigned")}

            }
        //alert(_ListItemInfo.toString());
    }

    function onRetrieveQueryFailed(sender, args)
    {
    alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
    }
       function onUpdatedQuerySuccess()
        {
        alert('Item status updated'); // Update column successful
        }

        function onUpdatedQueryFailed(sender, args)
        {
        alert('Request failed. ' + args.get_message() +'\n' + args.get_stackTrace());
        }
</script>
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900