<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx</link><description>Let me guess, either you are looking to learn ‘how to import data’ or you are stuck with some issues while importing data. If one of these is the case, then you are at the right place. Importing data into CRM was never this easier. It would be good if</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8106442</link><pubDate>Sat, 08 Mar 2008 00:36:39 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8106442</guid><dc:creator>Manbhawan Prasad</dc:creator><description>&lt;p&gt;One correction: Section - 'what can go wrong'&lt;/p&gt;
&lt;p&gt;bullet point-4 - &amp;quot;Reference resolution does not work with manual maps even if you provide GUIDs.&amp;quot;&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8115810</link><pubDate>Sun, 09 Mar 2008 05:17:20 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8115810</guid><dc:creator>castor</dc:creator><description>&lt;p&gt;and now there is also scheduling tool from Castor for scheduling the imports made by the MS CRM 4.0 import tool: &lt;a rel="nofollow" target="_new" href="http://www.castorsoft.com/Products/ImportScheduler/ImportScheduler4.aspx"&gt;http://www.castorsoft.com/Products/ImportScheduler/ImportScheduler4.aspx&lt;/a&gt; &lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8174964</link><pubDate>Thu, 13 Mar 2008 01:27:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8174964</guid><dc:creator>ze-hussain</dc:creator><description>&lt;p&gt;when i load file, i am getting error &amp;quot;the number of field differ from column heaing&amp;quot;&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8181718</link><pubDate>Thu, 13 Mar 2008 19:28:30 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8181718</guid><dc:creator>Manbhawan</dc:creator><description>&lt;p&gt;You might want to check the following - &lt;/p&gt;
&lt;p&gt;1) Number of columns in data rows are same as header row.&lt;/p&gt;
&lt;p&gt;2) Further to this, you might open your file in notepad and check if for blank values also, it has field separator (,)&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8293501</link><pubDate>Mon, 17 Mar 2008 21:28:06 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8293501</guid><dc:creator>glennkimball</dc:creator><description>&lt;p&gt;I've put my csv file in the proper format, eliminated all extraneous characters, and have the sme number of columns in data rows as in the header row, but I still get the error &amp;quot;the number of fields differ from column heading&amp;quot; error. &amp;nbsp;Please advise.&lt;/p&gt;
&lt;p&gt;Glenn Kimball - 972-353-3800 x747&lt;/p&gt;
</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8327032</link><pubDate>Thu, 20 Mar 2008 09:29:39 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8327032</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi Glenn,&lt;/p&gt;
&lt;p&gt;This error comes only when there is a mismatch in number of header and data column or your filed delimiter is also part of your data.&lt;/p&gt;
&lt;p&gt;e.g &lt;/p&gt;
&lt;p&gt;In the following example the data in First Name field is &amp;quot;abc ,d&amp;quot; contains comma in it and comma (,) is also used as field delimiter. &lt;/p&gt;
&lt;p&gt;First Name, Last Name&lt;/p&gt;
&lt;p&gt;abc,d ,xyz&lt;/p&gt;
&lt;p&gt;Import wizard will flag above error in such case. For succesfully importing such data you'll have to use data delimiter as follows.&lt;/p&gt;
&lt;p&gt;&amp;quot;First Name&amp;quot;, &amp;quot;Last Name&amp;quot;&lt;/p&gt;
&lt;p&gt;&amp;quot;abc,d&amp;quot; ,&amp;quot;xyz&amp;quot;&lt;/p&gt;
&lt;p&gt;Can you please check if your csv has this kind of data?&lt;/p&gt;
&lt;p&gt;You can do this by going to the failure tab of submitted Import and look at the contents of source row colum.&lt;/p&gt;
&lt;p&gt;Hope this helps.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8335103</link><pubDate>Tue, 25 Mar 2008 08:11:16 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8335103</guid><dc:creator>aneal@nealabc.com</dc:creator><description>&lt;p&gt;Does anyone know the correct format to put .csv file when using DMM - for CRM Live uploade to associate a Contact Entity to the Parent Customer?&lt;/p&gt;
&lt;p&gt;I've tried the following:&lt;/p&gt;
&lt;p&gt;First Name, Last Name, &amp;lt;Parent Customer Name&amp;gt;&lt;/p&gt;
&lt;p&gt;First Name, Last Name, &amp;lt;Parent Customer GUID&amp;gt;&lt;/p&gt;
&lt;p&gt;First Name, Last Name, &amp;lt;Name, {GUID}&amp;gt;&lt;/p&gt;
&lt;p&gt;None of these work as well as they don't work in the manual instance to upload - can't seem to find the correct format documented anywhere.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8337204</link><pubDate>Wed, 26 Mar 2008 07:55:14 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8337204</guid><dc:creator>Raju Kulkarni</dc:creator><description>&lt;p&gt;Aneal,&lt;/p&gt;
&lt;p&gt;The csv data required to associate a contact entity to its Parent Customer through DMM could be in any format. To migrate such data, you will need to create a lookup mapping. A demo of how to migrate such references/relationships/associations is available@ &lt;a rel="nofollow" target="_new" href="http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx"&gt;http://blogs.msdn.com/crm/archive/2008/01/04/microsoft-dynamics-crm-4-0-data-migration-manager-with-john-o-donnell.aspx&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;You can also find these details in the help that comes with DMM. Search for the page: 'Define Relationship - Wizard Page' in the help file.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8345683</link><pubDate>Mon, 31 Mar 2008 17:27:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8345683</guid><dc:creator>revs</dc:creator><description>&lt;p&gt;I am also haveing import issues like Glenn. I have double and triple checked the CSV format, and tried quoted non-quoted text etc. Keeps saying that the header fields and columns do not match up!.&lt;/p&gt;
&lt;p&gt;Any other ideas?&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8347748</link><pubDate>Tue, 01 Apr 2008 12:56:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8347748</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi Revs,&lt;/p&gt;
&lt;p&gt;Can you share the contents of your csv (header row and data row) for which this this error is coming.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8353370</link><pubDate>Thu, 03 Apr 2008 13:16:31 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8353370</guid><dc:creator>revs</dc:creator><description>&lt;p&gt;Thanks for the offer of help Huma. I have managed to find the issue however. &lt;/p&gt;
&lt;p&gt;There were invisible characters in the file causing issues - they did not show up in Notepad, but after close inspection in another application I was able to find and remove them.&lt;/p&gt;
&lt;p&gt;revs&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8374414</link><pubDate>Thu, 10 Apr 2008 13:01:49 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8374414</guid><dc:creator>Ben Hiep</dc:creator><description>&lt;p&gt;I have the same csv issue.&lt;/p&gt;
&lt;p&gt;Strange enough if you use any Microsoft product to export a csv file. For instance contacts from outlook to crm or from access.&lt;/p&gt;
&lt;p&gt;Also strange that I do not see any synchronisation from outlook to crm where contacts are involved. It is a more likely scenario first having an email system and then choosing a CRM system then the other way around or am I crazy?&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8380282</link><pubDate>Fri, 11 Apr 2008 16:53:44 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8380282</guid><dc:creator>Shashank</dc:creator><description>&lt;p&gt;Does anyone know the correct format to put .csv file for BULKIMPORT&lt;/p&gt;
&lt;p&gt;I've tried the following:&lt;/p&gt;
&lt;p&gt;First Name, Last Name, &amp;lt;Parent Customer Name&amp;gt;&lt;/p&gt;
&lt;p&gt;First Name, Last Name, &amp;lt;Parent Customer GUID&amp;gt;&lt;/p&gt;
&lt;p&gt;But none of these works.Can some one pls help regarding this as crucial for us.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8382223</link><pubDate>Sat, 12 Apr 2008 00:31:11 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8382223</guid><dc:creator>Bob</dc:creator><description>&lt;p&gt;Has anyone else run into this problem?&lt;/p&gt;
&lt;p&gt;I can import contacts and products but when I try to import account it fails.&lt;/p&gt;
&lt;p&gt;I have created a very simple test csv file with 1 data row in notepad and I am using auto-map. &amp;nbsp;It is failing at the &amp;quot;Transform Parse Data&amp;quot; stage.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8396897</link><pubDate>Tue, 15 Apr 2008 10:34:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8396897</guid><dc:creator>Manish</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;I am trying to import data from CSV file but so far I am unable to do that. I have followed the process and at the end clicked &amp;quot;IMPORT&amp;quot; button but nothing has happened thereafter.&lt;/p&gt;
&lt;p&gt;Under Workflow/Imports - state says &amp;quot;SUBMITTED&amp;quot;&lt;/p&gt;
&lt;p&gt;Under Settings/System Jobs - State says &amp;quot;WAITING&amp;quot;&lt;/p&gt;
&lt;p&gt;jobs are in waiting state for last two days.&lt;/p&gt;
&lt;p&gt;Can you please help me ?&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8398672</link><pubDate>Wed, 16 Apr 2008 09:11:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8398672</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi Manish,&lt;/p&gt;
&lt;p&gt;It seems that Microsoft CRM Asynchronous process service is not running on your CRM installation.&lt;/p&gt;
&lt;p&gt;if it is not running kindly start it.Import should work fine after this.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8398678</link><pubDate>Wed, 16 Apr 2008 09:21:16 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8398678</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi Bob,&lt;/p&gt;
&lt;p&gt;What error are you seeing in Failure tab of import form for the data row?&lt;/p&gt;
&lt;p&gt;Any error in Tranformation phase usually means either data in lookup/picklist columns are not specified correctly.&lt;/p&gt;
&lt;p&gt;For Lookup type of column:&lt;/p&gt;
&lt;p&gt;In the column that you use to create the lookup, such as the Parent Customer column in the Contact record type, use the exact value that is in Microsoft Dynamics CRM. For example, if you already have an account named &amp;quot;A Bike Store&amp;quot;, the following contacts.csv file could be used to import two contacts with this account as a parent customer: &lt;/p&gt;
&lt;p&gt;First Name,Last Name,Parent Customer&lt;/p&gt;
&lt;p&gt;Alan,Brewer,A Bike Store&lt;/p&gt;
&lt;p&gt;Ann,Beebe,A Bike Store&lt;/p&gt;
&lt;p&gt;Important The value used to create the lookup must be unique. For example, if there are two accounts with the name &amp;quot;A Bike Store&amp;quot;, the records will not be imported.&lt;/p&gt;
&lt;p&gt;For PickList type of column: &lt;/p&gt;
&lt;p&gt;Make sure the values used in your source file have consistent capitalization. For example, do not include values for the Rating attribute in Leads as &amp;quot;Warm&amp;quot; and &amp;quot;warm&amp;quot;. If the source file values differ just by case, importing records with either variant might fail. &lt;/p&gt;
&lt;p&gt;Hope this helps.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8398695</link><pubDate>Wed, 16 Apr 2008 09:41:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8398695</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi Shashank,&lt;/p&gt;
&lt;p&gt;The lookup columns in like &amp;quot;Parent Customer&amp;quot; can only be imported using bulk import if you are using AutoMap.&lt;/p&gt;
&lt;p&gt;Kindly see my reply to Bob for the expected data format for lookup type of columns if you are specifying name.Giving a guid also works.&lt;/p&gt;
&lt;p&gt;If it doesn't help kindly share the data in row and error you are getting.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>Bulk Record Deletion in Microsoft CRM Online</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8421854</link><pubDate>Thu, 24 Apr 2008 18:16:47 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8421854</guid><dc:creator>Microsoft Dynamics CRM Team Blog</dc:creator><description>&lt;p&gt;This blog post will cover custom filter-based mass record deletion for a given entity System. Note: If&lt;/p&gt;
</description></item><item><title>Bulk Record Deletion in Microsoft CRM Online</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8421999</link><pubDate>Thu, 24 Apr 2008 18:59:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8421999</guid><dc:creator>Microsoft CRM Live Team</dc:creator><description>&lt;p&gt;This blog post will cover custom filter-based mass record deletion for a given entity System. In this&lt;/p&gt;
</description></item><item><title>Bulk Record Deletion in Microsoft CRM Online</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8422042</link><pubDate>Thu, 24 Apr 2008 19:14:27 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8422042</guid><dc:creator>Microsoft Dynamics CRM Team Blog</dc:creator><description>&lt;p&gt;This blog post will cover custom filter-based mass record deletion for a given entity System. In this&lt;/p&gt;
</description></item><item><title>Duplicate Detection Security Model</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8438029</link><pubDate>Tue, 29 Apr 2008 18:36:01 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8438029</guid><dc:creator>Microsoft Dynamics CRM Team Blog</dc:creator><description>&lt;p&gt;Security model of duplicate detection is in accordance with the security flow of MSCRM v4 which is very&lt;/p&gt;
</description></item><item><title>Duplicate Detection Security Model</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8438202</link><pubDate>Tue, 29 Apr 2008 19:10:52 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8438202</guid><dc:creator>Microsoft CRM Live Team</dc:creator><description>&lt;p&gt;Security model of duplicate detection is in accordance with the security flow of MSCRM v4 which is very&lt;/p&gt;
</description></item><item><title>Duplicate Detection Security Model</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8438275</link><pubDate>Tue, 29 Apr 2008 19:32:08 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8438275</guid><dc:creator>Microsoft Dynamics CRM Team Blog</dc:creator><description>&lt;p&gt;Security model of duplicate detection is in accordance with the security flow of MSCRM v4 which is very&lt;/p&gt;
</description></item><item><title>Duplicate Detection Security Model</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8467106</link><pubDate>Thu, 08 May 2008 00:01:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8467106</guid><dc:creator>Microsoft Dynamics CRM Team Blog</dc:creator><description>&lt;p&gt;Security model of duplicate detection is in accordance with the security flow of MSCRM v4 which is very&lt;/p&gt;
</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8499684</link><pubDate>Tue, 13 May 2008 12:54:49 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8499684</guid><dc:creator>Priyanka Tiwari</dc:creator><description>&lt;p&gt;This is realy helpful to import data in CRM.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8514293</link><pubDate>Fri, 16 May 2008 21:23:05 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8514293</guid><dc:creator>Bill Smith</dc:creator><description>&lt;p&gt;There is some kind of serious error here making the import of simple contact and account data a real problem. &lt;/p&gt;
&lt;p&gt;it is much too sensitive - and now I have a very clean file and it still gets errors on every contact even though Notepad and excel say the *.csv file is fine. &lt;/p&gt;
&lt;p&gt;As this is impacting every new user of CRM I urge you to assign resources to this and see it as it is - a disasterous error which seriously impacts first time users. Like buying a toy at Christmas that just does not work.&lt;/p&gt;
&lt;p&gt;250-386-9926&lt;/p&gt;
&lt;p&gt;Myzan - Gold Partner&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8527034</link><pubDate>Wed, 21 May 2008 11:14:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8527034</guid><dc:creator>Manish</dc:creator><description>&lt;p&gt;Hi Huma,&lt;/p&gt;
&lt;p&gt;Thanks for your reply.&lt;/p&gt;
&lt;p&gt;I have checked the Microsoft CRM Asynchronous process service and it is running. Still the status is waiting.&lt;/p&gt;
&lt;p&gt;please help me what to do.&lt;/p&gt;
&lt;p&gt;Regards,&lt;/p&gt;
&lt;p&gt;Manish&lt;/p&gt;
&lt;p&gt;=========================&lt;/p&gt;
&lt;p&gt;Hi Manish,&lt;/p&gt;
&lt;p&gt;It seems that Microsoft CRM Asynchronous process service is not running on your CRM installation.&lt;/p&gt;
&lt;p&gt;if it is not running kindly start it.Import should work fine after this.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8531152</link><pubDate>Thu, 22 May 2008 06:41:50 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8531152</guid><dc:creator>Manish</dc:creator><description>&lt;p&gt;Hi Huma,&lt;/p&gt;
&lt;p&gt;Thanks for your reply.&lt;/p&gt;
&lt;p&gt;I have checked the Microsoft CRM Asynchronous process service and it is running. Still the status is waiting.&lt;/p&gt;
&lt;p&gt;I have checked &amp;quot;System Jobs&amp;quot;. it says&lt;/p&gt;
&lt;p&gt;Import File perse - Waiting for resources&lt;/p&gt;
&lt;p&gt;Transform perse data - Waiting for resources&lt;/p&gt;
&lt;p&gt;Import - Waiting for resources&lt;/p&gt;
&lt;p&gt;please help me what to do.&lt;/p&gt;
&lt;p&gt;Regards,&lt;/p&gt;
&lt;p&gt;Manish&lt;/p&gt;
&lt;p&gt;=========================&lt;/p&gt;
&lt;p&gt;Hi Manish,&lt;/p&gt;
&lt;p&gt;It seems that Microsoft CRM Asynchronous process service is not running on your CRM installation.&lt;/p&gt;
&lt;p&gt;if it is not running kindly start it.Import should work fine after this.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8531478</link><pubDate>Thu, 22 May 2008 11:21:35 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8531478</guid><dc:creator>Manish</dc:creator><description>&lt;p&gt;Hi huma,&lt;/p&gt;
&lt;p&gt;I dont have Microsoft CRM Workflow services. how can i install this service&lt;/p&gt;
&lt;p&gt;this may be the reason the status is waiting.&lt;/p&gt;
&lt;p&gt;Regards,&lt;/p&gt;
&lt;p&gt;Manish&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8570742</link><pubDate>Tue, 03 Jun 2008 04:50:19 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8570742</guid><dc:creator>Vannessa</dc:creator><description>&lt;p&gt;Import data status reason says submitted, but no import records returned and it has been over 5 hours...0 successes 0 errors 0 total count. &lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8571214</link><pubDate>Tue, 03 Jun 2008 11:30:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8571214</guid><dc:creator>iva_doycheva</dc:creator><description>&lt;p&gt;Hi, there.&lt;/p&gt;
&lt;p&gt;I there any way to import many .csv files and their map in xml file. And this to be by code behind, not using this tool.&lt;/p&gt;
&lt;p&gt;Greethings, Iva&lt;/p&gt;
</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8571535</link><pubDate>Tue, 03 Jun 2008 16:57:43 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8571535</guid><dc:creator>a.maris</dc:creator><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;I have the same problem as Manish: when i try to import, the status is waiting. The Microsoft CRM Asynchronous process service is running. I need a sollution. What can i do?&lt;/p&gt;
&lt;p&gt;Regards,&lt;/p&gt;
&lt;p&gt;Andrei&lt;/p&gt;
</description></item><item><title>Microsoft Dynamics CRM Team Blog : Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8579245</link><pubDate>Sat, 07 Jun 2008 03:22:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8579245</guid><dc:creator>Weddings</dc:creator><description>&lt;p&gt;Let me guess, either you are looking to learn ‘how to import data’ or you are stuck with some issues while importing data. If one of these is the case, then you are at the right place. Importing data into CRM was never this easier. It would be good i&lt;/p&gt;
</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8611868</link><pubDate>Tue, 17 Jun 2008 19:35:47 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8611868</guid><dc:creator>Jennyfer</dc:creator><description>&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;I am having the same problem as Manish. &amp;nbsp;When I try restarting the service, it says that the service started and stopped since it is not being used. &amp;nbsp;&lt;/p&gt;
&lt;p&gt;Thank you, &lt;/p&gt;
&lt;p&gt;Jennyfer&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8613642</link><pubDate>Wed, 18 Jun 2008 05:31:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8613642</guid><dc:creator>Manish</dc:creator><description>&lt;p&gt;Dear All,&lt;/p&gt;
&lt;p&gt;I have solution for the problem of Importing data through .csv file.&lt;/p&gt;
&lt;p&gt;Please go to this link on Microsoft website.&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://msdn.microsoft.com/en-us/library/bb291036.aspx"&gt;http://msdn.microsoft.com/en-us/library/bb291036.aspx&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Download BulkImport.Exe and install it. It C# file and build solution. Try to run it as it is and see whether it works or not. I tried to run as it is but i got error message-401 - regarding unauthorised access and 404 regarding proxy settings. &lt;/p&gt;
&lt;p&gt;So If you get the same error, what i suggest is to build the solution in studio and copy the exe from DEBUG folder and paste anywhere on your CRM server(may be on desktop) and run it. &lt;/p&gt;
&lt;p&gt;If you are able to connect the CRM server then &lt;/p&gt;
&lt;p&gt;you are lucky but i was not so lucky. I made one change in the code and then I was able to connect it. &lt;/p&gt;
&lt;p&gt;If you get error even after running the solution file from CRM server, then debug the code and fix it. If your CRM server is installed properly then i think you should get the same error what I got. I made one change in codding which is below.&lt;/p&gt;
&lt;p&gt;open BULKIMPORT.sln file&lt;/p&gt;
&lt;p&gt;right click BulkImportForm.cs and select view code&lt;/p&gt;
&lt;p&gt;go to &amp;quot;ValidateConnectionInformation(string serverUrl, string userId, string userPassword)&amp;quot; method&lt;/p&gt;
&lt;p&gt;if you have not made any changes in this file before then go to line no 1140 and insert one line (may be message)&lt;/p&gt;
&lt;p&gt;at line 1139 the statement is &lt;/p&gt;
&lt;p&gt;if (responseHtml.IndexOf(CRM_TEST_HTML) &amp;gt; -1)&lt;/p&gt;
&lt;p&gt;add one line after this (message - which I have added).&lt;/p&gt;
&lt;p&gt;MessageBox.Show(&amp;quot;after responsehtml&amp;quot; + responseHtml.IndexOf(CRM_TEST_HTML));&lt;/p&gt;
&lt;p&gt;or &lt;/p&gt;
&lt;p&gt;MessageBox.Show(&amp;quot;any message&amp;quot;);&lt;/p&gt;
&lt;p&gt;save it and build the solution and run it. I am sure it will work.&lt;/p&gt;
&lt;p&gt;In .csv file, make sure your first line is heading. Heading must match with the attribute name in CRM (not the display name of attribute like text box and name is first_name_textbox and not First Name)&lt;/p&gt;
&lt;p&gt;Also if you have date in one of your column in .csv file, change your regional setting of CRM SERVER to (English - United State) and date format is (m/d/yyyy).&lt;/p&gt;
&lt;p&gt;I am sure this will work.&lt;/p&gt;
&lt;p&gt;Best of Luck.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8622070</link><pubDate>Thu, 19 Jun 2008 18:34:46 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8622070</guid><dc:creator>Sarah</dc:creator><description>&lt;p&gt;We are also having very frustrating problems with importing straight forward .csv files using the data migration manager. &amp;nbsp;The error message suggests that we have different number of fields but we don't! &amp;nbsp;We've checked and double checked using notepad and can't see any issues with the file format which frustratingly appears to be identical (apart from the data) to another file that imported like a dream. &amp;nbsp;Please can microsoft acknowledge that there is a problem and at least let us know we're not all going crazy?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;p&gt;Sarah&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8624609</link><pubDate>Fri, 20 Jun 2008 08:35:35 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8624609</guid><dc:creator>Manu</dc:creator><description>&lt;p&gt;Hi Sarah,&lt;/p&gt;
&lt;p&gt;There is no known issue around this in the product. You must be having different number of fields in data rows than header row. Even if you have extra ',' (comma) then also it gets counted as one field. Pls make sure that you have equal number of ',' (commas) in the header row and data rows.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8657044</link><pubDate>Thu, 26 Jun 2008 18:09:20 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8657044</guid><dc:creator>James Perkins</dc:creator><description>&lt;p&gt;I suspect this problem about having different number of fields in data rows and header rows stems from carriage returns in, probably, the BusinessStreet (Street Address in Outlook) of an Outlook Contact record which has been exported from Outlook into a csv file in order that it can be imported into CRM 4. Certainly, having hit this problem myself, and then experimented with removing this Street Address field (most of which in the UK need to have multiple lines to define an address, which are therefore separated by carriage return characters) the error message in the Import Wizard seems to go away. Now, how to find a way of including this data and have it import successfully ? Why, oh why, if this really is the case, does Microsoft not test these things ! Anyone finding a solution to this please let me know on jperkins@accsimple.com, thanks.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8659641</link><pubDate>Fri, 27 Jun 2008 06:04:33 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8659641</guid><dc:creator>Huma</dc:creator><description>&lt;p&gt;Hi James,&lt;/p&gt;
&lt;p&gt;Carriage returns are not supported as part of data in CRM 4.0 Import. They are used to identify new row of the data in data file.&lt;/p&gt;
&lt;p&gt;Due to &amp;nbsp;this reason you get data and column mismatch error.&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Huma&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8684985</link><pubDate>Thu, 03 Jul 2008 21:10:08 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8684985</guid><dc:creator>Kendall Reed</dc:creator><description>&lt;p&gt;We are consistently having failures at the &amp;quot;Transform Parse Data&amp;quot; stage any time we attempt a Lead import that includes a column for &amp;quot;Industry&amp;quot;. &amp;nbsp;We are using automatic data map, all other picklists and lookups import OK if we delete that column from the csv. &amp;nbsp;These are not &amp;quot;list value is not mapped&amp;quot; errors, it's a system job failure, and it happens even if we delete all the data values from the &amp;quot;Industry&amp;quot; column in the csv. &amp;nbsp;If we delete the column outright, though, it runs OK. &amp;nbsp;Any thoughts on that?&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8690898</link><pubDate>Fri, 04 Jul 2008 22:55:37 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8690898</guid><dc:creator>Ezequiel</dc:creator><description>&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;I was trying to import some data into CRM and I always got the error &amp;quot;The selected map does not contain mappings for the column headings in the file you are trying to import&amp;quot;.&lt;/p&gt;
&lt;p&gt;After many attempts I changed the field delimiter from ; (semicolon) &amp;nbsp;to , (colon) and it worked perfectly.&lt;/p&gt;
&lt;p&gt;Is it a known bug of the import feature?&lt;/p&gt;
&lt;p&gt;Regards&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8721817</link><pubDate>Fri, 11 Jul 2008 21:27:50 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8721817</guid><dc:creator>Animan</dc:creator><description>&lt;p&gt;I can import the data as you desrcibed above but ho do I maintain the realtionships between the data.&lt;/p&gt;
&lt;p&gt;i.e.&lt;/p&gt;
&lt;p&gt;Child Table contains&lt;/p&gt;
&lt;p&gt;Chiild_ID&lt;/p&gt;
&lt;p&gt;Parent_ID&lt;/p&gt;
&lt;p&gt;Name&lt;/p&gt;
&lt;p&gt;Parent Table contains&lt;/p&gt;
&lt;p&gt;Parent_ID&lt;/p&gt;
&lt;p&gt;Name&lt;/p&gt;
&lt;p&gt;Description&lt;/p&gt;
&lt;p&gt;How can import these two tables into CRM and maintain their relationship so that when I look up the child It will also show me the Parent for that child,&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8857465</link><pubDate>Wed, 13 Aug 2008 13:44:06 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8857465</guid><dc:creator>Simon Shaw</dc:creator><description>&lt;p&gt;Please would someone alert me (&amp;amp; cc the board of course) if they have found a solution to the import job not being processed but waiting indefinitely (with Async service running ok).&lt;/p&gt;
&lt;p&gt;TIA, Simon&lt;/p&gt;</description></item><item><title>Data import</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8941378</link><pubDate>Wed, 10 Sep 2008 20:50:53 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8941378</guid><dc:creator>sanjai_pg</dc:creator><description>&lt;p&gt;Hi, when I do a data import in crm 4.0, I want to do duplicate detection (which is available). If there are duplicate records found, is it possible to still update the record with the additional data available. Eg. I import a record which shows as duplicate of another record in the system. But the record that I have tried to import has a few 'additional data' that the one present in the system. Is it possible to import these 'additional data' alone into the already present record, without importing the full record (which is obviously a duplicate).&lt;/p&gt;
</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#8999208</link><pubDate>Tue, 14 Oct 2008 12:02:54 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8999208</guid><dc:creator>Eddy Watts</dc:creator><description>&lt;p&gt;Hi, have a look at the Quickbix suite, very easy to install, &lt;a rel="nofollow" target="_new" href="http://www.quickbix.com"&gt;http://www.quickbix.com&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Cheers&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9006606</link><pubDate>Sun, 19 Oct 2008 23:04:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9006606</guid><dc:creator>Leyla</dc:creator><description>&lt;p&gt;at least for a very specific and complicated , &lt;/p&gt;</description></item><item><title>re: Importing Data in CRM </title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9058133</link><pubDate>Mon, 10 Nov 2008 19:04:22 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9058133</guid><dc:creator>Alley</dc:creator><description>&lt;p&gt;I have successfully imported over 500 files, but all files with a parent customer will not load:&lt;/p&gt;
&lt;p&gt;0x80040356...stating that the source data is not in the required format...I know it is though.&lt;/p&gt;
&lt;p&gt;All lines with a parent customer are failing.&lt;/p&gt;
&lt;p&gt;All the parent cutomers are in CRM already.&lt;/p&gt;
&lt;p&gt;What is going worng please?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;p&gt;Alley&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9060580</link><pubDate>Tue, 11 Nov 2008 21:12:36 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9060580</guid><dc:creator>Katrina</dc:creator><description>&lt;p&gt;Also receiving the 0x80040356 error on import for Leads, fails on the Rating field. &amp;nbsp;We also do not have the Automatic Data Map option shown in the screenshot here.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9113492</link><pubDate>Tue, 18 Nov 2008 01:58:57 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9113492</guid><dc:creator>CRM</dc:creator><description>&lt;p&gt;Hi&lt;/p&gt;
&lt;p&gt;I have an issue with the duplicate detection job on contacts. When i click on view duplicates it just doesnt load. Any suggestions on this please.&lt;/p&gt;</description></item><item><title>Importing data into standard fields in CRM (Created/Modified by, etc)</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9159949</link><pubDate>Mon, 01 Dec 2008 12:06:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9159949</guid><dc:creator>Peter Hörnell</dc:creator><description>&lt;p&gt;Hi there!&lt;/p&gt;
&lt;p&gt;I'm working with migrating data from an old custom made system into Microsoft Dynamics CRM 4.0.&lt;/p&gt;
&lt;p&gt;To my help I've been using a tool called Import Manager 2008 which has served me well this far. (I do know that you don't support this tool, hence my question is not about that tool itself).&lt;/p&gt;
&lt;p&gt;However, when it comes to the fields, created/modified by, and created/last modified (date) it seems I can't import into these field. I have the information of all my entities stored in a SQL Server environment.&lt;/p&gt;
&lt;p&gt;My question is: do you know a way to import data into these four fields? Any ideas on how to achieve this would be much appreciated.&lt;/p&gt;
&lt;p&gt;Best regards, &lt;/p&gt;
&lt;p&gt;Peter H&amp;#246;rnell&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9164297</link><pubDate>Tue, 02 Dec 2008 15:09:03 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9164297</guid><dc:creator>PAP</dc:creator><description>&lt;p&gt;How could we import Annotation that may be on several lines.&lt;/p&gt;
&lt;p&gt;The csv is fine for ex.&lt;/p&gt;
&lt;p&gt;field1, &amp;quot;a long field2&lt;/p&gt;
&lt;p&gt;on 2 lines&amp;quot;, field3&lt;/p&gt;
&lt;p&gt;but the import tools seems to be unable to understand that this is only one record and so complains that he find only one delimiter for each row.&lt;/p&gt;</description></item><item><title>Not able to see Asynchronous Processing Service</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9397969</link><pubDate>Thu, 05 Feb 2009 12:31:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9397969</guid><dc:creator>Mahesh</dc:creator><description>&lt;p&gt;How can i start the Asynchronous Processing Service in the MS Dynamics server? It is not there in Administrative tools/services. &lt;/p&gt;
&lt;p&gt;What should i do to install that service?&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9435160</link><pubDate>Fri, 20 Feb 2009 02:48:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9435160</guid><dc:creator>Andrew</dc:creator><description>&lt;p&gt;I also have a problem when exporting from outlook. &amp;nbsp;Users have multiple lines in the address fields and this inserts a manual line feed. I can remove this line feed easy enough in word and replace it with a comma but I really want to be able to split those other lines in to the appropriate street address field. so the 3rd line goes in to Street 3, 2 in to 2 and so on. Also if I just add a comma then the address 1: field becomes too long and won't impport anyway.&lt;/p&gt;
&lt;p&gt;If you were using outlook properly there is no way to map extensive address information to similar fields in CRM. &lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9435782</link><pubDate>Fri, 20 Feb 2009 12:59:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9435782</guid><dc:creator>Gillian</dc:creator><description>&lt;p&gt;Hi, I have an xml file with data for numerous tables against the contact including a set of new one to many tables. This can either be update or new data. Can I import from an XML file?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9435800</link><pubDate>Fri, 20 Feb 2009 13:09:08 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9435800</guid><dc:creator>Gillian</dc:creator><description>&lt;p&gt;I also need to run regular imports into CRM from xml files. What is the best tool to do this? I'm thinking of creating a service to pick up the xml files and import them into CRM and schedule the service. I don't know how to generate the ID's however and need some guidance on that please.&lt;/p&gt;
&lt;p&gt;thanks&lt;/p&gt;
&lt;p&gt;Gillian&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9441810</link><pubDate>Tue, 24 Feb 2009 00:44:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9441810</guid><dc:creator>Juan Carlos</dc:creator><description>&lt;p&gt;I was trying to import some data into CRM and I always got the error &amp;quot;The record is empty&amp;quot;&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9471865</link><pubDate>Thu, 12 Mar 2009 19:15:05 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9471865</guid><dc:creator>Geoff</dc:creator><description>&lt;p&gt;Trying to import a few records in a CSV file. Under Settings&amp;gt;Data Management&amp;gt;Imports it is still showing Status = Submitted after a few hours.&lt;/p&gt;
&lt;p&gt;I have checked, and all MS CRM services are running on the server. What would cause this to just sit here?&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9863134</link><pubDate>Mon, 10 Aug 2009 15:48:45 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9863134</guid><dc:creator>Szasza_boy</dc:creator><description>&lt;p&gt;A workaround for the &amp;quot;the number of field differ from column heaing&amp;quot; error:&lt;/p&gt;
&lt;p&gt;1) Put a new entry into &amp;quot;CRM Partners&amp;quot; manually.&lt;/p&gt;
&lt;p&gt;2) Export the data to XLS.&lt;/p&gt;
&lt;p&gt;3) Save the XLS as CSV.&lt;/p&gt;
&lt;p&gt;4) Correct the required fields if necessary. (i.e.: Name, Surname)&lt;/p&gt;
&lt;p&gt;5) Import the CSV file with automatic data mapping.&lt;/p&gt;
&lt;p&gt;It worked for me, but only with a limited amount of record columns. (The data export doesn't export all the manually filled data...:-()&lt;/p&gt;
&lt;p&gt;Anyway I'm also having a problem with the data import, because there is only &amp;quot;submitted&amp;quot; status. The Asynchronous Service is running... :-(&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9909708</link><pubDate>Tue, 20 Oct 2009 06:48:02 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9909708</guid><dc:creator>Tony</dc:creator><description>&lt;p&gt;Trying to import accounts but the jobs are in waiting status (other jobs are in completed status) i get the following errors in logs:&lt;/p&gt;
&lt;p&gt;System.Net.WebException: The request failed with HTTP status 404: Not Found. &lt;/p&gt;
&lt;p&gt;in System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse &lt;/p&gt;
&lt;p&gt;(SoapClientMessage message, WebResponse response, Stream responseStream, &lt;/p&gt;
&lt;p&gt;Boolean asyncCall) in &lt;/p&gt;
&lt;p&gt;System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke (String &lt;/p&gt;
&lt;p&gt;methodName, Object [] parameters) in Microsoft.Crm . &lt;/p&gt;
&lt;p&gt;SdkTypeProxy.CrmService.Execute (Request Request) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Execute (Object &lt;/p&gt;
&lt;p&gt;request) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Asynchronous.UserSettingsCacheLoader.RetrieveUserSettings &lt;/p&gt;
&lt;p&gt;(CrmService ICrmService, Guid userId) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Asynchronous.UserSettingsCacheLoader. LoadCacheData (Guid &lt;/p&gt;
&lt;p&gt;userId, IOrganizationContext context) in Microsoft.Crm.Caching.BasicCrmCache &lt;/p&gt;
&lt;p&gt;`2.CreateEntry (TKey key, IOrganizationContext context) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Caching.BasicCrmCache` 2.LookupEntry (TKey key, &lt;/p&gt;
&lt;p&gt;IOrganizationContext context) in Microsoft.Crm . &lt;/p&gt;
&lt;p&gt;Asynchronous.ImportOperation.GetUserLanguage (AsyncEvent asyncEvent) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Asynchronous.ImportOperation.InternalExecute (AsyncEvent &lt;/p&gt;
&lt;p&gt;asyncEvent) in Microsoft.Crm.Asynchronous.AsyncOperationCommand.Execute &lt;/p&gt;
&lt;p&gt;(AsyncEvent asyncEvent) in Microsoft.Crm.Asynchronous.AsyncHostHandler.Handle &lt;/p&gt;
&lt;p&gt;(AsyncEvent asyncEvent) in &lt;/p&gt;
&lt;p&gt;Microsoft.Crm.Asynchronous.QueueManager.PoolHandler.ProcessAsyncEvent &lt;/p&gt;
&lt;p&gt;(AsyncEvent asyncEvent)&lt;/p&gt;
&lt;p&gt;what can i chwck ??&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9925674</link><pubDate>Thu, 19 Nov 2009 19:15:10 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9925674</guid><dc:creator>G-Man</dc:creator><description>&lt;p&gt;Whenever I try to import a .csv file using my &amp;nbsp;mapping, the Status is showing Waiting. The Asynchronous Prossing service is runing. Do you have any suggestions on how to resolve this issue.&lt;/p&gt;</description></item><item><title>re: Importing Data in CRM 4.0 Made Easier</title><link>http://blogs.msdn.com/crm/archive/2008/03/07/importing-data-in-crm-4-0-made-easier.aspx#9931344</link><pubDate>Wed, 02 Dec 2009 10:47:35 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9931344</guid><dc:creator>Jason</dc:creator><description>&lt;p&gt;I have an odd problem with this system: I manage to import a whole pile of contacts and their asscoiated accounts via the tool .. great! But some of the imports fail and are logged as failures. &lt;/p&gt;
&lt;p&gt;When I go to the analysis pane (I.e. I open up the import results window) and click on the 'Failures' list I get this error with a big red cross&lt;/p&gt;
&lt;p&gt;Error&lt;/p&gt;
&lt;p&gt;An error has occured&lt;/p&gt;
&lt;p&gt;Try this action again. if the problem continues check the Microsoft Dynamics CRM Community for solution or contact your organizations Microsoft Dynamics CRM Administrator. Finally you can contact Microsoft Support&lt;/p&gt;
&lt;p&gt;So I cant 'see' the failures. In this case I know what 'most' of them are (duplicates) but I'd still like to be able to see them for obvious reasons&lt;/p&gt;
&lt;p&gt;Any idea as to why this might happen?&lt;/p&gt;</description></item></channel></rss>