When trying to map the Lookup with GUID during bulk import gives an error
message " The Source Data is not in the required format".Can anyone pull me
out of this.

Regards
Satish
Satish@mtccrm.com

On Apr 8, 3:26*am, Satish <Sat...@discussions.microsoft.com> wrote:
hi satish ,
this might be due to presence of commas in any of ur coloumn
values.plz try to remove all the commas from the fields and again try
to import

Hi Mitesh,
I tried out removing the commas from my source file.Even Still
I am not able to import the lookups using the GUID.

"rendezvouswithmitesh@gmail.com" wrote:

On Apr 10, 11:32*am, Satish <Sat...@discussions.microsoft.com> wrote:
if u r using simple bulk import feature of MSCRM 4.0 Instead use the
Data Migration Manager and use it to auto connect your
contacts to their parent accounts. I recorded a screencast at
channel9.msdn.com - search on the CRM tag and you should find it. The
new
data migration manager tool is a great way to import csv files and
link the
data across entities as the records are imported

Hi Mitesh,
Thank you for the reply.i have already done a data migration i
want to know why the LookUps are not getting mapped with the GUID during data
import.

I have your answer.

Create a 2nd mapping file (CSV) of user names. It should have 2 columns.
One is the Domain logon name "domain\userid", the 2nd column is name column
of the import file. Have column names like DomName and Import Name.

DomName, ImportName
testdom\testuser1,Test User
testdom\jdoe,John Doe

If your user names in the import file are Last, First, that's ok, just put
quotes around the name in the imput and User.csv file.

testdom\jdoe, "Doe, John"

When you import data, import your data file AND the user file. Map the data
fields. Map the input user name to the owner field. When you map the User
file, you map the DomName to "Domain User Name", map ImportName to NOTHING
(Ignore).

The next step the import process is "Specify User Data". This is where you
tell the DMM how to tied it together. Source User Attribute = DomName,
Microsoft Dynamics CRM User Attribute = Domain Logon Name, Source user
Attribute = ImportName.

It wil then ask you to verify the usernames if pulls from AD.


That will do it.



Brad Rosse
Stonebridge
brosse@sbti.com

"Satish" wrote:

Hi Brosse,
Thanks for your reply . I can able to migrate data using data
migration manger.But i am concerned about how to import lookups using Bulk
import.


"BROSSE" wrote: