Create FTP site in IIS 7.0

The fact is FTP management is provided by IIS 6.0. So when we try to set FTP using IIS 7.0 it will ask us to Launch IIS 6.0. After that there is a series of steps to Configure a FTP which is clearly mentioned in the below link:

http://www.hostmysite.com/support/dedicated/iis/iisftp/

Predefined Escape Sequences in C# for ASP.Net

There are 11 predefined literals:

\’ single quote
\" double quote
\\ backslash
\0 null character
\a alert
\b backspace
\f form feed
\n new line
\r carriage return
\t horizontal tab
\v vertical tab

CRM 4 in windows server 2008

'Request IP Address has different address family from network address.'
Error while accessing CRM 4.0 in Windows Server 2008 Operating System

The fact is MSCRM 4.0 doesn't work with IPv6.

The fix for this is simple, open your hosts files
(:\windows\system32\drivers\etc\hosts)
and add a line for your server name there with an IPv4 address. Save and ping again to make sure it is working.
Once it is, do an IISReset and it will be working!

Refrence site: http://www.sadev.co.za/node/170

CRM 4.0 - Making & saving picklist values to CRM database dynamically

There is a common issue with picklist and CRM 4.0. If we add picklist items statically, while saving the values will be saved to CRM database properly. But while we add items dynamically it won't be saved with proper values but with NULL !!!

I have found a nice workaround for this issue as follows:

1) Instead of picklist type i declared the attribute as simple text
2) On the onLoad event i created a html select control dynamically and binded the values from CRM database.
3) i added this SELECT control to the innerHTML of our attribute
4) hide our CRM attribute (so now our CRM attribute is hidden and SELECT control is visible)
5) On onSave event i loop through the SELECT control and get the selected item
6) Set the selected item's value to the hidden CRM attribute
7) So while saving the correct selected value will be saved to database
SUCCESS

Limitations:

Can't declare the CRM attribute as business required
don't get any events like onChange for created SELECT control

Refered links are:

http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2839313&SiteID=27
http://www.stunnware.com/crm2/topic.aspx?id=JS1

CheckBox onChange() event in CRM 4.0

In CRM 4.0, the checkbox onChange doesn't work. it is the onClick() for checkbox that works. So we need to implement the onClick() event in the onLoad() event of the form. Sample code is as given below:

crmForm.all.new_check.onclick = function()
{
if ( crmForm.all.new_check.checked )
{
crmForm.all.new_from.style.display='none';
}
else
{
crmForm.all.new_from.style.display='inline';
}
}

CRM 4.0 look and feel customisation.

Dear All,

Here are some referral links to the below tasks:
1) Modifying the color of disabled form fields
2) Changing the color of a label
3) Removing a navigation bar entry at runtime
4) Setting the active tab
5) Hiding tabs at runtime
Code snippets available at : http://www.stunnware.com/crm2/topic.aspx?id=JS7

6) Setting the background color of a CRM form
7) and a lot more......
http://www.stunnware.com/crm2/topic.aspx?id=js13

Accessing CRM database via Javascript in CRM 4.0

To access the CRM database from JavaScript, use the following as a template:

var connection = new ActiveXObject("ADODB.Connection");
var connectionString = "Provider=SQLOLEDB;Server=STUNNWARECRM;Database=stunnware_mscrm;Integrated Security=sspi";

connection.Open(connectionString);

var query = "SELECT name FROM FilteredAccount";
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open(query, connection, /*adOpenKeyset*/1, /*adLockPessimistic*/2);
rs.moveFirst();

var values = "";

while (!rs.eof) {
values += rs.Fields(0).Value.toString() + " ";
rs.moveNext();
}

connection.Close();

alert(values);

Cheers
Binukumar S

reference: http://www.stunnware.com/crm2/topic.aspx?id=JS7

Using Javascript with CRM 4.0 Referral links

Hi all,

As per my R&D for Javascript with CRM 4.0 i found some usefull links which i like to share with you all. They are:

http://ronaldlemmen.blogspot.com/search/label/javascript

: General !

http://www.stunnware.com/crm2/topic.aspx?id=JS4

: General !

http://blogs.msdn.com/jonasd/archive/2007/05/21/playing-around-with-iframes.aspx

: Playing around with iframes !

http://www.stunnware.com/crm2/topic.aspx?id=JS11

: Changing the default view of related entity !

Resizing Windows/Forms in CRM 4.0

If you have a lot of data on an entity form, then you sometimes do want to force the page to open in full screen mode. There's a small javascript which will allow you to do this. Just add these two lines of code to the form onload of your entity form:

window.moveTo(0,0);
window.resizeTo(screen.availWidth, screen.availHeight);

Also, when you open a custom page you can also set the window size by using the same javascript function. In your code you can use the following function in the Page.OnLoad() to set the window size to match your requirements:

private void SetWindowSize(int iWidth, int iHeight)
{
StringBuilder sbResizeScript = new StringBuilder();
sbResizeScript.Append("\n");
ClientScript.RegisterClientScriptBlock(this.GetType(), "ResizeScript", sbResizeScript.ToString());
}

Cheers
Binukumar S

source: http://ronaldlemmen.blogspot.com/search/label/javascript

Accessing webservices via Javascript in CRM 4.0

how to create a piece of javascript code which retrieves data from a webservice ? This information has been included in the CRM SDK and you'll be able to find it here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/CrmSdk3_0/htm/v3d0accessingwebservices.asp

Here's the code example of that page:

// Declare variables.
var i=0; var j=0; var k=0; var r=0;
var serverUrl = "http://www.webservicex.net";

// This is the picklist.
switch (parseInt(event.srcElement.DataValue, 10))
{
case 1:
i = "JPY";
break;
case 2:
i = "GBP";
break;
case 3:
i = "EUR";
break;
}

// Instantiate at connection to the Web service and call the get method.
var xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");

xmlhttp.open("get", serverUrl + "/CurrencyConvertor.asmx/ConversionRate?FromCurrency=USD&ToCurrency="+escape(i), false);
xmlhttp.send();
var startTag = "";
var endTag = "";
var exch;
var valueStart = 0;
var valueEnd = 0;

// Parse the returned XML string.
valueStart = xmlhttp.responseXML.xml.indexOf(startTag, valueEnd) + startTag.length;

valueEnd = xmlhttp.responseXml.xml.indexOf(endTag, valueEnd+1);
exch = xmlhttp.responseXML.xml.substring(valueStart, valueEnd);

// Set the Exchange rate on the custom attribute.
crmForm.all.fabrikam_exchangerate.DataValue = parseFloat (exch);
j = crmForm.all.totalamount.DataValue;
var kk = j*(parseFloat(exch));

// Calculate and set the total sum in the selected currency.
crmForm.all.fabrikam_totalcurrency.DataValue = kk;


Cheers
Binukumar S

reference: http://ronaldlemmen.blogspot.com/search/label/javascript