Skip to main content


Showing posts from 2012

How to create new (missing) columns for entities in your Data Export Service Azure SQL database

SharePoint 2010: SPUtility.GetFullUrl(properties.Site, properties.ListUrl) in Custom Workflow and Alternate Access Mappings

While testing a custom SharePoint workflow that automatically sends out emails I stumbled over a small issue that bugged me and our customer a lot.   The email sends out some text with an url link to a list item. The problem was that the external url to the server was used only at the beginning of the workflow and later when the workflow continued through some internal trigger the internal server host name was used.   E.g.: External Url: Internal Url: http://stgalegri   I found out the in the alternate access mapping settings the default url was the internal url. I changed the settings to the following:     I have the following explanation for this behavior: When the workflow is started and the following code is used: SPUtility .GetFullUrl(properties.Site, properties.ListUrl) The Site.HostName property will be instanciated with the context of the calling user that open the web site via the external url. This causes the email text wit

CRM 4.0: Query Parameters for new Activity records

In the blog of  St├ęphane Dorrekens  he wrote about the ability to use query parameters in CRM 2011 and CRM 4.0. As for CRM 4.0 there is a limitation for custom parameters as well as the usage of activity field names as query parameters for new activity records. If you create a new activity in CRM 4.0 it usually redirects to e.g. "/activities/appointment/edit.aspx". With this url you cannot add a query parameter like "subject=Test Appointment" or any other field like you could do for accounts or other entities in CRM 4.0. To workaround this issue you can use this approach instead to reach your final goal: You must use the URL "/userdefined/edit.aspx? etc =4201". Now you can set the " etc "-parameter to the correct object type code. (/sdk/list.aspx to find out the right code) After this you can use the same technique like for accounts, contacts, etc. (e.g. subject="Test") to prefill the new activity.