Wednesday, December 21, 2011

How to clear the Windows SharePoint 2010 Services configuration cache

There were many common issues that could occur in WSS v3 and MOSS that would require you to clear the configuration cache on your servers. While less common, these issues can still turn up occasionally on SharePoint Server 2010 (And Foundation). While the resolution for these issues might be the same, the steps are a bit different. The main thing to note is that the Configuration Cache is located in a different directory on Windows Server 2008 then it was in Windows Server 2003. The new path for the Configuration Cache under Windows Server 2008 is: %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\ The overall steps remain largely the same:

  1. Stop the Timer service. To do this, follow these steps:
    • Click Start, point to Administrative Tools, and then click Services.
    • Right-click SharePoint 2010 Timer, and then click Stop.
    • Close the Services console.
  2. On the computer that is running Microsoft SharePoint Server 2010 and on which the Central Administration site is hosted, click Start, click Run, type explorer, and then press ENTER.
  3. In Windows Explorer, locate and then double-click the following folder:
  4. %SystemDrive%\ProgramData\Microsoft\SharePoint\Config\GUID
  5. Notes
    • The %SystemDrive% system variable specifies the letter of the drive on which Windows is installed. By default, Windows is installed on drive C.
    • The GUID placeholder specifies the GUID folder. There may be more than one of these.
    • The ProgramData folder may be hidden. To view the hidden folder, follow these steps:
      • On the Tools menu, click Folder Options.
      • Click the View tab.
      • In the Advanced settings list, click Show hidden files and foldersunder Hidden files and folders, and then click OK.
      • You can also simply type this directly in the path if you do not want to show hidden files and folders.
  6. Back up the Cache.ini file. (Make a copy of it. DO NOT DELETE THIS FILE, Only the XML files in the next step)
  7. Delete all the XML configuration files in the GUID folder (DO NOTE DELETE THE FOLDER). Do this so that you can verify that the GUID folders content is replaced by new XML configuration files when the cache is rebuilt.
    Note When you empty the configuration cache in the GUID folder, make sure that youdo NOT delete the GUID folder and the Cache.ini file that is located in the GUID folder.
  8. Double-click the Cache.ini file.
  9. On the Edit menu, click Select All.
  10. On the Edit menu, click Delete.
  11. Type 1, and then click Save on the File menu. (Basically when you are done, the only text in the config.ini file should be the number 1)
  12. On the File menu, click Exit.
  13. Start the Timer service. To do this, follow these steps:
    • Click Start, point to Administrative Tools, and then click Services.
    • Right-click SharePoint 2010 Timer, and then click Start.
    • Close the Services console.
  14. Note The file system cache is re-created after you perform this procedure. Make sure that you perform this procedure on all servers in the server farm.
  15. Make sure that the Cache.ini file in the GUID folder now contains its previous value. For example, make sure that the value of the Cache.ini file is not 1.
  16. Check in the GUID folder to make sure that the xml files are repopulating. This may take a bit of time.

Tuesday, December 20, 2011

Publish a workbook to a SharePoint 2010 site

Publish a workbook to a SharePoint 2010 site

In Microsoft Excel 2010, you can publish a workbook to a Microsoft SharePoint Services 2010 site so that other users can view its data in a web browser without having Excel installed on their computers. In addition, by setting some publish options, you can emphasize specific parts of your workbook in the browser. A great way to utilize this feature is by displaying an Excel chart on a SharePoint page to help your organization make agile business decisions. This article shows you how to publish a workbook from the Excel 2010 desktop program, and does not cover connecting a workbook or workbook data to an Excel Web Access web part on a SharePoint page.
When you publish a workbook to a SharePoint server, the entire contents of the workbook are saved to the server and can be viewed and worked with if you open the workbook in the Excel desktop program. If Office Web Apps are deployed on the SharePoint server, viewing and working with your data in the web browser can be very much like working with your data in the Excel desktop program. In fact, simultaneous editing of a workbook is possible in the browser grid when Office Web Apps are deployed. When you view a workbook in the browser, if the Edit in Browser button is visible, this means that Office Web Apps are available.

