Social Business and Mobility: How can mobility contribute to social business?

This is an article also published by the same author at:
http://www.uniqueworld.net/blog/mobility-contribute-social-business/

---

Two of the hottest trends right now are social business and mobility.

When people talk about social business, most often the first thing that springs to mind is: How do you create a tool that reaps the same benefits as Facebook, Google+ and Twitter?

In terms of mobility, the issue becomes: How can mobility contribute to the benefits of social business?

When you look at the statistics for Facebook, there is a rapidly growing trend for users to access via mobile. In fact, in 2012, of the 845 million Facebook users, 425 million are mobile users. That is 50.3%!

But just how big is this trend? According to a prediction by Morgan Stanley in April 2010, the number of mobile users will surpass desktop users in 2014. With an explosion in enabling technologies from Apple (iPads, iPhones), Google (Android OS), and Microsoft (Windows 8, Windows Phone 8), I can only see even greater acceleration in the adoption of mobile technologies.

These consumer trends will have an impact on how we work in the enterprise. The question is HOW will it impact the enterprise?

This YouTube presentation provides an eye-cathing overview of the growth in mobile phones to the end of 2012.

https://www.youtube.com/watch?v=0aUQLIPdtg8

I should now explain what I mean by social business and mobility.

Social Business?

Social Business is all about revolutionising how companies operate and bringing value to all employees, customers, partners, suppliers and stakeholders. It is about bringing together, connecting and engaging both internal and external individuals of an organisation to form an ecosystem. It requires an organisation to implement strategies, processes and tools to achieve the level of engagement from all parties in order to optimise the value that is generated.

Mobility?

No, I do not mean traveling on a motorised scooter! I’m actually referring to mobility in terms of accessing information from various portable devices at any time.

So how does mobility assist in social business?

Many of us have already adopted mobile technology like smart phones and tablets outside of work, and have got used to accessing cool apps that allow us to do things such as reading about our friend’s cat or their unusual interests. But when we take these devices to work and expect to do the same, we find we access can’t access information in the same way on mobile devices at work.

The main benefit of mobility for organisations is it accelerates adoption and provides agility, bringing additional value to existing applications and information. Mobility also comes with other benefits:

• Agility: Mobile devices (Smart Phones and Tablets) enable individuals to stay connected any time, wherever they are.
• Additional access channels (Mobile access): Mobile devices offer a convenient alternative for individuals to connect.
• Ease of access: Mobile devices are always on, and mobile applications are lightweight, easy to use.
• Low cost: Mobile applications are relatively easy and quick to develop.
• Sensor packed: Mobile devices contain many built-in capabilities that desktops do not always have (geolocation sensors, gyroscopes, cameras, microphones, NFC, and more). These added capabilities can come in handy for an organisation.

Mobility however comes with some risks in areas such as:

• Security: Mobile devices are unfortunately easier to lose, vulnerable to hacking and viruses. They contain so many apps (and information with it) that can be accessed without a password, they suddenly becomes a risk in the eyes of the IT department.
• IT governance: Because of the security risks involved, IT departments want to introduce policies to control the security on mobile devices. Fortunately, mobile platforms are acknowledging the need for governance and introducing features to help in this regard.
• Privacy: This is a difficult one. Mobile devices by nature are designed to be used anywhere. When sensitive information is viewed in public areas, will this pose an issue to your organisation? However, if your organisation’s social tools are opened up to people outside the organisation, does it still pose such a threat?

With each benefit it brings, mobility introduces risks, but many can be mitigated with appropriate measures.

So, who are the main players that offer mobility for the enterprise?

Currently in the market there are a number of social tools available for the enterprise. Most social mobile apps extend access to enable users to join communities, micro blog, view activity streams, and more. The point here is all these apps aim to increase engagement with more ease.

The main players in the mobile social space are:

• NewsGator


• Jive


• Telligent


• Yammer

What can we do with social business and mobility?

Besides these pre-baked mobile apps, your organisation may need to extend other social applications as mobile apps (crowdsourcing or mining information from social responses, etc).

Regardless of what mobile apps are available or possible, it is important not to get lost in the hype and excitement. It is important to understand how it will assist your organisation to achieve its strategic goals.

Ask the business:

