Skip to main content


Showing posts from 2011

iPhone 4 Personal Hotspot on Optus Prepaid

Recently I decided to try the Personal Hotspot feature of iPhone 4, but found some obstacles.


When I try to activate or set up Personal Hotspot on my iPhone:

I am getting the following message:

"To enable Personal Hotspot on this account, contact OPTUS". It means I can't use that feature of my phone.


I use prepaid mobile service from Optus with iPhone 4. I bought my phone directly from Apple and it's not locked to any mobile service provider. As a part of my prepaid service I have got some data which is "mobile Internet and can be used within Australia for internet browsing and downloading content" (from Optus site). I pay for mobile services and data.

I contacted Optus as per message above in Twitter. Here's the conversation I have got with Optus representatives:

The details are on my Twitter account @SlavaGorbunov

The says "Please note: iPhone Personal Hotspot / Tethering is not available with Pre-Paid mobile …

Import Excel files to SharePoint 2010

Sometimes we have a need to transfer Excel spreadsheet to the SharePoint 2010 environment.

Because Excel is very popular business application, I see quite a few spreadsheets out there that are used for managing complex business operations.

At some stage the decision comes up to move Excel-based system to SharePoint for certain good reasons and business users try to upload their spreadsheets to SharePoint lists and libraries.

It might seem obvious that we could use out-of-the-box functionality provided by Microsoft in SharePoint 2010 which is "Import Spreadsheet" which "creates a list which duplicates the columns and data of an existing spreadsheet".
What it does in reality is: allowing you to select a range of cells, creating a list with all columns as single or multiple lines text. That's it.
So for real life scenarios we need a different approach to import Excel data to SharePoint appropriately.

In the scenario here we have got a simplified application management …

Microsoft OneNote for iPhone

Have recently installed OneNote on iPhone 4. It's one of the apps that I was waiting for and I jumped into playing with it straight away.

The interface is intuitive and displays your notebooks on start:

When you type you can add to-do lists, bullet point lists and insert photos:

There is an option to see Recently Viewed notes:

 In my case I am synching notebooks with the SkyDrive:

Search is available:

You can email the note:

And of course create a new one:


Very pretty and simple app which allows me to manage my OneNote stuff. I didn't find an option to create new notebooks though, but I don't think it is a very big problem.

SharePoint 2010 Foundation Audit Settings

I have recently implemented audit for SharePoint 2010 Foundation using PowerShell.

There was a couple of discussions where some people said it's impossible to enable audit in SharePoint 2010 Foundation:


1. Go to Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell
2. When it is loaded you then run the following command to get your site collection object: $site = Get-SPSite http://site_URL
3. If you don't get errors then execute the following commands one by one to set audit options and update it: $site.Audit.AuditFlags = [Microsoft.SharePoint.SPAuditMaskType]::Update $site.Audit.Update()
4. [Microsoft.SharePoint.SPAuditMaskType]::Update is a enum value of type SPAuditMaskType. You can have a look here for all p…

VG Content Display Web Part for SharePoint 2007 Released

Wylde Solutions released a SharePoint 2007 (MOSS 2007 and WSS 3.0) version of VG Content Display Web Part.

VG Content Display Web Part is an alternative to Content Query Web Part (CQWP). It is easy to set up, uses custom XSLT file and it works with SharePoint 2010 Foundation.
It allows displaying context-related content using current page metadata as filter values.

Content Display Web Part

Wylde Solutions has published a new project on CodePlex - VG Content Display Web Part.

An alternative to Content Query Web Part (CQWP). It is easy to set up, uses custom XSLT file and it works with SharePoint 2010 Foundation. It allows displaying context-related content using current page metadata as filter values.

Current release has been tested on SharePoint 2010 Server and SharePoint 2010 Foundation. Future release will be available for MOSS 2007.

InfoPath 2010 Forms in SharePoint 2010 - Part 2

A new must-read publication from Wylde Solutions about implementing business forms using InfoPath 2010 in SharePoint 2010.

Process automation and implementation of forms is an important part of any business collaboration. Business process automation will increase efficiency and reduce costs and will also help organise the work of a business unit or a team or a single person within the organisation.

With SharePoint 2010 we have plenty of features that allow us to design and implement business workflows and business forms to take advantage of new technologies. When we use technology properly we benefit from having efficient business processes and thus better leveraging of our resources to achieve better results for the business.

This publication is a walk-through of the business process design and implementation using SharePoint 2010, InfoPath 2010 and Visio 2010.

We will use a hypothetical Incident Management Workflow to showcase the process of:
Business form design and implementation u…

SharePoint 2010 License Upgrade


You have SharePoint 2010 Server Standard installed, but have got Enterprise license and need to upgrade license type of the SharePoint 2010 Server.

Sometimes if you go to Central Administration -> Upgrade and Migration -> Convert License Type, you might see that you can't type your Enterprise license key into the textbox and there is no option to convert your license:

Some people suggest that this is because you have the Enterprise license key already entered and you don't need to upgrade. This is not true. There is just a different routine to upgrade.


1. Go to Central Administration -> Upgrade and Migration -> Enable Enterprise Features:

2. For the Select Feature Set option choose Enterprise and type in the Enterprise key into the Product Key textbox that will appear. Then click OK:

3. After some time you will see the message that SharePoint Server Standard has been successfully upgraded to Enterprise. Click OK:

4. Select Enable all sites in this …

User Profiles Synchronization - SharePoint 2010


Synchronize User Profiles with Active Directory for a new SharePoint 2010 installation or for existing SharePoint 2010 installation.


1. Go to Central Administration -> Manage Service Applications -> User Profile Service Application settings. Select Configure Synchronization Connections:

2. Click Create New Connection button:

 3. In the Type dropdown select Active Directory. Specify service account that has access to Active Directory and click Populate Containers to select objects that you want to import from specified Active Directory:

4. When the new connection is created go to Edit Connection Filters action screen:

 5. In our case we want to synchronize only active user accounts. So we add Exclusion Filter for Users as Attribute = userAccountControl, Operator = Bit on equal, Filter = 2. Which is exactly the the same as LDAP query (!(userAccountControl:1.2.840.113556.1.4.803:=2))
Then click Add:

6. When the Exclusion Filter appears click OK to save settings:

7. St…