samedi 31 janvier 2015

Validating Password based on nested IFstatements and FIND function Problem



I am having trouble figuring out how to validate multiple special characters in SharePoint 2010 when a user inputs a password. The special characters that are allowed are: !@$*+ . When i have one IF statement such as: =IF(FIND("!",Password),TRUE) , it works just fine and will inform the user there is no "!" if it isnt entered.


My problem is finding out how to enter in multiple IF statements to valid if any of the following special characters:!@$*+ are entered.


If i do a IF statement saying: =IF(OR(FIND("!",Password),TRUE),IF(FIND("@",Password),TRUE) it will only validate and allow passwords when both the !@ specials characters are entered, when it needs only one of the special characters to be correct, not both. Any help would appreciated, thanks!






Retrieve list items Links



when retrieving list items via Javascript how to get the link or action to click and go to that item link






Referencing JS and CSS in sandbox web parts error



I am trying to reference JS and CSS files in sandbox web part, but once I try to deploy it gives me this error:



The expression prefix 'SPUrl' was not recognized. Please correct the prefix or register the prefix in the section of configuration.



I am referencing my css and js this way:



<SharePoint:ScriptLink Name="<% $SPUrl:~sitecollection/style library/assets/js/modernizr.js %>" ID="modernizr" runat="server" ></SharePoint:ScriptLink>
<SharePoint:CssRegistration ID="CssRegistration1" Name="<% $SPUrl:~sitecollection/style library/assets/css/style.css %>" runat="server" After="corev15.css" ></SharePoint:CssRegistration>


Anything wrong with that? Is there a limitation for this in Sandbox solutions?






How to Get User's Friendly Display Name on SharePoint 2010



I have been searching around the web trying to find some help on this. We are working on a aspx page hosted on a Sharepoint2010 site. We have been able to successfully get the current logged in user's username in the format of "DomainName\UserName" - by using the below very basic code:



<asp:LoginName id="LoginName01" runat="server" FormatString={0}/>


Need help in getting the friendly display name of the user - "FirstName LastName" - of the current logged in user.






SharePoint 2013 multilingual text based on regional settings



I have a SharePoint 2013 site with custom newsfeed webpart. The news items are retrieved from a Custom SharePoint list. I want to change the header of the webpart to different language based on the regional settings. For example, If I change the regional settings of computer to German I want to change display webpart heading in German in SharePoint site.


Is it possible to do using resource files for each language.






How do I put a PDF file into a Document library via web service?



I have a SharePoint 2010 environment that has a SSRS report. The user clicks a button and sees the report rendered via PDF. I would like to instead of downloading that PDF, place it into a document library. Is this possible via JavaScript and web services?






Create Excel from SPListItemCollection and upload to a Document Library



Here is the scenario, I have a Timer Job. It sends Monthly summary of a list based on certain filters. I am able to generate Datatable from SPListItemCollection that I get using CAML. I would like to know how to generate an Excel file and upload it to a Document Library on the fly. Any suggestions?


P.S: Generating Excel from Datatable is not an issue, I am unable to figure out How to upload a Document that was just created from code (StreamWriter)?






Ways to route documents to a secure location in SharePoint Online 2013



I'm looking for a solution to allow for a a document to be uploaded by a user with a limited about of permissions. I'd like this document be to routed to another location into a folder. I was looking at another document repository for the final location the file ends up in. But If there is another way to move it to a secure location in differ folder depending on who uploaded it that would be even better.


I'm hoping to find a solution that doesn't require any code modification and can use build in tools or apps. I really appreciate any help.






REST with fiddler unauthorized



I am trying to use REST in SharePoint with fiddler, but whenever I make a request I get 404 unauthorized. So how do people test their REST requests using fiddler?






Getting a list of Document libraries for the currently login user



I want to get a list of all the document libraries in the site for the currently login user only?


How can i do this? any code sample if possible?






Covert routing style .NET app to SharePoint-online hosted app



We have a on-premises IIS hosted web application that uses route information to fetch data from web service and display content to users. For instance, a news URL will look like:


http://ift.tt/1tM5AYH


-which is basically http://www.contoso.com/ {news controller} / {article-id}


All code in existing application is already just HTML/JavaScript, except for Routing.


Now that we have SharePoint 2013 online, and contoso.com will ultimately become a SharePoint site collection, I'm trying to find a way to keep the URLs same.


I realize that there is no way to add routes to the SharePoint 2013 online site collection. Additionally, Apps for SharePoint created via Visual Studio do not allow any server side code and only HTML + JavaScript if deployed using the SharePoint-hosted model.


So are we left with on-premises hosted SharePoint app - which allows arbitrary programming technology - BUT which requires an on-premises SharePoint installation - which basically means two SharePoint environments?


Or is there are simpler way of doing this?






How to filter for files using rest api ( sharepoint online )?



Why doesn't the following string returns data from within a folder in the same asset library:


Asset Library Name is Production_Library


Folder Name is at the top level of the asset library and is named Communication Management


The filter works nicely here at the /items level filtering against the Business Process field.




http://ift.tt/167uaYN eq 'Communication Management'


However, the filter doesn't work at all here within the folders against the Name Field.




http://ift.tt/1CYG58O eq 'Communication Management'





Custom domain name of SharePoint 2013 app



Let's say our SharePoint 2013 online url is http://ift.tt/1wO5r22


Is it possible to add a subsite (like an application under IIS website) that launches a SharePoint app?


I created a sample SharePoint 2013 app in Visual Studio and deployed it to SharePoint online, and got a long isolated url like http://ift.tt/1tLLYUA


I'm wondering if the app can be accessed under the same root domain as shown in the picture below, something like http://ift.tt/1wO5r24.


If this is not possible, how are users supposed to access the app? Like the developer provides the isolated domain link to the app in a page?


enter image description here






Get data from repeating table infopath



I have repeating table in infopath form which displays one column with name and other column with checkbox control. When user selects the checkbox, i need to display the corresponding name value in a separate table above the repeating table. How can i achieve this?






Infopath form printing extra blank pages in SharePoint 2013



I have an infopath form when i am printing the form, it is printing extra blank pages. If the form has 4 pages content it is printing extra 8 pages. I even tried to create a different view and printing the same but it did not work. Any suggestion plz






Create a Sharepoint wiki page using JSOM



I need to create a Sharepoint wiki page using JSOM, Can anyone guide me to create path? I'm very very new to Sharepoint and eager to learn..


i found this but it has used Rest API and didn't find very useful to me Creating a SharePoint Wiki Page via JavaScript and REST or CSOM


Thank you all






Incorrect duration sets for recurring events when use custom New Form for SharePoint Calendars



I made a custom NewForm.aspx for the calendar list to enter datas then when I add a new recurring event to repeat the event every day until next 2 months and save the event, It just repeats the event for just one month and not any more and EndEvent column has the value of StartEvent ! but when I do the same things with the SharePoint original NewForm , It works properly ! It's going to make me crazy :| what's the differece and why it happens !






Web API with social.following



I would like to create a Web API which interacts with the SocialFollowManager. I want to be able to make a document unfollowed. The exposed Web Api will be later accessed by a mobile application.


Does anyone done that and if yes could you point me to some examples?






sharepoint 2013 - Query search to _Layouts directory



Within SharePoint 2013 - I was able to create a query for a search that allows me to find pages in my current site collection....



{searchTerms} Path:https://my-site/


Through this same search tool, it is possible to query for custom .net pages that live under my _layouts directory as well? something like this...



{searchTerms} Path:https://my-site/_layouts/customfolder/


I am having trouble getting any results when I attempt to do that...


thanks for any advice on what I need to adjust in my search settings to get pages to show up.


...still stuck on this issue - any ideas on searching for external sources via _layouts directory?






Power Bi on SharePoint Online 2013



I have a Power Bi License on SharePoint Online - suspect the free one. I have access to the Power Bi Admin center and gateway on SPO. I have Power Bi on my Windows 8 desktop.


On my client I've created a pbix report with an SOP List data sourcde.. on my client it works and refreshes!




  1. How can I present that report on an my SPO page to users? I've tried to upload to do library and dashboard page on an SPO Bi Site and it only wants to download the file. Must users need to have a Power Bi license to view the page/report?




  2. Once up, will my report allow for data refresh to SPO List sources? Automatic refreshes? We've had issues with this before with Excel Services where SPO data will not allow refresh with powerview.




  3. Any option within Power Bi to build WYSIWYG (SSRS type) reports where we can arrange SPO Data into full page view?








How to select multiple value in SharePoint list



I cant select multiple items from SharePoint list when we have large data in list. When we have large data, it shows items without check box like this enter image description here


plz help me to resolve this issue.






Why does .get_title() called from an (SPOnline) App-Web return an incorrect Localized DisplayName?



Can someone please explain me where I go wrong with the testcode (all the way the bottom)


I develop ViewMaster365.com Apps [using Microsoft Napa! so I can not do anything with .Net code] which Create Calculated Columns in the Host-Web; so in the Formulas I need to use Localized DisplayNames on non-english sites.


MSDN documentation for Field.get_title() says: Gets or sets value that specifies the display name of the field.


But On the same non-english Subsite get_title() returns different results when run directly in the site compared to when run from an App.


Steps to reproduce:


Run code in a teamsite



  1. Create a non-english Locale subsite I used German in my example, its not my own language but can read it

  2. Run the script below in Chrome Snippets


This produces the results I expect, get_title() gets me the localized DisplayName



Run code from an App-web



  1. [install an (english¿) App with read rights in]

  2. Now open the App in that same subsite (now Host-web)

  3. Run the script below in Chrome Snippets the script is now accessing the subsite through the App-web


Now get_title() returns me the DisplayName as if the site was an English Locale;


!! extracting the DisplayName from the SchemaXml clearly shows the correct DisplayName !!


It looks to me like get_title() returns the Locale DisplayName of the App Web instead of the Host-Web.. (I have not tested what happens with an App which is not in english.. couldn't find one; and with Napa I can only create english Apps)



Test code


Code to be run as Chrome Snippets (or any way you want it)


try-catch is used to try App code first; if it fails it defaults to the current ClientContext



var listName='Tasks';
var reportDIV=document.getElementById('DeltaPlaceHolderMain');
var listTitle='<h1>'+listName+'</h1>';
reportDIV.innerHTML=listTitle;
var context,web;
JSRequest.EnsureSetup();
try{
context = new SP.ClientContext(decodeURIComponent(JSRequest.QueryString["SPAppWebUrl"]));
var appContextSite = new SP.AppContextSite(context, decodeURIComponent(JSRequest.QueryString["SPHostUrl"]));
web = appContextSite.get_web();
} catch(e){
context = new SP.ClientContext.get_current();
web=context.get_web();
}
listTitle+='<h2>context.get_url() = '+context.get_url()+'</h2>';
var fields=web.get_lists().getByTitle( listName ).get_fields();
context.load(fields);
context.executeQueryAsync(
function(){
var fieldEnumerator = fields.getEnumerator();
var rows=0,table='<tr><td><b>get_internalName()</b></td><td><b>get_title()</b></td><td><b>DisplayName from get_schemaXml()</b></td></tr>';
while (fieldEnumerator.moveNext()) {
var field=fieldEnumerator.get_current();
var DisplayName = field.get_schemaXml().split('DisplayName="')[1].split('"')[0];
var Title=field.get_title();
Title = DisplayName!=Title ? '<b style="color:red">'+Title+'</b>' : Title;
var cols = []; cols.push( field.get_internalName() , Title , DisplayName );
table+='<tr style="background-color:#E0E7F'+(rows++%2?1:10)+'"><td>'+cols.join('</td><td>')+'</td></tr>';
}
reportDIV.innerHTML=listTitle+'<table width=100%>'+table+'</table>';
}
,
function( sender,args){ alert(args.get_message())}
);





vendredi 30 janvier 2015

Overwrite The Current Version In Custom List (Sharepoint 2010)



enter image description here


As we can see in above image there is a functionality to overwrite the current version in Document Library but I want to achieve this in Custom List. Any Idea or Help will be appreciated Thanks in advance...






Cannot find "Site Collection Storage Management" in SharePoint Online 2013



Our Microsoft TAM has told us of a recently deployed feature in SPO that allows all sites to shared a single pool of automatically managed storage. However the section of the admin panel he is telling me to use (named above) does not appear for me at all. This MS blog post also explains how to turn this feature on. The section highlighted simply is not there in my admin panel. I asked him for more information and here is his response (exact quote, except for the delinkifying the urls):



Enable self service http: http://ift.tt/1uSO42K and http: office.com/teachers will add an additional 750TB of pooled SharePoint Online storage.



I am thinking he skipped a couple of indefinite articles in that sentence. He seems to be telling me to permission my farm to allow users to create their own sites (which I already do), then go to two sites (both of which redirect to the same SPO login page), and then my 750TB will automagically appear. I have spent the last hour crawling through all the Site Features, Site Collection Features, and anything else I could think of. I still cannot figure out what he is telling me.


Coming to this community in hopes of avoiding humiliating myself front of my TAM. Please save me from this terrible fate.






Unable to get property 'get current' of undefined or null reference



function listAllCategories() {



var ctx = new SP.ClientContext(appWebUrl);
var appCtxSite = new SP.AppContextSite(ctx, hostWebUrl);

var web = appCtxSite.get_web(); //Get the Web

var list = web.get_lists().getByTitle("NewsList"); //Get the List

var query = new SP.CamlQuery(); //The Query object. This is used to query for data in the List

query.set_viewXml('<View><Query><OrderBy><FieldRef Name=\'Article Date\' Ascending=\'False\'/></OrderBy></Query>' + '<RowLimit>2</RowLimit></View>');


var items = list.getItems(query);

ctx.load(list); //Retrieves the properties of a client object from the server.
ctx.load(items);

var table = $("#tblcategories");
var innerHtml = "<table><p><h3></h3></p><tr><td></td><td><p></p><p></p></td></tr></table>";

//Execute the Query Asynchronously
ctx.executeQueryAsync(
Function.createDelegate(this, function () {
var itemInfo = '';
var enumerator = items.getEnumerator();
while (enumerator.moveNext()) {
var currentListItem = enumerator.get_current();
innerHtml += "<table><p><h3>" + currentListItem.get_item('Article Title') + "</h3></p><tr><td><img src='" + currentListItem.get_item('Article Thumbnail').$2_1 + "'/></td><td><p> " + currentListItem.get_item('Article Body') + "</p><p> Posted In: <a href = '" + currentListItem.get_item('Article Categories').$2_1 + "'>" + currentListItem.get_item('Article Categories').$3_1 + "</a></p></td></tr></table>";
}
table.html(innerHtml);
}),
Function.createDelegate(this, fail)
);


}






SharePoint 2013 - Prevent Site Pages or Publishig Pages from showing in Search Results



With SharePoint 2013, is there a way to tell SharePoint that I have specific site pages or specific publishing pages that I do not want to show on search result pages? Where would the settings for this be?


I'm using the search box snippet and search content snippet for this project.


Thanks






SharePoint 2013 - Getting the best out of "Content Search" Snippet



I'm basically trying to build a search and search results page.


OOTB with SharePoint 2013...




  • I went to design manager to grab a snippet called "Content Search" which is under Dynamic Content from the ribbon.




  • I took this snippet, created a custom query, and placed it within my custom page layout and published this page.




  • I created a publishing page and successfully assigned my search-page-layout to

    this new page. I can now see my search result page. But it has no data displaying...




Where can I find a SharePoint snippet that is a search input box, that will go on my custom page layout, and when use it, it will communicate with my new search result page?


Thanks!






Search web part styling



I located a bunch of web parts in a page all of them consisting with titles and borders (Chrome Type) – this is how the customer wants this page to look like. When I add a search box web part it causes all other web part’s borders to disappear.


Does anyone to know how this behavior can be fixed? I want to apply the simplest solution hoping not to mess with the page css to much.






Could not load assembly in SharePoint foundation



I am using following code to perform generic delete by name of entity and key id.


I have used this code in SharePoint 2010 and worked fine, but not working on SharePoint Foundation 2013.


This solution is developed and tested on standalone SharePoint 2013 server but never had issue like this. Project upgrade to 2013 was successful in Visual studio 2013 and works without any issue. I had these kind of errors before because of Sandbox assembly somehow get hooked in VS project but you can delete in post build events and it works fine


I have looked everywhere but this dll has no referrence, SharePoint Foundation 2013 is installed on "Windows Server 2012 r2" with SP1 and Dec 2013 CUs.


Any help will be much appreciated...


using (var ctx = new ProjectNameObjects()) { var name = typeof(T).Name; var container = ctx.MetadataWorkspace.GetEntityContainer(ctx.DefaultContainerName, DataSpace.CSpace); string entitySetName = (from meta in container.BaseEntitySets where meta.ElementType.Name == name select meta.Name).First();



Object entity = null;
IEnumerable<KeyValuePair<string, object>> entityKeyValues = new KeyValuePair<string, object>[] {


new KeyValuePair(idFieldName, entityId) };



var key = new EntityKey(string.Format("ProjectNameObjects.{0}", entitySetName), entityKeyValues);

if (ctx.TryGetObjectByKey(key, out entity))
{
ctx.DeleteObject(entity);
ctx.SaveChanges();
return true;
}


}


Loader Exception: System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module) at System.Reflection.RuntimeModule.GetTypes() at System.Reflection.Assembly.GetTypes() at System.Data.Metadata.Edm.ObjectItemConventionAssemblyLoader.LoadTypesFromAssembly() at System.Data.Metadata.Edm.ObjectItemAssemblyLoader.Load() at System.Data.Metadata.Edm.AssemblyCache.LoadAssembly(Assembly assembly, Boolean loadReferencedAssemblies, KnownAssembliesSet knownAssemblies, EdmItemCollection edmItemCollection, Action1 logLoadMessage, Object& loaderCookie, Dictionary2& typesInLoading, List1& errors) at System.Data.Metadata.Edm.ObjectItemCollection.LoadAssemblyFromCache(ObjectItemCollection objectItemCollection, Assembly assembly, Boolean loadReferencedAssemblies, EdmItemCollection edmItemCollection, Action1 logLoadMessage) at System.Data.Metadata.Edm.ObjectItemCollection.ImplicitLoadAllReferencedAssemblies(Assembly assembly, EdmItemCollection edmItemCollection) at System.Data.Metadata.Edm.MetadataWorkspace.ImplicitLoadAssemblyForType(Type type, Assembly callingAssembly) at System.Data.Metadata.Edm.MetadataWorkspace.ImplicitLoadFromEntityType(EntityType type, Assembly callingAssembly) at System.Data.Objects.ObjectContext.TryGetObjectByKey(EntityKey key, Object& value) at ProjectName.UI.Phase2.Common.DAL.Delete[T](Object entityId, String idFieldName, String msgPrefix, ProjectNameLabel lbl) Could not load file or assembly 'Microsoft.Office.Server.UserProfiles.Synchronization, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies.






Picture Library failed to load



since i added those three lines to Masterpage



<sharepoint:scriptlink name="MicrosoftAjax.js" runat="server" defer="False" localizable="false" />
<sharepoint:scriptlink name="SP.core.js" runat="server" defer="False" localizable="false" />
<sharepoint:scriptlink name="SP.js" runat="server" defer="True" localizable="false" />


all Javascript works well but when i try to open a Picture Library i got weird errors


http://1drv.ms/1wJPNEI






Fixing SharePoint 2013 Foundation performance issues



Can any one can give the permanent solution for slow performance of Sharepoint 2013 foundation server? My server has 32 GB RAM. If I enter the data to list, I got the server unable to save this time error. I am always restarting the search host controller service to solve this problem.


Please any one can tell me the permanent solution.






How do I rewrite the domain in Sharepoint 2010 when "www" is missing in the request path?



I need http://ift.tt/1HtCh3y to be redirected to http://ift.tt/1yNowCc (adding the "www"). For some reason it always redirects to http://ift.tt/1HtChjZ. I have the following rewrite rule in my web.config:



<rule name="Vanity URL" stopProcessing="true">
<match url=".*" />
<conditions>
<add input="{HTTP_HOST}" pattern="example.com" />
<add input="{URL}" pattern="^photogallery$" />
</conditions>
<action type="Redirect" url="http://ift.tt/1yNowCc" appendQueryString="false" redirectType="Found" />
</rule>


I've also tried putting the URL match outside of the conditions:



<rule name="Vanity URL" stopProcessing="true">
<match url="^photogallery$" />
<conditions>
<add input="{HTTP_HOST}" pattern="example.com" />
</conditions>
<action type="Redirect" url="http://ift.tt/1yNowCc" appendQueryString="false" redirectType="Found" />
</rule>


I've also tried a million permutations of regexes, but I feel like there is some default Sharepoint routing to the main default.aspx page that is overriding all of my efforts. Can anyone help?






PWA Project Site List Web Part Closed And Re-added - Datasheet View Disabled



On our PWA instance, we have a master template which defines the SharePoint Project Site layouts. On this template, we have a list web part, which is editable in Datasheet View.


On a particular project, a user closed the list web part. After re-adding it, Datasheet View is disabled. The tooltip reads - "This control is currently disabled. You might not have the right permission level to use this, you might need to select an object or item, or the control might not work in this context."


I've ensured that List Settings -> Advanced Settings -> "Allow items in this list to be edited using the datasheet" is enabled, and tried toggling it off and back on to no effect. I've also verified that I have permissions to edit the list - I'm logged in as admin.


I'm using IE9 and able to access Datasheet View on other projects (where the list web part wasn't closed) in the same IE instance, so it's not browser settings.