• What is the purpose?
• How will it bring value?
• What are your goals?
  
  
  
  • Improve communication?
  • Improve engagement?
  • Improve efficiency?
  • Improve access?
  • Improve productivity?
  • Increase lead generation?
  • Reduce communication costs?

Who is the audience?

• Customers?
• Sales people?
• Executives?
• Ground staff?

What is the business trying to achieve through social business?

• Is it to empower your mobile workforce with access to the tacit knowledge?
• Is it to make it easier to find the right matter expert?

How can mobile access help contribute to these goals?

What are the common daily processes and tasks?

How do people currently use their mobile devices for work?

I’d advise organisations not to get mobility tools for the sake of having the latest and greatest. Rather, they should focus on the purpose and role of mobile access in social business. Think how mobility can help deliver benefits to the organisation, then then think how mobility can contribute to social business.

Windows 8 - Where did my Hibernation option go? How to get the Hibernation option back in Windows 8.

So you've upgraded to Windows 8, all is good until you try to hibernate your Windows 8 PC. By default the hibernation option is disabled.

To get the Hibernation option back, follow these steps:

1. Open up File Explorer.

2. Click Computer (from the left) and then click "Open Control Panel" from the Computer ribbon.

3. Open "Power Options" from the "Control Panel Items" window.

4. Click "Choose what the power buttons do" option from the left.

5. Click "Change settings that are currently unavailable" option from the left (if it appears).

4. Tick the check box adjacent to "Hibernate" and click "Save Changes".

Your power menu options should now look like this:

SharePoint 2010: Using the SharePoint Client Model to populate a jQuery AutoComplete box

Intro

It's been a while since I did some coding - I've been playing more of a Business Consulting role, but sometimes still get to have some fun :)


My favourite thing about jQuery, is the jQuery UI Toolkit. Amongst it is an Autocomplete menu control as described here - http://jqueryui.com/demos/autocomplete/. You can download the tool kit, and even style it using the themeroller. 

The ingredients include:
1. Getting jQuery to run on a SharePoint Page/Custom Web Part
2. Getting the HTML and jQuery working
3. Getting the SharePoint Client Object Model (OM) working
4. Getting the jQuery Autocomplete to work together with the SP Client OM.

Benefits

Why should we use this approach? If you have a need for an autocomplete menu, and need it to be loaded on the fly whilst typing, then this may most likely be your solution!

Getting Started

To start, there are a couple of options:
A. Create a HTML file and save the code on this page into this file. Upload the file into the Site Assets library, and on any web part zone in SharePoint, add a Content Editor web part. In the web part properties, add a Content Link to this html file. I find this approach to be quickest whilst developing.

B. Directly place the HTML+jQuery code into a Content Editor web part using the "Edit HTML Source" option from the Ribbon (SP will tend to change your HTML for you in this option)

C. Write a custom web part to render this HTML+jQuery, including features that deploys delegate controls to register <link> lines to the jQuery library, etc. (Production quality)

1. Running JQuery on a SharePoint Page

I've tried to add jQuery on a SharePoint page so many times, however the jQuery just doesn't run at times. What do we do?


The trick is to have the JavaScript initiation code inside the following code block:



<script type="text/javascript">
    JSRequest.EnsureSetup();
    $(document).ready(function () {
        ExecuteOrDelayUntilScriptLoaded(EntryPointFunction, "SP.js");
    });
</script>



This block will allow any scripts (EntryPointFunction in the example above) to run after any SharePoint JavaScript.

2. JQuery AutoComplete Menu

This is an awesome control - The code required includes the  jQuery, and the HTML:


<script type="text/javascript">
$("#tags").autocomplete({ source: dataSourceArray });
</script>


<input type="text" id="tags" />


There are many options to setting up this autocomplete control, however it's all documented in the jQueryUI link above, so I'll skip through that.

3. SharePoint Client OM Script to query list data

And below, is the JQuery to get the SharePoint Client OM to query data from the list "Data". It returns the values from the "Title" field where the title contains "Test". Notice the CAML query on the line query.set_viewXml. 

When the query values are returned from the call after ctx.executeQueryAsync, the getDataWithQuerySuccess function will run - this is where our fun starts.

There's a while loop which helps us build up an array of Titles. If you need multiple dimensions (which the autocomplete box will support), you can use this instead:

 availableTags.push(

{ 

label: listEnumerator.get_current().get_item("Title"), 

id: listEnumerator.get_current().get_item("ID") 

});

