You may read more about the update here.
You may read more about the update here.
SnapShot! 3.0 for Dynamics CRM is now available. Here is a quick overview of what is included in this release:
SnapShot! was enhanced in the following ways:
Internally SnapShot! was entirely re-architected to reduce the amount of time it took to extract data from Dynamics CRM. Additionally, the engines that generate the Microsoft Excel and Microsoft Word documents was replaced. While the performance of each installation will vary, in my test environment this combination resulted in a speed improvement of greater than 50%.
The ZIP archive technology I was using in SnapShot! produced .zip files that were not compatible with Windows 8 so it was replaced with something that was.
On the SnapShot! user interface, I separated the business objects from the other Dynamics CRM components. Business Objects include:
Since each of these can result in an extremely large Excel worksheet, I decided that the summary reports should each receive their own worksheet.
The following new features were added.
This singular report allows you to see what entities and fields are being audited. Read more about this feature here.
This feature creates a comprehensive list of all of the workflows and plug-ins defined within the system which will allow your QA department (or the developers) to develop testing scenarios which will activate the various automation components to ensure they are functioning as designed.
For a complete list of all SnapShot! features, please visit our product page.
If you purchase SnapShot! before Friday, March 7th at 11:59pm MST, you will receive a 10% discount.
Use the code: Conv2014 when you check out.
Next week I will be releasing an update to the ultimate Dynamics CRM documentation tool:
SnapShot! for Dynamics CRM.
This is such a major update that I am moving the version number to 3.0. Here are some highlights:
I will be there all week working in the Microsoft booth and appearing at the Ask the MVP sessions. Track me down and ask me for the discount code for 10% off of the purchase price of SnapShot!.
Email me at mitch at crmaccelerators dot net and ask for the same code.
Thanks for your support everyone.
Your mileage may very since everyone writes code in a slightly different manner and using different coding techniques.
OR, if you have never heard of Transformer! download the trial version and give it a shot.
mitch at crmaccelerators dot net
Unfortunately, SOAP calls are beyond the scope of what Transformer! can handle so if your code is SOAP-related, Transformer! will not be of much help.
People who are successful in finding code that we can add to our list of conversions will be rewarded with a product discount or an Amazon gift card.
Thanks in advance for the help.
I verified a strange bug related to attachments and the deleting of the parent record chain.
For on-premise CRM administrators, you can use this script to find the orphans:
SELECT t1.* FROM Attachment t1 LEFT JOIN ActivityMimeAttachment t2 ON t2.AttachmentId = t1.AttachmentId WHERE t2.AttachmentId IS NULL
My assumption is that you would need to clean these up manually.
If you are using CRM Online, then you will have a much different story and one for which I do not have an answer.
In a nutshell, you need to use the CRM SDK write a small application that will compare the IDs in the Attachment table to those in the ActivityMimeAttachment table and produce a list of Attachments that are not connected to ActivityMimeAttachments, then delete those records.
Occasionally, and for reasons that are unclear, the CRM Email Router file Microsoft.Crm.Tools.EmailAgent.SystemState.xml gets corrupted which causes the Email Router service to stop (and your email along with it).
If you find your Email Router is not running and a restart does not work-it immediately starts and stops, check the Windows Application event log to see if you see any errors in the MSCRMEmail category.
They actual error can vary, but it contains a message stating some type of problem with the Microsoft.Crm.Tools.EmailAgent.SystemState.xml file.
Here is a sample Microsoft KB article outlining one such error:
Regardless of the error, the solution is to delete the Microsoft.Crm.Tools.EmailAgent.SystemState.xml file then restart the Email Router service.
ends on January 23rd at 12:00pm CST.
For more information and to register, visit:
In the first article we discussed using SQL to determine the size of the Attachments in the database.
My friend Aron Fischman shared with me similar queries using FetchXml:
<!--Email Attachment File Size Analysis--> <fetch distinct='false' mapping='logical' aggregate='true'> <entity name='activitymimeattachment'> <attribute name='activitymimeattachmentid' alias='EmailAttachmentCount' aggregate='count'/> <attribute name='filesize' alias='FileSizeSum' aggregate='sum'/> <attribute name='filesize' alias='FileSizeAvg' aggregate='avg'/> <attribute name='filesize' alias='FileSizeMax' aggregate='max'/> <attribute name='filesize' alias='FileSizeMin' aggregate='min'/> </entity> </fetch> <!--Annotation File Size Analysis--> <fetch distinct='false' mapping='logical' aggregate='true'> <entity name='annotation'> <attribute name='annotationid' alias='AnnotationCount' aggregate='count'/> <attribute name='filesize' alias='FileSizeSum_bytes' aggregate='sum'/> <attribute name='filesize' alias='FileSizeAvg_bytes' aggregate='avg'/> <attribute name='filesize' alias='FileSizeMax_bytes' aggregate='max'/> <attribute name='filesize' alias='FileSizeMin_bytes' aggregate='min'/> </entity> </fetch>
Way back when, like in version 3.0 and 4.0, Dynamics CRM had a hidden page that would display a list of entities and attributes in a concise list.
That went away in version 2011 but the good folks on the CRM SDK team (Jim specifically), created a managed solution that was included in the SDK.
The main purpose of the tool is to show you information about CRM entities that does not show up on the normal CRM user interface through the dialogs associated with solutions. This information is available, but only available via programmatic access.
My utility SnapShot! for Dynamics CRM uses exactly the same techniques to produce reports showing information not normally seen through the CRM UI.
After you have downloaded and installed the SDK, you can find the Metadata Browser here:
Install the Metadata Browser as you would any other managed solution. When finished, open the solution and go to the Configuration page, where you can launch the different Metadata Browser components.
The first tool is the main Metadata Browser itself, which you activate by clicking the Open Metadata Browser button:
The interface looks like this:
As you click on an entity on the left-hand side, it’s properties will be displayed on the right.
At this point you can either view or edit the entity and its details.
The second function will display a dialog that will allow you to edit an entity. This is the same dialog that is shown when you click the Edit Entity button on the Metadata Browser.
Here is what that interface looks like:
As you can see, you can edit or view any of the properties of the entity.
In conclusion, this is a simple yet powerful tool and one that is often overlooked but one which is great to have in your toolbox, should you need it.
Well, have you ever had a day when you are just an idiot?
It seems the tickets did not renew properly which made the event appear to be sold out, which it is not.
So, if you tried to register for the class and found the registration closed, I apologize. Please try again.
Here is a link to the original posting: