• About Me

    Josh works for Nintex which is a leading global innovator of software products that extend Microsoft SharePoint technology. Josh focuses on Nintex Workflow + SharePoint + Project.

    View Joshua Tan's profile on LinkedIn

    MCP Transcript
    Transcript ID: 753958
    Access Code: JoshuaTan
  • Twitter Updates

    Error: Twitter did not respond. Please wait a few minutes and refresh this page.

Languages in SharePoint 2010

Posted by joshuatanjh on August 13, 2010

In the last few weeks, I’ve had a go at installing 13 language packs on SharePoint 2010. A few things I’ve discovered in the process of deploying languages.

Firstly what you’ll need to do is determine the languages you want installed on your SharePoint 2010 farm. For a list of languages that are available see Language Packs (SharePoint Server 2010).

To download the language pack, see 2010 Server Language Packs for SharePoint Server 2010, Project Server 2010, Search Server 2010, and Office Web Apps 2010.

Select the required language by selecting the desired language in the Change Language drop-down. Don’t forget to click on Change.

Note: In 2007, you would have required the WSS language packs. In 2010, you do NOT need SharePoint Foundation language packs.


The page should then refresh and change to the language that you selected. Click Download (if you can still understand).

Install the language pack on the web server(s), if you need more details on actual steps see Installing language packs on the Web servers.

Useful Tip: If installing more than 1 language, install all the languages first and then only run the SharePoint 2010 Products Configuration Wizard once which will configure all languages installed. That will save you heaps of time.

Once you’ve done that, you should now have that language pack installed to your SharePoint environment. As per SharePoint 2007, you would have additional site templates where you can choose to create sites based on the language you’ve installed.


So what’s new with languages in SharePoint 2010?

After you’ve installed your language pack, you can now change the language of a site that’s created in English (or really any other site) that you want to show in a language that you can understand. And this setting is persistent, so whenever you go to the site it will always be displayed in the language that you’ve selected!

In order to do this, the Site Administrator would have had to enable languages on the site. To do this, go to Site Settings > Language Settings.


Select the languages that you want by checking them. Click OK.

Now if you go to the spot on the right hand corner with you Username, expand the menu and you’ll see Select Display Language. Select a language and the site will be displayed in the language you selected!


Posted in SharePoint 2010 | Leave a Comment »

Requirement Gathering

Posted by joshuatanjh on March 18, 2009

Requirements gathering can be challenging at times. Sometimes discussions just go of tangent. Here are a few of the things I have found helpful.

Pre-requirement Gathering – Prior to engaging users for requirement gathering sessions:

  1. Overview of the solution that they’re looking at – applicable if you’re pitching a solution and are gathering requirements for it. Give a good overview of what it is capable of and as much as possible, relate to generic challenges faced by most organisations.
  2. Give out an agenda, describing what the requirement gathering sessions are for, how long it will take, any preparation that might be required (current processes, forms, etc.).

Requirement Gathering Agenda – When conducting a session, I find that this is a good guideline:

  1. Introduction – Get the users to give an overview of the company (if you haven’t already) and where they fit into the organisation, what their department/business unit does and what their role is within that.
  2. Current state – what their day to day activity might look like, what are the things/processes that they are/business unit is involved in. Sometimes you get some valuable information or can derive certain things, i.e. users are disciplined, quick to learn, tech savy, etc. Not everything that they’re doing today is evil or bad! Somethings may require minor tweaks, others revamp/overhaul.
  3. Current problems/issues faced with the lack of process/systems – favourite time where you listen to all the challenges, be careful not to go into solution mode (both you and the user). Just document the issues and problems.
  4. Requirements – What they want in the solution. Gather both functional and non-functional requirements. Try to ensure that users can distinct between ‘must haves’ and ‘nice to haves’. Always validate with users.
  5. Wrap it up – let them know what the next steps are. Whether it’d be a follow on workshop, deliverable document, follow up calls to validate items.

Some of the items here have been incorporated from the Microsoft BVPS engagement model.

Posted in Business Analysis, MOSS 2007 | Leave a Comment »

Opening the Enterprise Resource Pool from Ms Pro

Posted by joshuatanjh on June 1, 2008

Really good forum answer that addresses a “mystical” problem I had been facing.

Thanks to Chak from

“Microsoft Office Project Professional 2007 is required for this action. ensure that your copy of Project Professional 2007 can connect to this server. If both of these conditions are true and you still get this message, contact your system administrator for assistance”

FYI, reason beyond the error: MPP file extensions are setup to open with default application MS Project. You have both the versions of MS Project Pro installed on your machine. In your case, your MPP file was setup to open with default application MS Project Pro 2003. (You can verify it by opening the any MPP file from your local machine. You will see the MS Project Pro 2003 will launch by default. But now you may see 2007 as you already fixed the issue.) When you are trying to open resource info from PWA, your machine is trying to invoke MS Project 2003. So, you are seeing the error “”Microsoft Office Project Professional 2007 is required for this action. ensure that your copy of Project Professional 2007 can connect to this server” When you ran the Diagnostics, it re-register the Project Pro 2007 application and sets as the default application as MS Project Pro 2007 to open MPP files. So, now you able to open the MS project 2007 by invoking it from PWA.

For the full thread. Click here.

Posted in EPM 2007 | Leave a Comment »

Project Server 2007 Help

Posted by joshuatanjh on February 19, 2008

Recently I’ve been looking around for some references, guides and helps for Project Server 2007. Found some of the following resources and they seem quite helpful.

Learn about available roles in Project Web Access

Project management quick reference guide for Project 2007 (note: this is for Project 2007 and does not include working with Project Server 2007)

The quick reference looks neat, if I’ve got time I’ll update it to reflect working on Project 2007 in a server environment.

Posted in EPM 2007 | Leave a Comment »

The Archive Database in Project Server 2007

Posted by joshuatanjh on December 28, 2007

The archive database in project server 2007 isn’t really a database that facilitates a functionality of archiving projects. The archive database is the database used to backup projects to and restore projects from.

The projects will still exists in the Draft and Published Databases.Looks like archiving of projects will still need to be done in a way as described in this link.

Another interesting information on the backup of databases is the backup is an all or nothing process but the restoring of a project can be done on an individual basis.

Posted in EPM 2007 | 3 Comments »

Project Server 2007 Pre-migration Checklist

Posted by joshuatanjh on December 28, 2007

I’ve recently been involved in our in house project server 2003 – 2007 migration. Below is a useful list in helping build a checklist and identifying possible issues with migration.

  • Checking for check-out projects
  • Checking for Projects that have been externally edited
  • Checking for projects with pending status updates
  • Checking for duplicate Enterprise Resources
  • Checking for duplicate Enterprise Resource used in projects
  • Project Version should be at least ‘Project Server 2003 SP2A’
  • Enterprise Global should not be externally edited
  • Checking if the Enterprise Global is checked out
  • Checking of the Enterprise Global is locked
  • Checking if the default language on the Web tables database and Project tables database and Project tables database should match
  • Checking if Resources have comma in their names
  • Checking if required enterprise resource custom fields do not have values
  • Checking if a resource custom field has a value which is not in the lookup table definition
  • Checking if Enterprise resources are externally edited
  • Checking if there are Enterprise Resource Duration custom fields with value lists
  • Checking if Enterprise Resource Duration custom fields contain valid values
  • Checking if Enterprise Custom Field names do not contain leading or trailing spaces
  • Checking if the Migration Administrator Account exists in Project Server 2003

More information at the link:

Posted in EPM 2003, EPM 2007 | Leave a Comment »

Working with Outlook and Project Server

Posted by joshuatanjh on August 29, 2007

If you didn’t know, you can sync your task in Project Server to your Outlook. The Project Server 2007 Outlook Sync works with Outlook 2003/2007.

So what is new in the Outlook Sync in Project Server 2007.

Outlook Sync for Project Server 2003:

Outlook Sync for Project Server 2007:

So now you can have your tasks sit the the Outlook Tasks instead of cluttering up your calendar! The rest of the options are the same. You can create a task from Outlook and have that created in Project Server, it’s still a one way creation of task and you can sync updates and progress of the task back.

Posted in EPM 2007 | 3 Comments »

Project 2007 Certifications

Posted by joshuatanjh on August 28, 2007

Recently I attended a Live Meeting on the latest Project Certification offerings from Microsoft based on the new EPM 2007 solution stack.

There’s a total of 3 exams to take in becoming a MCITP (Microsoft Certified IT Professional. In short you need to do an exam on Project Professional 2007 and a Project Server 2007 one before doing the final one which is a combination of both on an enterprise level. Below are the links to the recorded webcast and datasheet on the certifications.

Posted in EPM 2007 | Leave a Comment »

Project Professional 2007: Saving to Project Server, "save job 0% complete"

Posted by joshuatanjh on August 27, 2007

If you’re using Project Server 2007 and when you try to save a project and you get, “save job 0% complete”. You can do 2 things:

  1. Check your Queue under “Personal Settings > My Queued Jobs” and see what the issue is. If there isn’t any error. You can then ask the administrator to check in the Global Queue, which is “Server Setttings > Manage Queue” to try to retry the jobs.
  2. If all else fails, try restarting the Queue Service. It’s called Microsoft Project Server Queue Service. Restart that and you should be on your way!

Posted in EPM 2007 | 1 Comment »

Project Server 2007 Overview Presentation

Posted by joshuatanjh on August 24, 2007

Thank you for those who came to MOSSIG and stayed on for my session, I know we were running out of time and your presence was very much appreciated by myself and the MOSSIG board.

You can retrieve my presentation slide deck at the MOSSIG Site or you can click here to get to the slide straight away.

There were a few interesting questions that were raised during the session. One of them was since Project Server 2007 is built on SharePoint, how does search work. From a logical perspective and mind you I’ve not tested this yet; I think:

  1. All Project Workspace information (Risk, Issues, Deliverables) will be searchable if it has been included in the search settings.
  2. I’m quite sure project plans and tasks may not be searchable as they sit in seperate databases unless the Business Data Catalog was configured to go get the information from the Project Server database, but why would you do that? Wouldn’t it be better to built reports around this information? Resources can search for their task within their own “My Tasks”.
  3. Although Project Server is built on top of SharePoint it does not store the data of Project Server in it’s Content DB’s, perhaps the configuration of project server on sharepoint but not the actual project information (i.e. project plan, tasks, assignments, actuals, updates, resource information).

I’ll probably do a role based presentation (business focused) the next time at MOSSIG on how the different roles (Executives, PM, Resources) would interact with each other on the an EPM solution! I just need a faster machine!

Posted in EPM 2007, UserGroup | Leave a Comment »