But you will need to change the jQuery to handle this. Anyhow the Code will now look like this:

<script type="text/javascript">

    JSRequest.EnsureSetup();

    $(document).ready(function () {

        ExecuteOrDelayUntilScriptLoaded(loadData, "SP.js");

    });

    function loadData() {

        var selectedItems;

        filterData();

    }

    function filterData() {

        var ctx = new SP.ClientContext.get_current();

        var lst = ctx.get_web().get_lists().getByTitle('Data');

        var query = new SP.CamlQuery();

        query.set_viewXml("<View><Query><Where><Contains><FieldRef Name='Title'/><Value Type='Text'>Test</Value></Contains></Where></Query></View>");

        selectedItems = lst.getItems(query);

        ctx.load(selectedItems);

        ctx.executeQueryAsync(getDataWithQuerySuccess, getDatasWithQueryFailure);

    }

    function getDataWithQuerySuccess(sender, args) {

        var availableTags = new Array();

        var listEnumerator = selectedItems.getEnumerator();

        while (listEnumerator.moveNext()) {

            availableTags.push(listEnumerator.get_current().get_item("Title"));

        }

    }

    

    function getDatasWithQueryFailure(sender, args) {

    /*Error Logic here*/

    }

</script>

4. JQuery AutoComplete Menu with SP Client OM Script

The last step is to combine the SP Client OM code with the jQuery AutoComplete Menu. I've included the whole piece with the styles, and script references as well below:



<link href="/_layouts/SPSix/css/ui-lightness/jquery-ui-1.8.20.custom.css" rel="stylesheet" />
<script src="/_layouts/SPSix/js/jquery-1.7.2.min.js"></script>
<script src="/_layouts/SPSix/js/jquery-ui-1.8.20.custom.min.js"></script>
<style type="text/css">
    .inputwarning
    {
        border: 1px solid #F75D59;
        padding: 2px;
    }
    .ui-autocomplete
    {
        max-height: 200px;
        overflow-y: auto; /* prevent horizontal scrollbar */
        overflow-x: hidden; /* add padding to account for vertical scrollbar */
        padding-right: 20px;
    }
    /* IE 6 doesn't support max-height
* we use height instead, but this forces the menu to always be this tall
*/
    * html .ui-autocomplete
    {
        height: 200px;
    }
</style>
<script type="text/javascript">
    JSRequest.EnsureSetup();
    $(document).ready(function () {
        ExecuteOrDelayUntilScriptLoaded(loadData, "SP.js");
    });


    function loadData() {
        var selectedItems;
        $('#tags').keyup(function (event) {
            filterData();
        });
    }


    function filterData() {
        var ctx = new SP.ClientContext.get_current();
        var lst = ctx.get_web().get_lists().getByTitle('Data');
        var query = new SP.CamlQuery();
        query.set_viewXml("<View><Query><Where><Contains><FieldRef Name='Title'/><Value Type='Text'>" + $('#tags').val() + "</Value></Contains></Where></Query></View>");
        selectedItems = lst.getItems(query);
        ctx.load(selectedItems);
        ctx.executeQueryAsync(getDataWithQuerySuccess, getDatasWithQueryFailure);
    }


    function getDataWithQuerySuccess(sender, args) {
        var availableTags = new Array();
        var listEnumerator = selectedItems.getEnumerator();
        while (listEnumerator.moveNext()) {
            availableTags.push(listEnumerator.get_current().get_item("Title"));
        }
        $("#tags").autocomplete({ source: availableTags });
    }
    
    function getDatasWithQueryFailure(sender, args) {
    /*Error Logic here*/
    }
</script>
<span>Enter Keywords: </span><input type="text" id="tags" />

5. Now what?

What's next? Using the AutoComplete Menu Select event, you can add additional functionality when the user selects the autocomplete box. Some examples of how I've used this:

• As a replacement of default SharePoint drop downs that only support a begins with type ahead.
• As a filter for custom web parts that require special query strings or parameters.
• And more... Share your ideas with me below!

Basically the options are endless!

Have fun!

SharePoint 2010: Tip of the Day - Finding what level of SharePoint 2010 is installed?

