11/29/2011

SharePoint on a Mac Video


SharePoint 2010 on a Mac from Dux Raymond Sy on Vimeo.

SharePoint 2010 on a Mac OSX Compatibility List

Creating and Editing SharePoint Content

ContentFeature Description Works on an OS X Mac?
Document Library Stores collections of documents Yes
Form Library XML Based business forms No (Requires InfoPath)
Picture Library Store and share photos. Yes
Links List of Web and file share links Yes
Announcements List of announcements Yes
Contacts Contact database Yes
Events Calendar of events Yes
Tasks List of taks Yes
Issues An issues tracking database Yes
Custom List Specify your own columns Yes
Custom List in Datasheet View Edit a custom list as a Datasheet No
Import Spreadsheet Create a new list from an existing spreadsheet No
Discussion Board Discuss issues related to project Yes
Survey Create a survey for users Yes
Basic Page Create a new simple Web page Yes
Web Part Page Add a Web page consisting of Web Parts Yes
Sites and Workspaces Create a new sub site to your SharePoint Yes  


Import Excel Spreadsheet to a SharePoint 2010 Custom List

Import data from Excel into SharePoint 2010. We have the following Excel containing usage data of different browsers over the months.
import
Go into SharePoint 2010 and select the option “More options…” under “Site actions”.
import2
This will open the create dialog of SharePoint 2010 which normally allows you to create content like sites, pages and lists. Look for something called “Import spreadsheet” and press the “Create” button.
import3
“Import spreadsheet” will create a custom list from an Excel data file. Give the custom list a name and use the browse functionality to select the earlier mentioned xlsx file. Click on the “Import” button to start the import.
import4
This will open Excel and let you select the range of cells to import into the custom list of SharePoint 2010. The first row in the Excel sheet will define the column names.
import5
When the “Import” button is clicked the Excel sheet is closed and the new custom list is opened in SharePoint 2010. As you can see the columns are based on the first row of the selected data. The data is not linked in any way back to Excel. So you will need to export it again to get linked data. The custom list is standard SharePoint and will allow you to do anything with this list what would be possible in SharePoint 2010.

"The specified file is not a valid spreadsheet or contains no data to import" Error When Importing an Excel Spreadsheet into SharePoint 2010

In Internet Explorer click Tools --> Internet Options.
Click Security --> Trusted Sites > Sites --> and add your site name.
Make sure to enter both the http and https form of the URL.
You'll need to uncheck the box for "require sever verification"