Skip to main content

Posts

Showing posts from 2010

Working with SharePoint using Mac - Part 1

We have a lot of friends, customers and business partners who use Mac at home or at work. Some of them would like to work with SharePoint from their Mac, but think that document management side of things will lack the smooth experience that Windows users have.

70% of our team use Mac on a daily basis either in iMac shape or in MacBook shape.
We also are very interested in research different ways how people can get value using technologies that they got used to combined with some innovation.

For those who concern about using Mac when working with SharePoint we will provide the set of articles describing the way it becomes possible to use Mac OS and SharePoint together.

Here's the first one in the series of articles about using Mac to work with SharePoint:
Mac OS X Snow Leopard + Word for Mac 2011

Enjoy.

SQL Server Scripts - Part 1

This post will start a series of useful MS SQL Server scripts.

Here's the one to display all tables and related columns that were created in the certain database:

/* Begin */
SELECT 

a.[TABLE_NAME],
c.COLUMN_NAME

FROM
(
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE (TABLE_TYPE = 'BASE TABLE')
) a

INNER JOIN

(
SELECT
s.[name] as COLUMN_NAME,
tt.name as TABLE_NAME FROM syscolumns s INNER JOIN (SELECT * FROM sysobjects WHERE type = 'U') tt ON tt.id = s.id
) c

ON c.TABLE_NAME = a.TABLE_NAME
ORDER BY a.TABLE_NAME
/* End */

The following script will display just table names:

/* Begin */
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE (TABLE_TYPE = 'BASE TABLE')
/* End */

Enjoy! :)

Issue connecting to SharePoint 2010 Foundation site from iPhone

You can get an error when trying to browse your SharePoint 2010 Foundation site on iPhone or Safari 5.0 browser.

The symptoms: when you navigate to your Web site using its URL as http://mightysharepointsite.com or something you will get the following very descriptive error "Unexpected error - Correlation ID: 1abc234d-ab5c-6789-012a-a1b2c34de5fg Date and time: 03/08/2010 12:54:09 PM".

This error actually means:
"System.ArgumentException: Item does not exist. It may have been deleted by another user.    at Microsoft.SharePoint.SPList.GetItemById(String strId, Int32 id, String strRootFolder, Boolean cacheRowsetAndId, String strViewFields, Boolean bDatesInUtc) at Microsoft.SharePoint.SPList.GetItemByIdSelectedFields(Int32 id,    String[] fields) at Microsoft.SharePoint.SPWeb.GetListItem(String strUrl, Boolean bFields, String[] fields)     at Microsoft.SharePoint.Utilities.SPMobileUtility.GetMobileFileUrl(String absolutePath, SPWeb web) at Microsoft.SharePoint.Utilities.SPU…

Working with Managed Metadata in SharePoint 2010 - Term Set Management

Initially I published an article Working with Managed Metadata in SharePoint 2010 here I want to illustrate some core functionality that is available when you want to manage Managed Metadata.

In the Site Settings select "Term store management" item:


Then select the term set you would like to manage. In my scenario I want to create a term set to store Document Categories. For example I have two categories: Accounting, Technical.
So first I select a metadata group that you want to update and select "New Term Set" command:



I call it Document Categories and Save it. Then I select this new term set and choose "Create Term" command:

To create "Accounting" term:


Then create as many terms as I want to get Accounting and Technical as I wanted:


You can also do other command with your terms - Copy, Reuse, Merge, Deprecate, Move, Delete:


After that I add Managed Metadata to my content type that I use for documents, select Document Categories Term Set and I c…

SharePoint 2010 & Ubuntu

Last week I worked 2.5 days doing SharePoint 2010 using Ubuntu 10.04 installed on my 6 yo laptop.

Laptop: Samsung P28, Intel Celeron M, 1Gb RAM, 40Gb HDD, WiFi network adapter. Browser: Mozilla Firefox for Ubuntu canonical 1.0

Tasks I was able to do in regard to SharePoint implementation:

- Document management. Creating documents using OpenOffice then uploading them into SharePoint via browser.
- Management of custom lists, content types, site columns, views etc. All site settings available from Web browser UI.
- Forms Authentication and Search set up. I used rdesktop to connect remotely to the SharePoint Web and Application server.

Positive:
- I have got most of the new features of user experience: ribbon, menus, styles etc.
- If I don't need custom Web applications development for SharePoint or SharePoint Designer work on my laptop or other client machine I can use Open Source and free software easily. Anyway Visual Studio and SharePoint Designer could be installed straight on …

SharePoint 2010 Search Issue - FQDN Crawl

I have recently set up a standalone SharePoint 2010 environment.

The Web application was created with host header and the site collection is accessible from the client machines, but not internally. That was because of using FQDN to access the Web site.

The error when I tried to access site internally was similar to the one described here:

You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or a later version

And the search returned the following error in the Event Log:

"The start address cannot be crawled.

Context: Application 'Search_Service_Application', Catalog 'Portal_Content'

Details: This item could not be crawled because the crawler could not connect to the repository."

One of the suggestions was to disable the loopback check, but that would compromise the Web server.

So what I have done was:

1. Added a binding to my IIS Web site for a different port. Let's say my Web server name is win-v7m…

InfoPath 2010 and SharePoint 2010 - Part 1

SharePoint 2010 together with InfoPath 2010 is a great improvement since 2007 version of both products.
This post will show you how easy it is now to capture information to SharePoint with InfoPath 2010.
1. I will not use Form Library in this scenario, because to me there is no difference, but even I will have some advantage of using Custom List rather than Form Library. OK, I created a custom list called Sales Orders and added some columns: Order Status - choice, Account Manager - person or group and Reference - single line of text:

2. Then I went to modify the list form in InfoPath:



3. When the InfoPath is opened you can see all the columns from the custom list and a basic layout set up already. If you are familiar with InfoPath 2007 you see how much is improved in 2010:



4. Let's change some colours and add some text:



5. Publish - there is a tiny button in the top left corner of the screen called Quick Publish:

6. When the form is published you can go and add new list item:



As you …

Document Sets - SharePoint 2010 - Part 1

Hi again, in this post I am going to demonstrate how set up and start using Document Sets in SharePoint 2010.
In Beta version there was a little problem when working with Document Sets. You could see the discussion around it here: Document Set content type issue. Now it is fixed and I will show you how to set up Document Sets properly to also use Keywords.

1. Activate two site collection features - Document Sets and Document ID Service:


2. Select a document library settings where you want to implement Document Sets. In my case it is Shared Documents. When you have selected the settings go to Advanced settings and then allow content types management:



3. Add an existing content type called Document Set:



4. Now I want to create a new Document Set. I have a sales opportunity and I have two documents related to this sales opportunity. So first I select New Document -> Document Set command, then provide name and description and there it is:


5. To check if our Document ID is working just …