Moving to http://www.nullfactory.net

I have moved my blog to http://www.nullfactory.net. The transition is pretty much done and all new posts will be published to the new location.

Enjoy!

List of Files Changed Between Changesets in Visual Studio Online using PowerShell

So recently I had the requirement of getting a list of files that changed between two different releases. We wanted to use this list to act as a verification to ensure that all artifacts were included in a release package.

I modified the code posted here in order to quickly write a console application to do the task. With the immediate problem solved, my colleges and I bounced the idea about porting the code into a PowerShell script which would allow us to enhance it better in the long run.

The solution would be built around the Visual Studio Online(VSO) REST service. This reduces any dependency on Team Foundation Server(TFS) specific client side assemblies or tools. The limitation is that, at the moment, it is only supported in Visual Studio Online and not all features are supported.

Pre-Requisites

Security and Credentials

In order make things simple, let's enable Alternate Authentication for access the account. This enables the script to use Basic Authentication when making request to the VSO REST service. This can be done by navigating to the profile page, selecting Credentials > Enable alternate credentials and providing new credential information. More instructions available here.

The credentials will be collected using the Get-Credentials cmdlet. This provides the standard windows credentials dialog for the user to enter information. Since this makes the script interactive, I debated about having the username and password as a parameter for the script, but in the end decided against it. Maybe the next improvement would be to include a silent version of the script.

The REST call

Invoke-RestMethod cmdlet will be used to make the actual call to the REST service. So what's the difference between Invoke-WebRequest and Invoke-RestMethod you may ask? While similar, the Invoke-RestMethod attempts to parse the returned JSON so that we do not have to do it manually within our script. Think of it as a super set of Invoke-WebRequest just like Invoke-WebRequest is a superset of System.Net.WebClient. Read more about it here and here.

I ran into strange issue when attempting to authenticate the request. The
Get-Credentials cmdlet would return a System.Management.Automation.PSCredential object as expected, but when passed into into the Invoke-RestMethod cmdlet, it was not generating the the basic authentication header token within the request. I still haven't figured out why this happens, but the workaround was to add the authentication header explicitly as shown here.

$basicAuth = ("{0}:{1}" -f $username,$password)
$basicAuth = [System.Text.Encoding]::UTF8.GetBytes($basicAuth)
$basicAuth = [System.Convert]::ToBase64String($basicAuth)
$headers = @{Authorization=("Basic {0}" -f $basicAuth)}

Making the call to the service

1. First get a list of changesets related to the project within the timeframe that we're interested in.
   

   https://{account}.visualstudio.com/defaultcollection/_apis/tfvc/changesets?api-version=1.0&searchCriteria.fromId=100&searchCriteria.toId=200&searchCriteria.itemPath=$/{project}
   

   It took me a while to figure it out but you should notice this call is only allowed to be made against the entire Team Project Collection. So in order to filter out the project, provide the project path via the searchCriteria.itemPath filter. That is searchCriteria.itemPath=$/{projectname} where {projectname} is the one that you are interested in.
   
2. Next iterate through each of the results to retrieve the detailed information on of each of the changesets. This result would include a collection of all the files that were affected.
   

   https://{account}.visualstudio.com/defaultcollection/_apis/tfvc/changesets/{changesetId}/changes?api-version=1.0

3. Again, iterate through each of the changes and extract the path property of the json result set. This is the path and name of the file.
   
4. Remove duplicates entries and folder creation entries as necessary.

Final Thoughts

You can download my implementation here.

The next steps would make this to its own cmdlet in order to make it more reusable in other scripts. Also check out the Curah! page that I created while working on this.

References

• Identifying all .vb files changed between two changesets
• Microsoft Technet - Get-Credential
• Screen scraping for pleasure or profit (with PowerShell’s Invoke-RestMethod)
• Hey, Scripting Guy! - InvokeRestMethod for the Rest of Us
• Microsoft Technet - Invoke-RestMethod
• Accessing Visual Studio Online REST API using Powershell 4.0, Invoke-RestMethod and Alternate Credentials

Bind Media Keys on the RC11 Air Mouse within Android

I recently bought a Measy RC 11 air mouse to complement the Rockchip MK808  and one thing I noticed right away was that the media buttons did not function. I guessed it had something to do with key mapping and learned that Android maintains mapping information within key layout files in the  path. My goal would be to edit the appropriate files to map the media buttons to the key codes (scancodes).

I essentially followed the instructions provided here while making slight adjustments to suit my own needs. The only prerequisite being that the device needs to be rooted.

The key layout files themselves can be stored in various locations and Android refers to them in the following hierarchy:

/system/usr/keylayout/Vendor_XXXX_Product_XXXX_Version_XXXX.kl
/system/usr/keylayout/Vendor_XXXX_Product_XXXX.kl
/system/usr/keylayout/DEVICE_NAME.kl
/data/system/devices/keylayout/Vendor_XXXX_Product_XXXX_Version_XXXX.kl
/data/system/devices/keylayout/Vendor_XXXX_Product_XXXX.kl
/data/system/devices/keylayout/DEVICE_NAME.kl
/system/usr/keylayout/Generic.kl/data/system/devices/keylayout/Generic.kl

As Generic.kl file acts as the default file used in the case a mapping was not found, the documentation strongly recommends that we do not modify it.

The first step in the process was to make myself a copy of the Generic.kl using ES File Explorer File Manager. Temporarily rename the copy to Vendor_[VendorID]_Product_[ProductID].kl. The [VendorID] and [ProductID] will be replaced with the proper IDs once identified.  This will be our new mapping file.

Next, we figure out the the scan codes to the media buttons using the the keytest app written by Chris Boyle. Fortunately, the scancodes generated from the RC11 didn’t differ from the generic mapping. I updated it with my preferred mapping:

key 62    HOME
key 63    ENVELOPE
key 64    MUSIC
key 65    MEDIA_REWIND
key 66    MEDIA_PLAY_PAUSE
key 67    MEDIA_FAST_FORWARD
key 68    VOLUME_MUTE
key 87    VOLUME_DOWN
key 88    VOLUME_UP

Now we identify the keyboard vendor id and product id codes. To do this I installed a copy of Android Terminal Server Emulator and used the cat /proc/bus/input/devices command to list the details about the devices attached attached. This contains the vendor as well as the product Id that we require.

The output should look similar to the one below:

I: Bus=0003 Vendor=0c45 Product=7403 Version=0100
N: Name="SONiX USB Device" 

P: Phys=usb-usb20_host-1.1.1/input0
S: Sysfs=/devices/platform/usb20_host/usb2/2-1/2-1.1/2-1.1.1/2-1.1.1:1.0/input/input9
U: Uniq=
H: Handlers=sysrq kbd event1 keychord 

I: Bus=0003 Vendor=0c45 Product=7403 Version=0100
N: Name="SONiX USB Device"
P: Phys=usb-usb20_host-1.1.1/input1
S: Sysfs=/devices/platform/usb20_host/usb2/2-1/2-1.1/2-1.1.1/2-1.1.1:1.1/input/input10
U: Uniq=
H: Handlers=kbd event2 keychord
B: PROP=0

Identify your device from the list and rename your previously created file to include the vendor and product Ids. Mine is now called Vendor_0c45_Product_7403.kl.

Now all that remains is to deploy the changes to the /system/usr/keylayout/ path. You would require root privileges to write to this folder. Once file has been copied over make sure that Group and Other entities have read permission on the file, I spent quite a bit of time trying to figuring this one out.

Rebooting the device or re-plugging in the keyboard receiver will cause the new mapping to take effect.

While my experience is specific to the RC11, this process can be adopted to meet your own requirements. I’ve attached my key layout file for your convenience.

As usual, bad things can happen when modifying system files, so please make sure to take all the appropriate precautions as well as backups. I am not responsible for anything you might break.

This has been a very fun learning experience for me. Look forward to more Android related posts from in the future.

References

• http://www.thriveforums.org/forum/toshiba-thrive-development/9626-how-create-customized-keylayout-any-usb-bluetooth-keyboard-rooted.html
• http://source.android.com/tech/input/key-layout-files.html
• http://www.armtvtech.com/armtvtechforum/viewtopic.php?f=6&t=752
• http://chris.boyle.name/2010/08/android-keymaps

TF31003 Error: TFS + Visual Studio 2012 + Windows 8

I think anyone who's worked with Team Foundation Server for significant amount of time has run into this or a similar variant of the (TF31003: Either you have not entered the necessary credentials or your user account does not have permission to connect to the Team Foundation Server at https://***.visualstudio.com/. Ask your server administrator to add the appropriate permissions to your account) error message at least once. I ran into it earlier today while trying to connect to the online Team Foundation Service (http://tfs.visualstudio.com) using Visual Studio 2012 running on Windows 8.

As the error code to be a generic one and covers a wide variety of issues, it took a bit of trial and error before was finally able to narrow down the issue that was ailing me:
http://stackoverflow.com/questions/11034882/tfs-in-visual-studio-2012-under-windows-8

As suggested, clearing all the cookies in IE resolved the issue for me.

Here is another link to the exact problem/solution that I found after the fact:
http://caioproiete.net/en/error-tf31003-connecting-to-tfspreview-from-visual-studio-2012/

Bookmark Organizer 0.2 with SkyDrive Integration

I am pleased to announce the latest iteration of Bookmark Organizer. It now comes with the ability to synchronize your bookmarks with SkyDrive. Please read the original post for application pre-requisites and installation.

improvements

• Ability to synchronize with SkyDrive
• Various bug fixes and performance improvements
• Update to WP7 Root Tools SDK 0.2.1.0 alpha
• New splash screen :)
  

known Limitations

• Synchronization is limited to the root folder of SkyDrive. I might include the ability to choose the location if there’s demand for it.
• The app is limited to one way synching, its either Device to SkyDrive or vice versa. Source bookmarks are mirrored to the destination.
• The available sync file extensions are restricted. This is a limitation imposed by SkyDrive. Please read more about it here.
  

disclaimer

The usual disclaimer applies; I am not responsible for anything you might break by using this application. Please use at your own risk.

download

Please feel free to suggest any improvements and I will try to accommodate you as best as I can.

xsd.exe and included schemas

Today I learned that the xsd.exe tool ignores all xsd:import statements. And the workaround is to explicitly provide all the schemas as command line arguments.

xsd.exe MainSchema.xsd  Reference1.xsd Reference2.xsd

According to the post here, the fact that the W3C Schema spec describes the schemaLocation attribute as a hint, not a true location might be a plausible reason to this behavior.

Visually Differentiate Dynamics CRM 2011 Environments (alternate)

I am a big fan of this hack to visually differentiate CRM environments and have been using it religiously in all CRM environments I have worked on.
I have since found an implementation of for CRM 2011 here. Although it served its purpose, I was not quite comfortable with changing the ribbon styles as it could be a annoyance when designing/implementing ribbon icons. So here is my take on it:
There are 2 files that require modification; main.css.aspx and theme.css.aspx (The theme.css.aspx file only needs to be modified if you want this to work with read-only forms). You can find them both under %programfiles%\Microsoft Dynamics CRM\CRMWeb\_common\styles folder.

main.css.aspx

div.ms-crm-TopBarContainerGlobal
{
/* background-repeat: no-repeat;
background-color: #ffffff; */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#00ff00', endColorstr='#0100ff',GradientType=1 ); /* IE6-9 */
}

div.ms-crm-TopBarContainerForm
{
/* background-repeat : repeat-x; */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#00ff00', endColorstr='#0100ff',GradientType=1 ); /* IE6-9 */
}

themes.css.aspx

div.ms-crm-ToolBar
{
<%--<% = this.GetStyleCss(CrmTheme.Current.Form.ToolBar) %>--%>
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#00ff00', endColorstr='#0100ff',GradientType=1 ); /* IE6-9 */
}

The gradients were generated using CSS gradient editor.

IIS Reset for the changes to take effect.


An here is the end result:




As this is an un-supported change, you would not be able to implement this in a CRM Online environment. Here is an alternate solution that works well with CRM Online.

Bookmark Organizer 0.1 for Windows Phone 7.5

UPDATE: Version 0.2 is released!

I saw a tweet a few days back where someone wanted to sync favorites within windows phone. Unfortunately, the current iteration of the OS does not allow developers that level of access to their favorites. I was curious if it was still achievable, at least via un-supported means and this app was the result.

A little research revealed that the phone stores the favorites as url files within the \Windows\Favorites folder and that Internet Explorer treats every file with a “.url” extension as a favorite entry. It was only a matter of reading and manipulating these files.

This initial version allows to do basic CRUD operations on the available bookmarks and also import from a hosted CSV file. The CSV file itself should be a valid 2 columned file containing the Title and Url of the bookmark.
The app is built around the WP7 Root Tools SDK 0.1.6.0 alpha which does most of the heavy lifting.

Pre-requisites:

• An Interop-Unlocked Windows Phone running Mango (7.5)
• WP7 Root Tools by Heathcliff74

Installation:

1. Download and deploy the XAP file using your favorite deployment tool.
2. Make Bookmarks Organizer a trusted app using WP7 Root Tools

Future version:

• The ability to do 2 way sync with a cloud service.
• Improved UI maybe?

Disclaimer:

This app interacts with system files that were not meant to be accessed. I hold no responsibility if your phone gets ‘bricked’, blows up or any other unfortunate mishap by using this application. Please use at your own risk.
Please feel free to email me your comments, feature requests or bugs.

Download:

Flashing OEM ROM on Samsung Focus

I flashed my Samsung Focus using the Rogers OEM ROM the other day and then followed the update method described here to get back to 7.10.8107.79 within 30 mins.

Why? Because my Samsung Focus is finicky on the best of days. More so when it comes to pushing updates via Zune. It was a nightmare getting Mango on it when it was first release, I kept hitting the dreaded 80180048 error. And my slow as molasses internet connection was not helping; constantly re-downloading 160+ Megs of updates for each failure was painful to say the least. My best guess was something somewhere was timing out. And I was not too keen on going through that whole process again.

Followed everything described on the thread. Although I didn’t install the OEM drivers that were provided, I let Zune pick them out for me and this is what it got me:

This one brings the firmware up to 2124.11.8.1: http://download.windowsupdate.com/msdownload/update/software/dflt/2011/08/404680_i917rrwckh1_prod.pks_c73375d693c8eae569b062eefedea268bbe907d1.cab

And this to 2124.11.9.4: http://download.windowsupdate.com/msdownload/update/software/dflt/2011/10/417964_i917rrwcki4_prod.pks_1636e51c72b74f38ddfdf77ee9bbf5b2efb1d732.cab

The above links were not present on the original thread at the time of writing, I hope it helps someone else out there.

Listing of Form Mode For Organization Users

With rollup update 7, Dynamics CRM introduced Read-Optimized Forms and gave administrators the ability to set the default Form Mode for all users within the organization. It also provides the option to allow users to override this selection as well.




If the latter option is enabled, I noticed that CRM does not provide administrators a way to view the user’s selection. This information is not available in any of the out of the box views nor can it be added as the Form Mode selection is stored within the UserSettings entity.
The following FetchXml used within a SSRS report should fill the requirement gap:

<fetch mapping="logical" count="50" version="1.0">
  <entity name="systemuser">
    <attribute name="address1_telephone1" />
    <attribute name="businessunitid" />
    <attribute name="fullname" />
    <attribute name="siteid" />
    <attribute name="title" />
    <filter>
      <condition attribute="isdisabled" operator="eq" value="0" />
    </filter>
    <link-entity alias="settings" name="usersettings" from="systemuserid" to="systemuserid">
      <attribute name="entityformmode" />
    </link-entity>
  </entity>
</fetch>

 

And best of all, this method is fully supported.

Calculated Fields In Dynamics CRM Read Optimized Forms

The latest rollup update introduced a new feature called Read Optimized Forms. This enables a read-only version of the entity forms that optimized for users that want to rapidly read data instead of editing them.

One of the pre-requisites in the current implementation is that the form should be devoid of all script customizations. If so, how would you work around a situation where the form requires values to be dynamically calculated.

One of the recommended approaches, as defined in the SDK, is to use a synchronous sandbox plugin running on the Retrieve message of the entity.

The following code snippet demonstrates this:

1. protected void ExecuteDynamicCalculationPlugin(LocalPluginContext localContext)
2. {
3.     if (localContext == null)
4.         throw new ArgumentNullException("localContext");
5.  
6.     //The OutputParameters property bag contains the result of the core operation.
7.     Entity outEntity = localContext.PluginExecutionContext.OutputParameters["BusinessEntity"] as Entity;
8.  
9.     //Ensure values are valid to perform calculation
10.     if (outEntity.Attributes.Contains("null_hours") &&
11.         outEntity.Attributes.Contains("null_days"))
12.     {
13.         int hours = (int)outEntity.Attributes["null_hours"];
14.         int days = (int)outEntity.Attributes["null_days"];
15.  
16.         outEntity.Attributes["null_hours"] = hours * days;
17.     }
18. }

And the plugin is registered as PostOutsideTransaction on the Retrieve event of the entity with the assembly under Sandbox isolation. This approach would also work on Online solutions as well.

Please beware of long running calculations as they are now being done synchronously as opposed to being done asynchronously through JavaScript.

Dynamics CRM Security Role with Minimum Permission

When it comes to software solutions, it is always best practice to follow the Principal Least Privilege. This is no different with Dynamics CRM 2011. This post will provide you will basic instructions in creating a security role with the least privileges.

The help page in the Security Role entity under the “Create or edit a security role” topic already provides a pretty good summary of the minimum privileges required:

It's helpful to keep in mind the minimum privileges you need to define for some common tasks. These include:

• When logging in to Microsoft Dynamics CRM:
  1. To render the home page: prvReadWebResource, prvReadCustomization
  2. To render an entity grid (that is, to view lists of records and other data): Read privilege on the entity, prvReadUserSettings, prvReadQuery
  3. To view single entities in detail: Read privilege on the entity, prvReadSystemForm, prvCreateUserEntityUISettings, prvReadUserEntityUISettings
• When logging in to Microsoft Dynamics CRM for Outlook:
  1. To render navigation for Microsoft Dynamics CRM and all Microsoft Dynamics CRM buttons: prvReadEntity, prvReadQuery
  2. To render an entity grid: Read privilege on the entity, prvReadCustomization, prvReadWebResource, prvReadUserQuery
  3. To render entities: Read privilege on the entity, prvReadSystemForm, prvCreateUserEntityUISettings, prvReadUserEntityUISettings, prvWriteUserEntityUISettings

So suppose I want a user to have minimum read permission to a Custom Entity and for him to view records that have been assigned to him. I would add the following permission:

Basic Read Permission on your entity (prvRead[entityName])

Access to Viewing the entity grid and entity forms (prvReadQuery, prvReadSystemForm)
As well as the permissions that are added by default (prvReadSdkMessage, prvReadSdkMessageProcessingStepImage, prvReadSdkMessageProcessingStep, prvReadPluginAssembly, prvReadPluginType) These permissions are required for smooth operations of internal operations such as core CRM plugins.

The UserEntity UI Settings provides access to the functionality to remember the user’s last accessed Form (prvCreateUserEntityUISettings, prvReadUserEntityUISettings)

Permission to access User Preferences (prvReadUserSettings)

Also keep in mind that when designing security roles, a good understanding of the organization structure and deployed CRM solutions is key to success. As it is possible that there are additional plugins and workflows running in the background that require additional permissions.

Dynamics CRM 2011 Developer Training Kit

Developer Training Kit has just been released. Get it here

Dynamics CRM 2011 Books

https://community.dynamics.com/roletailored/customerservice/b/cscrmblog/archive/2011/02/01/microsoft-dynamics-crm-2011-book-club.aspx

Pretty impressive line up of Dynamics CRM 2011 books to be released during this year. Its going to be an interesting year ahead.

Whitepaper for ISV and Developers

The November release of the Whitepaper for ISVs and Developers can be found here. Its a nice presentation of the available customization options without diving too deep into the technical details.

http://community.dynamics.com/product/crm/crmtechnical/b/crmteamblog/archive/2010/11/10/new-microsoft-dynamics-crm-2011-whitepaper-for-isvs-and-developers.aspx

CRM 4.0 Update Rollup 15 released

I really appreciate the frequency in which the updates are released. Find more information about the update here:

http://blogs.msdn.com/b/crm/archive/2011/01/13/update-rollup-15-for-microsoft-dynamics-crm-4-0.aspx

Count Down to Dynamics CRM 2011

CRM 2011 Beta SDK Sept/Oct Refresh

I'm not sure how I missed this, but there was a new update to the 2011 SDK a few days back.

Most notably they've added hands-on-labs and tons sample code. Sweet!

Go get the latest version here.

Disable Aero Peek

Am I the only one that get easily annoyed by the Aero Peek feature in Windows 7? It gets pretty bad when you're working with multiple monitors and accidentally hover over a taskbar window icon. Its almost like a miniature light show. :/

Here's how to disable all that craziness:

http://www.howtogeek.com/howto/5473/make-aero-peek-display-instantly-or-disable-it-in-windows-7/

</rant>

CRM 2011 Beta Released

CRM 2011 beta is out now. Go grab you copy now!
http://crm2011beta.com

Download Links:

1. Microsoft Dynamics CRM 2011 Beta On-Premises Server and Client Bits
2. Microsoft Dynamics CRM 2011 Software Development Kit (SDK)
3. Microsoft Dynamics CRM 2011 Beta Implementation Guide
4. Microsoft Dynamics CRM Online Beta Readme
5. Microsoft Dynamics CRM 2011 Beta Readme

CRM 2011 Beta forum:
http://social.microsoft.com/Forums/en-US/crm2011beta/threads

Source:
http://blogs.msdn.com/b/girishr/archive/2010/09/08/microsoft-dynamics-crm-2011-beta-is-here.aspx