tag:blogger.com,1999:blog-5719332149137711434.post3251971389052204020..comments2024-02-22T23:24:18.865+11:00Comments on Leon's CRM Musings: Importing tricks for Dynamics CRM 3.0 and 4.0Leon Tribehttp://www.blogger.com/profile/05713816319075495059noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5719332149137711434.post-23147883750368706422012-04-24T22:47:26.606+10:002012-04-24T22:47:26.606+10:00I found a KB article for updating lookup reference...I found a KB article for updating lookup references via Import tool<br /><br />http://support.microsoft.com/kb/981837/en-usPasqualhttps://www.blogger.com/profile/10221614325023800620noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-89757049458690367542011-06-21T11:34:17.541+10:002011-06-21T11:34:17.541+10:00A new trick for mass-stripping of hidden character...A new trick for mass-stripping of hidden characters. In the Find/Replace feature of Excel you can enter hidden characters and replace en-masse. Basically in the find box you type ALT-0010.Leon Tribehttps://www.blogger.com/profile/05713816319075495059noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-36512120779194687242011-01-31T22:39:33.534+11:002011-01-31T22:39:33.534+11:00try using GUID without { }....
Your Record:
First...try using GUID without { }....<br /><br />Your Record:<br />First Name, Last Name, Country Code<br />aa,bb,"ey_countrycode,{8A70C89C-DA85-4228-A37B-C3CDACA4E109}"<br /><br />New Record:<br />First Name, Last Name, Country Code<br />aa,bb,"ey_countrycode,8A70C89C-DA85-4228-A37B-C3CDACA4E109"SHONIhttps://www.blogger.com/profile/12103248525632634770noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-49831515930847210332010-01-08T02:15:04.512+11:002010-01-08T02:15:04.512+11:00Saved me some time for sure!Saved me some time for sure!Joel Anderssonhttps://www.blogger.com/profile/02144969481231480040noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-30065572798113923302009-09-03T07:08:04.083+10:002009-09-03T07:08:04.083+10:00Error on page would suggest an issue with the web ...Error on page would suggest an issue with the web page itself I think. I'd try different versions of IE perhaps or flushing the IE cache.Leon Tribehttps://www.blogger.com/profile/05713816319075495059noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-20237134236750958382009-09-02T23:47:14.852+10:002009-09-02T23:47:14.852+10:00This is a very helpful text and I came across one ...This is a very helpful text and I came across one of the bumps along the way.<br /><br />It does not solve my problem unfortunately. <br /><br />When I try to map the source file in the CRM it simply states "error on page" in the lower left corner. No pop-up or what ever. I have tried renaming all the categories in the csv (and a txt) file to CRM names but it does not help.<br /><br />Any suggetions ?Ziphttps://www.blogger.com/profile/11461126147919987589noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-2988838156691730222009-03-18T04:04:00.000+11:002009-03-18T04:04:00.000+11:00It may be the format of the GUID. Try the name of ...It may be the format of the GUID. Try the name of the country code i.e. the value in the primary string field for the entity, see if that fixes it.Leon Tribehttps://www.blogger.com/profile/05713816319075495059noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-4301741123483356562009-03-18T02:46:00.000+11:002009-03-18T02:46:00.000+11:00Thank you for the summary!I think I have gone thro...Thank you for the summary!<BR/><BR/>I think I have gone through all pages Google offers on this and still I cannot work out my problem.<BR/>I'm trying to import a simple contact with a simple lookup reference.<BR/>The lookup is the problem: "lookup reference could not be resolved"<BR/><BR/>My CSV looks like this:<BR/>First Name, Last Name, Country Code<BR/>aa,bb,"ey_countrycode,{8A70C89C-DA85-4228-A37B-C3CDACA4E109}"<BR/><BR/>whereas ey_countrycode is the referenced entity name, The Guid is a valid instance of it.<BR/><BR/>Can you think of any cure :) ?Unknownhttps://www.blogger.com/profile/15912630120252066096noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-64699198528429834102009-03-01T09:42:00.000+11:002009-03-01T09:42:00.000+11:00This is the most comprehensive post I've ever seen...This is the most comprehensive post I've ever seen on the topic! Excellent work Leon. I'll be sharing it! Thanks.Running With Scissorshttps://www.blogger.com/profile/18075932210056883142noreply@blogger.comtag:blogger.com,1999:blog-5719332149137711434.post-11572986972925773692009-02-14T02:15:00.000+11:002009-02-14T02:15:00.000+11:00Great Article! I have come across these issues sev...Great Article! I have come across these issues several times and although frustrating do give a better insight into CRM.<BR/><BR/>The Data Migration Manager is a much more powerful tool and can indeed import multiple entity data and link them, as long as you know how to tweak your data files to reference each other... <BR/><BR/>Cheers<BR/><BR/>AllanAllan Connollyhttps://www.blogger.com/profile/13282592471646992420noreply@blogger.com