This is a quick tip bought to by SharePoint Six!

Tip 1: To quickly find out the build level of SharePoint 2010 using Powershell, use the following commands:

$farm = Get-SPFarm
$farm.BuildVersion

Tip 2: For a list of build numbers, go to Joe's blog: http://blogs.technet.com/b/sharepointjoe/archive/2011/02/01/sp2010-sharepoint-2010-build-level-and-version-numbers.aspx

Tip 3: For the latest patches, go to this site: http://technet.microsoft.com/en-us/sharepoint/ff800847.aspx

SharePoint: I'm presenting at SharePoint Saturday Sydney 2011

I'm so excited! I'm presenting at SharePoint Saturday Sydney 2011!

I'll be discussing about "Applying Content Type Hubs and Managed Metadata To Improve Document Management in the real world". Hope to see you all there on the day for a fruitful session!

The abstract for the session is below:

"SharePoint 2010 offers a suite of new and enhanced capabilities, which if utilised effectively in select business scenarios can bring enormous value to organisations. Document Management is one area where SharePoint 2010 offers many new features and benefits. This session covers two new document management capabilities: The Content Type Hub and Managed Metadata. Douglas will walk through the anatomy of Content Type Hubs and Managed Metadata, recommended approaches, constraints and how to best work around these constraints. A number of typical document management scenarios will be used throughout the session to demonstrate the concepts and keep it real. If time permits, he will also share some C# code snippets which support the scenarios described."

For more information:
http://www.sharepointsaturday.org/sydney/Pages/meetings.aspx

SharePoint 2010: PSConfiguration issues with GetUserPropertyFromAD call

Problem
As I was installing SharePoint 2010 at client site, I came across an error I've never seen previously. During the SharePoint 2010 "Configuration Wizard Step 3 - creating configuration database",  the operation failed.


Symptoms
The error in the Configuration Wizard was:

Failed to create the configuration database.
An exception of type System.Collections.Generic.KeyNotFoundException was thrown. Additional exception information: The given key was not present in the dictionary.
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

Matching Error in the installation logs was:

04/14/2011 10:51:06  9  ERR                    Task configdb has failed with an unknown exception
04/14/2011 10:51:06  9  ERR                    Exception: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.   at System.ThrowHelper.ThrowKeyNotFoundException()   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)   at Microsoft.SharePoint.Utilities.SPUtility.GetUserPropertyFromAD(SPWebApplication webApplicaiton, String loginName, String propertyName)
   at Microsoft.SharePoint.Administration.SPManagedAccount.GetUserAccountControl(String username)   at Microsoft.SharePoint.Administration.SPManagedAccount.Update()   at Microsoft.SharePoint.Administration.SPProcessIdentity.Update()   at Microsoft.SharePoint.Administration.SPApplicationPool.Update()   at Microsoft.SharePoint.Administration.SPWebApplication.CreateDefaultInstance(SPWebService service, Guid id, String applicationPoolId, SPProcessAccount processAccount, String iisServerComment, Boolean secureSocketsLayer, String iisHostHeader, Int32 iisPort, Boolean iisAllowAnonymous, DirectoryInfo iisRootDirectory, Uri defaultZoneUri, Boolean iisEnsureNTLM, Boolean createDatabase, String databaseServer, String databaseName, String databaseUsername, String databasePassword, SPSearchServiceInstance searchServiceInstance, Boolean autoActivateFeatures)   at Microsoft.SharePoint.Administration.SPWebApplication.CreateDefaultInstance(SPWebService service, Guid id, String applicationPoolId, IdentityType identityType, String applicationPoolUsername, SecureString applicationPoolPassword, String iisServerComment, Boolean secureSocketsLayer, String iisHostHeader, Int32 iisPort, Boolean iisAllowAnonymous, DirectoryInfo iisRootDirectory, Uri defaultZoneUri, Boolean iisEnsureNTLM, Boolean createDatabase, String databaseServer, String databaseName, String databaseUsername, String databasePassword, SPSearchServiceInstance searchServiceInstance, Boolean autoActivateFeatures)   at Microsoft.SharePoint.Administration.SPAdministrationWebApplication.CreateDefaultInstance(SqlConnectionStringBuilder administrationContentDatabase, SPWebService adminService, IdentityType identityType, String farmUser, SecureString farmPassword)   at Microsoft.SharePoint.Administration.SPFarm.CreateAdministrationWebService(SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)   at Microsoft.SharePoint.Administration.SPFarm.CreateBasicServices(SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)   at Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword, SecureString masterPassphrase)   at Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, String farmUser, SecureString farmPassword, SecureString masterPassphrase)   at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()   at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()   at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

