This blog will explain you how to Convert SharePoint List to PDF,CSV,Excel using JavaScript for SharePoint Online Just few days back I was surfing through the SharePoint Store and I found an app called “List2Pdf”. This actually is useful when it comes to users who store the data in SharePoint Lists and then export the Read more about Convert SharePoint List to PDF,CSV,Excel using JavaScript[…]
There are times when we need to fetch only the items within a specific folder. In those cases we can use the ‘Folder’ property of SPQuery class. Simply set the ‘Folder’ property to a Folder object which represents the folder instance from where we need the items.
|
1 2 3 4 5 6 7 |
SPList spList = spWeb.Lists.TryGetList("Documents"); SPFolder folder = spList.RootFolder.SubFolders["Document Set 1"]; SPQuery query = new SPQuery(); query.Query = "Enter your query here"; query.Folder = folder; SPListItemCollection items = spList.GetItems(query); |
Reference URL: http://spdeveloper.co.in/articles/pages/get-items-from-a-specific-folder-in-sharepoint-list.aspx
Recently i came up with an issue with an SP 2007 requirement, where I was updating records using a visual web part. But due to an event receiver deployed by another vendor, the records were not getting updated. I tried to disable the event receiver by implementing the code from the link http://www.sharepointnadeem.com/2011/12/disable-event-firing-from-non-event.html But this dint Read more about Attach and Detach Event Receiver Programmatically C#[…]
This blog post explains on how to get file content from SharePoint using external applications basically other programming languages. Although the below code is in C#, i am sure you will figure out how to do it using any other programming language like JAVA, PHP etc. If your documents are stored in SharePoint and these Read more about Get File Content SharePoint using external applications[…]
I was having a tough time searching on the internet on how to connect to SharePoint On Premise from an external application. Now as you all know, we need to first authenticate ourselves in SharePoint, after which we can perform GET METHOD REST API CALLS And to perform POST commands, we need a request digest Read more about Connect to SharePoint On Premise using external applications[…]
This blog post explains you how to create a Document Set using SharePoint REST Interface. Happy SharePointing!!!!!!!!!!!!! 😀 Reference Link: http://sharepoint.stackexchange.com/questions/147149/creating-document-set-and-setting-values-with-rest-listdata-svc
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
<span class="kwd">function</span><span class="pln"> getListUrl</span><span class="pun">(</span><span class="pln">webUrl</span><span class="pun">,</span><span class="pln">listName</span><span class="pun">)</span> <span class="pun">{</span> <span class="kwd">return</span><span class="pln"> $</span><span class="pun">.</span><span class="pln">ajax</span><span class="pun">({</span><span class="pln"> url</span><span class="pun">:</span><span class="pln"> webUrl </span><span class="pun">+</span> <span class="str">"/_api/lists/getbytitle('"</span> <span class="pun">+</span><span class="pln"> listName </span><span class="pun">+</span> <span class="str">"')/rootFolder?$select=ServerRelativeUrl"</span><span class="pun">,</span><span class="pln"> type</span><span class="pun">:</span> <span class="str">"GET"</span><span class="pun">,</span><span class="pln"> contentType</span><span class="pun">:</span> <span class="str">"application/json;odata=verbose"</span><span class="pun">,</span><span class="pln"> headers</span><span class="pun">:</span> <span class="pun">{</span> <span class="str">"Accept"</span><span class="pun">:</span> <span class="str">"application/json;odata=verbose"</span> <span class="pun">}</span> <span class="pun">});</span> <span class="pun">}</span> <span class="kwd">function</span><span class="pln"> createFolder</span><span class="pun">(</span><span class="pln">webUrl</span><span class="pun">,</span><span class="pln">listName</span><span class="pun">,</span><span class="pln">folderUrl</span><span class="pun">,</span><span class="pln">folderContentTypeId</span><span class="pun">)</span> <span class="pun">{</span> <span class="kwd">return</span><span class="pln"> $</span><span class="pun">.</span><span class="pln">ajax</span><span class="pun">({</span><span class="pln"> url</span><span class="pun">:</span><span class="pln"> webUrl </span><span class="pun">+</span> <span class="str">"/_vti_bin/listdata.svc/"</span> <span class="pun">+</span><span class="pln"> listName</span><span class="pun">,</span><span class="pln"> type</span><span class="pun">:</span> <span class="str">"POST"</span><span class="pun">,</span><span class="pln"> contentType</span><span class="pun">:</span> <span class="str">"application/json;odata=verbose"</span><span class="pun">,</span><span class="pln"> headers</span><span class="pun">:</span> <span class="pun">{</span> <span class="str">"Accept"</span><span class="pun">:</span> <span class="str">"application/json;odata=verbose"</span><span class="pun">,</span> <span class="str">"Slug"</span><span class="pun">:</span><span class="pln"> folderUrl </span><span class="pun">+</span> <span class="str">"|"</span> <span class="pun">+</span><span class="pln"> folderContentTypeId </span><span class="pun">}</span> <span class="pun">});</span> <span class="pun">}</span> <span class="kwd">function</span><span class="pln"> createDocumentSet</span><span class="pun">(</span><span class="pln">webUrl</span><span class="pun">,</span><span class="pln">listName</span><span class="pun">,</span><span class="pln">docSetName</span><span class="pun">)</span> <span class="pun">{</span> <span class="kwd">return</span><span class="pln"> getListUrl</span><span class="pun">(</span><span class="pln">webUrl</span><span class="pun">,</span><span class="pln">listName</span><span class="pun">)</span> <span class="pun">.</span><span class="kwd">then</span><span class="pun">(</span><span class="kwd">function</span><span class="pun">(</span><span class="pln">data</span><span class="pun">){</span> <span class="kwd">var</span><span class="pln"> folderUrl </span><span class="pun">=</span><span class="pln"> data</span><span class="pun">.</span><span class="pln">d</span><span class="pun">.</span><span class="typ">ServerRelativeUrl</span> <span class="pun">+</span> <span class="str">'/'</span> <span class="pun">+</span><span class="pln"> docSetName</span><span class="pun">;</span> <span class="kwd">return</span><span class="pln"> createFolder</span><span class="pun">(</span><span class="pln">webUrl</span><span class="pun">,</span><span class="pln">listName</span><span class="pun">,</span><span class="pln">folderUrl</span><span class="pun">,</span><span class="str">'0x0120D520'</span><span class="pun">);</span> <span class="pun">});</span> <span class="pun">} </span> |
The version history trimmer code currently deletes all the versions from just one document.But this will give you an idea of how to make it work for multiple documents as well here is the code below on how to use it Version Trimmer :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script type="text/javascript"> _spBodyOnLoadFunctionNames.push("AddTrimmerIcon"); function AddTrimmerIcon() { $(".ms-qcb-root ul li:nth-child(4)").each(function() { $(this).first().before('<li class="ms-qcb-item">' + '<button class="ms-qcb-button ms-qcb-buttons-alignmentfix js-listview-qcbUploadButton js-callout-body js-qcb-button ms-qcb-glyph" type="button"' + 'title="Select file and trim versions of the file" role="button" accesskey="t" onclick="TrimDocument()"><span class="ms-qcb-glyph ms-listview-glyph-withmargin ms-listview-sync-glyph ms-core-form-heading"><img style="height:20px;width:25px;" src="' + _spPageContextInfo.webServerRelativeUrl + '/SiteAssets/VersionTrimmer/vtrimmer.png"/></span><spancb-glyph ">Trim</span></button></li>') }); } function TrimDocument() { SP.SOD.executeFunc('sp.js', 'SP.ClientContext', Trim); } function Trim() { var count = SP.ListOperation.Selection.getSelectedItems(ctx).length; if (count == 0) { alert("Please select an item from the list"); return false; } if (count > 1) { alert("Please select only one file"); return false; } SP.UI.ModalDialog.showWaitScreenWithNoClose('Trimming Versions', 'Please wait while the versions of the file are being deleted'); var title = ctx.ListTitle; var items = SP.ListOperation.Selection.getSelectedItems(ctx); //get file versions $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('" + title + "')/items(" + items[0].id + ")/File/Versions", method: "GET", headers: { "Accept": "application/json; odata=verbose" }, success: function(data) { var totalversions = data.d.results.length; $.each(data.d.results, function(index, item) { var count = index; $.ajax({ url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('" + title + "')/items(" + items[0].id + ")/File/Versions('" + item.ID + "')", type: "POST", contentType: "application/json;odata=verbose", headers: { "Accept": "application/json;odata=verbose", "X-RequestDigest": $("#__REQUESTDIGEST").val(), "X-HTTP-Method": "DELETE", "IF-MATCH": "*" }, success: function(data) { if (totalversions == (count + 1)) { SP.UI.ModalDialog.commonModalDialogClose(SP.UI.DialogResult.c ancel); } }, error: function(data) { SP.UI.ModalDialog.commonModalDialogClose(SP.UI.DialogResult.cancel); } }); }); }, error: function(data) { SP.UI.ModalDialog.commonModalDialogClose(SP.UI.DialogResult.cancel); } }); } </script> </head> <body> </body> </html> |
below is what you will see ARF.docx has 2 versions as Read more about Version History Trimmer[…]
Recently i was surfing through the SharePoint store and checking out all the apps that developers made. I found this Accordion app which shows data from multiple lists. And so i thought, why not i try the same thing for my projects. Below is a concept i implemented. I have a Custom List called as Read more about Display multiple lists/libraries in an accordion view[…]
Shows 4 reports: Active Editors (Users who have modified documents in the last one month) Active Authors (Users who have uploaded or created documents in the last one month) Work in Progress (Users who have checked-out documents) File Types (Different Document Extensions present in the Library) Please visit ChartNew.js to know how the charts work. Read more about Library Statistics using ChartNew.js[…]
I get a requirement where user needs to download the selected files from the SharePoint Document Library by zipping all of them. This I wanted to tr purely using JavaScript. The below will explain you how to download selected files as zip file using JSZip. After surfing the internet I found this useful tool called Read more about Download selected files as Zip file using JavaScript[…]