Find the correct Organization Name in MSCRM 4.0

If you need to find the correct organization name of your ms crm 4.0 deployment, use the following query:

select uniquename from mscrm_config.dbo.organization

This is the name ms crm requires to connect to the correct organization.

Kevin Dosseray

Comments

Post a Comment

Popular posts from this blog

Scribe Certified!

Last week I managed to become Scribe Certified! In order to get the certification I had to pass 2 exams: Scibe Server and Sribe MSCRM Adapter. You can take the exams online so it is possible to look stuff up if you don't know the answer right away. The exams are not that easy, but if you have experience with the product and have read the training materials you should do just fine. Kevin Dosseray
Read more

Updating CRM Data from Excel

In the beta version of MS CRM 4.0 it was possible to update CRM data from Excel: you could export data to Excel, change the data in the Excel file, save it as an CSV file and import it back into CRM through the 'Data Management' -> 'Import' option. Sadly enough, with the official release of CRM 4.0, this useful feature of updating data from Excel was left out... But apparently, this is not completely true. You just need to know how to 'enable' the feature. So here we go: - Export the data you like to update to Excel (go to the grid or create an advanced find, select the records you want, click 'Export to Excel' and choose static worksheet). - In the Excel file, add a column to the left with the name of the entity as column name. In this column, add the Guids that correspond to the records. - Update some values and save the excel as a CSV. - In CRM, go to Settings -> Data Management -> Imports and create a new import record. - Select the CSV you ...
Read more

Disable CRM Form through JavaScript

I often get the question how to disable a form, so here it is: The trick is to disable all the fields that are on the form. You can do this by using the following JavaScript: if (crmForm.FormType == 2) { for( var i = 0 ; i { if( crmForm.all[ i ].req) crmForm.all[ i ].Disabled = true; } } In the code I check if the form is in the update modus (FormType == 2), because I don't think that disabling a form while in create modus makes much sense. In the real world you'd probably disable a form depending on the value of another field. Would you like to keep some fields editable, you can do the following: if (crmForm.FormType == 2) { for( var i = 0 ; i { if( crmForm.all[ i ].req && crmForm.all[i].id != "name") crmForm.all[ i ].Disabled = true; } } Here I disable all fields except the name field (crmForm.all[i].id != "name"). You can add other fields according to your needs. Just make sure you use the sc...
Read more