The cure 
I checked the permissions for the SharePoint installation account on the MS SQL Database - it seemed to already have the correct security roles assigned (dbcreator and securityadmin).


I then noticed this line in the error logs: "Microsoft.SharePoint.Utilities.SPUtility.GetUserPropertyFromAD"


It's now apparent that psconfig is failing when trying to read a User Property from Active Directory. It turned out the domain had been setup so that domain accounts do not have access to read AD Properties. I simply gave the "Setup Administrator" and "Farm Account" accounts read permissions.

SharePoint 2010 - SharePoint 2010 just got quicker. The latest patch is doing it’s job!

I’m running Windows 7 on a Dell Latitude E4300 4GB RAM with SharePoint Server 2010 installed for development and demo purposes. In the beginning SharePoint was running with an acceptable performance, but sometimes there would be a little wait here and there.

A few days ago Microsoft released an update for SharePoint Foundations 2010, which it claimed would improve stability and performance.

Guess what? After it was installed, I browsed my SharePoint sites using Chrome – man, it was lightning fast! Was it Chrome? Don’t think so. Same quick response in Internet Explorer 8! The performance is noticeably MUCH quicker. Great job guys!

This is the patch I installed:
Update for Office SharePoint Foundations 2010 (KB2032588)

“Microsoft has released an update for Office SharePoint Foundation 2010, 64-bit Edition. This update provides the latest fixes to Microsoft WSS 2010, 64-bit Edition. Additionally, this update contains stability and performance improvements.”

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=f6f1d567-a21f-4770-80ba-f7d6e05f11aa

SQL Versions – Tip of the day

I was installing SharePoint 2010 – wait, what about the pre-requisites?
- SQL 2005 SP3 with Cumulative update package 3
- OR SQL 2008 SP1 with Cumulative update package 2

So what version have we got? Here’s the tip of the day (for me and to you to share), run this SQL Query to find out:

SELECT serverproperty('productversion'),
       serverproperty('productlevel'),
       serverproperty('edition') 

This should give you information to determine the version number, the release level (RTM or Service Pack), and the edition (Express, Standard or Enterprise).

For convenience, I’ve added the version numbers required for SharePoint 2010:
- SQL 2005 SP3  - 2005.90.4035
- SQL 2008 SP1 – 2007.100.2531.0


For more version numbers go to http://support.microsoft.com/kb/321185.

Referenced from this Microsoft KB http://support.microsoft.com/kb/321185

From Developer to Architect?

For a few years now, I’ve been coding on .NET, SharePoint, and the like. I went to University and learnt about Object Orientation. I hardly noticed nor appreciated the many OOP concepts that I’ve unconsciously applied to my coding/solution design. Dare I say it, I think this may describe many developers with around 2-4 years of coding experience up their belts.

I recently started reading a few articles online and came to realisation of the extent to the level of OOP concepts that have actually been applied. It made more sense why some of solutions worked better than others (of which include both .NET and SharePoint solutions).

Like many others, I’ve just had the time to understand and learn how to use API’s and/or how to ‘structure’ code to get the job done in the least amount of time with the best quality (least amount of bugs), but never to understand some software architecture concepts. Take my tip, re-learn the concepts that reflect what you already know – a design pattern.

Here are the links I have referred to:

• Introduction to Object Oriented Programming Concepts (OOP) and More
• Design Principles and Design Patterns
• Object Oriented Design Principles and Patterns

Microsoft SharePoint Server 2010 – Certifications?

I just read an official note that there will be new four SharePoint 2010 certifications – and they are not specific to either SharePoint Foundation 4 or SharePoint Server 2010.

These exams are:

• 70-667: TS: Microsoft SharePoint 2010, Configuring
• 70-668: PRO: Microsoft SharePoint 2010, Administrator
• 70-573: TS: Microsoft SharePoint 2010, Application Development
• 70-576: PRO: Designing and Developing Microsoft SharePoint 2010 Applications

