Retrieving sharepoint lists using SOAP
sharepoint,soap,sharepoint-list
Chang - I wrote a simple SharePoint list SOAP query below in VBA. I was able to run it within Excel and pull data from SharePoint. Yet, almost nobody makes SOAP calls using VBA. Usually it's done using JavaScript, C#, or Java. Also, most people have moved away from SOAP...
Configure SharePoint 2010 UPS with PowerShell
powershell,sharepoint,sharepoint-2010,ups
For anyone else that happens to come across this problem, have a look-see at this: http://www.harbar.net/archive/2010/10/30/avoiding-the-default-schema-issue-when-creating-the-user-profile.aspx TL;DR When you create UPS through CA, it creates a dbo user and schema on the SQL server using the farm account, however when doing it through powershell it creates it with a schema...
Get longest List title name in array javascript Sharepoint
Simply declare a length-storing variable outside your while loop, then within your while loop compare the length of the currently iterating listString with your length-storing variable: var longest = ""; while (listEnumerator.moveNext()) { var currentItem = listEnumerator.get_current(), title = currentItem.get_title(); listString += "<br>" + title; if (longest.length < title.length) longest...
Calling C# code from JavaScript in SharePoint
I've solved it as follows : function getOutlook() { var xmlHttpReq = createXMLHttpRequest(); xmlHttpReq.open("GET", _spPageContextInfo.siteServerRelativeUrl + "/_layouts/SendDocuments/MyCustomHandler.ashx?ItemsArray=" + fileRefArray, false); xmlHttpReq.send(null); } function createXMLHttpRequest() { try { return new XMLHttpRequest(); } catch (e) { } try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { } try { return new ActiveXObject("Microsoft.XMLHTTP");...
Setting On Change on id from parameter does not work
jquery,forms,sharepoint,element,onchange
I found that it wasn't necessary to get the ID, since I had found the element. $('nobr:contains("Event Date")').closest('tr').find('input[title$="Event Date"]').on("change", function(){ alert("changed"); }); However, I still wished that getting the ID as a string would work. But, for now, it was just an extra unneeded step....
Unable to upload file to Sharepoint @ Office 365 via REST
javascript,ajax,rest,sharepoint,office365
To me it just seems a bit light, visit this link https://msdn.microsoft.com/en-us/library/office/dn769086.aspx on technet, and compare your upload function to this: // Add the file to the file collection in the Shared Documents folder. function addFileToFolder(arrayBuffer) { // Get the file name from the file input control on the page....
Im trying to populate a Sharepoint list with the most upcoming dates from certain colums of data from another Sharepoint list?
sql,ms-access,sharepoint,ms-access-2007
You could try an Excel table (they also have these functions in access if I recall, but I avoid access like a plague). To connect Excel to share point follow the steps in this article: support.office.com Ok, now that we are connected you should see all of the columns and...
why I don't get list subfolders despite using RecursiveAll option
web-services,vba,sharepoint,soap,caml
After alot of trials I've removed all extra unused tags and just checked that link on msdn and updated my caml by adding another tag queryoptions as follows which solves my problem: <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/"> <listName>listname</listName>...
Create Outlook meeting on SharePoint page
sharepoint,sharepoint-2010,outlook,interop,meeting-request
The Considerations for server-side Automation of Office article states the following: Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office...
Web Part “Recent Checkins” in sharepoint not showing changes
git,sharepoint,tfs,checkin,changeset
The SharePoint integration with TFS does not support git. That webpart will not work with git.
Qlikview document reload fails due to authorization restrictions on SharePoint 2010
sharepoint,sharepoint-2010,qlikview
I am not sure which credentials you use on the server, I assume that they must be different from your own. In this case, you could set up a task on the server using Task Scheduler to execute your batch script to reload the QlikView document. If you set the...
Access data from SharePoint-hosted app
If it is a regular calendar in the host web, you can access its data via CSOM or REST Api. Have a look at the following URLs go get a better idea. CSOM : BasicOps SPListItemTasks REST: Rest operations...
How do I disable a Sharepoint Web Part without being on the exact page?
You can add parameter Contents=1 to URL of the webpart page. It displays page in setup mode allowing you to remove webpart from the page. The final URL will look like this http://portal.contoso.com/page.aspx?Contents=1
Query not returning expected results(CAML)
Your CAML query needs to be wrapped in a View element when seeting the ViewXml. Your Value tags are both malformed; you're closing the element in the opening tag, meaning you have malformed XML. Your query has an underscore at the end of the value you specify for the...
Making jslink target specific list
sharepoint,sharepoint-2013,jslink
Ended up going with Paul Hunts solution that he writes about on myfatblog.co.uk. http://www.myfatblog.co.uk/index.php/2013/09/listview-web-part-issues-with-jslink-and-display-templates-a-solution/ The script ended up looking like this and I pasted it into the jslink function where I define what listContext to override. // Override the RenderListView once the ClientTemplates.JS has been called ExecuteOrDelayUntilScriptLoaded(function(){ // Copy and...
Upload file to SharePoint 2010 using PowerShell and the OData API
powershell,sharepoint,sharepoint-2010,odata,powershell-v3.0
In order to create an attachment resource the following properties have to be specified: Endpoint Uri: http://server/site/_vti_bin/listdata.svc/entityset(itemid)/Attachments Method: POST Headers: Slug: "entityset|itemid|name" ContentType: */* Body: content Having said that, my conslution that the specified body parameter ($payload) is invalid in the provided example. The following example demonstrates how to upload...
SharePoint list new item through SoapEnvelope
javascript,jquery,ajax,sharepoint,soap
Have you checked whether this field exists and that you're using its internal name? And another thing, I was curious why you are using this method? Can't you use the client object model to do these actions?
How to check if page is published
According to SP.Publishing.PublishingWeb Methods the method GetPublishingPages is not supported in JSOM API. But you could consider the following example to determine whether page is published or not using JSOM API function getPublishingPages(success,error) { var ctx = SP.ClientContext.get_current(); var list = ctx.get_web().get_lists().getByTitle('Pages'); var items = list.getItems(SP.CamlQuery.createAllItemsQuery()); ctx.load(items,'Include(File)'); ctx.executeQueryAsync(function() { success(items);...
Sharepoint Web Parts roll up
The best way to do this is using a SharePoint content search webpart. To get your head around the basics of how to pull search results from multiple sites see SharePoint 2013 Search: My Open Tasks
“Global” groups without AD
You can not create such groups as SharePoint groups have site collection scope. When your create the same group (with the same name) in two site collections they are still different (have different IDs). Only AD groups can be used across several different site collections.
Create a second form that references the same List (SharePoint 2013)
forms,sharepoint,sharepoint-2013
Create a content type for each type of data (ie.offers and demands). Assign both content types to the list. This will allow you to have an offer form and a demand form within the same list.
Angularjs service call from $rootscope causes unending iterative loop
javascript,angularjs,sharepoint,angular-resource
When you invoke a function within interpolation {{xxx()}} you need to be careful. Interpolation runs every digest cycle and you are calling a function within that, All is well, but then within the function you are making an service call or something which again triggers a digest cycle (ex:- after...
Web part custom properties Issues
Probably because you marked that field as static; remove that and you will be good to go
Configuring a standard single server TFS 2013 with SharePoint 2013 and SSRS for reporting
sharepoint,reporting-services,tfs,ssas,reporting
No problem, you can integrate your existing TFS single server deployment with your external SharePoint server assuming you have the necessary permissions. MSDN: Verify your SharePoint installation https://msdn.microsoft.com/library/dd578601(v=vs.120).aspx MSDN: Set up remote SharePoint https://msdn.microsoft.com/library/hh548140(v=vs.120).aspx Cheers ...
Count times a value is repeated in data fetched using REST call
javascript,jquery,rest,sharepoint
You could first map the TypeOfIssueValue values to a new array and then count each occurence based on this answer. The code would be : var a = data.d.results.map(function(issue) { return issue.TypeOfIssueValue }); result = {}; for (i = 0; i < a.length; ++i) { if (!result[a[i]]) result[a[i]] = 0;...
SharePoint 2013 App Deploy Error: “A different version of this App is already installed with the same version number”
visual-studio,visual-studio-2012,sharepoint,sharepoint-2013
First off welcome to the world of SharePoint dev. SharePoint can be quite painful with holding onto things, but the solution in your case is fairly easy - anytime you make a change to the AppManifest increment the version number. This is done on the general tab of the AppManifest,...
IIS hosted ASP.NET and SharePoint server libraries - authentication / security issue
asp.net,iis,sharepoint,asp.net-web-api,owin
Ok the issue has been fixed. The problem was not the IIS itself but the SharePoint ASP.NET context. When running in that context you have to make sure to handle the cross-site scripting protection in a correct manner. Here is how The E_ACCESSDENIED resulted from a false configuration in the...
How to bind a SharePoint list attachment to a Kendo Grid column dynamically
c#,json,sharepoint,kendo-ui,grid
Note that the schema.data configuration can accept a function, so you can parse the information that comes from the server before you bind it to the widget: Schema.parse And in the Kendo UI Templates, you can execute fully functional JavaScript, so you can implement a simple if statement: Templates...
Get all items of a sharepoint list
c#,sharepoint,folder,subfolder,client-object-model
Since your goal is: to download all files of my SharePoint list the following example demonstrates how to accomplish it: using (var ctx = new ClientContext(webUri)) { var qry = new CamlQuery(); qry.ViewXml = "<View Scope='RecursiveAll'>" + "<Query>" + "<Where>" + "<Eq>" + "<FieldRef Name='FSObjType' />" + "<Value Type='Integer'>0</Value>" +...
Sharepoint 2013: CRUD operations on Site Columns
sharepoint,sharepoint-2013,crud,site-column
This is doing exactly what you need, I've done it for work as well couple of weeks ago. var ctx; var web; var fieldChoice; var fieldName; var values; $(function () { SP.SOD.executeOrDelayUntilScriptLoaded(Function.createDelegate(this, function () { fieldName = $('#dropdown').find(":selected").text(); populateValues(fieldName); }), 'SP.js'); }); function selection() { fieldName = $('#dropdown').find(":selected").text(); populateValues(fieldName); }...
How to prevent fill in values when saving over CSOM to a choice field
You could consider to validate choice field value before saving its value as demonstrated below: static class ListItemExtensions { public static bool TryValidateAndUpdateChoiceFieldValue(this ListItem item, string fieldName, string fieldValue) { var ctx = item.Context; var field = item.ParentList.Fields.GetByInternalNameOrTitle(fieldName); ctx.Load(field); ctx.ExecuteQuery(); var choiceField = ctx.CastTo<FieldChoice>(field); if (!choiceField.FillInChoice) { var allowedValues =...
oData SharePoint Add List Item Containing Value Properties
c#,sharepoint,sharepoint-2010,odata,wcf-data-services
This was a great blog post explaining how to link complex list items (DataServiceCollecton and Value objects) in the SharePoint oData API: http://blog.heeresonline.com/2014/07/sharepoint-wcf-dataservices-choice-lookup-column-editing/ The important thing to remember is to add the new item to the data context before you begin populating complex fields of type DataServiceCollection or Value objects....
Angularize SharePoint Client Side Taxonomy Picker
angularjs,sharepoint,sharepoint-2013,sharepoint-apps
Given the challenges of making a "responsive" Managed Metadata field, I built the following using the JavaScript Object Model to retrieve terms and then push them for use in an Array. This includes retrieving Synonyms. // Query Term Store and get terms for use in Managed Metadata picker stored in...
Sharepoint 2013, File Upload Custom Page Lay Out
Solution: Adding this to the Custom PAge Layout. <a href="javascript:;" onclick="openInDialog(500,600,true,true,false,'https://harepoint.com/sites/site/_layouts/15/Upload.aspx?List=%7BFBD05330-969D-4853-B00A-6E728BA87F0B%7D');" class="ms-cui-ctl-large "><span unselectable="on" class="ms-cui-ctl-largeIconContainer"><span unselectable="on" class=" ms-cui-img-32by32 ms-cui-img-cont-float"><img unselectable="on" src="/_layouts/15/3082/images/formatmap32x32.png?rev=38" alt="" style="top: -239px; left:...
How to Merge a from 2 sharepoint lists and display it in a ASP.NET GridView ?
c#,asp.net,sharepoint,gridview
Using Linq2SharePoint is not good idea. There are many issues with that. Including performance issues. Sometimes it generates strange errors and it's very hard to debug it. You use CAML in your code. CAML can do join as well. See here how to do it. It's handled by SharePoint itself...
SharePoint - Reference file in item properties
OK. It seems that Sparqube Lookup Classic uses the file title and cannot work with files that have no title. So, first you have to set the title and then everything works: public static void PublishDocToSP() { var clientContext = GetClient(); SP.Client.File file; var folderName = "DocLib"; // Upload file...
jQuery validate plugin inside a jquery UI dialog for SharePoint page application
jquery,asp.net,sharepoint,jquery-validate,jquery-ui-dialog
Maybe it will help someone. I solver my problem. It was necessary to element with id="dialog" wrap in element with id="dialogForm" and get this: <form id="dialogForm" action="" > <div id="dialogAddNewRoute" title="Добавление пункта назначения" class="CustomDialogCSS"> <fieldset> <label for="nameCountry">Страна</label> <input type="text" id="nameCountryID" name="nameCountry" /> <br/><br/> <label for="nameCity">Город</label> <input type="text"...
Creating term fails in SP 2013
c#,sharepoint,sharepoint-2013,csom
Make sure that your user has permissions to term store. Go to central administration ==> manage service application ==> click on line (not link) of your service application ==> choose "Permissions" ribbon button and add your account. Also make sure that your term set ist open for term creation. You...
Header set on $resource not returning proper odata response
According to the docs for $resource, the headers object should be placed within an action: appServices.factory('appItems', ['$resource', function ($resource) { return $resource("/_api/web/lists/getbytitle('Todo Task List')/Items", {}, { 'query': { method: "GET", isArray: false, headers: { 'Accept': 'application/json;odata=nometadata'} }, 'update': { method: 'PATCH', headers: { 'Accept': 'application/json;odata=nometadata'} }, } ); }]); As...
Using angular submit button causes redirect instead of calling function in SharePoint
angularjs,sharepoint,sharepoint-2013
I solved it by closing the tag of SharePoint instead of creating a custom masterpage. Ex: <!-- Close the default form tag put in place by SharePoint instead of creating a custom Masterpage without this element that requires increased permissions and complexity to deploy. Without this tag closed, the form...
Access SharePoint expanded properties
powershell,sharepoint,sharepoint-2010,odata,powershell-v3.0
The query is malformed since $ symbol have to be escaped using single-quoted string literals, for example: $url = "http://contoso.intranet.com/_vti_bin/listdata.svc/TheList?`$select=Id,Title,Stakeholder/Name&`$expand=Stakeholder" Then Stakeholder value could retrieved as demonstrated below: $StakeholderValue = $data.link | where { $_.title -eq "Stakeholder" } | select -Property @{name="Name";expression={$($_.inline.entry.content.properties.Name)}} Modified example $url =...
Update multiple fields in SharePoint programmatically
The problem I believe is with your foreach (SPField field in fields) line of code. You are essentially modifying the collection that you are looping over. What I would suggest you try is looping and getting the ID's of all the fields in to a List<GUID> Then do a foreach...
Powershell error Add-PSSnapin “Microsoft.SharePoint.PowerShell”
powershell,sharepoint,sharepoint-2010,powershell-v2.0
Check to see if module is already loaded: if (Get-Module -ListAvailable -Name SomeModule) { Write-Host "Module exists" } else { Write-Host "Module does not exist" } Source: How do I check if a powershell module is installed? UPDATED: Try { if((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null){ Add-PsSnapin Microsoft.SharePoint.PowerShell }...
Sharepoint 2010 Blog - Order rest query by Category
json,rest,sharepoint,sharepoint-2010
Category field (PostCategory internal name) is a multiple choice field, in SharePoint REST it is not supported to apply $orderby query option to this type of field. But you could sort returned items using JavaScript. The following example demonstrates how to order Posts by Category field. There is one important...
How to get sharepoint folder by name using CamlQuery
c#,sharepoint,sharepoint-2010,dynamics-crm-2011,caml
Since you are using SharePoint CSOM API, i would recommend to utilize Web.GetFolderByServerRelativeUrl Method for getting folder object located at the specified server-relative Url Example var folderUrl = "Lists/Discussions/2013"; //folder named 2013 located in Discussions list using (var ctx = new ClientContext(webUri)) { var folder = ctx.Web.GetFolderByServerRelativeUrl(folderUrl); ctx.Load(folder); ctx.ExecuteQuery(); }...
Update SharePoint list entry using ListData.svc and PowerShell
powershell,sharepoint,sharepoint-2010,odata,powershell-v3.0
The following example demonstrates how to update List Item using SharePoint REST Interface: <# .Synopsis Update Lst Item .DESCRIPTION Updates List Item operation using SharePoint 2010 REST Interface. To update an existing entity, you must perform the following actions: - Create an HTTP request using the POST verb. - Add...
Calling PHP variable as function value
javascript,php,jquery,variables,sharepoint
I tried what MattyF and Venkat suggested, and I couldn't get it to work, and what I ended up doing was creating a solution using Java alone. var day = new Date().getDate(); var checkActive; if (day % 2 == 0) { // If the day number is Odd, we will...
C# CSOM - Check if File Exists in Document Library
You could consider the following approaches to determine whether file exists or not. Query based You could construct CAML query to find list item by its Url as demonstrated below: public static bool FileExists(List list, string fileUrl) { var ctx = list.Context; var qry = new CamlQuery(); qry.ViewXml = string.Format("<View...
ERROR: Collection was modified; enumeration operation may not execute. Other solutions are not working for me
If you can't use ToList() or ToArray() directly, create a new list and add items from users to it, then use that new list in the foreach loop Though it is obious that your users implement IEnumerable interface (otherwise you wouldn't be able to use it in the foreach loop),...
Update value of input after text
The input is not in your td so the find method won't work. You need to select the next td first. $( "td:contains('Company')").next("td").find("input").val("test"); I updated your fiddle with the right selector JSFiddle updated...
Hide and Show Divs without using Jquery
I have given a detailed step by step, this should work just like the current source code you have but without the use of jQuery. function toggle(){ //Get all elements with the class comb var comb=document.getElementsByClassName('comb'); //Loop through all elements for(var i=0; i<comb.length; i++){ //Hide all elements comb[i].style.display='none'; } //...
Display element's attribute using PowerShell's Format-Table
powershell,sharepoint,sharepoint-2010,powershell-v3.0
you dont have to use a hashtag. PS>$xml.feed.entry.content.type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ...
SharePoint 2013 Can't load user profiles “HttpContext is in an assembly that is not referenced”
c#,asp.net,.net,sharepoint,sharepoint-2013
There is a good chance SharePoint assemblies you are using built against .Net 2.0/3.5 assemblies and you are referencing .Net 4.x assemblies (or other way around). If latest version of Framework (4.x) is not requirement switching project to older version can be a solution. To do so change "Target Version"...
PowerShell map persistent sharepoint path
I ran into this problem a few weeks back in a script which mysteriously stopped worked whilst I was developing it, seems to be a Windows error 66 rather than Powershell as explained here Here is an alternative to net use which uses credentials # map drive using credentials (New-Object...
How to redirect a URL in SharePoint Online?
You don't have much options: being in SP Online you don't own the infrastructure, thus you can't rely on some techniques which may be overkill for this simple case, such as plugging in a custom HttpModule in the IIS pipeline, or working with IIS Rewrite URLs. The only would be...
SharePoint JavaScript API for Workflow throws an error
javascript,sharepoint,workflow
Propbaly this error occurs since one of the specified files from SharePoint JavaScript library has not been loaded. SP.js SP.Runtime.js SP.WorkflowServices.js To ensure that the specified file(s) has been loaded you could consider the following approach: SP.SOD.registerSod('SP.ClientContext', SP.Utilities.Utility.getLayoutsPageUrl('sp.js')); SP.SOD.registerSod('SP.WorkflowServices.WorkflowServicesManager', SP.Utilities.Utility.getLayoutsPageUrl('SP.WorkflowServices.js')); SP.SOD.loadMultiple(['SP.ClientContext',...
Access Denied when using ExecuteQuery() for a Sharepoint site
If you go to the group through the UI as a user you need to edit the setting that allows other group members to see whos in the group Navigate to site settings > people and group > click on your Group > on one of the menus like actions...
how to find which object is causing “Attempted to use an object that has ceased to exist”
I believe there is no way to find which object is creating problem. you need to check each web part one by one to the which webpart is creating problem. Then you need to find which object is creating problem. once the object is found you need to use Elevated...
Convert “float;#22.0000000000000” into just “22.0” in C#
Use given code to get only 22.0 string value = "float;#22.0000000000000"; var number = value.Split('#')[1]; double num = double.Parse(number); Console.WriteLine(num.ToString("0.0")); Result: 22.0 mentioned code should be work. item.GetFormattedValue("ColumnName") OR try this post https://social.msdn.microsoft.com/Forums/office/en-US/fdef03db-9678-46cf-8ff7-03551f4b8466/how-to-convert-a-decimal-number-field-to-c?forum=sharepointdevelopmentprevious...
Read/Write Microsoft Access (.accdb) synced to Sharepoint with Ruby
I may be misunderstanding your situation, so I apologize in advance if that is the case. When you sync an Access DB with SharePoint, Access creates a SharePoint list for each table. It then links the list to the local Access database. As you edit data through your forms, you...
Display JQuery dialog using a JS-file
Set autoOpen to true: $( "#dialogSendMail" ).dialog({ resizable: false, height:350, width:650, modal: true, autoOpen : true, buttons: [ { text: "Send Mail", click: $.noop, type: "submit", form: "myForm" }, { text: "Close", click: function () { $(this).dialog("close"); } } ] }); ...
Placing VSDocman external files on Sharepoint
visual-studio,sharepoint,visual-studio-2013,sharepoint-2010
I was able to resolve this by mapping as a network drive using \\sharepointsite\shared documents\project1\docs\images In windows explorer. Once I figured out I could map to the drive, I just paste the same url in to VSDocman and attach the images that I needed. Worked like a charm....
“add data driven subscription” missing in SSRS sharepoint mode
sharepoint,reporting-services,sharepoint-2013,ssrs-2012
Fixed it. Though the database server had Enterprise installation of SQL Server, the SQL Server components installed such as reporting services sharepoint add-in on the Sharepoint servers were of standard edition and not enterprise. Upgraded the edition by using the upgrade edition option in the sql server installation center on...
Why does my Sharepoint WebPart deploy (nominally), but is still not available for adding to a page/form?
sharepoint,sharepoint-2010,web-parts,webpartpage
By comparing a working project with this one, I was finally able to get it to deploy without the "A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe." add-time error msg....
How to use inline conditional (if then else) in XSLT?
xslt,sharepoint,sharepoint-2010,xslt-1.0,dataviewwebpart
As mentioned in the comments, the if () then else construct is only supported in XSLT/XPpath 2.0. My own preference would be to use the verbose, but readable: <xsl:template match="some-node"> <div> <xsl:attribute name="ID"> <xsl:choose> <xsl:when test="string(@ID)"> <xsl:value-of select="@ID"/> </xsl:when> <xsl:otherwise>default</xsl:otherwise> </xsl:choose> </xsl:attribute> </div> </xsl:template> or perhaps a shorter: <xsl:template match="some-node">...
Configuring TFS Extensions for SharePoint on remote server article has some error?
Installing TFS on the server installs the required prerequisites, TFS Client Object Model, The Server Object model, the WSP that installs the SharePoint Extensions and a few other items. These elements are required for the Sharepoint Extensions to connect to the remote TFS server. Installing these only drops these bits,...
sharepoint 2010 get value of choice field through api call
rest,sharepoint,sharepoint-2010
The query: http://myintranet:2010/sites/ImagesGallery/_vti_bin/listdata.svc/ImageList?$expand=ImageType returns list items values for List resource only. In order to retrieve field resource itself, the different endpoint have to be specified, in particular: http://myintranet:2010/sites/ImagesGallery/_vti_bin/listdata.svc/ImageListImageType It is assumed that list name is ImageList and field name is ImageType Example $.getJSON(endpointUrl) .done(function(data) { //print field choice options data.d.results.forEach(function(item){...
How to enableMajor?
In order to enable Create major versions the following steps should be performed: set SP.List.enableVersioning property to true call SP.List.update Method to update the list Example function enableListVersioning(listTitle,success,error) { var ctx = SP.ClientContext.get_current(); var list = ctx.get_web().get_lists().getByTitle(listTitle); list.set_enableVersioning(true); list.update(); ctx.executeQueryAsync( function () { success(); }, error); } //usage enableListVersioning('Pages', function(){...
Error deploying InfoPath form on Sharepoint 2013: The XSN cannot be used on the server
sharepoint,sharepoint-2013,infopath
I figured it out, the field Access Path in the Publishing Window must be blank, even if InfoPath suggests to keep it as the same as the Publish Path.
Escape single quotes in PowerShell
powershell,sharepoint,sharepoint-2010,powershell-v3.0
You need to double the quotes when using single-quoted string literals: '&$filter=(OwnerId eq 1234 and Status eq ''Ready'')' ^^ ^^ Demo: PS > '&$filter=(OwnerId eq 1234 and Status eq ''Ready'')' &$filter=(OwnerId eq 1234 and Status eq 'Ready') PS > Using backticks only works with double-quoted string literals (since they process...
SharePoint 2013: Hello World remote app using REST configuration
rest,sharepoint,sharepoint-2013,access-token
Click on BasicSelfHostedAppREST project and hit F4 (Show Properties) ...
what is wrong with this js link code? the array should show its data but it gives undefined. I want to display data in two columns
I guess you need to render list items from Announcements list horizontally, right? The following example demonstrates how to accomplish it: SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() { SPClientTemplates.TemplateManager.RegisterTemplateOverrides({ Templates: { View: renderAnnouncementsView }, ListTemplateType: 104 }); }); function renderAnnouncementsView(rCtx) { var listData = rCtx.ListData; var viewHtml =''; viewHtml = '<table><tr>'; for (var...
SharePoint newListItem Soap with img attachment
javascript,ajax,cordova,sharepoint,soap
SharePoint: AddAttachment SOAP Web Service Yes, you can use SharePoint SOAP web services to upload an image attachment to a list. However, there are some limitations. My demo below uses the AddAttachment action of the Lists web service. The required parameters are listed and can be modified for your own...
CAML query filtering is not working
c#,.net,sharepoint,sharepoint-2010,caml
The overload of SPList.GetItems that would accept a string is actually this overload which accepts a params string[] argument of a list of fields that should be returned while returning all items in that list. It's not expecting a CAML query. You need to stuff your CAML into an SPQuery...
How to configure my SharePoint server for Business Intelligence [closed]
sharepoint,business-intelligence
Well I know that link only answers are not considered good style at SO. But since the question is very broad and a complete answer is out of scope any way, here is a step-by-step guide on how to setup your SharePoint Server 2013 to use the BI features: http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx...
Add Button in SharePoint List Ribbon Button Using JSOM
javascript,sharepoint,ecmascript-5,csom
It's the location property, here is the list over default locations from msdn Example: newUserCustomAction.set_location('NewFormToolbar'); Update: Tbh if you want maximum control, you should use the set_commandUIExtension, you can use the same markup as you when you deploy a custom action. Could be like this: var context = new SP.ClientContext.get_current();...
Retrieve File From Sharepoint Library Using C#
Solved by link and explanation below: Unable to retrieve file information from SharePoint library using Client Object Model Relavent snippet: CamlQuery qry = new CamlQuery(); qry.ViewXml = "<View></View>"; qry.FolderServerRelativeUrl = "/001/API/Asset Optimisation Interface/Asset Technical Data/"; I hadn't expected that the Server Relative URL was not relative to the location in...
How can I get Internet explorer to display this image correctly
i think you copied this code from somewhere.... there is some special character between <td></td> if you write the code again space will not come or copy this code <p> </p> <table cellspacing="0" cellpadding="0" style="width: 100%; height: 232px;" > <tbody> <tr> <td class="ms-rteTable-default" style="width:292px;"></td> <td class="ms-rteTable-default" style="width:33.33%;"></td> <td class="ms-rteTable-default" style="width:33.33%;"></td> </tr>...
How to check if list contains needed rows using javascript in sharepoint2010?
What you'll want to do is compose a CAML query that filters on the desired Name and eventID, and query the list for matching items. In the callback method for that asynchronous query, set a variable to false. Then, when you iterate through the returned items, set the variable to...
Any idea about inserting html to SharePoint?
Open page for edit. Then from "Media and Content" group choose "Script Editor" web part. And then click Edit Snipper and paste your html code there. You can also use Content Editor web part and provide link to your html code. If you want to change style for whole SharePoint...
Is this kind of logic possible using CAML Queries?
Thanks to spevilgenius on spservices.codeplex.com, here is what worked for me: <And> <Or> <Contains> <FieldRef Name="Column1"/><Value Type="Text">word1</Value> </Contains> <Contains> <FieldRef Name="Column2"/><Value Type="Text">word1</Value> </Contains> </Or> <Or> <Contains> <FieldRef Name="Column1"/><Value Type="Text">word2</Value> </Contains> <Contains> <FieldRef Name="Column2"/><Value...
Sharepoint Angular REST add item yields 400 (Bad Request)
jquery,angularjs,rest,sharepoint
This error might occur due to the following reasons: 1.Invalid List Item payload In particular the format of body attribute must have the following format for list item: $http({ data: { Title : 'John Doe', __metadata: {type: 'SP.Data.ContactsListItem' }}, //remaining parameters are omitted for clarity }); where Title is a...
Set audience on specific node in SharePoint quick launch with powershell
Solved it by adding ;;;; before the group name. $node.Properties["Audience"] = ";;;;Custom group" ...
TFS change SharePoint links
I was unable to work out how to do this using the PowerShell Cmdlets but I have been able to write a program to do this using Team Foundation Work Item Tracking Client I have looped through each of the work items and their external links, if the link is...
Sharepoint 2013 Search results for Powerpoint files
In SharePoint Server 2013 cumulative update published on October 26th 2013 Microsoft changed method of extracting Title and Author managed properties from documents. Details are here: http://blogs.msdn.com/b/spses/archive/2013/10/31/show-more-relevant-titles-in-search-results-in-sharepoint-2013-plus-some-other-improvements.aspx Sometimes, people save or upload Word documents or PowerPoint presentations with titles like “Document1.docx” or “Presentation1.pptx”. Before the MetadataExtractor was introduced this title...
SPContext.Current.Web.CurrentUser; return wrong user
Because your spadmin is the system user have a look at here: or here ...
Append text to text hyperlink using javascript
If you give the hyperlink an ID (you would end up with <a id="someID" href="...">New Applications<a> you can use this code: document.getElementById('someID').innerHTML += value; This will append whatever is in value to the end of "New Application"...
Sharepoint RDL report referring a new cube in the SSAS DB fails to execute the query to a shared data source
sharepoint,reporting-services,datasource,cube,rdl
It's solved! My college proposed to switch on SQL Server Profiler, than I ran report from SharePoint again and Profiler showed, that SharePoint connectes to SSAS DB with 'Reader' role and then mistake 'Unknown or unprocessed cube' rises. But the Cube was processed, we checked it. So we went to...
Sharepoint REST Field Property does not exist
This error occurs since $select query option accepts field internal name but not display name. Having said that, you might need first to determine field internal name, for example: /_api/web/lists/GetByTitle('Anwendungen')/fields?$select=InternalName&$filter=Title eq 'RAM' Once the field internal is determined, you could query field value like this: /_api/web/lists/GetByTitle('Anwendungen')/items?$select=<RAM internal name> where <RAM...
Maintain Sharepoint Server Url with subfolders in document list
excel,vba,excel-vba,sharepoint,listobject
I've used GetListItems with Soap query and webservice to get list items instead of the posted method
Msocaf Report error in memory management /spdispose check
After doing some poc I found the answer. rootsite = SPContext.Current.Web.Site.WebApplication.Sites[0].Url; this type of line where a site is opened by not disposed properly msocaf gives the above mentioned error....
sharepoint rest service 401 not found
java,url,sharepoint,connection
Add request property and request method solved the problem. InputStream getAuthenticatedResponse(final String urlStr, final String domain,final String userName, final String password) throws IOException { Authenticator.setDefault(new Authenticator() { @Override public PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication( domain + "\\" + userName, password.toCharArray()); } }); URL urlRequest = new URL(urlStr); HttpURLConnection conn...
Issues when trying to add new list items using the reference Microsoft.Sharepoint.Client
c#,winforms,sharepoint,sharepoint-2013
I found the issue cause: I was using the "Display Name" of the fields, but I need to use the "Internal Name" instead. So I checked in the List settings the Internal Name of the fields and then I used at this part of the code: oListItem["field 1"] = "a";...
AngularJS Error on SharePoint Online Webpart Page
javascript,angularjs,sharepoint
You need to remove jQuery(document).ready(function () { will run your code, why it needed you there in first place. Working Plunkr...
SharePoint oData API Only Returns 1000 Records
sharepoint,odata,sharepoint-2013,wcf-data-services
I created an extension method called SelectAll() that returns all of the records for a given query. public static List<T> SelectAll<T>(this DataServiceContext dataContext, IQueryable<T> query) { var list = new List<T>(); DataServiceQueryContinuation<T> token = null; var response = ((DataServiceQuery)query).Execute() as QueryOperationResponse<T>; do { if (token != null) { response =...
Execute SharePoint Function On Page Load in AngularJS Application ($scope issue???)
javascript,angularjs,sharepoint,sharepoint-2013,sharepoint-api
I was able to get this working. The problem was that Angular doesn't appear to respect non-Angular functions, so using $scope.apply around the push of my array to $scope was effective. Note that wrapping the entire function caused issues with the digest of Angular: var termsArray = []; execOperation(); function...