Mac OS X Yosemite Microsoft Office 2011 Document Connection App fails to connect to SharePoint 2013



Using a Mac OS X Yosemite 10.10.1 and Microsoft Office for Mac 2011 14.4.7 connection to SharePoint 2013 build 15.0.4667.1000 utilizing the "Document Connection" app that comes with Office 2011 shows error, "The connection failed." Cannot check documents in our out nor save them.


Document Connection does not prompt for credentials upon entering SharePoint URL. Also tried basic authentication under Preferences.


enter image description here






Add New Calendar item default All Day Event



Is there any way to make "All Day Event" the default for adding a new calendar item without running a script. Our environment does not allow scripts to run so I cannot use the jquery.min.js to perform that, so I needed to know if there are any other methods to set this up? Below is what I was trying to use and it didn't work so I'm assuming it was because our environment doesn't allow scripts to run. I followed the process on this link: http://ift.tt/1veNy2h I copied the jquery-2.1.1.min.js to our documents folder first then added the following script to "Edit HTML sSource" in content editor which I added to the list page for the calendar:



<script src="http://PATH/Documents/jquery-2.1.1.min.js"
type="text/javascript"></script>
<script type="text/javascript">
$(function(){$('#ctl00_ctl34_g_269284a8_768b_44ec_b1e1_43bd1b219be7_ctl00_ctl05_ctl06_ctl00_ctl00_ctl04_ctl00_ctl00_AllDayEventField').attr("checked","checked"); // checks All Day Event
//hide check-box
$('tr:has(span[title=All Day Event])').not('tr:has(tr)').hide();
});
</script>





