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.
$url="http://crm.sardverb.com/Company/xrmservices/2011/OrganizationData.svc/ContactSet?`$filter=StatusCode/Value eq 1" $assembly = [Reflection.Assembly]::LoadWithPartialName("System.Web.Extensions") $count=0 $output = @() while ($url){ function GetData ($url) { $webclient = new-object System.Net.WebClient $webclient.UseDefaultCredentials = $true $webclient.Headers.Add("Accept", "application/json") $webclient.Headers.Add("Content-Type", "application/json; charset=utf-8"); $data=$webclient.DownloadString($url) return $data } $data=GetData($url) | ConvertFrom-Json $output += $data $count=$count+$data.d.results.length write-host $count if ($data.d.__next){ #$url=$null $url=$data.d.__next.ToString() } else { $url=$null } } $output.d.results | Select -ExcludeProperty ParentCustomerId,__metadata @{l="ParentCustomerID";e={$_.ParentCustomerID.Id}},* | Export-Csv -NoTypeInformation C:\Contact.csv
Hope that helps someone.
No comments yet.