Best iPad clients for SharePoint 2010. Part2. Setting Up SharePlus for the iPad

Best iPad clients for SharePoint 2010

SharePlus, your SharePoint data in your hands.

Collaborate with your team, sharing documents, calendars and tasks lists right from the meeting room, a taxi, or when out visiting a client. Browse documents, discussions, announcements, InfoPath forms, reports, wiki pages, custom lists and external list.

SharePlus will work with your current SharePoint credentials, so you won’t have to ask for special permissions to use it. SharePlus doesn’t also require any server side components.

SharePlus is available at three plans: Lite, Pro and Enterprise.

The SharePlus Lite Sharepoint Mobile Solution provides read-only access to SharePoint sites. It enables site, subsite, list, and list item navigation. Supports server side view definitions, and content types. Send documents to third party applications.
Connect to SharePoint
Connect to Microsoft SharePoint server 2010 using any of the following authentication methods: Windows Based, Forms Based. HTTPS SSL and client certificates are supported as well, as Microsoft ISA Server, and Microsoft Forefront Authentication.
Read documents
 Open office documents and PDF files, in an easy to use, scrollable view to read them. Send them to third party apps with the Open In file sharing feature, to edit them. Bear in mind that to save them back to a SharePoint list you will need to upgrade to SharePlus Pro.
Navigate Sites & Lists
 Navigate the structure of sites, subsites, lists, and lists items of a SharePoint server with the user experience of a native app. Browse list items metadata and search within lists.
Sort & Group Items
 Customize the way your data is displayed either by using the server side List View definitions, or by sorting and grouping them in SharePlus, with an easy to use, drag n drop user interface.

SharePlus Pro
Everything the Lite version does, plus read/write support allowing you to add and modify list items, receive documents from third party apps and update them to SharePoint lists. Automatically synchronize entire lists and folders for offline viewing and editing. Enhanced security with app level passcode lock support, and encryption of all cached data with data protection.
Content Management
 Add, edit, and remove list items such as Calendar, Tasks, Pictures, Contacts, Discussion Boards, Blogs, Custom and External Lists.
Automatic Synchronization & Offline support
 Turn on offline support for entire lists, enabling a silent process which automatically stores locally all the lists data, enabling offline access, and even edit support, allowing you to take your SharePoint assets with you no matter what the connectivity is like, ensuring fast access to your data when you most need it.
 Enable passcode lock at the application level providing an additional level of security to your data, which could make the difference in case of theft or loss of your device. Additionally all the data stored locally is encrypted using Apple’s Data Protection guidelines.
Local Files Management
Manage your local files, renaming, removing and grouping contents in folders, zipping and unzipping files.
Document Management
 Edit documents in third party apps, such as Documents To Go, and save them back to SharePlus to update them in SharePoint’s document libraries. Leverage SharePoint’s Check In/Check Out support, as well as Document Approve/Reject features when collaborating on the creation of documents with team members.
Media Recording
 Capture audio and video records with your iPhone or iPad2 and upload them straight to your SharePoint list of choice, allowing powerful multimedia data entry scenarios.
Wifi Sharing
Enable team members to access your device’s data by sharing your SharePlus’s Local Files folder with a web access, making them available to anyone in the network with a web browser.

SharePlus Enterprise
While the Pro version is targeted to the individual, SharePlus Enterprise is meant for in house deployment across companies. It includes rebranding, configuration broadcast to manage uniform connection access settings across workgroups, plus custom on demand features to accommodate the needs and requirements of small to large organizations.
Custom features
 If there’s an additional feature you need to make the most of SharePlus in your organization, SharePlus Enterprise is the right context to request it.
Have your brand, icon and aesthetics displayed in your Enterprise version of SharePlus, this is specially valuable in customer facing scenarios of usage, such as mobile workforces.
Additional Security
 Multi factor authentication and remote swipe are some of the security features usually implemented in the context of SharePlus Enterprise engagements.
Premium support
In a nutshell when one of our Enterprise customers raises an issue, we drop everything to respond to it.
In House Deployment
 Implement your own Enterprise App Store, deciding what get’s approved and what not, releasing updates when you need them, leveraging your mobile workforce. SharePlus Enterprise licenses are distributed in house relying on mobile device managers platforms, such as AirWatch, MobileIron, Sybase Afaria.
Configuration broadcast
Execs rarely like to configure app settings such as SharePoint connections configurations, and offline support. That’s why we provide the ability to have this done once by the IT team, and then pushed to the corresponding devices.
Feature Trimming
Some of SharePlus Pro features may not get along with corporate policies, such as emailing documents from within the app. SharePlus Enterprise allows for feature trimming.

Best iPad clients for SharePoint 2010. Part1. Setting Up Moprise for the iPad

Best iPad clients for SharePoint 2010 overview.

I like to tell you about best iPad clients for SharePoint 2010. Moprise is one of the best iPad clients. You can easily get access to SharePoint 2010 documents.
Moprise is an iOS SharePoint client. The free version allows users to view SharePoint documents, but not edit them. Free version limited to 2 SharePoint sites. The paid version, which costs $14.99 per user, provides more features such as uploading new documents, and Quickoffice integration for editing and you can use it for unlimited SharePoint Sites. Moprise also offers customized installations. Enterprise version is include custom branding, configuration for in-house app store deployment and 1 year premium support.

Many of you are familiar with Moprise for the iPad. Moprise is SharePoint viewer that allows you to access, pull, and email documents to create a magical iPad experience that is easy for users and requires no training. Moprise also saves you time by only requesting your SharePoint log in credentials once. Moprise is also secure.

To set up Moprise please see steps at the getting started video!

What is your SharePoint URL? Where do you get it? How do you pull documents to work on them? What programs can you pull documents into? This video will walk you through, and give you a preview of what you’ll see in Moprise if you haven’t downloaded it yet.

Good luck!


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%ProgramDataMicrosoftSharePointConfig 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%ProgramDataMicrosoftSharePointConfigGUID
  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.

Excel Workbook Publishing, SharePoint 2010 Excel Services

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.

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 as shown below.
  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 as shown in below
  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 as shown below
  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.

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

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!