Monday, March 25, 2013

Introducing SQL2FetchXML Online Converter

Today, I would like to share with you that KingswaySoft, where I work, has just launched a new website called, which is a free online converter that helps convert SQL script into CRM FetchXML query.

FetchXML is a proprietary query language that is used in Microsoft Dynamics CRM, which helps query data from CRM system through its web service interface. We, as developers, are usually familiar with writing SQL script. Often the case, we take pride in our productivity when writing SQL script, and sometimes complex ones. But when it comes to FetchXML, we need to worry about the XML syntax, formatting, which makes us much less productive. With website, you can continue to use your SQL mindset, and let the utility handle the conversion for you.

Please feel free to give it a try and let me know how it goes.

Hope you find this utility useful.

Sunday, March 17, 2013

Packed and Ready to Go, See You at Convergence 2013 - New Orleans

I want to say that I am very excited that I am on my way to New Orleans to attend Microsoft Dynamics Convergence 2013. This is my first time attending Convergence, and I am really looking forward to this great event.

If you are also coming to Convergence, it might be a great opportunity to meet up for a chat or a coffee. The following is the list of my engagements in the event if you want to catch up with me.

Date Time Assignment / Session Location
Mondy, March 18, 2013 4:00 - 6:00pm Attending Microsoft Booth Dynamics CRM Kiosk #4
Tuesday, March 19, 2013 12:00 - 3:00pm Attending Microsoft Booth Dynamics CRM Kiosk #4
5:00 - 6:00pm Ask the MVPs: Discussion with Microsoft Dynamics CRM MVPs (Facilitated by Donna Edwards, joined by a total of 10 MVPs as panel members including me) Room #386
Wednesday, March 20, 2013 10:30am - 1:00pm Attending Microsoft Booth Dynamics CRM Kiosk #4
2:00pm - 3:00pm Ask the MVPs: Discussion with Microsoft Dynamics CRM MVPs (Facilitated by Donna Edwards, joined by a total of 10 MVPs as panel members including me) Room #386

I just started my 10-hour connected flights to New Orleans, I look forward to seeing you there.

Friday, March 01, 2013

Updated: Microsoft Dynamics CRM 2011 JavaScript Development Cheat Sheet

I just made some updates to CRM 2011 JavaScript Development Cheat Sheet. There are a couple changes in this update to reflect some recent SDK updates.
  • added Xrm.Utility Methods
  • added getClientUrl method
  • marked getAuthenticationHeader and getServerUrl methods as deprecated
Since UR12, getServerUrl is deprecated, and getClientUrl is the recommended approach. To handle the transition, you might want to first check if getClientUrl is available and then use getServerUrl as a second option. This is to ensure backward compatibility, which is important for ISVs. You can see my implementation in the most recent of XrmSvcToolkit.

You may download the cheat sheet document from the following link on my Windows Live SkyDrive.

This may not worth a dedicated blog post, but I thought this is the only way to reach out to the community in order to have your attention.

Please let me know in case I have missed anything important.

Release: XrmSvcToolkit v0.2

It has been a while since the last update of XrmSvcToolkit.

Today, I just updated the library to a new version, v0.2, which includes the following two updates:
  • Cross-browser support
  • Bug fixes for synchronous calls that don't have any return values
So the library should work for CRM 2011 December 2012 Service Update or UR12. 
The new version is available for download at codeplex website. Please let me know if you run into any issues with the new version. 
Hope this helps.