Wednesday, April 10, 2013

Collaborate editing in Excel by multiple users concurrently in SharePoint 2010


The Excel webapp(Edit in the browser) is the only the procedure to do collaborate editing in Excel by  multiple users concurrently.

Steps:
1.       Choose the file to update
2.       Tick the “Type” field
3.       “Edit in browser”
4.       Update fields
5.       Click on Folder>Test File
6.       Go back to sheet to ensure update is there

References:

http://office.microsoft.com/en-us/excel-help/about-shared-workbooks-HP005262294.aspx
http://www.kraftkennedy.com/blog/bid/102003/Simultaneous-Editing-in-Office-2010-Web-Apps-Only-in-Excel
http://blogs.office.com/b/microsoft-excel/archive/2010/01/21/collaborative-editing-using-excel-web-app.aspx

Friday, April 5, 2013

Step by step Configuring PDF IFilters in Sharepoint2010 Search

Step by step Configuring PDF IFilters in Sharepoint2010  Search

Reference:
http://www.codeproject.com/Articles/82546/How-to-configure-PDF-iFilter-for-SharePoint-Server
http://www.mossgurus.com/adnan/Lists/Posts/Post.aspx?ID=9
http://www.sharepointdiary.com/2011/03/pdf-search-ifilter-configuration.html
  1. Install PDF iFilter 9.0 (64 bit) from here.
  2. Download PDF icon file from pdf16.gif and copy at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\.
  3. Add the following entry in docIcon.xml file, which can be found at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML.
    <Mapping Key="pdf" Value="pdf16.gif" /> 
  4. Add PDF file type on the Manage File Type page under Search Service Application.
  5. Open registry by executing regedit on the Start --> Run.
  6. Navigate to the following location:
    \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\
    14.0\Search\Setup\ContentIndexCommon\Filters\Extension 
  7. Right-click Extension, a menu will appear.
  8. Click New--> Key to create a new key for .pdf. See screen shot below:
  9. Enter .pdf and save key.
  10. Now add the following GUID in the default value as shown in the figure below.
    {E8978DA6-047F-4E3D-9C78-CDBE46041603} 

  11. If you are configuring SharePoint Server 2010, then restart Search service by executing the following command on the command line:
    net stop osearch 
    net start osearch 
  12. If you are configuring PDF iFilter on Search Server 2010, then restart the SharePoint Server Search 14 service as shown in the figure below:
  13. Perform incremental to include PDF files.
  14. PDF iFilter is successfully configured. Now you can search for the content of PDF file. See screen shot below: