If you are creating your own integration module for CRM, then it is very wise to make sure that the process is running only once. For performance reasons you can decide to split the process in multiple threads, but running a single process multiple times can cause quite some unforseen issues.The following code snippet will allow you to check if an application with the same name is running
Showing posts with label import. Show all posts
Showing posts with label import. Show all posts
Tuesday, 20 January 2009
Thursday, 17 July 2008
Not all emails are sent from MailMerge
Posted on 02:14 by Unknown
Yesterday I looked at an issue with a colleague of mine (Nico Verhagen). The problem was that a mailmerge quick campaign has been created which should send out approximately 1500 emails. When the quickcampaign had finished, there were only 43 emails sent and nothing failed. How could that be true?Apparently only 800 contacts had an email address specified, so that already is causing half of the
Sunday, 9 March 2008
Import CSV file to DataTable
Posted on 15:07 by Unknown
I'm preparing a demo right now and for this I'm importing a CSV file to CRM. Especially the piece around the import of data from a CSV file to a DataTable is very generic. I'm sharing it with you guys for if it does make sense for you to use this as well.class CSVReader{ public System.Data.DataTable GetDataTable(string strFileName) { System.Data.OleDb.OleDbConnection conn = new
Tuesday, 29 January 2008
Dynamics CRM and NAV Integration
Posted on 01:29 by Unknown
Many newsletters get into my mailbox and there are just a few which I read. One of them is the newsletter from my friends at Scribe. Especially in this newsletter, great news is made public. They will be releasing the NAV Adapter for Scribe Insight next month! This means that you will be able to integrate NAV with any other database or product where they do have an adapter for. Of course for
Wednesday, 23 January 2008
Overriddencreatedon
Posted on 01:11 by Unknown
Everybody who's performing data imports knows the problem. When you create a record in CRM, the created on field always points at the date the record is created. Ofcourse you could go into the database and update the date by using a SQL script. But then again, there is this good white angel hanging above your shoulder whispering "Don't do it, it's not supported". No matter what this angel says,
Monday, 21 January 2008
AttributeInfo.TypeName(int) != AttributeMetadata.Type.Name(float)
Posted on 01:05 by Unknown
You might bump into an error message while importing an entity from a customizations file. The error show could be:Error: lead: AttributeInfo.TypeName(int) != AttributeMetadata.Type.Name(float)The cause of this error is a mismatch in attribute type. Usually a field has been removed in the other environment and has been recreated with another attribute type. The type in your destination CRM system
Thursday, 17 January 2008
Dynamics CRM 4.0 Test Data
Posted on 04:45 by Unknown
The test data to be used in demo's etcetera is available on the Microsoft download site. Here you can find the exe and details: http://www.microsoft.com/downloads/details.aspx?FamilyId=D5F77EE7-3D01-4944-B5DC-C8CDC8123DF4&displaylang=en
Tuesday, 27 November 2007
Improve performance of Microsoft Dynamics CRM
Posted on 00:53 by Unknown
The performance of your CRM implementation is one of the key factors for customer acceptance. There are multiple options available for optimizing your system. Here's a list to get started:Microsoft - Optimize Microsoft Dynamics CRM 3.0Microsoft - Optimize Microsoft Dynamics CRM 1.2Aaron Elder - Optimize the CRM Webservice CallsBrein Reid - Reduce the amount of useless calls to IIS 6.0
Tuesday, 15 May 2007
Interesting issues with the CRMDateTime continuum.
Posted on 03:21 by Unknown
This is a guest post by a friend and colleague of mine: Leon Krancher. He has been digging into an issue regarding CRMDateTime and integration. Make sure you read this before you start your own integration!Well I guess I’d better start off with a little introduction. My name is Leon Krancher and I’m a colleague of Ronald at Avanade. As we both work with CRM we occasionally find time to get
Thursday, 19 April 2007
Tips on using the publishreports executable
Posted on 06:55 by Unknown
Update: see the bottom for a solution to be able to use the filter in the report!Some days ago I posted an article around how to move reports from a server to another server in the development process. Now I've been working with it, I can share some tips.The first tip is on how to publish the reports. How does the publishreports.exe know where to find the publish.config and the reports? This
Thursday, 29 March 2007
Import has encountered an error and has been canceled
Posted on 04:30 by Unknown
Another error resolving post.Here's the error:Import has encountered an error and has been canceled. Your system has been restored to its original state. Import has been canceled because the ISV.Config file could not be imported. Check that the file format is valid.Also connecting to the CRM Workflow Manager will probably not work. This error message is thrown:The specified Microsoft CRM server
Monday, 19 February 2007
A schema validation error has been detected
Posted on 05:08 by Unknown
More and more MS CRM developers are experiencing this error message:A schema validation error has been detected at line 21087, position 16.This error shows up if you want to import a customizations file which has been exported from a system which has the Update Rollup package 1 installed.There may be multiple reasons for this error to show up, but at least one of them is the existence of one of
Friday, 16 February 2007
Error while importing via Tools -> Import
Posted on 07:44 by Unknown
Today I got a question regarding importing via the CRM Import tool (Menubar -> Tools -> Import). Only a small number of records would import, all the others would not. Even though the source seemed fine, they did throw this error:0x80040328: Number of columns does not match the header rowThis appears to be related to the source anyway. When you save an file in Excel 2003 as csv, it does the
Subscribe to:
Posts (Atom)