Find SCA in modern sites

Hello Everyone,

We all are very keen to learn new features in SharePoint online. I was going to through few which I am going to post in my upcoming articles, but meanwhile I found there is no direct link to add SCA.

You will need to familiarize yourself with SharePoint Online and below is the link to get into SCA page.

https://WebURL/sites/SiteCollectionName/_layouts/15/mngsiteadmin.aspx

Cheers and happy learning.

Open with Windows Explorer in sharepoint

Hi Friends,

 

Its a well known issue and I am writing below steps towards troubleshooting.

 

You can come across any of the below issues :

• Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server
• Internet Explorer could not open ServerName web folder. Would you like to see its default view instead?
• Your client does not support opening this list with windows explorer.  
• Access Denied

 

Now lets start investigating it:

 

1. We should first check if browser type is what? It works with 32 but IE 6,7,8,9,10. Note that it will not work with 64 bit IE.
2. Check if webclient service is on in services.msc. Its better if we restart this service.
3. We should add affected site in IE trusted sites.
4. Check if root site collection is created. If not, create one.
5. SharePoint WebDAV have clash with Windows WebDAV service, so stop windows with below steps:

Open Server Manager

• On the left side of the panel click on Roles
• Scroll down to the “Role Services” section, and click on “Remove Role Services”
• Under “web server” uncheck the box next to “WebDav Publishing”
• Choose Next, then choose Remove
• A reboot will be required

 

Above steps should resolve your issues. If you are still facing it, please post it here.

 

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location

I just came across one of my clients excel issue. When she is trying to open excel file by clicking on it, getting "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location" error. This generally happens if given site is not added as a trusted site in SharePoint central administration. Please go to the central administrations and do the steps mentioned below:

1. Open Central Web Administration
2. Click on Manage Service Applications
3. Click on Excel services Application.
4. Click on “Trusted file locations”
5. Add Trusted file
1. Address textbox write http://
2. Check Children trusted box under Trust Children
3. Check User-defined functions allowed under Allow User-Defined Functions
6. Repeat step 5 with address as https://(I would like to mention here that all their sites are secured(https))

Above steps resolved my issue successfully. Please post queries or comments, if any.

Change content type hub url on managed metadata service

Hi Friends,

Just come across a requirement of changing content type hub(CTH) url in managed metadata service(MMS). Initially we created a site collection and assigned it as a CTH site. Recently while working on some other stuff, one of the developer deleted the existing site.!!!! Big issue!!!

At the first glance we thought it must be a big issue but i wrote below powershell script to change my new site collection as CTH:


Set-SPMetadataServiceApplication -Identity "MyManagedMetadataService" -HubURI "http://spport01:5555/site/cth/"

Hurdle? I can be resolved!!!!


Post me for your responses and queries.

Create web application and site collection using powershell

Hi Folks,

Just came across a requirement of creating web application and site collections using power shell, posting it here.

Open an empty notepad file and copy paste below code segment :

Add-PsSnapin Microsoft.SharePoint.PowerShell

#My Parameters

$WebAppName = "MyWebApplication"
$WebAppHostHeader = "http://MyWebHost"
$WebAppPort = 7575
$WebAppAppPool = "AppPool_7575"

# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "MyDomain\hirwani"

$WebAppDatabaseName = "WSS_Content_7575"
$WebAppDatabaseServer = "MySQLServer\SharePoint"
$template = Get-SPWebTemplate "STS#0"


# Create a new Sharepoint WebApplication

New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount ($WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection

New-SPSite -Name "Root" -Url "http://in-mum-tfsport1:7575/" -Template $template -OwnerAlias "MyDomain\hirwani"

Save this notepad with .ps1 extension. Now execute it, you should get a new web application and site collection created.

Note : Change above parameters as per your requirement. Post here if you have any questions/suggestions.

Adding and activating solution in solution gallery

Fea days back, i came across this requirement to add solution to site solution gallery. I wrote below code segment :

ClientContext context = new ClientContext("http://in-air-eyshr2:1234/sites/ETD02");

//Activate Publishing feature
//Add wsp from file system to SP solution gallary
Folder destionationFolder = context.Web.GetFolderByServerRelativeUrl("_catalogs/solutions");
FileCreationInformation fci = new FileCreationInformation();
fci.Content = System.IO.File.ReadAllBytes("D:/WSPS/LDTest.wsp");
fci.Url = "LDTest.wsp";
fci.Overwrite = true;
Microsoft.SharePoint.Client.File fileToUpload = destionationFolder.Files.Add(fci);
context.Load(fileToUpload);
context.ExecuteQuery();

//Activate solution
DesignPackageInfo info = new DesignPackageInfo()
{
  PackageGuid = Guid.Empty,
  MajorVersion = 1,
  MinorVersion = 1,
  PackageName = "LDTest"
  };
  Console.WriteLine("Installing design package ");
  //Relative Path of Solution Uploaded in Solution Gallery
  //string fileRelativePath = "D:/WSPS/testwsp.wsp";
string fileRelativePath = "/sites/ETD02/_catalogs/solutions/LDTest.wsp";
DesignPackage.Install(context, context.Site, info, fileRelativePath);
context.ExecuteQuery();
Console.WriteLine("Applying Design Package!");
DesignPackage.Apply(context, context.Site, info);
context.ExecuteQuery();

and it gave me following output:

You can give me your suggestions or post relevant questions, if any

Learning SharePoint 2013

As SharePoint 2013 hits the floor, let's start learning it as soon as possible. To start with we need to learn it's basic structure.

It's based on .Net framework 4.5. The major changes are in the development area where Microsoft has launched App model which i am going to discuss more in my coming posts. Basic look & feel will be as below:

If we go to Site Settings:

Other major enhancements are 


Continuous Crawl: There has been a major upgrade to the crawling and indexing components in SharePoint Search. Now each and every document would be available to user instantly.

Cross-site Publishing: Cross-site publishing lets you store and maintain content in one or more authoring site collections, and display this content in one or more publishing site collections. When you change the content in an authoring site collection, those changes are now displayed on all site collections that are reusing this content.This feature helps ensure content is consistent when shared across several different areas and sites. 

SkyDrive: Users can now share documents and files from a personal SkyDrive or keep them secured for their personal use. SkyDrive files can still be indexed and located through search if they have been shared to that user.