Category: MicrosoftCRM
-
Using PowerShell to extract all contacts from MS CRM 2011
We are moving to Salesforce from MSCRM 2011. We need to get our data out so we can import into Salesforce. Here is the PowerShell script I am using to export contacts to csv. Hope that helps someone.
-
When using PowerShell to pull REST data from MS CRM, escape `$filter !
Note to self. When trying to filter a REST response in PowerShell, by using the “$filter” parameter in the url (as with MS CRM 2011), you must escape the “$” with “`$”. For example: Does not work: $url=”http://crmserver.company.com/Organization/xrmservices/2011/OrganizationData.svc/ContactSet$filter=StateCode/Value eq 0″ Works: $url=”http://crmserver.company.com/Organization/xrmservices/2011/OrganizationData.svc/ContactSet`$filter=StateCode/Value eq 0″ Gets me every time, and I can’t figure out why my…
-
A simple javascript/AJAX function to post a SOAP request to CRM 2011
This is a simple function that I use to post a SOAP envelope to CRM 2011. Just pass the URL and the xml (you can create that with this function) and you should be good to go
-
Using AJAX and SOAP to create a CRM 2011 activity
I have posted a bunch of PowerShell scripts to interact with CRM 2011, now I am going to put up similar javascript versions. I feel that there is a lot of javascript content out there for CRM 2011, but most of it is javascript inside the actual CRM interface. I don’t see a lot of…
-
How to hide a field in a SharePoint EditForm.aspx page, append a replica, add a jQuery autocomplete, and put the selected value in the original field.
If you look at this old post, you can see a technique that I used to hide a form field, and then append read-only data after it. I wanted to use this technique to hide a field in a form, append a replica with a jQuery autocomplete, and based on the selected value from the…
-
PowerShell 3 – Invoke-WebRequest and Invoke-RestMethod, unable to set the Accept header?
With both of these commands, when I try to add an Accept header (I want to receive my CRM 2011 data in JSON format, so I need Accept=application/json) I receive the error: “This header must be modified using the appropriate property or method.” I think this is a bug. This link shows the bug, and…
-
SharePoint 2010 modal dialog (showModalDialog) without an existing page
I was retrieving Activity data from a Microsoft CRM 2011 REST query. I wanted to have a popup with more information. I decided to use the built in showModalDialog. The problem was that all the examples I found showed how to popup an existing page. I wanted the modal to contain data that didn’t exist…
-
SharePoint 2010, CSOM and External Lists – must use LoadQuery
I was working on some JavaScript code to pull data from an External List that was pointing to a Microsoft CRM 2011 database. The code was being used to populate a jQuery autocomplete like this post. In that post you can see on line 10, I use the “load” method. This worked, but if I…
-
Looping through a SharePoint List Column with jQuery and replacing a GUID with a name from CRM 2011
This is a very specialized piece of code, but it came together nicely, so I thought I would share it. I have a SharePoint List that has a bunch of Microsoft CRM 2011 Contact GUIDs in it. Some columns have one GUID and others have multiple GUIDs separated by semicolons. My goal was: when a…
-
Using PowerShell to add a Contact to a CRM 2011 MarketingList (SOAP)
We had a user delete a Marketing List. I needed to recreate it. I went to a database backup and found the GUID of the deleted list. Then I used the following SQL query to find the GUIDs of all the members of that list: I saved the EntityId column to a text file, and…