Invalid characters in SharePoint naming conventions

This article lists the characters that you cannot use in the following names in Microsoft SharePoint:

• Site names
• Folder name
• Server names
• File names

Site names, subsite names, or site group names

• You cannot use the following characters anywhere in a site name, in a subsite name, or in a site or Active Directory group name:-
  • Tilde (~)
  • Number sign (#)
  • Percent (%)
  • Ampersand (&)
  • Asterisk (*)
  • Braces ({ })
  • Backslash (\)
  • Colon (:)
  • Angle brackets ([ ])
  • Question mark (?)
  • Slash (/)
  • Plus sign (+)
  • Pipe (|)
  • Quotation mark (“)
• You cannot start a site name, a subsite name, or a site group name with an underscore (_) character or with the period (.) character.
• When you create a site name, a subsite name, or a site group name, you cannot use strings that were already used to name managed paths.
• You cannot use the period character consecutively in the middle of a site name, a subsite name, or a site group name.
• You cannot use the period character at the end of a site name, a subsite name, or a site group name.

Folder names

• You cannot use the following characters anywhere in a folder name or a server name:
  • Tilde
  • Number sign
  • Percent
  • Ampersand
  • Asterisk
  • Braces
  • Backslash
  • Colon
  • Angle brackets
  • Question mark
  • Slash
  • Pipe
  • Quotation mark
• You cannot use the period character consecutively in the middle of a folder name.
• You cannot use the period character at the end of a folder name.
• You cannot start a folder name with a period character.

File names

• You cannot use the following characters anywhere in a file name:
  • Tilde
  • Number sign
  • Percent
  • Ampersand
  • Asterisk
  • Braces
  • Backslash
  • Colon
  • Angle brackets
  • Question mark
  • Slash
  • Pipe
  • Quotation mark
• You cannot use the period character consecutively in the middle of a file name.
• You cannot use the period character at the end of a file name.
• You cannot start a file name by using the period character.
• In addition, file names and folder names may not end with any of the following strings:
  • .files
  • _files
  • -Dateien
  • _fichiers
  • _bestanden
  • _file
  • _archivos
  • -filer
  • _tiedostot
  • _pliki
  • _soubory
  • _elemei
  • _ficheiros
  • _arquivos
  • _dosyalar
  • _datoteke
  • _fitxers
  • _failid
  • _fails
  • _bylos
  • _fajlovi
  • _fitxategiak

Read More

Configure SSL for SharePoint 2013

Access SharePoint site using custom URL

Read More

Generate script for ALTER DB column Data for all tables available in DB

Run Below query to generate script:

SELECT
'ALTER TABLE ' + TABLE_NAME + ' ALTER COLUMN Createdby varchar(50) ;' + 
'ALTER TABLE ' + TABLE_NAME + ' ALTER COLUMN Updatedby varchar(50) ;' AS Script
FROM INFORMATION_SCHEMA.TABLES

Take care of following items:

• Above query generate scripts for all the tables which were created in that database, deleted tables are also included in it.
• If tables contains that field or not it will generate script for that table also. Manually you have to remove that table script to run the generated scripts.
• CreatedBy and UpdatedBy is the field name of the tables which I want to update.
• Above query generates script for 2 fields, if you want to increase or decrease you have to update above query as per your requirement. 

Read More

How to change Default Home Page : SharePoint

I frequently get questions on changing the home page or using another page as the home page:

• Can I have three (or four or five or…) columns in the default home page?


• Do I have to use the new wiki home page in my Team Site?


• I want to test a new home page design, but I don’t want to lose the existing home page… (just in case you know…)


• How can I use a page from my wiki library as my home page?

Below are four ways to set another page as your home page: (all four work for both 2007 and 2010)

• From Site Settings (If the publishing features are enabled)


• From SharePoint Designer


• From code / API


• From PowerShell

The first two can be used by Site Owners, the second two can only be used for developers and administrators

Important Notes for all methods:
Make sure all of your users have at least read access to the new home page, and if in a library that you have it checked in and published.

1.   If the Publishing features are enabled for a site then: (From Site Settings)

Click on Site Action  =>  Site Setting  =>  Welcome Page

2.   From SharePoint Designer:

Right-click the new page and click "Set as Home Page".  (For SharePoint 2007 this only appears to work from SharePoint                    Designer if the file is in the root of the site. I.e. the same place as default.aspx.)

3. From Code / API

Please follow the following link for code.

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfolder.welcomepage.aspx

4. Via PowerShell

$site = Get-SPSite http://yourserver/sites/yoursite
$web = $site.RootWeb (or $web = $site.OpenWeb("yoursubsite") 
$folder = $web.RootFolder 
$folder.WelcomePage = "SitePages/home.aspx" 
(or $folder.WelcomePage = "default.aspx") 
(or $folder.WelcomePage = "Shared%20Documents/mycustomwebpartpage.aspx") 
$folder.update() 
$web.Dispose() 
$site.Dispose()

If you need any type of help please let me know on following email id : jaydoshi.com@gmail.com. Thank You.

Read More