According to this blog post, the exams are expected to be available in June/July timeframe. More details here.

Microsoft SharePoint 2007 – ItemAdded/ItemAdding List Event Receivers and SPFieldUserValue.User not returning SPUser

 

The Problem
I recently had to develop an Event Receiver that would require reading off the SPUser object of the item. What I found is that, at times when the exact name of the user is entered (and you click OK on the NewForm.aspx page without clicking the check name   button), the SPFieldUserValue will return

–1;#domain\username

rather than

23;#domain\username.
 

This is a problem when you try to access the SPFieldUserValue.User (SPUser type) property and it returns null.

The Solution
The solution was to get the SPFieldUserValue as a string, and then use the username to then try and resolve for the SPUser object. My rough cut out code is attached – quickly modified for this example. (*Use at your own risk. Is also why I don’t usually post code on my blog!)

Microsoft SharePoint Server 2010 Beta 2 – How to recover data from an unattached content and restore it to a (or another) site

A new feature in SharePoint 2010 is the ability to recover content from an unattached database (also tested to work for attached databases). The following are steps to do this (in case I forget in the future).
Note of warning: Screen shots and directions in this entry are based on SharePoint 2010 Beta (v. 14.0.4536.1000) and may change without notice.
I. Export from Database
1. Within Central Administration v4, browse to “Backup and Restore” section in the Quick Launch

2. Click “Recover data from an unattached content database”:

3. On the “Unattached Content Database Data Recovery” Page, enter the database server and database name of the source database to restore from, select “Browse content”, and click Next:

4. Select the Site Collection from the Database, the site from the database and the List as required, select “Export site or list”, and click Next (Note – this screen shot is based on a Beta version, and it appears that even though you have the correct site collection selected, the URL shows the central administration url. Only the relative URL is correct here):

5. Type in a file share location (ensure the SharePoint Farm account has owner access to this folder in Windows), and click Start Export:

6. Wait for the job to complete:


7. Files will be created in the share directory (Note: Contents of the .cmp file can be opened as a cab file – just like most other wsp packages):

II. Import to new Site
1. Open up the SharePoint 2010 Management Shell


2. Let’s assume we have already created a blank site to be restored to @ dougleung.com. We will now restore to that SharePoint Site:
Run this command in the Management Shell:
Import-SPWeb –Identity [url] –path [path]
eg. Import-SPWeb –Identity http://dougleung.com –path \\servername\folder\exportfile.cmp

3. Your contents from your export file (in this case the exported Announcements list) will be imported to the dougleung.com site.

Microsoft SharePoint 2010 Beta – Developer Resources

I was browsing around to dig more on SharePoint 2010 developer resources trying to get my head around more SharePoint 2010 knowledge. Some very useful resources for starters:

Get Started Developing on SharePoint 2010
http://msdn.microsoft.com/en-au/sharepoint/ee513147.aspx
This page includes 10 series of video tutorials on SharePoint 2010 development with topics including Building SP 2010 Web Parts, SharePoint 2010 concepts, Accessing SP 2010 data with server/client side APIs, Access external data with BCS, SP 2010 Workflows, Creating Silverlight UIs for SP 2010 solutions, Sandboxed solutions and Dialogs and Ribbon controls for SP 2010.

SharePoint Foundation 2010 and SharePoint Server 2010 SDK:
http://msdn.microsoft.com/en-us/library/dd776256.aspx
This SDK has been publicly online since the SharePoint 2010 Sneak Peak web site was available.

The main important links I want to put up for myself are:
What’s New in SharePoint Foundation 2010:
http://msdn.microsoft.com/en-us/library/ee539826%28office.14%29.aspx

What’s New in SharePoint Server 2010:
http://msdn.microsoft.com/en-us/library/ee557323%28office.14%29.aspx

Looks like I am on a steep learning curve… yet exciting and worth while!

Office Web Applications (Tech Preview) in Windows Live

We’ve seen Google Docs, we’ve see Microsoft Office – but we haven’t yet seen Microsoft Office applications running as a Windows Live service. The Windows Live team announced on their blog today the release of a ‘Tech Preview’ to a “select group of SkyDrive" customers”.

As the a consumer, I am extremely delighted on the news as I was never really a fan of Google Docs. It’s great to get free access to a fully functional and fully featured MS Office over the web :)