Before you publish the workbook, you have the opportunity (in the Publish Options dialog box) to select the worksheets or items that you want visible in the browser when editing has not been enabled by clicking the Edit in Browser button. Just remember that although you can select what is viewable in this mode, the entire contents of the workbook are still saved to the SharePoint server. If you want to include entire worksheets as an item in addition to other items, such as charts or PivotTables, define the entire worksheet as a named range. Select the entire worksheet, and then define a named range. This named range will then appear as an available item in the Publish Options dialog box when you are ready to publish. If you want to allow users to provide a parameter to a formula when viewing a worksheet in a browser, set a cell as a defined name. You can then add that defined name as a parameter on the Parameters tab in the Publish Options dialog box.

  1. Save & Send.
  2. Save to SharePoint.
    Note : If the Save to SharePoint command is unavailable, you can still save the workbook to a SharePoint site by using the Save As command. The Publish Options dialog box will not be available. You can also directly upload the workbook from a SharePoint library. Users can view and edit the contents of the workbook in the browser by going directly to the site where the workbook is saved.
  3. If you want to select individual worksheets or items to publish in the workbook, click the Publish Options button. Otherwise, if you want to publish the entire workbook, skip directly to step 4.
    On the Show tab, do the following:
    • To show the entire workbook in the browser, select Entire Workbook in the list box.
    • To show only specific worksheets in the browser, select Sheets in the list box, and then clear the check boxes for the sheets that you do not want to make visible.
      Note:  By default, all sheets are selected. To quickly make all sheets viewable again after you clear some of the check boxes, you can select the All Sheets check box.
    • To show only specific items in the browser (such as named ranges, charts, tables, or PivotTables), select Items in the Workbook in the list box, and then select the check boxes of the items that you want to show.
      Note:  If you select items that have the same name (such as a chart and its underlying table of data), only one of these items will be available in the browser. To show all the items, you must make sure that each item in the workbook has a unique name. You can rename tables on the Design tab in the Properties group, rename PivotTables on the Options tab in the Pivot Table group, and rename charts or PivotCharts on the Layout tab in the Properties group. Duplicate items, such as named ranges, can be renamed on them Formulas tab in the Defined Names group.
    • On the Parameters tab, add any defined names that you want to use to specify cells that are editable when users view the workbook in the browser. Then click OK to close the dialog box.
  4. Choose a location in which to publish your workbook. There may already be saved server locations under Current LocationRecent Locations, or Locations from which you can choose. If there are no such locations, or you want to save to a new location, under Locations, double-click Browse for a location.
  5. In the dialog box, enter the web address for the SharePoint site, and then browse to the site or library in which you want to save your workbook.
  6. If you haven't already selected individual worksheets or items or set parameters, click the Publish Options button.
  7. In the File name box, accept the suggested name for the workbook, or type a new name if you want.
  8. To display the workbook contents in a browser window immediately after the publish operation has completed, make sure the Open with Excel in the browser check box is selected.
  9. Click Save.

Monday, December 19, 2011

How to configure PerformancePoint services in SharePoint 2010

The following are the configuration steps to get PerformancePoint up and running on SharePoint 2010 Enterprise edition.
As PerformancePoint service is integrated in SharePoint 2010 environment, we need to do some configurations in Sharepoint 2010 Central Administration tool.
It also explains what components are enabled with the Site Collection and what Site features are required for storing PPS dashboards, scorecards, and reports in SharePoint Lists and Document Libraries.
Starting the PerformancePoint service
  1. Open the SharePoint 2010 central administration and click on System Settings then click on Manage services on server link under Servers category.
  2. Click the start link for the PerformancePoint Service.
 Activating PerformancePoint Site Collection Feature
  1. Open your Business Intelligence site and navigate to Site Actions and click on site settings option.
  2. Click on Site Collection Features option from Site Collection Administration.
  3. Activate the PerformancePoint service from the below list.
Setting up the Secure Store Account
Without secure store account you cannot access the performance points unattended service account to connect to data sources. PP 2007 uses application pool identity to connect to the data sources where as in 2010 it is domain account whose password is stored in the secure store.
In order to configure Secure Store for PPS, Follow these steps
  1. Open SharePoint 2010 central administration toll
  2. Click on Manage Service Applications under Application Management
  3. Click on the Secure Store Proxy and click Manage in ribbon
You will get a message saying ‘Generate a new key’, Click Edit on the ribbon then say Generate a new key
Setting up an Unattended Service Account
  1. Go to Central administration Home page
  2. Click “Manage Service Applications” under application management
  3. Click the PerformancePoint service application
  4. Click on the first link PerformancePoint Service Application Settings
  5. In the “Unattended Service Account” section, enter the username and password for querying the data sources
Testing the configuration of Performance Point Service, Open a Performance Point BI Center Site and Click on Run Dashboard Designer button
If you have successfully created a PerformancePoint site collection, you should be able to browse to the BI Center, launch Dashboard Designer, and connect to a data source using the unattended service account.

Tuesday, November 29, 2011

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.

Sunday, November 27, 2011

How to Add an Additional Exchange Email Account in Outlook

Microsoft Outlook 2010 is the full-version email client included in the Microsoft Office suite of productivity applications. Adding email accounts to Outlook is a fairly streamlined task, usually requiring only the email address and password for the Exchange email account.
To add an additional Exchange email account do next simple steps:
  • Run Outlook 2010
  • Click the File option on the top toolbar and then click the Add Account button under "Account Information".
    • Type the name of the person to whom the new email account belongs into the field labeled Your Name. Type the email address for the new account in the Email Address input box. Type the password for the email account, and then retype the password to confirm. Click Next. Outlook will attempt to connect with the Exchange email server and log in with the information you have provided.
    • If successful, click Finish. The configuration is complete. If unsuccessful, click the Retry button to reattempt the connection, or click the Back button and manually configure the email servers.
    • You see the message like this. Press Ok and restart your Outlook 2010.

    • Additional account was added!

    Good luck!

    Friday, November 25, 2011

    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
    2. 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.
    3. Create an Enterprise wiki by using Windows PowerShell
    4. 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:

        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 -OwnerAlias <domain\user> 
          -Template $wikitemp
          Where <domain\user> is the user name of the site owner.

    Wednesday, November 23, 2011

    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!

    Sunday, November 20, 2011

    How to migrate (copy) Microsoft Outlook 2010 custom views to backup or share

    Microsoft Outlook doesn’t offer an easy method to backup or share custom views, and exporting the contents to a new pst does not include the views or custom forms.

    Copy views to a ViewsBackup.pst
    1. Add a new .pst (File, New, Outlook Data File).
    2. Add folders to the .pst for each type of view you need to copy. (One folder each of Mail, Calendar, contacts, etc).
    3. Select the first new folder.
    4. Open the Define views dialog.
    5. Select the view you want to copy to the new pst and click Copy.
    6. Select one of the "This folder…" options.
    7. Change the view name, if desired.
    8. Click Ok.
    9. Repeat for each view you want to copy.
    Repeat for each folder type.
    To copy a view that was originally designed for “this folder only”, you’ll need open that folder, and make a copy of it using the “For all [folders]” option then begin with Step 3.
    Copying views to a different pst uses the same steps, but you’ll copy the “for this folder view” and set it for All [folder]. This adds it to the default pst (or Exchange mailbox). If you want it for a specific folder only, you’ll need to select the folder, copy the view again and set it for this folder only.
    Views created for “this folder only” are stored in the folder – moving or copying the folder to a new pst includes these views (as well as custom forms published to the folder).
    Exchange server users can copy views and published forms using the File, Folder menu.

    Friday, November 18, 2011

    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.

    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.

    Wednesday, November 16, 2011

    How to fix SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location

    If you are using the Office Web apps in SharePoint 2010 then you may come across this 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.” To fix it do next simple steps:
    1. Jump into Central Administration and goto Manage service applications.
    2. Click on Excel services Application.
    3. Then click on Trusted file locations
    4. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
    5. Fill in the boxes and also ticked the trust children box.
    Once you have done this go back to your SharePoint site and Excel document and it will open up in the browser! Good luck!

    Saturday, November 12, 2011

    How to create shared contacts folders in Outlook 2010

    To share your contacts in Outlook 2010 do next steps:
    1. Open Outlook 2010.
    2. Click on Contacts in the lower left corner, then click on the Contact Folder you wish to share to select.
    3. Next click on Share Contacts in the sharing section of the menu bar.
    4. An invitation will open up.
    5. Note: If option “Recipient can add ...” is checked the other person will be able to add, edit and delete items in the folder. If you only intend for them to see and use the items uncheck it.
      Click on the To… button and select a user from the Global Address List that you wish to grant permission to share your contacts.
      Then click Send and confirm the invitation. 
    6. Click Yes to confirm sharing folder.
    7. The person you invited will receive an email with the invitation. Open received email.
    8. They click Open this Contacts Folder to accept.

    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 "domain\spSearch" 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 -> "Domain\spSearch"
      • Content Access Account (Crawl) -> "Domain\spCrawl" 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 "Domain\spSearch" 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!

    Friday, November 11, 2011

    Benefits of outsourcing Exchange Email

    There are huge benefits to outsourcing your mail.

    No single point of failure (power goes out, nic card dies, hard drive failure). All of this results in your mail being down.You do not have to pay for an exchange admin (min of $50k a year to have someone keep your mail server running)

    Most hosting company (like the one i work for), have a ton of redundancy built into there networks. Its more more secure then your everyday work networks.

    You can save a lot of money also by outsourcing. You never have to worry about hardware failure. No more having to purchase Microsoft Licenses, backup software,antivirus software. You also do not have to pay for that person to keep the server running. That includes everyday maintenance.

    You also never have to upgrade. When you outsource, the hosting company do all the upgrades for you.

    Also, most your hosting company have Top notch Enterprise security. Specially if the company is SAS70 compliant. They get audited all the time to make sure the customers data is secure and protected.

    Also, Spam Filters. Most company's (at least you should check first), include spam filtering. That is another cost you will have to pay if you keep it in-house.

    There are a lot more, and i will be happy to go more in depth in this conversation if you wish. Also, I work for a Hosted Exchange company. If you are interested in talking to me offline about your needs, let me know. I didn't want to make this just about my company but i wanted to just give you facts on any hosted exchange company you go with.

    No matter what company you choose, i believe hosted exchange is a lot better then keeping it inhouse. Just make sure you do your research on the top hosted exchange company before you make your choice.

    You can send me a private message if you want to talk offline about your needs and i can at least give you more information about what you need to look for.


    Sunday, November 06, 2011

    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    A 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    A 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    A 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.

    • 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.

    Saturday, November 05, 2011

    How to configure SharePoint Foundation 2010 for SharePoint Workspace 2010

    SharePoint Workspace 2010 is the new version that will give you an offline copy of a SharePoint website and also allow you to work with a SharePoint site outside of a browser.  SharePoint Workspace 2010 is especially nice for editing documents in a SharePoint Document library.  SharePoint Workspace makes the SharePoint Document Library work just like a folder on your computer and will handle the synchronization of the documents back to the SharePoint server for you. If you try connecting SharePoint Workspace 2010 to a default SharePoint Foundation 2010 installation you may get an error like this one:

    Sync to SharePoint Workspace 
    SharePoint Workspace was unable to interpret the SharePoint location. Please check and ensure the location contains no typing errors. 
    OK Help 
    This is because the default configuration of SharePoint Foundation 2010 requires two configuration changes to allow SharePoint Workspace 2010 to work.
    The first is to enable the Remote Differential Compression feature on the server that is hosting SharePoint. This is used by SharePoint Workspace 2010 to send and receive the files for synchronization.
    To enable Remote Differential Compression:
    1. Go to the Server Manager > Features and choose Add Features.
    2. Check the box for the Remote Differential Compression feature and then click Install to enable this feature.
    The second configuration change to allow SharePoint Workspace 2010 to work with your SharePoint Foundation 2010 server is to add an Alternate Access Mapping of the public facing DNS name (or IP address) to SharePoint using the SharePoint CA.  If you are connecting to your SharePoint site using the computer name then this is not necessary, but if you are connecting over the Internet through either an IP address or DNS name then you will need to add this alternate access mapping.
    The reason is that when SharePoint is first installed, the only way it thinks users are connecting to the server is through the computer name: http://computer_name (as if on a local intranet).  Since most likely v Workspace 2010 users will be connecting through a public facing DNS name (or IP address), you will need to add this DNS name (or IP address) as an alternate access mapping (indicating that this DNS name is the same as the computer_name and should map to the SharePoint site).
    To add an Alternate Access Mapping to SharePoint Foundation 2010:
    1. Visit the SharePoint Central Administration on the SharePoint Foundation 2010 server.
    2. Once in the SharePoint Central Administration website, click on the Application Management link.
    3. Configure alternate access mappings
    4. Choose Edit Public URLs.
    5. And then select the public facing SharePoint website that you want to add an access mapping to.  You do this by changing the Alternate Access Mapping Collection (clicking on the “No selection” drop down button) to the website that is running on Port 80. The  default name of the public facing SharePoint site is “SharePoint – 80” but you may have changed that when you configured your SharePoint site. Once you have switched the Alternate Access Mapping Collection to the public SharePoint website (SharePoint – 80) then you can specify the Public URL by adding the publically accessible IP Address or DNS name to the Internet field.
    6. Click Save to apply the alternate access mapping and now you should be able to connect to your SharePoint Foundation 2010 site with SharePoint Workspace 2010.
    SharePoint Foundation 2010 is the free version of SharePoint that installs on top of Windows Server 2008.  With SharePoint Workspace 2010 you can get an offline copy of your SharePoint team site allowing you to add/edit your documents in any SharePoint document library easily and allow SharePoint Workspace 2010 to handle the file synchronization for you. 

    How to Use the Silverlight SharePoint Web Part to Display Silverlight Applications

    Silverlight applications are used to build rich Internet-based applications. SharePoint previously allowed Silverlight integration with some configurations and many deployment dependencies.
    SharePoint 2010 has introduced a new web part (Silverlight Web Part) which is an out of the box SharePoint web part. It facilitates one to view their Silverlight applications. The Silverlight web part always accepts the application in the ".xap" format, which is basically the compressed output file for the Silverlight application.
    So, how to use out of box Silverlight web part in SharePoint 2010?
    1. Create a sample Silverlight application using Visual Studio 2010.
    2. Find a .xap file in the projectfolder -> projectfolder.web -> ClientBin folder
    3. Upload the .xap file into one of the SharePoint libraries.  To upload the .xap file, go to the Library and click Add document.  Browse the source path of the clientbin folder and select the .xap file and click OK. One can select to overwrite the existing file in the library too.
    4. To add a Silverlight web part, go to SiteActions -> Edit Page. Click Add web part. In the Media and Content category, select Silverlight web part and click OK.
    5. Open the tool pane. Under the application category, click on configure and select the application file source path as the document name (.xap files) that you uploaded in the library. Click OK and select Stop editing from the Page tab
    6. The Silverlight application is viewable and accessible very easily without any kind of back-end configurations.

    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.

    Sunday, October 30, 2011

    How to create a blog in SharePoint 2010

    You have a SharePoint Foundation 2010 or SharePoint Enterprise 2010 and want to create a SharePoint blog? It is very easy.

    You may do next easy steps:
    1. Log into SharePoint.
    2. Go to Site Actions New Site.
    3. Click on Blog and enter a title as well as the desired URL name of the blog site, then click on Create.
    4. Your new SharePoint blog site will be successfully created.

    See steps to create a SharePoint blog at this video:

    Saturday, October 29, 2011

    How to Change the Title and Logo Url of a Sharepoint 2010 Site

    This guide will show how to change the title and the logo URL of your SharePoint 2010 site.
    1. Log into SharePoint.
    2. Navigate to the SharePoint site where you wish to change the title or URL.
    3. Click on Site Actions - Site Settings.
    4. Under Look and Feel, click on Title, description, and icon.
    5. Change the title of your site in the Title field and then specify a description in the Description field.
    6. Enter the Web address or path to the image file you wish to use in the URL field and enter a short description of the image in the Description field.
    7. Click on OK.
    All steps you can see at this video.