Deploying an HTML App to Multiple Sites



I am developing an HTML app for SharePoint Online. This will be a hybrid app which will consist of an HTML page, JavaScript and CSS files, and image resources.


This app will be hosted on a page in a content editor web part - The HTML file will be linked to the content editor web part. It will use ECMAScript CSOM to communicate with SharePoint and use jQuery for performing some DOM manipulations on the page. Since I have to do DOM manipulations in the host site, I cannot opt for a SharePoint-hosted app (which runs in an iframe).


I want some opinions on how to distribute this app to multiple sites so that users can easily use it.


One option that I have thought of is to create a provider-hosted app and perform remote provisioning -



  1. Manually configure the content editor web part in any one site and export it as a DWP file.

  2. Modify the DWP file and add a token for dynamically replacing the HTML file's path per site.

  3. Iterate through each site I want to deploy to (List of sites can be stored in a configuration file).

  4. Deploy all the required resources to each site, along with the DWP file (to the web parts gallery). Before deploying the DWP file, replace the HTML file path token with the actual site URL.

  5. Users will be able to see the web part when they click "Add a Web Part" in an edited page.


But, I am thinking if there is some other way this can be achieved. Because, I can deploy the current package to 1000 sites today, through the approach mentioned above, but what if some user wants to use it in 1001th site? I will have to run the remote provisioning again and deploy the required artifacts.






My site and properties from external sources



We have an on premise SharePoint 2013 farm.


In setting up mysite, we will only retrieve username and picture from AD, all other properies for profiles we need to get from another database that is not a part of SharePoint.


We have more than 2000 users.


I am wondering how to impelement this and about what kind of things\risks I need to consider.


How will the system understand that data from a database row will be mapped to the correct user?


I have given BCS a thought, but an external list will be to large.


Please advice.






How do I put a PDF file into a Document library via web service?



I have a SharePoint 2010 environment that has a SSRS report. The user clicks a button and sees the report rendered via PDF. I would like to instead of downloading that PDF, place it into a document library. Is this possible via JavaScript and web services?






Java script how count users in group by javascript



How could I count how many users are in Group? How could I count by JavaScript.






Custom button on webpart for submitting an infopath form



I try to make a button on a webpart who submit an infopath form located in an onther webpart (InfoPath Form Web Part).


I try many tips where i find on internet, but nothing working great.






using claims from trusted identity provider



I have a site that is using Azure ACS as our trusted identity provider. All authentication goes through this STS. ACS provides my identity claim (email) and can provide others. Additionally, I understand that I could write a custom claims provider to extend my user with even more claims.


What I'm struggling with is how I can use these claims to control authorizations within my site? I do not want to directly assign a user, by email, into a SharePoint group. Instead I would like to interrogate a claim to determine group membership.






Hidden Scroll on iframe



I used iframe on my Page. I want to hiding iframe's scroll. I added scrolling=no in my code. But I can't see the entire of page, in this case.


How can I hiding scroll and I see entire of page?






Why my grid doesn't have rows when I load my werbpart?



Scenario: - Webpart with MultiView control. I have some GridView controls inside some of the Views. All these views are NOT the view showed when we load the webpart for the first time. - The idea is to translate all the ASP.Net controls in the Page_Load event.


Problems: - When I call the translation function without testing the post back, the first translation is ok, but after that the texts became blank. I understand this occurs due to the fact I changed the control text, and as the control has EnableViewState = true, the next time the page is loaded it passes the already-translated text to be translated again, and as I don't have the translation for the already translated text, it becomes blank. - If I only call the translation when it' not a postback, then the controls that are not presented in the first time (remember, they are in other Views than the first one) do not translate properly.


The solution I see right now is to create a ViewState flag to control the translation for each grid, so I can guarantee it is translated just once, but it does sound strange.


Can anybody see a different way to do this?


Please do not answer with things like "use Resources", because I can't change this translation schema, it is mandatory in this case to NOT use resources.


[EDIT]: I tried using the RowCreated event to translate the header, and it worked at first. But when I go to another View of my MultiView and come back, the headers have the original untranslated value. Still working for a way to KEEP the translation.






Sharepoint 2010 - Make assigning users easier



we are using Sharepoint 2010 and maintaining an Action Item/Issue tracker list (for a limited number of people, <10). To make assigning Action Items to users easier I want to implement to option to either click on checkboxes


[ ] Jan [ ] Chris [ ] Sara


to select to whom to assign this task or to use the Sharepoint lookup and maintain a list of users (with 2 rows, one row saying Jan and the other one containing the link to this person) tasks can be assigned to in a seperate list (better option in my opinion).


I then want to use a Workflow to map the list with names to the real "Assigned to" field shown in the Action Item entry. This is where I'm currently stuck, I tried various options but they all don't work because I cannot do String modifications.


Anyone has a solution how to implement this?


Thanks and BR Orbit.






Could not load file or assembly 'Microsoft.Office.Server' or one of its dependencies



