Microsoft Office 365

1. Open "Central Administration"
2. Click “Manage service applications”, under “Application Management”
   
3. Click "New"
   
4. Select "User Profile Service Application"
   
5. Fill in the related fields
   (If I haven't mentioned the field, it has the default settings)
   
   a.  Name:  User Profile Service
   b.  Application Pool:  Use existing application pool:  Shared Services
   
   c.  Profile Database:
        i.  Database Server:  {SQL Server 2012 Name}
        ii. Database Name:  {Database}_UserProfile
   
   d.  Synchronization Database:
        i.  Database Server:  {SQL Server 2012 Name}
        ii. Database Name:  {Database}_UserProfile_Sync
   
   e.  Social Tagging Database:
        i.  Database Server:  {SQL Server 2012 Name}
        ii. Database Name:  {Database}_UserProfile_Social  
   
   f.  Profile Synchronization Instance: {SharePoint Server Name} (default - current server)
   
   f.  My Sites. If you don't have, in this example we done, you can leave it blank, as default.
   
6. Click "Create"
   
7. Click "OK"
8. See full here: User Profile Service Application Settings

Reset the IIS:

Changing your Region Settings

Change the “List separator” from a semi-colon to a comma

1. Open “Control Panel”
2. Click “Region” or “Region and Language”, depending on your Windows operation system
3. Click “Additional settings…”
   
4. Change:
   a. Decimal symbol                .               (full stop)
   b. List separator                     ,               (comma)
   
   Both need to change. It seems to conflict if you just change the “List separator” and not both. If they are both comma’s, the csv conversion returns semi-colon’s.
5. Click “OK”
6. Click “OK”

Import the csv sample template from SharePoint 2013 Term Store

1. Open SharePoint 2013
2. Click the cog (Site Actions), top right corner
3. Select “Site Settings”
4. Click “Term store management”, under “Site Administration”
5. Select the Managed Metadata Service application, on the left tree view
   
6. Click “View a sample import file”, on the right (properties pane)
   
7. Click “Save”

Working on the Terms

Compare Excel spreadsheet with Term Store

Save to csv

1. Open Excel 2013
2. Click "File" tab, on the Ribbon
3. Select "Save As", on the left
4. Click "Browse"
5. Select the file type: CSV (Comma delimited) (*.csv)
   
6. Give the file a relative name
   e.g. ImportTermSetNew

Import csv to SharePoint 2013 Term Store

1. Open SharePoint 2013
2. Click the cog (Site Actions), top right corner
3. Select “Site Settings”
4. Click “Term store management”, under “Site Administration”
5. Select the Managed Metadata Service application, on the left tree view
6. On the left, in the tree view, select the “Term Group” you would like to upload to.
7. Select “Import Term”
   e.g.: Test Term Group
   
8. Click “Browse”
9. Choose the relevant csv file
   e.g.: ImportTermSetNew.csv
10. Click “OK”
    

1. Open Central Administration
2. Click “Manage service applications”, under “Application Management”
   
3. Select “Managed Metadata” service (the first one). Click on the side, to select it, but not open it.
4. Click “Properties”, in the Ribbon
   
5. Scroll to the bottom, and confirm the Content Type Hub is the correct Content Type Hub URL

How to update the Content Type Hub URL:

1. Open “Central Administration”
2. Click “Manage web applications”, under “Application Management”
   
3. Here you will see the list of all the Site Collection in your farm

How to deploy a WSP to SharePoint Farm Solution library

1. Add the WSP to the SharePoint Server
1. The first thing you need to do is copy over the wsp deployment file. The best things to do is to create a deployment folder, where all the deployed files are kept.
2. Copy over the deployment files to: c:\Deploy\WSP
2. Add the WSP to the SharePoint Farm Solution library
1. Open “SharePoint 2013 Management Shell “ as administrator

   a. Open the Search on Server 2012

   b. Search for “SharePoint 2013 Management Shell”

   c. Right click “SharePoint 2013 Management Shell”

   d. Select “Run as Administrator”
2. Run this script: 
   Add-SPSolution "c:\Deploy\WSP\{file name}.wsp"  
3. Deploy the WSP to the SharePoint Farm Solution library
1. Open Central Administration
2. Click “System Settings”
   
3. Click “Manage farm solutions”, under “Farm Management”
   
   
4. Click on the {file name}.wsp package
5. Click “Deploy Solution”
   
6. Deployment settings
   

   Deploy When: Now

   Deploy to: All content Web application

7. Click “OK”

How to activate the WSP Feature on the Site Collection

1. Activate the WSP Feature on the Site Collection
1. Open the Root Site (the Site Collection)
2. Click the cog, in the top right corner (Site Actions)
3. Select “Site Settings”
4. Click “Site collection features”, under “Site Collection Administrator”
5. Go to {file name}
6. Click “Activate”, to the right

Edit Panel:

Display Panel: