How to create a Chart on a SharePoint 2010 site

The Microsoft Office SharePoint Enterprise 2010 is a collaborative application that can be used by multiple users connected to the same server. On an established SharePoint website for a server, you can upload files and edit other users’ work. You can also add new Web parts to files, such as adding a chart Web part containing data from another file stored on your computer. Adding a chart to a SharePoint Enterprise page can be helpful when you want to visually express data to other users connected to the SharePoint website.

  1. Log into SharePoint site.
  2. Navigate to the site where you want to create a Chart.
  3. Select an existing page that you want to add the chart.
  4. Click the Insert tab and then click Web Part.
  5. Click the Business Data option from the Web Parts group. Click the Chart Web Part option and then click the Add button.
  6. Click Save & Close.
  7. Data and Appearance option and then click the Connect Chart to Data option.
  8. Select your data source type, such as a Excel workbook that has been published to Excel Services or other data source type, and then click Next.
  9. Select the file containing the data and then click the Next button two more times. ClickFinish and the chart with your data will appear on the page.

How to create an Enterprise wiki

An Enterprise wiki helps users capture and publish knowledge that can be shared across the enterprise. When an organization needs an easy content editing experience in a single location for co-authoring content, conducting discussions, and managing projects, consider creating an Enterprise wiki.

      1. To create an Enterprise wiki by using Central Administration

Verify that you have the following administrative credentials:

      • To use Central Administration, the user account that is performing this procedure must be a member of the Farm Administrators group.

NOTE: You can also create an Enterprise wiki as a sub-site of another site by clicking New Site on the Site Actions menu.

        • In the Web Application section, click the Web Application drop-down list to select the Web application where you want to create the Enterprise wiki.

        • In the Title and Description section, type a title in the Title box and, optionally, type a description in the Descriptionbox.

        • In the Web Site Address section, select / to create the Enterprise wiki at the root of the Web application, or select/sites/ to create the Enterprise wiki site at a specific path. If you select /sites/, you must also type the site name.

        • In the Template Selection section, click the Publishing tab, and then click Enterprise Wiki.

        • In the Primary Site Collection Administrator section, type the user name for the user who will be the site collection administrator.

        • In the Secondary Site Collection Administrator section, type the user name for the secondary administrator of the site collection.

        • Designating a secondary site collection administrator is a best practice to ensure that someone can manage the site collection when a primary site collection administrator is not present.

        • If you are using quotas to manage storage for site collections, in the Quota Template section, click a template in the Select a quota template list.

        • Click OK.

      1. Create an Enterprise wiki by using Windows PowerShell

Verify that you meet the following minimum requirements:

    • See Add-SPShellAdmin.
    • On the Start menu, click All Programs.

    • Click Microsoft SharePoint 2010 Products.

    • Click SharePoint 2010 Management Shell.

    • From the Windows PowerShell command prompt window (that is, PS C:>), type the following commands:

      1. To display all the site templates, type the following command:Get-SPWebTemplate
      2. To create a variable that contains the name of the Enterprise wiki template, type the following command:$wikitemp = Get-SPWebTemplate “ENTERWIKI#0”
      3. To create an Enterprise wiki site, type the following command:

        New-SPSite http://yoursite.com/Wiki -OwnerAlias <domainuser> 

        -Template $wikitemp

        Where <domainuser> is the user name of the site owner.

Web Analytics: Monitors the health of the Report Consolidator component

The quick fix is via SharePoint PowerShell – open that and do the following step.

NOTE: You must be an Admin to do this. Run your SharePoint PowerShell as Administrator.

Step 1 – Get the GUID of the Service Application 

> Get-SPServiceApplication

Managed Metadata … Managed Metadata … 50f28d03-a89a-4cd0-a5ce-3fa95bf19ac7
Web Analytics Ser… Web Analytics Ser… ec65ee1c-f3d3-4bc7-9bb1-6cccb4705cdf
Excel Services Ap… Excel Services Ap… 4041c849-5ca9-48e1-93a6-1a7b4edac13f

Notice the Web Analytics service – copy the GUID in the ID Column.

Step 2 – Turn on Data Trimming on the Reporting Service


> Set-SPWebAnalyticsServiceApplication -Identity <GUID> -EnableDataTrimming

(replace <GUID> with the GUID you copied above – NOTE: if you only have one Analytics Service, you can omit the GUID)

for example:

> Set-SPWebAnalyticsServiceApplication -Identity ec65ee1c-f3d3-4bc7-9bb1-6cccb4705cdf -EnableDataTrimming

Give if a few minutes to let the SPTimer job kick then return to the Health Monitor, click the message and select Re-analyze Now – message should go away!

How to fix The list cannot be Displayed in Datasheet View

By default, the Datasheet view of a list or library is not supported when you are using the 64-bit version of Microsoft Office 2010 installed on a 64-bit Windows operating system.

If your business needs require using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component. These components are available here on the Microsoft download center:
2007 Office System Driver: Data Connectivity Components

NOTE: If you are using a 64-bit version of an Internet browser, for example the 64-bit version of Microsoft Internet Explorer 8.0, there is no support for the Edit in Datasheet feature.

NOTE: You must install all 64-bit versions of Office products before you install the 2007 Office System Driver: Data Connectivity Components.

OTHER REASONS DATASHEET VIEW MIGHT NOT WORK
There might be other reasons why Datasheet view is not working, including the following:

  • A datasheet component compatible with SharePoint 2010 is not installed.
  • Your browser does not support ActiveX controls.
  • Certain libraries and lists do not support Datasheet view, such as a slide library, and therefore the Datasheet view command is dimmed.

How to fix Sharepoint Foundation 2010 Search returns no results

SharePoint Foundation 2010 includes basic searching features. Despite all rumors and recommendations to upgrade to higher level searching packages, the basic SharePoint search works quite well … and it’s very useful.
If your SharePoint server is not returning search results, the following may help you resolve the issue. It’s important to create the right accounts, enable the right services, assign the accounts to these services and finally attach the search server to your web applications.
Let’s begin …
  1. You need to create domain accounts for Searching and Crawling. Using the Farm Account (or default accounts) is not recommended. In our example we will use “spSearch” and “spCrawl”. Use complex passwords! These domains accounts should only be standard users, no administrative privileges should be applied.
  2. Log into the SharePoint Central Administration Page
  3. CA > Security > General Security > Configure Managed Accounts > Register Managed Account.
    • Enter in “domainspSearch” and the password you chose
    • Click “OK”.
    • You should now see this account in the Managed Account list
  4. CA > System Settings > Servers > Manage Services on Server > SharePoint Foundation Search > Start.
    • Service Account -> “DomainspSearch”
    • Content Access Account (Crawl) -> “DomainspCrawl” and the password you chose
    • Leave everything else as defaults (you can change the Database Name if you are having issues)
  5. CA > Security > General Security > Configure service accounts
    • Choose “Windows Service -> SharePoint Foundation Service”
    • Choose “DomainspSearch” for the account selection
    • Click “OK”
  6. CA > Application Management > Manage Content Databases
    • This is important! For each site you want automatically crawled, you must assign the search server.
    • In the top right corner under “Web Application”, choose the web applications to be crawled, one at a time followed by a click on the “database name” column once they are loaded.
    • In the profile page, change the “Search Server” and “Preferred Server for Timer Jobs” to your server.
    • Click “OK”
    • Repeat for any other Website Applications you wish crawled
  7. CA > Monitoring > Timer Jobs > Review Timer Jobs > SharePoint Foundation Search Refresh
    • Choose “Run Now” to begin indexing your web applications (sites)
    • This can take several hours depending on the size of your database(s). Please be patient.
  8. If you’re feeling eager and have a background in SQL, you can use the SQL Management Studio to check the progress. If you are not familiar with SQL, don’t be a hero … this can cause major damage.
    • Load the SQL Management Studio
    • Expand the search database created in the earlier steps (typically WSS_Search_%hostname%)
    • Right click the database -> new query
    • Enter in the following Query:select * from msscrawlhostlist (execute)

You will be presented with a table of results including a column for Hostname and SuccessCount.
SuccessCount increases as it indexes each page.

    • You can also lookup the crawl summary with:select * from MSSCrawlURLLog
    • And should there be any error codes in the MSSCrawlURLog, they can be referenced with:select * from MSSCrawlErrorList where ErrorID = ‘<ERRORID>’
If you run into issues where things are still not being crawled, i would suggest deleting the spCrawl and spSearch from SharePoint and Active Directory, re-creating them from scratch, repeating this entire process, and changing the “database” value in step “3”. This will re-create the crawling database from scratch.
I hope it helpful to you!

Add multiple SharePoint and Exchange calendars to a SharePoint calendar

Add multiple SharePoint and Exchange calendars to a SharePoint calendar

Use the following procedure to create a view of multiple SharePoint 2010 and Exchange 2010 calendars for a SharePoint calendar. A view for a calendar can display a maximum of ten calendars.
 NOTE: To change calendar settings, you must have at least the design permission level for the site.
  1. In a SharePoint calendar, in the ribbon, on the Calendar tab, click Calendar Overlays.
  2. In the Calendar Overlay Settings page, click New Calendar.
    • To add a SharePoint calendar
      • Name and Type section, type the Calendar Name and then select SharePoint.
      • In the Calendar Overlay Settings section, type a Description for the calendar (optional), and change the Color theme for the calendar (optional).

TIP: Selecting different colors for different calendars makes it easier to distinguish which calendar an event is from.

      • Type the Web URL for the SharePoint site that the calendar is in and then click Resolve. If the calendar is in the same site as the group calendar, Web URL will already be populated accurately.
      • List drop-down arrow and select the calendar that you want to add to the calendar.
      • Click the List View drop-down arrow and select the view that you want to use for the calendar.
      • If you want this SharePoint calendar to always display in the SharePoint group calendar, select Always Show.
      • In the Name and Type section, type the Calendar Name and select Exchange.
      • In the Calendar Overlay Settings section, type a Description for the calendar (optional), and change the default Color theme for the calendar (optional).

TIP: Selecting different colors for different calendars makes it easier to distinguish which calendar an event is from.

      • Click FindOutlook Web Access URL and Exchange Web Service URL will be filled in automatically. If Find does not work in your environment, type the URLs manually
      • If you want this Exchange calendar to always display with the SharePoint group calendar, select Always Show.
  1. Click OK and then click OK again.

How to synchronize a SharePoint 2010 with Outlook 2010 (Exchange 2010). Part 3

Part 3. Synchronize a SharePoint task list with Outlook 2010

Please do next simple steps to sync a SharePoint 2010 task list with Outlook 2010 tasks.
    1. In your browser, navigate to the SharePoint site containing the Task list or Project task list you want to synchronize.
    2. Click the name of the task or project task list on the Quick Launch, or click Site Actions, click View All Site Content, and then in the appropriate list section, click the name of the task or project list.
NOTE: SharePoint site can be significantly modified in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your SharePoint administrator.
  1. In the ribbon, on the List tab, in the Connect & Export group, click Open in Outlook.
  2. When prompted to connect the SharePoint Contacts list to Outlook, click OK.
In Outlook 2010 the tasks are added under Other Tasks in the Navigation Pane, and in the To-Do Bar.
NOTE: You can work with your tasks from your SharePoint site similar to the way you work with your Outlook tasks. You can drag or copy tasks back and forth between the folders for Outlook and the SharePoint site. However, recurring tasks and task requests from Outlook are converted to regular tasks on the SharePoint site.TIP: After you connect a Task list or Project Task list to Outlook, you can send a sharing message to other team members that invite them to connect to the tasks. Right-click the list name in Outlook, and then click Share tasks list name. This creates an e-mail message that contains a link and a command to connect to the list.

How to synchronize a SharePoint 2010 with Outlook 2010 (Exchange 2010). Part 2

Part 2. Synchronize a SharePoint contact list with Outlook 2010 contacts

Please do next simple steps to sync a SharePoint 2010 contact list with Outlook 2010 contacts.
    1. In your browser, navigate to the SharePoint site containing the contact list that you want to synchronize.
    2. Click the name of the contact list on the Quick Launch, or click Site Actions, click View All Site Content, and then in the appropriate list section, click the name of the contact list.
NOTE: SharePoint site can be significantly modified in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your SharePoint administrator.
  1. In the ribbon, on the List tab, in the Connect & Export group, click Open in Outlook.
  2. When prompted to connect the SharePoint contacts to Outlook, click OK.

In  Outlook 2010 the contacts are added under Contacts in the Navigation Pane.

How to synchronize a SharePoint 2010 with Outlook 2010 (Exchange 2010). Part 1

Part 1. Synchronize a SharePoint library with Outlook 2010

Please do next simple steps to sync a SharePoint 2010 library with Outlook 2010.
    1. In your browser, navigate to the SharePoint site containing the library that you want to synchronize.
    2. Click the name of the library on the Quick Launch, or click Site Actions, click View All Site Content, and then in the appropriate library section, click the name of the library.
NOTE:SharePoint site can be significantly modified in appearance and navigation. If you cannot locate an option, such as a command, button, or link, contact your SharePoint administrator.
  1. Library tab, in the Connect & Export group, click Connect to Outlook.
  2. When prompted to open a program on your computer, click Allow.
  3. If you are prompted to confirm the operation, click Yes.
In Outlook, the library is added to the Navigation Pane under SharePoint Lists. The files in the library behave similar to e-mail messages. For Office files, click to preview the file in the Reading Pane or double-click the file to open it. Right-click the file for more options.
NOTES:
  • If the library has subfolders and you want to have access to all of the files in Outlook, view the library at its top level and then connect it to Outlook. By default, if you are in a subfolder of a library, and then connect the library to Outlook, only the contents of that folder are connected.
  • To access only the contents of a single folder in Outlook, there are two options. If the folder that contains files that you want to access in Outlook is not open, point to the folder, click the Open Menu arrow that appears, and then click Connect to Outlook. If the folder that you want to connect is already open, follow the steps to connect a library.
  • After you connect a library to Outlook, you can invite other team members to connect to the library. Right-click the library name in Outlook, and then click Share This Folder.

How to configure SharePoint Foundation Search

This is a guide which will help you to configure SharePoint Foundation Search.

Firstly you need to turn on the Foundation Search Service.  You do that with the following:

  1. Open Central Administration
  2. Go to System Settings -> Manage services on server
  3. Click on SharePoint Foundation Search
  4. Assign a service account to start the service (this is a managed account, so select on or add a new one)
  5. Assign a content access account (more on that below)
  6. Enter a database server and database name (or accept the defaults)
  7. Choose an indexing schedule
  8. Click Ok
  9. When you return to the Manage services on server page, click Start next to SharePoint Foundation Search

That’s only the first part, however.  You’ve got the Search service running and the indexer on a schedule, but you actually have not yet identified what to index. The next thing that you need to do grant the content access account (that you entered above) read access to your applications.  Do next steps:

  1. Go to Central Administration
  2. Go to Application Management -> Manage web applications
  3. Highlight the web application that you want foundation search to index
  4. Click User Policy in the ribbon
  5. In the Policy for Web Application box that appears, click Add Users
  6. Leave the Zone selection at (All zones), click Next
  7. In the Choose Users box, enter the username of the Content Access Account you used above when you configured SharePoint Foundation Search
  8. Check Full Read for permissions
  9. Click Finish

Now you have the indexer running and the content access account has privileges to read all of the content in your web application.  But you still haven’t identified the content to crawl.  That’s done at the content database level. Do this:

  1. Go to Central Administration
  2. Go to Application Management -> Manage Content Database Settings
  3. Click on the content database that contains the site(s)/site collection(s) that you want to index
  4. In the settings for that content database, in the section Search Server, use the drop down list to select the server with SharePoint Foundation Search service running
  5. Click OK.

You have turned on and set a schedule for indexing, granted permissions for the crawl account, and identified content to crawl.  More than likely for configure SharePoint Foundation Search, you’re done.  Based on the schedule that you created in the first part, and the amount of data that you need to crawl, you may need to wait a little while to check to see if everything is working.