4. September 2012 01:29
Many a times I run into this particular situation and somehow I observe people still retrieve all records and then loop through to get the total number of records. It is very easy to get it using the code given below.
QueryExpression query = new QueryExpression("account");
query.ColumnSet = new ColumnSet(true);
query.Criteria.AddCondition(new ConditionExpression("accountid", ConditionOperator.NotNull));
query.PageInfo = new PagingInfo();
query.PageInfo.Count = 1;
query.PageInfo.PageNumber = 1;
query.PageInfo.ReturnTotalRecordCount = true;
EntityCollection result = this.ServiceProxy.RetrieveMultiple(query);
int totalRecords = result.TotalRecordCount;
29. August 2012 10:43
This is a long due post almost a year or more. I was working with an ADFS 2.0 setup on a single box (Development only) and was facing challenges with installation and configuration of IIS Host Headers which will allow me to complete required steps for ADFS 2.0 setup for Microsoft Dynamics CRM 2011. When you are configuring a wildcard SSL certificate (*.crmxpress.com) in IIS snap-in you will notice that Host name is disabled when you try to configure site binding. After a little research, I found an article that described the steps to enable the host name.
- Open Microsoft Management Console (MMC) by Start -> Run -> Type MMC -< Enter.
- File -> Add/Remove Snap-ins.
- From the list of Snap-ins, select Certificates and add it to Console Root.
- Select appropriate option, in my case, it was My user account but you can select Service account or Computer account based on your configuration.
- Once the Snap-in has been added locate the certificate and right click-> Properties.
- In General tab, you will see Friendly name field. Enter *.<<yourdomainname>>.com or appropriate value based on your certificate.
- Click on Ok and now you can configure the site bindings and configure the host header.
8. April 2012 20:16
After a long time I am writing a post on CrmXpress and I will post my story so far, separately.
As of this post, I have a very important announcement to make. There is yet another release from CrmXpress and this time it is CrmXpress OptionSet Manager For Microsoft Dynamics CRM 2011. As the name suggests it's a very simple utility to manage OptionSets [Local and Global] within CRM 2011 and helps to automate really boring tasks i.e. to maintain [CRUD] option sets manually.
Here is a screenshot from the documentation :
Click Here to see the documentation in case you need any help with the usage of the app.
Click Here to download the latest stable build. As usual we intend to develop it further and we appreciate your feedback on the same.
PS: Watch out for few more CrmXpress releases in very near future.
24. January 2012 03:07
I have recently completed a set of exams [CRM 2011 and .Net 4.0] and almost thrice a week I check if new exams are released on CRM 2011, especially Extending Microsoft Dynamics CRM 2011 as this one is very important for CRM/xRM developers out there.
And good news is this exam is already out. Surprisingly the release date is 29th December 2011, I mean how many of us would have thought of checking released exams during the holiday season?
Anyways I am glad it is finally here and I intend to give it a shot ASAP. If you are looking for more information about the exam then follow this link.
8. December 2011 18:24
It works with Microsoft Dynamics CRM 2011 On-Premise as well as Online (With some creative thinking this utility can work with CRM 4.0 as well just you will have to put some efforts in order to introduce CRM 4.0 support). Thanks to Jamie Miley (http://mileyja.blogspot.com) the source code for this tool is available on CodePlex at: http://smartsoaplogger.codeplex.com/releases/76542/download/301730.
Also I would like to thank Jamie Miley for his efforts on building SOAP formatter (http://mileyja.blogspot.com/2011/03/crm-2011-jscript-soap-request-formatter.html) as I could build this tool very quickly using his codebase.
Here is a small video demo where SSL (I know SmartSoapLogger is a long name) connects with CRM Online and generates script and SOAP packets for a WhoAmI call.
6. December 2011 18:11
Microsoft Dynamics CRM lets you create trace files that monitor the actions performed by various Microsoft Dynamics CRM components. For example, CRM Async service can create its own trace file, which enables you to troubleshoot error messages or other issues with CRM Async service. Apart from that, these Trace files can be an excellent resource for an experienced CRM Developer to understand what exactly is going on behind the scenes.
CrmXpress TraceHelper helps you to enable/disable tracing for Microsoft Dynamics CRM with few clicks. It also gives you the option to manage the trace files from within a single window.
You can download it from here : http://www.crmxpress.net/Tools/CrmXpress.Win.TraceHelper.zip
Remember: once the settings are applied, IIS must be restarted to take the effect.
4. November 2011 17:59
It's been a long time since I thought to put this to public. I have used this tool for a quite a long time now. Basically, it allows you to create profiles with username and password. Now being CRM developer many a times you would want to launch CRM Web interface with another user's credentials. Generally, you would do so by using Run As or by creating a shortcut that will ask for credentials when it is clicked OR by disabling automatic logon in intranet zone.
I wanted to come up with a lot easier way to achieve this. That's why I made a simple utility that stores usernames and credentials and set of applications in a profile. You can create as many profiles as you want and add as many applications as you need. Credentials you provided are encrypted and stored with user settings. To add application, all you need to do is drag and drop a shortcut of the application or the application itself on to CrmXpress Run As Gui tool.
You can download it from here : http://www.crmxpress.net/Tools/CrmXpress.Win.RunAsGUI.zip
Your feedback is really important for me to provide feature upgrades/bugfixes.
Kindly note that I have tested this utility on Win7/Server2K8/Server2K8R2 x86/x64 editions with .NET Framework 2.0.
Here are steps to start using this tool.
- Launch CrmXpress.Win.RunAsGui.exe
- Click on Add. It will auto fill current user name and domain/workgroup name.
- Enter password.
- Click on Save. Your default user profile is now created.
- Click on Add again. It will auto fill current user name and domain/workgroup name. Change the name with any other domain/workgroup user name of your choice.
- Enter password for the user name that you have entered.
- Click on Save.
- Now you will have two profiles and you can access them via Profiles drop down list.
- Drag any application shortcut on to the CrmXpress.Win.RunAsGui's User Interface.
- The application will be added to the applications list for a given profile and it will be launched with credentials of whichever user profile you have selected.
- This program is provided as is without any guarantees or warranty.
- Although the author has attempted to find and correct any bugs in the free software programs, the author is not responsible for any damage or losses of any kind caused by the use or misuse of the programs.
- The author is under no obligation to provide support, service, corrections, or upgrades to this free software program.
28. October 2011 16:18
Here is another strange but interesting issue, I faced almost a month back. One of my acquaintances was trying to import a CRM Organization [They exported the database and were importing the database into an existing CRM installation] which was using a different domain. Everything was going fine until he reached to the point where you are supposed to map existing users with users from destination AD. The moment he reached that stage he was running into an Exception in Deployment Manager add-in [See the screenshot below].
After trying to troubleshoot this problem for a while, I found few pointers regarding empty domainname field in SystemUserbase table. Upon examination of the SystemUserbase table, we found that indeed there were few records with empty domainname field in there. Now INTEGRATION and SYSTEM are valid users of CRM and they do not have domainname mapped to them however, for every other record there must be an associated user from AD i.e. domainname field must be populated. In our case, there were few other users, which had empty domainname field. We filled in those fields with valid domain\username information and voila, import went just fine.
27. October 2011 16:56
Aha... yet another topic on User Accounts. Just last week or so I was discussing with a colleague of mine here at CrmXpress. It was about Service Accounts. Now we all know that if you are using a Service account [A dedicated account to run services for SQL or MSCRM or maybe even IIS], first thing you must do is during the creation of the service account itself, you MUST mark a checkbox labelled "Password Never Expires" so that the password expiry policies are not applied to this account.
Now in case you did not check this check box and your service account password expires, it will bring down all the dependent components/services/applications. To fix this quickly here are few places you might want to look into in case you end up with a service account with expired password. You can always set the password to what it was however some organizations have a policy against that. So you would want to look into places where you can change the password for a given service account. So here is a list of all the places that you should look into :
- Start -> Run -> Services.msc -> Sort by 'Log On As' column
- Start -> Run -> Inetmgr -> Expand Sites -> Select a web site which is using the service account -> Under Actions Pane -> Click on Basic Settings... -> Click on Connect As... button in the popup Window.
- Start -> Run -> Inetmgr -> Expand Application Pools-> Select an Application Pool which is using the service account -> Under Actions Pane -> Click on Advanced Settings... -> In the popup window -> Navigate to Process Model -> Set Identity Property.
- Check web.config files for encrypted\plaintext impersonation details
26. October 2011 12:04
If you have not already noticed that CrmXpress has always been run by BlogEngine.Net then well... know that it has been powered by BlogEngine.Net. As the new year arrives [Gujarati New Year is generally the next day of Diwali]. There were some unexpected problems during the upgrade and it brought this blog down for almost 3 days and I hope that it did not affect any one. If it did, sorry for the trouble caused and I would like to assure you all that in future we will not do an in-place upgrade without putting in effort to make sure that everything is working as per the expectations. Anyways now things are in control except our CrmXpress theme which shall be up and running soon.
Wish you all Happy Diwali and a Very Happy New Year!!! Stay tuned we have many gifts lined up for you.