Uncategorized

Importing Work Items into TFS 2010 using Excel – Part 1: Html Fields

This is part 1 of the series about importing Work Items into TFS 2010 using the Excel Add-in. For more information about the Excel Add-in for TFS, check out http://msdn.microsoft.com/en-us/library/dd286627.aspx.

Using Excel is a very convenient way to import Work Items into TFS. It’s fast and flexible and most people know how to use it! There are however some pitfalls one needs to consider. This series will describe some of them.

When configuring a Work Item Type, a choice can be made between a “Plain Text” field and an “Html” field. The difference is clear; Plain Text can only contain text whereas the “Html” field can contain markup as well.

Html Field vs Plain Text Field
Html Field vs Plain Text Field

Having the possibility to add markup to your text is of course a nice feature. There is however a downside to this when cooperating with Excel; You cannot edit Html type fields. It’s only possible to initially fill them when creating the work item in Excel. So be conscious when using Html fields!

Existing Work Item Html Field read-only in Excel
Existing Work Item Html Field read-only in Excel
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s