When I click to open any custom List in SharePoint 2007 root site, I receive this error:



An error occurred during the processing of . Could not load file or assembly 'Microsoft.Office.Server' or one of its dependencies. The system cannot find the file specified.
Troubleshoot issues with Windows SharePoint Services.


Similarly, when i try to create a new List, i also get the same error. But when i browse back, I see that list successfully creates.


The assembly 'Microsoft.Office.Server' is there in GAC and in Web.config as well. I googled but i could not find any solution. Let me know if anyone know the solution of this error?






Is there a SharePoint plugin/tool like this?



I am fairly new to SharePoint. This is for a design-build construction company. Currently our design team and office staff create/update files on a network drive. Once they are ready they have to upload them to SharePoint for the field staff and external contractors. So basically they store the files in two separate locations and anytime they update one they have to copy over the other to make sure both are up to date. I am wanting to move all files to SharePoint but upper management hates the idea of changing what we currently have in place. They have always used a network drive and do not want to move away from it.


My question is, is there a tool that we can put in place that allows SharePoint to pull documents from a network location. When a change is made either on SharePoint or on the network share it is updated in both places?






SBS 2011: can't open web-based Sharepoint Designer



I'm quite a newbie with Sharepoint, so please bear with me if I can't even ask the question appropriately...


We installed SBS 2011 (Sharepoint 2010) a couple of years ago and it's running fine. We never used Sharepoint features.


Now we wanted to explore Workflow features so I went to http://sites and logged in as a Sharepoint administrator (successfully).


My problem is that whenever I need to go into the web-based Sharepoint Designer, I get an error. The designer is active on the server, it should be available at https://sites:987, but I always get Connection reset when I browse to that address.


I even tried momentarily bringing down the Server Firewall to check if it was a firewall problem, but the same thing happens...


A distinctive circumstance of this server is that it is not connected to the Internet (that's a company requirement, I can connect occasionally for updates, but not permanently). I've been told this shouldn't be a problem for what I'm trying to do.


Can you please advise, and help me troubleshoot? Thank you.






ExcuteQueryAsync functions inconvenient



Can any body explain this ?



clientContext.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed));


it always output an Error in on MSDN site sure i've something wrong it worked when i replaced with the functions like



clientContext.executeQueryAsync(function(sender,args){...},function(sender,args){...});


can anybody tell why ? and whats "createDelegate" ? and whats "this" ?






cannot see some sharepoint datafeed cuse of user right, that is wrong!



I try to see 2 list data feed with same user rights that are in same sharepoint 2010 site via browser by some url like this "http://SiteURL/_vti_bin/listdata.svc/ListName . One is ok but another ask me user and password and then can not dispaly. I think is about list size but i saw same issue for some smale lists too. I try to correct issue by delete some fileds and bingo! i could ! but i need whole site with whole fileds.I tried this via Excel 2013 powerpivot and got error 401 , via Execl 2013 PowerQuery i saw same issue . we have sharepoint 2010 Integrated with windows authentication and use ntlm please help me.






Content Search Webpart - Return Sites - Customer Template



What property filter should I use in the content search webpart to return sites created using my customer site template?


Here is what I use now which returns all subsites under current site:



path:{Site} contentclass:STS_Web Site<>{Site.URL} UrlDepth<4


I used JSOM and got the Site Title and Site Name using get_title() and get_id() function and hence I know the title and Id of my custom site template. I tried the these values in SiteTemplate, SiteTemplateId, WebId properties in the search webpart using contains and equals conditions but I do not get any results when I use this condition.


Any suggestions?






Server asks for credentails but doesn't show default.aspx



I've installed Sharepoint 2013 Server on Windows Server 2012. But I've problems login into Administration Control Panel.

I have installed development environment.

After a lot of waiting Sharepoint asks me about my login credentials but after I typed my credentials there is a page displayed saying about "unexpected error".

I've turned on "Basic authentication" and disabled other ones (I have that configuration for Sharepoint 2010 on Win 7) but it didn't help.

Thanks






Connect Visual Studio to custom Pages



I would like to connect my Visual Studio to our Sharepoint Sites and edit them. I can see connections in the server explorer, but that is all. Can not open them.


I really do want to move away from: make change on .aspx file, find it in my folder, copy it to sharepoint designer, refresh the page.


This is really annoying to develop Pages.






Can not link data to SharePoint list from Access



I'm working with Sharepoint 2013 & MS Access 2013, till yesterday, everything still good, I click on the button Open with Access, input data, share to site...

BUT TODAY, the button Open with Access has been disabled (i dont know why) so I must create a DB and connect to Sharepoint site through External Data/More/Sharepoint list. But when I input the link http://10.x.x.x/MySite/ to Specifyy a Sharepoint site: text box, i get the error message "Microsoft Access could not connect to the site you specified. Verify the address of the site or contact your site administrator". What can I do to connect to the site with MS Access again?






How to increase length of search api query text?



Length of Search api query text must be 4096 characters. Are there ways to increase query text?






What is the permanent solution for SharePoint 2013 foundation high performance? My server have the 32 GB RAM



Can any one can give the permanent solution for slow performance of sharepoint 2013 foundation server and my server have the 32 GB RAM. If i enter the data to list i got the server unable to save this time error. I am always restart the search host controller service to solve this problem. Please any one can tell me the permanent solution






JavaScript to get all sites i'm follwing?



I'm looking for a way to get all the sites I'm following by using JavaScript. What's the best way to do this?






SharePoint redirects to error.aspx when no cookie present for office addins web browser control



I am new to SharePoint and facing an issue with SharePoint claims authentication redirection.


Scenario - If I clear cache of IE browser, and login into chrome and open a word file for edit. MS Word will try opening file, but there is no cookie available of claims authentication in IE Web browser control. It will ask to provide credentials and even user providing credentials it redirects to error.aspx page. But session still establish and user can close with and continue working. But user will be prompted error window.



/_layouts/Login.aspx?ReturnUrl=/_layouts/15/error.aspx)). Parent No


But in case where cookie is available in IE browser, it redirects to Authenticate.aspx.


I am not sure what is wrong.






SharePoint Online Iterating through Document Libraries CSOM



I am trying to iterate though a document library and set each document/items whithin to inherit permissions (at the moment each doc/item is using uniquer permissions).


I am able to get the specific document library that I am interesting in, however I cannot at the moment iterate though each of the items/documents within it, but here is what I have so far:



Add-Type -Path "Libraries\Microsoft.SharePoint.Client.dll"
Add-Type -Path "Libraries\Microsoft.SharePoint.Client.Runtime.dll"
Add-Type -Path "Libraries\Microsoft.SharePoint.Linq.dll"
Add-Type -Path "Libraries\Microsoft.SharePoint.dll"

$webUrl = "http://ift.tt/1yJKrtK"
$username = "####"
$password = "####"
$securePass = ConvertTo-SecureString $password -AsPlainText -Force
$listname = "TestDoc";

$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($webUrl)
$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($username, $securePass)


$web = $ctx.Web
$lists = $web.Lists
$ctx.Load($lists)
$ctx.Load($web)
$ctx.ExecuteQuery()


write-host `n "Web Url:" `n $web.Url

foreach ($list in $lists)
{

if ($list.Title -eq "TestDoc")
{
#print list name if found
write-host `n "Found the list:" `n $list.Title `n


#attempting to iterate through items in the document library
foreach ($item2 in $list.Items)
{
#list the items/documents in the document library
write-host $item2.Title
}


}
}


It is the foreach loop I am having trouble at the moment as I am not sure how to loop though each of the items/documents in the document library.


Any suggestions on the approach I should take would be much appreciated.






Using BCS i want records from SQL Server (ex-Employee) and after that in a page i need to use a Webpart where a user can search a record .



(employee detail only from external DB) Can anybody suggest how to do or the procedure to achieve this ?






Add Custom Web Part to newly created page programmatically



I created a custom web part for SharePoint 2013 and I would like it to be added to a blank page that is created for it.


I looked it up and found out, that the I can add an Event Receiver to the Feature, so I added one, but the event receiver is never fired.


The event that I tried was the FeatureActivated and FeatureInstalled .


Do I have to set some kind of special properties for the project to make the event handlers work?


Is there any other way to create a blank sharepoint web page and add a custom web part to it programmatically?


I used this tutorial : Create a Web part page with web part






Error with Provider Hosted App on Edit Form of a list item



We have an error on the Edit Form of one of our pages.


We have developed a SharePoint Online Provider Hosted app which replaces the standard edit form of a list item and has some further events behind the save button. Since this is rather new territory for us, we're using a roundabout way of achieving this by using a script editor web part to display an iFrame of our app. That way we can pass the Url through to our app and retrieve query strings from them.


Our issue comes quite intermittently in that we sometimes get a "web page cannot be found" error or sometimes a "resource cannot be found" error, however, when we load another app on the site (from the same app project, but using an app part), then go back to the Edit Form, the information in the iFrame suddenly renders.


Any ideas on what might be causing this issue at all? Ideally, we should be rendering the app to the Edit Form is the proper manner, rather than scripting an iFrame that points to out app in Azure. Would this be the cause of the problem?


Thanks






How to reverse GrantAccessToProcessIdentity("Domain/User")?



In our SP2013 on-premise farm, we have two web applications. One for standard team sites and one for MySiteHost. These 2 web application are running under two different IIS app pool with two different identity.


Users followed some sites. The users can post newsfeed directly from their Mysite to those team site's newsfeed. However, they encountered error. After investigation, (refer to this site) I ran follow scripts:



$wa= Get-SPWebApplication $WebApp_MySite
$wa.GrantAccessToProcessIdentity($ID_WebApp)
$wa= Get-SPWebApplication $WebApp
$wa.GrantAccessToProcessIdentity($ID_WebApp_Mysite)


It seems fix the problem. However someone told me I don't need to run last 2 lines. It grants unncessary permission to users.


My question is, how can I reverse what I have done?






RoleDefinitions.BreakInheritance 2013 CSOM API



I need to break permission level inheritance. The following works fine with the server API: SPWeb.RoleDefinitions.BreakInheritance(true, true)


Now I need to do the same with Sharepoint 2013 CSOM API. The method BreakInheritance seems not to be available for RoleDefinitions.






ImpersonationLevel setting in webservice all



I have a c# client in windows which interact with SharePoint server using WebService calls such as GetListItems. There can be multiple way to call the webservice. I am using web reference proxy class(which uses .net aspx) to call the SharePoint Webservice.


Please tell me if there is way to set the Impersonation Level before calling the webservice.


I know that when we create Service reference proxy class using WCF it has a way to set the impersonation level. We can set AllowedImpersonationLevel value to TokenImpersonationLevel.Impersonation. But I am not using WCF but I need similar functionality.


The SharePoint server is on the another domain and has custom code written and that is why impersonation is required.






Logon authentication



We have a domain in our environment name "Roofing" in which SharePoint is installed.


We are not able to login if the domain name is case sensitive. for ex: if i use the user name as:



ROOFING\Shinyj ( WITH CAPS)


i will receive the same logon page again to enter password.


But if i use the user name as: Roofing\Shinyj ( without CAPS) I works fine.


Hope you got an idea now.


This happens to all the users who have access to the Site.


Do i need to have some specific settings in my environment to have it work anyways.


Appreciate your response.


Regards, Shiny Joseph






Why does .get_title() called from an (SPOnline) App-Web return an incorrect Localized DisplayName?



Can someone please explain me where I go wrong with the code (all the way the bottom)


On the same non-english Subsite get_title() returns different results when run directly in the site compared to when run from an App.


Steps to reproduce:


Run code in a teamsite



  1. Create a non-english Locale subsite I used German in my example, its not my own language but can read it

  2. Run the script below in Chrome Snippets


This produces the results I expect, get_title() gets me the localized DisplayName



Run code from an App-web



  1. [install an (english¿) App with read rights in]

  2. Now open the App in that same subsite (now Host-web)

  3. Run the script below in Chrome Snippets the script is now accessing the subsite through the App-web


Now get_title() returns me the DisplayName as if the site was an English Locale; extracting the DisplayName from the SchemaXml clearly shows the correct DisplayName.


It looks to me like get_title() returns the Locale DisplayName of the App Web instead of the Host-Web.. (I have not tested what happens with an App which is not in english.. couldn't find one)



Test code


Code to be run as Chrome Snippets (or any way you want it)


try-catch is used to try App code first; if it fails it defaults to the current ClientContext



var listName='Tasks';
var reportDIV=document.getElementById('DeltaPlaceHolderMain');
var listTitle='<h1>'+listName+'</h1>';
reportDIV.innerHTML=listTitle;
var context,web;
JSRequest.EnsureSetup();
try{
context = new SP.ClientContext(decodeURIComponent(JSRequest.QueryString["SPAppWebUrl"]));
var appContextSite = new SP.AppContextSite(context, decodeURIComponent(JSRequest.QueryString["SPHostUrl"]));
web = appContextSite.get_web();
} catch(e){
context = new SP.ClientContext.get_current();
web=context.get_web();
}
listTitle+='<h2>context.get_url() = '+context.get_url()+'</h2>';
var fields=web.get_lists().getByTitle( listName ).get_fields();
context.load(fields);
context.executeQueryAsync(
function(){
var fieldEnumerator = fields.getEnumerator();
var rows=0,table='<tr><td><b>get_internalName()</b></td><td><b>get_title()</b></td><td><b>DisplayName from get_schemaXml()</b></td></tr>';
while (fieldEnumerator.moveNext()) {
var field=fieldEnumerator.get_current();
var DisplayName = field.get_schemaXml().split('DisplayName="')[1].split('"')[0];
var Title=field.get_title();
Title = DisplayName!=Title ? '<b style="color:red">'+Title+'</b>' : Title;
var cols = []; cols.push( field.get_internalName() , Title , DisplayName );
table+='<tr style="background-color:#E0E7F'+(rows++%2?1:10)+'"><td>'+cols.join('</td><td>')+'</td></tr>';
}
reportDIV.innerHTML=listTitle+'<table width=100%>'+table+'</table>';
}
,
function( sender,args){ alert(args.get_message())}
);





No Apps Currently available, office for apps using Azure Web Site and office 365



I am trying to deploy and use an app for office. I created a simple Apps for Office project in Visual Studio 2013 and I deployed the web project to an Azure Web Site.


I changed the SourceLocation of the Manifest file to point to https://myAzureWebSite/app/home/home.html and I followed this article to deploy the app project to the Apps for Office list in my App Catalog site collection which I created it in my Developer tenant in Office 365. http://ift.tt/1yJ9Eoj.


I have trusted my app catalog by going to Excel -> File -> Options -> Trust Center -> Trust Center Settings -> add url of the app catalog site collection and clicked ok.


I have reopened the excel file and go to Insert -> My apps -> My Organization but it shows No Apps currently available






jeudi 29 janvier 2015

List Field Iterator Create New Item by Code



I have a web part and I dynamically add a List field iterator to it:



//contentType is the content type ID

SPList list = web.Lists[listName];

SPContentType spct = web.AvailableContentTypes[contentTypeName];
Iterator = new ListFieldIterator()
{
ControlMode = SPControlMode.Display,
TemplateName = spct.NewFormTemplateName,
ListId = list.ID
};
Iterator.ListItem["ContentTypeId"] = contentType;
Iterator.EnableViewState = true;

var currentMode = SPControlMode.New;
Iterator.ControlMode = currentMode;
PlaceHolder p1 = (PlaceHolder)this.FindControl("PlaceHolder1");
p1.Controls.Add(Iterator);


I have 2 questions:




  1. How I can hide the buttons that appear with the list field iterator?




  2. I want to add a method that create the item (Library list item with attachment) by code, by reading the item of list field iterator and create it, how I can do it?








add permission on list items userwise by using CSOM/Javascript sharepoint 2013 [on hold]



i am adding permission on list items userwise by using CSOM/Javascript sharepoint 2013 can anybody have idea how to do this?






Query String (URL) Filter for Search Result?



How to activate a Query String (URL) Filter for Search Result?






whats the best approach to copy andn sync lists - sharepoint 2013



I Have a list A and would create List B. I would like to copy List A to List B and then keep it synced.


Any ideas?


Thanks in Advance






What happens if I check "Require Content Approval" as "Yes" and then I create a "Publishing Approval" workflow on it?



I checked the option "Require Content approval " in list setting and then I created a "Publishing Approval " workflow for adding a item in list . But I was not able to see the added item in approver's list until the creator approves the item.






InfoPath customize action when button is clicked



In an InfoPath 2013 form that accesses a custom list, I would like to add functionality to the form. When a user clicks on a button, checkbox, and/or some other item, I would like to change a 'status' value in the workflow. Basically when the item is clicked, I would like to start that part of the workflow.


Thus can you tell me if I can place a button in the 'Ribbon' that is auto generated by InfoPath and/or if I can place a button somewhere else on the form?


If so can you tell me the following when the user clicks the button and that starts the workflow?




  1. Can I place the button on the ribbon? (Can you let me know if this option is possible and how to accomplish this goal?)




  2. Can I place the button just somewhere on the form?




  3. Can I place the button in the ribbon and somewhere on the form?




Of the option you chose, can you tell me how to accomplish that goal?






Programmatically create site collection self service site creation



Good Day,


I'm sitting with the following issue. I'm creating a site collection programmatically... all was working fine on my dev server, until I deployed to test server. When I run the code on the test server the code fails with an unauthorized(Access Denied) exception. After some investigation it turned out that the app pool account for the SharePoint Site did not have sufficient permissions on the contentDB to create site collections. One solution I found was to make the SharePoint site web application pool account the same as central admin. Lo and behold, this resolved my problem. The site collection was being created. BUT, because this is a major security risk (having the same accounts for both web apps) I started looking for another solution. So I found this post: http://ift.tt/1BwZMAb


This is to enable self service site creation on the web application for a specific user I.E the SharePoint site app pool account. Note, at this stage I reverted the app pool account to original account so the accounts are now different again.


I followed the steps in the blog by disabling "use self service" for all users and creating permission policy. Setting the permissions for the user policy, adding a user to the security and setting the permissions to use the new Permission policy. So theoretically this should work for the app pool account.


I'm running my code with elevated privileges. Note this is after I enabled self service site creation. Code below



using (SPSite newSpCollection = rootSite.SelfServiceCreateSite("sites/" + SiteUrl, SiteName, SiteDescription,1033,"COMMUNITY#0",userLoginName,userName,userEmail,null, null, null)){ //do stuff here}





How to create read only list view in SharePoint 2010?



Is it possible to create read only view for list?


The people having edit access also should not be able to edit any record in this view.


Please advise.






How to send reminder by using list item created user?



I need to send mail if created item in list past three from "created" field and "Process status" field is equal to Pending.


enter image description here


Instead of mention the date i want mention this formula "created <= now-3" but i cant add this workflow designer. Kindly help me this question and give any other method do this.






What is wrong with the following Caml query



I have the following table with columns:



Editor | _UIVersionString | Title | LookupNumber | Author
a | b | Title1| 100;800 | admin


I use the following query caml



<Or>
<Or>
<Contains>
<FieldRef Name="Editor"/>
<Value Type="Text">a</Value>
</Contains>

<Contains>
<FieldRef Name="_UIVersionString"/>
<Value Type="Text">a</Value>
</Contains>

</Or>

<Or>
<Or>
<Contains>
<FieldRef Name="Title"/>
<Value Type="Text">a</Value>
</Contains>
<Contains>
<FieldRef Name="Lookup" />
<Value Type="Lookup">a</Value>
</Contains>
</Or>

<Or>
<Contains>
<FieldRef Name="LookupNumber" />
<Value Type="Text">a</Value>
</Contains>
<Contains><FieldRef Name="Author"/>
<Value Type="Text">a</Value>
</Contains>
</Or>

</Or>
</Or>


But this always throws an error! Why???????






Cannot Copy and Paste in SharePoint 2007 datasheet view



I currently have office 2013 and I have been copy and pasting into a datasheet view list for SharePoint 2007 for a long time. All of a sudden I cannot paste any values into my list. the load wheel will show up for a brief moment but nothing happens. I am currently using a surface tablet and using IE 11. I can however paste my values from excel onto notepad and then onto the SharePoint 2007 list. The file I am copying from is an XlSX extension.






How to set a default calculated date 36 hrs from "Now", Excluding Weekdays



I can set the default to =Today+(36/24) but it calculates from 12am. I want it to calculate from the current time, so 36 hrs from Noon or after would be 2 dates ahead. Ideally, I would also like to calculate only weekdays.






How do I get and sort child items using rest api?



I have an asset library with managed content types, but for some reason I'm unable to get the managed content fields when I drill down to the Child level. At the moment, I'm only able to file names using 'this.name'. Anything else returns undefined.


How do I get the file names, associated descriptions, and return the data sorted with a hyperlink for each item?


//gumdropsgc.sharepoint.com/sites/Training/_api/web/lists/getbytitle('Modules')/files //gumdropsgc.sharepoint.com/sites/Training/_api/web/lists/getbytitle('Modules')/files('sizksoufas-aslj')/Children


$.ajax({ url: "https:http://ift.tt/1HmxSPU", type: "GET", headers: {"Accept": "application/json;odata=verbose"}, cache:false, success: function(data){ console.log(data); var html = ""; $(data.d.results).each(function(){ html = html + "" + this.Task_Description + "" ; }); html += ""; $("#listResult").html(html) } });

<div id="listResult"></div> </code>





Sync Two SharePoint Lists



I have one list, call it List A, and I want to create a new list, List B, that has all the same fields as List A with some additions. List B will be edited at a later time, but I want it to be updated every time a new item is created/edited in List A. What is the best way that I can synchronize two separate lists in SharePoint?






Generate automatically SSRS reports via SharePoint Workflow



I have developed SSRS reports (.rdl) and I want when a user subscribes to a report, this one will be generated by a workflow periodically, how can i do that on sharepoint 2010 ?






Editing users permissions so that users can edit listed items but not the sites look



im creating a sharepoint network for a big concern. What i want to do is simply give the users full permission when it comes to adding and editing documents. BUT, i do not want them to be able to edit the site itself. The problem seems to be that when editing the specific permissions the option that gives users permission to edit documents also includes editing the site. So my question is simply, is there a way to split theese or can i find a way around this?


Help would be appreciated.


EDIT: PROBLEM HAS BEEN SOLOVED






Link to the uploaded document in RichTextHtmlField is not generated if custom document upload form is used



I have a RichTextHtmlField in a page. The user who is entering data need to upload the document for reference. I want to change the selected option of Destination Library in the form. To do so, I have copied entire content of Upload.aspx page and created a custom action to launch the custom upload form. When I click on the custom action button I am getting the exact ouput which I want but after the upload operation completes I am not getting the link generated in the field area, as SharePoint OOTB upload form does.


My custom action contains following code:



<CustomAction Id="Ribbon.PublishTab.Publishing.Actions.UploadDocumentButton" Location="CommandUI.Ribbon">
<CommandUIExtension>
<CommandUIDefinitions>
<CommandUIDefinition Location="Ribbon.EditingTools.CPInsert.Links.Controls._children" >
<Button Id="Ribbon.PublishTab.Publishing.UploadDocumentButton1" Command="UploadDocumentButton1"
Image16by16="/_layouts/15/Solution/Images/Approval_16_by_16.jpg"
Image32by32="/_layouts/15/Solution/Images/Approval_32_by_32.jpg"
LabelText="Upload File" TemplateAlias="o1" Sequence="1000" />
</CommandUIDefinition>
</CommandUIDefinitions>
<CommandUIHandlers>
<CommandUIHandler Command="UploadDocumentButton1" CommandAction="javascript:function test(){

var url = _spPageContextInfo.webAbsoluteUrl + '/_layouts/15/DiscussionBoardEventReceiver/Pages/UploadFile.aspx?UseDivDialog=true&amp;LCID=1033&amp;Source=' + _spPageContextInfo.serverRequestPath +'&amp;AssetPageFolder=true&amp;seed=0.10343389471709208';
var options = {url: url};
SP.UI.ModalDialog.showModalDialog(options);

} test();">
</CommandUIHandler>
</CommandUIHandlers>
</CommandUIExtension>
</CustomAction>


The page UploadFile.aspx the exact code which is found in Upload.aspx in \_layouts folder.


The file is uploaded successfully but the link is not getting generated. What am I missing?






Hide field in Add/Edit/Display Form



I need to hide some fields in a Add/Edit/Display Form. I believe this can be done via some HTML in the form? I have only done this once and cannot remember how I did it last time. I am currently editing the form in SP designer.






Get File Url from a Lookup Column REST API



I have a lookup column that correlates to a background image in my presentation layer. Is it possible to expose the URL to the actual file via the $expand mechanism using REST?


Example REST URI



http://ift.tt/1D36Oi5


If I do a separate REST call to the actual Document Image list there are a couple properties that look useful, the most useful being ServerRelativeUrl. But I get an invalid request error trying to $expand on this property. See below.



The query to field 'Document_x0020_Image/ServerRelativeUrl' is not valid.


I'd very much appreciate any help with this issue. Thanks.






Add user to a new list item



I would like to add to a list a new item with a User or Group field. The code is this:



ListItemCreationInformation listItemCreationInformation = new ListItemCreationInformation();

ListItem item = list.AddItem(listItemCreationInformation);


User u = context.Web.EnsureUser("Name Surname");

item["MyUserField"] = u;
item.Update();


Do you know what's wrong or what I should do?






Impersonation Step that's dependent on an IF condition



I'm writing a workflow for a dispatch process in a warehouse. The item goes through several stages before it can be closed, and at each stage, the item must be edited by different groups.


I'm thinking the best way to do this is using impersonation steps, changing the permissions at each of the stages of the process to give appropriate access to the relevant group, and preventing certain people from editing the item.


My question is, is it possible to have an IF statement prior to an impersonation step? So, for example:


IF 'document status' equals 'pending'<br> --- [Admin] has full control<br> --- [Finance] has read<br> --- [Security] has contribute


Is this possible?






hyperlink column in spservices



I am trying to get hyperlink type of column named as "Important Link". withoutvar liHtml5="



  • " + ($(this).attr("ows_Important_x0020_Link")).split(", ")[0]+"

  • "; other code works perfect. Please help. My SPservice code is as below:


$().SPServices({



operation: "GetListItems",
async: false,
listName: "URL_List",
CAMLQuery: "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='text'>"+ URL+ "</Value></Eq></Where></Query>",
CAMLViewFields: "<ViewFields><FieldRef Name='Title'/></ViewFields>",
completefunc: function (xData, Status)
{
var itemCount = $(xData.responseXML).SPFilterNode("rs:data").attr("ItemCount");
alert(itemCount);
if(itemCount == 0)
{
//check if URL contains slash
var SlashTesing=URL.indexOf("/") != -1;
alert(SlashTesing);

if(SlashTesing== true)
{
NewURL=URL.substring(0,URL.lastIndexOf("/"));
gofunction(NewURL);
}
else
{
var liHtml2="<h2>"+"Sorry...we dont have this info "+"</h2>";
$("#tasksUL").append(liHtml2);
}
}
else
{
$(xData.responseXML).SPFilterNode("z:row").each(function()
{
var text="<h2>"+"Showing information for this URL :"+URL+"</h2>";
var liHtml2="<li>" + $(this).attr("ows_Department") + "</h4>"+"</li>";
var liHtml3="<li>" + $(this).attr("ows_Team") + "</h4>"+"</li>";
var liHtml4="<li>" + $(this).attr("ows_PointOfContact")+ "</h4>"+"</li>";
var liHtml5="<li>" + ($(this).attr("ows_Important_x0020_Link")).split(", ")[0]+"</li>";


$("#tasksUL").append(text);
$("#tasksUL").append(liHtml2);
$("#tasksUL").append(liHtml3);
$("#tasksUL").append(liHtml4);
$("#tasksUL").append(liHtml5);

});
}
}
});





Why my grid doesn't have rows when I load my werbpart?



Scenario: - Webpart with MultiView control. I have some GridView controls inside some of the Views. All these views are NOT the view showed when we load the webpart for the first time. - The idea is to translate all the ASP.Net controls in the Page_Load event.


Problems: - When I call the translation function without testing the post back, the first translation is ok, but after that the texts became blank. I understand this occurs due to the fact I changed the control text, and as the control has EnableViewState = true, the next time the page is loaded it passes the already-translated text to be translated again, and as I don't have the translation for the already translated text, it becomes blank. - If I only call the translation when it' not a postback, then the controls that are not presented in the first time (remember, they are in other Views than the first one) do not translate properly.


The solution I see right now is to create a ViewState flag to control the translation for each grid, so I can guarantee it is translated just once, but it does sound strange.


Can anybody see a different way to do this?


Please do not answer with things like "use Resources", because I can't change this translation schema, it is mandatory in this case to NOT use resources. through a translation function, only when it's no






Sharepoint 2013 and ajax problem



I used that Ajax branding technique to load list items or any document library item into my design in Sharepoint 2010 now im working on 2013 and with the same technique i got failure



$.ajax({
url: '~/Lists/listname/AllItems.aspx',
data:{id:"#divId"},
dataType: "html"
success: function(data){
console.log($(data).find('table[summary="Awr Latest"]'));
}

});


in 2010 i got response with the table of content that i need now im getting a response with the masterpage and the content div but no table in it


any ideas ?






Tagging a .zip file with Document Library Columns



I have a Document Library for which a documentType column is defined. When I upload any file except for .zip files, I have the opportunity to enter values into the documentType column, thus classifying my document. This is not the case with .zip files, only the Name(filename) column is displayed. Same behavior if I choose the Edit Properties option from the document/file menu. Is there any reason why library metadata columns are disabled for .zip files? How can I tag these columns for .zip files? Thanks.






Sharepoint recover / restore deleted list views



Just wondering if it is possible to recover or restore list views that have been deleted. i have a sharepoint list which has several list views. one of these list views was connected to an excel document. this list view was accidentally deleted and this now directly affects the excel document it had a data connection to. is there any way i can get this list view back i looked in the recycle bin but its not there.


Just to clarify nothing on the list was deleted just one of the views






Query String (URL) Filter for Search Result?



How to activate a Query String (URL) Filter for Search Result?






How to add ads in SharePoint hosted app?



How can we add ads (eg Google adsense) to SharePoint hosted app ?






Additional Metatdata and project sites



I have been asked to complete the following and im a little unsure if it can be done and how.


A number of team sites would like to display a list of project sites which they are currently working on. The project sites would need to be assigned to departments as multiple deparatments can work on a single project.


I am aware you cannot add additonal metadata to a site but is there any other way other than creating a list and referecing it?


Thanks,






XSL how to add a field to View



In Discussion Board Subject View I want to add one field. How could I add this in Sharepoint Designer. I have got this code from Sharepoint designer Subject View:



<WebPartPages:XsltListViewWebPart runat="server" ViewFlag="" ViewSelectorFetchAsync="False" InplaceSearchEnabled="True" ServerRender="False" ClientRender="True" InitialAsyncDataFetch="False" WebId="00000000-0000-0000-0000-000000000000" IsClientRender="False" GhostedXslLink="thread.xsl" NoDefaultStyle="" ViewGuid="{48EFF361-7793-4174-81E4-1F3F0ABD8430}" EnableOriginalValue="False" DisplayName="Subject" ViewContentTypeId="" Default="TRUE" ListUrl="" ListDisplayName="" ListName="{89E1B0A9-AD77-4374-A960-327A6F6627A6}" ListId="89e1b0a9-ad77-4374-a960-327a6f6627a6" PageType="PAGE_DEFAULTVIEW" PageSize="-1" UseSQLDataSourcePaging="True" DataSourceID="" ShowWithSampleData="False" AsyncRefresh="False" ManualRefresh="False" AutoRefresh="False" AutoRefreshInterval="60" Title="Discussions List" FrameType="Default" SuppressWebPartChrome="False" Description="Use the Discussion list to hold forum-style conversations, including question and answer, on topics relevant to your team, project, or community." IsIncluded="True" ZoneID="Main" PartOrder="2" FrameState="Normal" AllowRemove="True" AllowZoneChange="True" AllowMinimize="True" AllowConnect="True" AllowEdit="True" AllowHide="True" IsVisible="True" TitleUrl="/piony/PRO/prolog/Lists/Dyskusja spolecznosci" DetailLink="/piony/PRO/prolog/Lists/Dyskusja spolecznosci" HelpLink="" HelpMode="Modeless" Dir="Default" PartImageSmall="" MissingAssembly="Cannot import this Web Part." PartImageLarge="" IsIncludedFilter="" ExportControlledProperties="False" ConnectionID="00000000-0000-0000-0000-000000000000" ID="g_48eff361_7793_4174_81e4_1f3f0abd8430" __MarkupType="vsattributemarkup" __WebPartId="{48EFF361-7793-4174-81E4-1F3F0ABD8430}" __AllowXSLTEditing="true" __designer:CustomXsl="fldtypes_Ratings.xsl" WebPart="true" Height="" Width=""><ParameterBindings>


1900-01-01T00:00:00Z20sp.ui.discussions.js|sp.ui.communities.js|sp.ui.communities.jsthread.xsl


Which field should I edit ?






How to access Thumbnails in XSLT from Picture Library



Can anyone help me? I would like to display the thumbnails from my picture library in my XSLT template I'm making. Here is the template so far.



<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>
<figure>
<figcaption>
<h3><xsl:value-of select="@Title" disable-output-escaping="yes" /></h3>
<span><xsl:value-of select="@Description" disable-output-escaping="yes" /></span>
<span><xsl:value-of select="@ImageCreateDate" disable-output-escaping="yes" /></span>
<span><xsl:value-of select="$GetThumbnail" /></span>
<a href="#" data-lightbox="photo-gallery" title="View Image"></a>
</figcaption>
</figure>
</xsl:template>


Where and what code could I use to access the thumbnails? Many thanks






How to display list items store in different Web Application without REST?



I have an one intranet site, and one public site. These have different web application. I want to display Tasks list and also insert items in intranet site into public site.


I try to add XsltListViewWebPart into page of public site, but this just worked for displaying list store the same Site Colletion. The best way I know is used REST service and get data from Tasks list and display it into public site. But the cons of this way is not having the button New Item of the task, and we need to fill Task Items into Grid view to display it.


I want this Tasks List can work good in XsltListViewWebPart but I can't. So, please help if you have any ideas or the best solution about this problem?






After retracting a solution the Sharepoint 2010 farm displays error



"The DataSourceID of 'TopNavigationMenuV4' must be the ID of a control of type IHierarchicalDataSource. A control with ID 'topSiteMap' could not be found."






Creating files in Document library in SharePoint 2010 using Powershell



I am using below script to copy files from one library to another:



$SourceWebURL = "http://sitecollection/sites/site"
$SourceLibraryTitle = "doclib"
$DestinationWebURL = "http://sitecollection/sites/site"
$DestinationLibraryTitle = "doclib"
$ssite = Get-SPSite $SourceWebURL
$sweb = $ssite.OpenWeb("subsite")
$dsite = Get-SPSite $DestinationWebURL
$dweb = $dsite.OpenWeb("Archivesubsite")
$sList = $sWeb.Lists | ? {$_.Title -eq $SourceLibraryTitle}
$dList = $dWeb.Lists | ? {$_.title -like $DestinationLibraryTitle}
$AllFolders = $sList.Folders
$RootFolder = $sList.RootFolder
$RootItems = $RootFolder.files

foreach($Folder in $AllFolders)
{
echo $Folder.url
foreach($Item in $Folder)
{
$sBytes = $RootItem.OpenBinary()
$dFile = $dList.RootFolder.Files.Add($Item.Name, $sBytes, $true)
$dFile.Update()
}
}


I want to loop in each folder in doclib and create the files in folders in destination library. Error I am getting is : You cannot called a method on null valued expression.






Difference between Assembly Deployment Target set to "GlobalAssemblyCache" or "WebApplication"



When I view the properties for my SharePoint 2010 project I can see an option of Assembly Deployment Target which can be set to either GlobalAssemblyCache or WebApplication.




  1. From this question I was able to figure out that setting value to GlobalAssemblyCache deploys DLL to C:\Windows\assembly. For WebApplication, it says that it will deploy to website/bin. What is the exact path where the WebApplication option deploys the solution?




  2. From this question it seems that custom fields cannot be deployed with option of WebApplication. They can only be deployed to GlobalAssemblyCache. Are there any other restrictions when deploying to WebApplication?




  3. While developing SP solutions which option should be preferred and why?








mercredi 28 janvier 2015

Credential in SharePoint Site while opening each document



Once I log in using the credentials in sharepoint I need to do this for each document I try to open.


So click on a link to some document in SharePoint, input the credentials and it works fine but if I then try to open another document the same Windows Security window pops up.

I enter the credentials again the document opens but if I open another........................etc etc you get the picture I think.


I would like to know how can i get out of it without using the credential again and again.


Appreciate your response at the earliest.


Thanks


Regards, Shiny Joseph






SharePoint 2013 - Consuming external web service



I am trying to create a SSO to connect to an External App in our Extranet platform. I've a custom web service, and with mail address I can get a token. By using a simple console application or ASP web site, I can generate the token, but inside SharePoint, this is not working as expected.


I have a simple WSDL, and by clicking on a link/button, I want to obtain the token. What can I use in order to do that?


I have test webpart (asynchronous is not working), a custom .ashx code calling the web service but without success.


Any help would be appreciate!






Access denied while calling external URL ajax call



I got the access denied error when i am calling external URL from Ajax call. it is working fine without SharePoint 2010.



<script>
function httpGet(theUrl) {
debugger;
var xmlHttp = null;
xmlHttp = new XMLHttpRequest();
xmlHttp.open("GET","http://ip.jsontest.com/", false);
xmlHttp.send(null);
alert(xmlHttp.responseText);
var obj = JSON.parse(xmlHttp.responseText);
alert(obj.ip);
return xmlHttp.responseText;
}
</script>


Please help me to resolve this.






Is there a way to schedule Javascript on Sharepoint online environment



Is there any way to schedule a javascript for Sharepoint site? Actually we are using Sharepoint Online environment and are not allowed to deploy any custom code on the site. hence cannot use Timer jobs/workflows.


Please provide any suggestions on how we can schedule the Javascript for Office 365(Sharepoint Online) site.


Thank You






how to retrieve the document from sharepoint document library



Here i copied my code and output. i uploaded documents in SharePoint document library but i can't retrieve the document from the SP document library .



using Microsoft.SharePoint.Client;
using System;
using System.Collections.Generic;
using System.System. Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Net;
using Microsoft.SharePoint;

using Microsoft.IdentityModel.S2S.Tokens;
using ClientOM = Microsoft.SharePoint.Client;
using System.Text;


namespace candidate_profileWeb
{
public partial class Default : System.Web.UI.Page
{


SharePointContextToken contextToken;
string accessToken;
Uri sharepointUrl;
protected void Page_Load(object sender, EventArgs e)
{

string contextTokenString = TokenHelper.GetContextTokenFromRequest(Request);
if (contextTokenString != null)
{
contextToken =
TokenHelper.ReadAndValidateContextToken(contextTokenString, Request.Url.Authority);
sharepointUrl = new Uri(Request.QueryString["SPHostUrl"]);
accessToken =
TokenHelper.GetAccessToken(contextToken, sharepointUrl.Authority).AccessToken;


Submit.CommandArgument = accessToken;
retrive.CommandArgument = accessToken;

}
if (IsPostBack)
{
sharepointUrl = new Uri(Request.QueryString["SPHostUrl"]);
}

//Execute a request to add a list that has the user-supplied name.
}


protected void Submit_Click(object sender, EventArgs e)
{
var accesssToken = ((Button)sender).CommandArgument;

if (IsPostBack)
{
sharepointUrl = new Uri(Request.QueryString["SPHostUrl"]);
}

//Execute a request to add a list that has the user-supplied name.
ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(sharepointUrl.ToString(), accesssToken);
Web web = clientContext.Web;
ListCollection lists = web.Lists;
List List = clientContext.Web.Lists.GetByTitle("Candidate profile");
clientContext.Load(List);

DateTime dt = DateTime.Today;

ListItemCreationInformation listCreationInformation = new ListItemCreationInformation();

List documentsList = clientContext.Web.Lists.GetByTitle("Candidate profile");

var fileCreationInformation = new FileCreationInformation();
byte[] documentstream = System.IO.File.ReadAllBytes(browse.PostedFile.FileName);
fileCreationInformation.Content = documentstream;
fileCreationInformation.Url = browse.PostedFile.FileName;
fileCreationInformation.Overwrite = true;
Microsoft.SharePoint.Client.File uploadFile = documentsList.RootFolder.Files.Add(
fileCreationInformation);



uploadFile.ListItemAllFields["cname"] = cname.Text;
uploadFile.ListItemAllFields["qualification"] = qualification.Text;
uploadFile.ListItemAllFields["gender"] = gender.Text;
uploadFile.ListItemAllFields["address"] = address.Text;
uploadFile.ListItemAllFields["posting"] = posting.Text;
uploadFile.ListItemAllFields["domain"] = domain.Text;
uploadFile.ListItemAllFields["experience"] = experience.Text;
uploadFile.ListItemAllFields["salary"] = salary.Text;



uploadFile.ListItemAllFields.Update();
clientContext.Load(documentsList);
clientContext.ExecuteQuery();


try
{
clientContext.ExecuteQuery();
}
catch (Exception j)
{
Label2.Text = j.Message;


}
}

protected void retrieve_Click(object sender, EventArgs e)
{
var accesssToken = ((Button)sender).CommandArgument;
if (IsPostBack)
{
sharepointUrl = new Uri(Request.QueryString["SPHostUrl"]);
}


ClientContext clientContext = TokenHelper.GetClientContextWithAccessToken(sharepointUrl.ToString(), accesssToken);
Web web = clientContext.Web;
ListCollection lists = web.Lists;
List List = clientContext.Web.Lists.GetByTitle("Candidate profile");
clientContext.Load(List);

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View><Query><Where><Eq>" +
"<FieldRef Name ='qualification'/> <Value Type ='Text'>" + TextBox1.Text + "</Value>" +

"</Eq></Where></Query></View>";

Microsoft.SharePoint.Client.ListItemCollection items = List.GetItems(camlQuery);
clientContext.Load(items);
try
{
clientContext.ExecuteQuery();
}
catch (Exception er)
{
Label1.Text = er.Message;
}

foreach (Microsoft.SharePoint.Client.ListItem item in items)
{



TableRow tablerow = new TableRow();
TableCell tablecell1 = new TableCell();
TableCell tablecell2 = new TableCell();
TableCell tablecell3 = new TableCell();
TableCell tablecell4 = new TableCell();
TableCell tablecell5 = new TableCell();
TableCell tablecell6 = new TableCell();
TableCell tablecell7 = new TableCell();
TableCell tablecell8 = new TableCell();
TableCell tablecell9 = new TableCell();

tablecell1.Text = item.FieldValues["cname"].ToString();
tablecell2.Text = item.FieldValues["qualification"].ToString();
tablecell3.Text = item.FieldValues["gender"].ToString();

tablecell4.Text = item.FieldValues["address"].ToString();
tablecell5.Text = item.FieldValues["posting"].ToString();
tablecell6.Text = item.FieldValues["domain"].ToString();
tablecell7.Text = item.FieldValues["experience"].ToString();
tablecell8.Text = item.FieldValues["salary"].ToString();

/*in that table118 column i want to retrive document from sharepoint document library this is my doubt please how to change this code. text file easily we are converting to string. But how to convert .doc file to string , how to show that document in text box table119*/

tablecell8.Text = item.FieldValues["resume"].ToString();




tablerow.Cells.Add(tablecell1);
tablerow.Cells.Add(tablecell2);
tablerow.Cells.Add(tablecell3);
tablerow.Cells.Add(tablecell4);
tablerow.Cells.Add(tablecell5);
tablerow.Cells.Add(tablecell6);
tablerow.Cells.Add(tablecell7);
tablerow.Cells.Add(tablecell8);
tablerow.Cells.Add(tablecell9);
ListTable.Rows.Add(tablerow);

}
}

}
}


output:


in that resume column how to retrive the document from sharepoint document library, name, qualification,domain.....and all retriving but document is not retriving. how to convert .doc file to string.






Error while creating a folder in sharepoint library using powershell



I am using below script to create a folder:



$folder = $dList.AddItem("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folder)
$folder["Title"] = "Test"
$folder.Update();


Error: Invalid item data - missing fileref






Sharepoint server 2013 slow performance



Recently upgraded from 2010 to 2013 everything works fine but the performance is very slow whenever i open sherepoint designer it take too much time to communicate with the server especially after enabling Enterprise services in central adminstration






How to retrieve value of type hyperlink from managed property in display template?



I have a site column of type HyperLink / Picture where the url for the icon is stored. I want to access this in the custom display template for search items.


Whenever I try to access the site column named ServiceIcon as described above, it retrieves null value. I have checked it using another tool whether any sort of value is being assigned to this managed property or not and it shows that correct value has been assigned to it. The following is the code:



<mso:ManagedPropertyMapping msdt:dt="string">'Title':'Title','Path':'Path','Description':'Description','EditorOWSUSER':'EditorOWSUSER','LastModifiedTime':'LastModifiedTime',
'CollapsingStatus':'CollapsingStatus','DocId':'DocId','HitHighlightedSummary':'HitHighlightedSummary','HitHighlightedProperties':'HitHighlightedProperties','FileExtension':'FileExtension',
'ViewsLifeTime':'ViewsLifeTime','ParentLink':'ParentLink','FileType':'FileType','IsContainer':'IsContainer','SecondaryFileExtension':'SecondaryFileExtension','DisplayAuthor':'DisplayAuthor','ServiceOffering':'ServiceOffering','ServiceColor':'ServiceColor','ServiceIcon':'ServiceIcon'

var pictureURL = $getItemValue(ctx, "ServiceIcon");
pictureURL.overrideValueRenderer($urlHtmlEncode);
alert("pic URL : " + pictureURL);


This alert displays null value. I have verified and the mapping with the crawled property has been done correctly. Please help.






Moving SQL Log files to a new drive



SQL log files(.LDF files) and data files are in the same drive because of which the drive is full.


I want to move the log files to a new drive.


Can someone help me with the steps on what to be done?