Sounds interesting? Check out the Video below.

Source: http://windowslivewire.spaces.live.com/blog/cns!2F7EB29B42641D59!41451.entry?wa=wsignin1.0&sa=434146655

MOSS 2007 – User Profile Imports and LDAP Cheat Sheet

 

I’ve tried to get an instance importing but still with no luck – there must be something else preventing it from importing… Anyways, I decided to write down my research for the day:

Default SharePoint settings are:

Search Base: dc=domain,dc=company,dc=com
Base Query: (&(objectCategory=person)(objectClass=user))

Options:

Options for Search Base:
- Can define a specific OU to base the import on. eg. ou=Sydney,ou=Department1,dc=domain,dc=company,dc=com

Options for LDAP Filter Query:
Get all accounts with email address:
(&(objectCategory=Person)(objectClass=User)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(email=*))

Get active accounts – filter our disabled AD accounts:
(&(objectCategory=person)(objectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2))

Get accounts in the Department1 OU:
(&(objectCategory=Person)(objectClass=User)(memberof:1.2.840.113556.1.4.1941:=(CN=Authenticated Users,OU=Department1,DC=domain,dc=company,dc=com)))

Get accounts with a first name:
(&(objectCategory=Person)(objectClass=User)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(!(!givenName=*)))

 

Good References:
Scope of Query – Base, One Level, Subtree: http://msdn.microsoft.com/en-us/library/aa746467%28VS.85%29.aspx

LDAP Search Filter Syntax:
http://msdn.microsoft.com/en-us/library/aa746475%28VS.85%29.aspx

Importing Specific group into SP User Profile Store with LDAP:
http://mindsharpblogs.com/wayne/archive/2005/06/15/497.aspx

LDAP Attributes:
http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm#LDAP_Attribute_

A Nice LDAP Attribute Table:
http://www.it.ufl.edu/projects/directory/ldap-schema/attributes.html

Assemblies – A good read on AnyCPU, x86, and x64

Just read the following blog spot by Eugene Rosenfeld, a MOSS MVP, about assembly compilations. In my opinion, a very good to read article:

http://thingsthatshouldbeeasy.blogspot.com/2009/08/anycpu-x86-x64-whats-difference.html

Time Capsule 2006 to 2009 - The Technologies of a technical consultant

I was sitting on the train today, thinking about the technologies I have worked with in the last three years. And you know what? I have to say web technologies have developed extremely quickly (Well of course it is!). Being a consultant allows me to indulge myself into the latest technologies, and most of the time, take the latest technologies for granted.

Sometimes I think it is actually quiet an effort to keep up (yet I have to for my passion and profession). What I mean for example is say, you install an SDK for Silverlight 2.0, work with it a little while, then you will find yourself installing the SDK for Silverlight 3.0 (And of course with that Visual Studio 2010)! It is hard work to keep up, but it is worth it!

I've worked with SharePoint 2003, I'm working with SharePoint 2007 technologies and now with the sneak peak at the exciting SharePoint 2010, I have to say being a techy guy is the best job in the world! It is very rewarding to see Microsoft listening to customers, giving them what they want. I dig the new BCS, I dig the new ribbon within the web browser, I dig multi-item checkouts, I dig the new developer tools, I dig the new backup and restore tools, I dig the new central admin.....I dig it, I dig it, I dig it! Then again, it is hard work to keep up, but it is worth it!

Anyways, the purpose of this is to keep a time capsule of the (non beta) technologies I have played within the 3 yr period. Who knows how many of these technologies will stay in my list? Here goes...

2006-2009:
Microsoft Technologies

• C#/VB
• ASP.NET
  
• .NET 1.0, 1.1, 2.0, 3.0, 3.5
• SQL 2000, SQL 2005, SQL 2008
• Windows 2000, Windows 2003, Windows 2008, Windows XP, Windows Vista, Windows 7
  
• Microsoft CRM 3.0
• Microsoft CRM 4.0
• WSS 2
• SharePoint Portal 2003
• WSS 3
• MOSS 2007
• MS Office 2003/2007
  
• Microsoft Search Server 2008 and FAST
  
• Silverlight 1.0
• Silverlight 2.0
• Internet Explorer 6.0/7.0/8.0
  

