Monday, December 29, 2008

How do I get the GUID in CRM?

So this is a quick and dirty trick for getting the GUIDs for a set of records in Dynamics CRM v3.

1) Create a view of the records you want the GUIDs for
2) Export as a Dynamic list
3) Right click on A2 and select 'Edit Query...'
4) A bunch of boxes will pop up. Close them as soon as they open
5) You will now see in your workbook an extra column has magically appeared on the end. These are your GUIDs

In v4 things have been made much simpler. Simply export as a dynamic worksheet and unhide the hidden column at the end which is your GUIDs.

3 comments:

Taarik said...
This comment has been removed by the author.
Leon Tribe said...

In CRM 2011 there should be an option to 'make this data available for reimporting...'. If ou select this option, one of the first three columns (which are hidden) has the guid for the record.

Karl Melrose said...

You know you've got a quality CRM consultant when you google a question and his blog comes up!