|
Parameter
value
|
Description
|
|
GLOBAL#0
|
Global
template
|
|
STS#0
|
Team
Site
|
|
STS#1
|
Blank
Site
|
|
STS#2
|
Document
Workspace
|
|
MPS#0
|
Basic
Meeting Workspace
|
|
MPS#1
|
Blank
Meeting Workspace
|
|
MPS#2
|
Decision
Meeting Workspace
|
|
MPS#3
|
Social
Meeting Workspace
|
|
MPS#4
|
Multipage
Meeting Workspace
|
|
CENTRALADMIN#0
|
Central
Admin Site
|
|
WIKI#0
|
Wiki
Site
|
|
BLOG#0
|
Blog
|
|
SGS#0
|
Group
Work Site
|
|
TENANTADMIN#0
|
Tenant
Admin Site
|
|
ACCSRV#0
|
Access
Services Site
|
|
ACCSRV#1
|
Assets
Web Database
|
|
ACCSRV#3
|
Charitable
Contributions Web Database
|
|
ACCSRV#4
|
Contacts
Web Database
|
|
ACCSRV#6
|
Issues
Web Database
|
|
ACCSRV#5
|
Projects
Web Database
|
|
BDR#0
|
Document
Center
|
|
OFFILE#0
|
(obsolete)
Records Center
|
|
OFFILE#1
|
Records
Center
|
|
OSRV#0
|
Shared
Services Administration Site
|
|
PPSMASite#0
|
PerformancePoint
|
|
BICenterSite#0
|
Business
Intelligence Center
|
|
PWA#0
|
Project
Web App Site
|
|
PWS#0
|
Microsoft
Project Site
|
|
SPS#0
|
SharePoint
Portal Server Site
|
|
SPSPERS#0
|
SharePoint
Portal Server Personal Space
|
|
SPSMSITE#0
|
Personalization
Site
|
|
SPSTOC#0
|
Contents
area Template
|
|
SPSTOPIC#0
|
Topic
area template
|
|
SPSNEWS#0
|
News
Site
|
|
CMSPUBLISHING#0
|
Publishing
Site
|
|
BLANKINTERNET#0
|
Publishing
Site
|
|
BLANKINTERNET#1
|
Press
Releases Site
|
|
BLANKINTERNET#2
|
Publishing
Site with Workflow
|
|
SPSNHOME#0
|
News
Site
|
|
SPSSITES#0
|
Site
Directory
|
|
SPSCOMMU#0
|
Community
area template
|
|
SPSREPORTCENTER#0
|
Report
Center
|
|
SPSPORTAL#0
|
Collaboration
Portal
|
|
SRCHCEN#0
|
Enterprise
Search Center
|
|
PROFILES#0
|
Profiles
|
|
BLANKINTERNETCONT
|
Publishing
Portal
|
|
SPSMSITEHOST#0
|
My
Site Host
|
|
ENTERWIKI#0
|
Enterprise
Wiki
|
|
SRCHCENTERLITE#0
|
Basic
Search Center
|
|
SRCHCENTERLITE#1
|
Basic
Search Center
|
|
SRCHCENTERFAST#0
|
FAST
Search Center
|
|
visprus#0
|
Visio
Process Repository
|
28 March, 2013
Site Collection Codes
27 March, 2013
Cannot open the excel files in Sharepoint 2010
Its not a issue actually its just a setting that has changed may be after Migration to 2010.
Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an error
This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator
Normally what we tend to do is we will go to the administrator and ask him to add the library to the trusted location .
Not need . No setting to be made on the server it is just a Library setting which can be changed from the site itself . Until you want to use excel web services ( Please make a note of this )
Cause : By default the files are designed to open in browser . So it is checking for trusted location
Resolution :
=> Go to the Library
=> On the top click on Library and go to Library settings .
=> Under General settings you will find Advanced settings
=> Over there you will find the option which by default is set to open in Browser
=> you need to set it to Open in Client and there you go .
=> Click OK and you are done .
Hope it helps and you don't disturb the administrators :)
Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an error
This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.
To create an Excel Services Application trusted location, contact your system administrator
Normally what we tend to do is we will go to the administrator and ask him to add the library to the trusted location .
Not need . No setting to be made on the server it is just a Library setting which can be changed from the site itself . Until you want to use excel web services ( Please make a note of this )
Cause : By default the files are designed to open in browser . So it is checking for trusted location
Resolution :
=> Go to the Library
=> On the top click on Library and go to Library settings .
=> Under General settings you will find Advanced settings
=> Over there you will find the option which by default is set to open in Browser
=> you need to set it to Open in Client and there you go .
=> Click OK and you are done .
Hope it helps and you don't disturb the administrators :)
My Links missing in SharePoint 2010 after Migration
We have just Migrated to 2010 and get a lot of tickets on this issue .
In MOSS 2007, we are used to seeing a link in a drop-down box at the top right of our SharePoint sites, called My Links. At first glance, it seems that this functionality has been removed from SharePoint 2010. It’s still there but with a different name (Quick Links) .
How to retrieve the Lost my links from the 2007 site after migration to 2010 ?
Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. Sometimes people want info out of the DB not excuses.
Disclaimer : Take all the required backups before you make any changes
Courtesy - Shane Young
Ref : http://msmvps.com/blogs/shane/archive/2007/11/21/finding-my-links-in-the-database.aspx.
How do you get My Links back?
Click the Connect to Office button. This is the interface to add or remove a link to the library to the list of “My Links”, as well as to manage this list of links.
When you click Add to SharePoint Sites, this library is not only added to your own personal list of links, but it is added to all of your Office suite of applications, on the “Open” and “Save As” screens.
When you click Manage SharePoint Sites, the following screen is displayed, with a list of your whole list of links:
Where is my links on my Mysite ?
Go to your My Site and click on My Content at the top. Click Site Actions, Edit Page, and click to Add a Web Part. In the Recommended Items category of web parts, click to add the My Links web part to the page. There it is! Right click on the My Links web part title, and copy that URL to the clipboard.
If you want the My Links link to be more obvious and accessible, though? Yes, there’s a way to do that also, although it still won’t be the same as it is in SharePoint 2007. It entails adding My Links to the Personalization Site Links in the User Profile Service Application.
http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=daba3a3b%2Dc338%2D41d8%2Dbf52%2Dcd897d000cf3&ID=66&Web=dbb90e85%2Db54c%2D49f4%2D8e97%2D6d8258116ca0
In MOSS 2007, we are used to seeing a link in a drop-down box at the top right of our SharePoint sites, called My Links. At first glance, it seems that this functionality has been removed from SharePoint 2010. It’s still there but with a different name (Quick Links) .
How to retrieve the Lost my links from the 2007 site after migration to 2010 ?
Modifying a SharePoint Database is NOT SUPPORTED. Some would even argue running this select query against a database is not supported. Sometimes people want info out of the DB not excuses.
Disclaimer : Take all the required backups before you make any changes
- So the first thing you need to do is figure out what profile database you need information out of. To do that you go to Central Admin.
- Now Click Shared Services Administration from the quick launch.
- From this screen hover over the appropriate SSP name, click the drop down arrow, and choose Edit Properties.
- Now find where it says SSP Database. This your Database Name.
- Now you need to open a SQL Query Window using the SQL Management tools
- Then run the query below – Remember to replace the Use statement with your database name from step 4
Use SharedServices1_DB
Select
UP.NTName,
UP.PreferredName,
UP.Email,
UL.Title,
UL.URL
From
UserLinks UL inner join UserProfile_Full UP on UL.recordId = UP.recordID
How do you get My Links back?
Libraries
In a library, go to the Library tab in the ribbon.Click the Connect to Office button. This is the interface to add or remove a link to the library to the list of “My Links”, as well as to manage this list of links.
When you click Add to SharePoint Sites, this library is not only added to your own personal list of links, but it is added to all of your Office suite of applications, on the “Open” and “Save As” screens.
When you click Manage SharePoint Sites, the following screen is displayed, with a list of your whole list of links:
Where is my links on my Mysite ?
Go to your My Site and click on My Content at the top. Click Site Actions, Edit Page, and click to Add a Web Part. In the Recommended Items category of web parts, click to add the My Links web part to the page. There it is! Right click on the My Links web part title, and copy that URL to the clipboard.
If you want the My Links link to be more obvious and accessible, though? Yes, there’s a way to do that also, although it still won’t be the same as it is in SharePoint 2007. It entails adding My Links to the Personalization Site Links in the User Profile Service Application.
- In Central Administration, click Manage Service Applications.
- Click the User Profile Service Application.
- Click Configure Personalization Site.
- Click New Link.
- Your URL will look something like that. In this scenario, I have a web app just for the my sites. Fill in an owner because that field is required. Leaving the Audience field blank means that this link will be shown to everyone.
http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=daba3a3b%2Dc338%2D41d8%2Dbf52%2Dcd897d000cf3&ID=66&Web=dbb90e85%2Db54c%2D49f4%2D8e97%2D6d8258116ca0
Subscribe to:
Posts (Atom)