Third Party

• Javascript and AJAX
  
• JQuery
• Flash
  
• DotNetNuke
• SugarCRM
• Meridio
• HP Trim
  
  

Silverlight 2.0 – Silverlight Apps calling asmx web services

A while back I worked on a Silverlight application that was hosted in SharePoint. The Silverlight application was to call a web service written by a third party vendor in .NET 2.0.

Problem
As what we all normally would do in a Silverlight app is to call this web service. However, I got the following error when my application tries to call the asmx web service:

“An error occurred while trying to make a request to URI 'http://localhost:1000/webservice.asmx'. This could be due to attempting to access a service in a cross-domain way without a proper cross-domain policy in place, or a policy that is unsuitable for SOAP services. You may need to contact the owner of the service to publish a cross-domain policy file and to ensure it allows SOAP-related HTTP headers to be sent. Please see the inner exception for more details.”

Solution

After some research, I found a recipe to get it going again:

1. Create a new file within the web service application (at the root of the requesting domain), called clientaccesspolicy.xml with the following contents:
   
   
   <?xml version="1.0" encoding="utf-8"?>
   <access-policy>
   <cross-domain-access>
   <policy>
   <allow-from http-request-headers="*">
   <domain uri="*"/>
   </allow-from>
   <grant-to>
   <resource path="/" include-subpaths="true"/>
   </grant-to>
   </policy>
   </cross-domain-access>
   </access-policy>
   
   
   
2. Create another file within the web service application(at the root of the requesting domain), called crossdomain.xml with the following contents:
   
   <?xml version="1.0" encoding="utf-8"?>
   <cross-domain-access>
   <allow-http-request-headers-from domain="*" headers="*"/>
   </cross-domain-access>

After adding these policy files, my app started working. Hope this helps.

References

http://timheuer.com/blog/archive/2008/04/06/silverlight-cross-domain-policy-file-snippet-intellisense.aspx

http://timheuer.com/blog/archive/2008/06/10/silverlight-services-cross-domain-404-not-found.aspx

Microsoft SharePoint 2007 – Renaming a MOSS Server

This is the N-the time I’ve had to rename a SharePoint server, and every time I keep on forgetting the exact steps… so these are notes for the (Technical) me.

1. Change each alternate access mapping for MOSS 2007/WSSv3 deployment in Central Admin reflecting new server name
2. Register the change with SharePoint, using:
   
   stsadm -o renameserver -newservername <newname> -oldservername <oldname>
   
   
3. Rename server in Windows
4. Restart server
5. Post restart, update SharePoint farm credentials using:
   
   stsadm -o updatefarmcredentials -userlogin <domain\domainuser> -password <password>
   
   
6. Run an iisreset
7. Check the accounts used in application pools within IIS, update to reflect new machine name accounts
8. Rebuild the search index (remove and recreate)
9. Operation Complete!

Source: http://www.sharepointblogs.com/mirjam/archive/2007/08/06/renaming-a-moss-server.aspx (Thank you Mirjam)

Microsoft SharePoint 2007 – An iPhone Client to view SP Content?

SharePoint comes standard with the support for mobile browsing – and if you’ve used it, you would have to say it does the job. But what if you now you feel like bringing surfacing the information on an iPhone (Besides browsing SharePoint sites directly from Safari)? The product would no doubt be a very attractive app for use on the go.

So recently, I stumbled across quiet an interesting product ‘iShare’ from Spyk software: A SharePoint Client App for the iPhone.

The iShare app allows users to login using Windows Authentication or SharePoint Forms Authentication and view, search and create content within a SharePoint Site. There is a list of files which this little app can open:

Adobe Acrobat (.pdf)

Microsoft Word (.doc, .docx)

Microsoft Powerpoint (.ppt, .pptx)

Microsoft Excel (.xls, .xslx)

Images (.jpeg, .jpg, .tiff, .gif)

Web pages (.html, .htm, .aspx)

Text Files (.txt)

Contacts (.vcf)

Now, I do not have an iPhone neither have I used this application – so I cannot comment on the product… so give it a shot and leave a comment :) Apparently you can get it on the iPhone Apps Store.

http://www.spyk.com/Products/iShare/Pages/iShare.aspx

Here are some screenshots from the iShare site: