Mapping to 'Owner' attribute using Data Migration Manager

TheMSsForum.com: The Microsoft Software Forum

I'm having a problem when I run the Data Migration Manager for MS CRM 4.0. I
try to map a valid User to the 'Owner' field and I keep getting an error
that the data is not in the right format. I can assign the user to other
fields that use User data just not the Owner one.

I've checked that the User has appropriate permissions, and I can change the
Owner to the User after through CRM, I just can't seem to do it during
migration.

Anyone have thoughts on this?

Thanks,
Jeff
Top

Re: Mapping to 'Owner' attribute using Data Migration Manager by ajaybhojwani

ajaybhojwani
Mon Mar 17 19:42:37 CDT 2008

In the source file you need to subsitute the Owner name column with
the GUID of the user record from CRM. You can get the GUID of the user
by running the following statement in SQL Server Management Studio on
the machine that has Data Migration Manager installed -

select systemuserid, fullname from MSCRM_MIGRATION.dbo.systemuserbase

Regards,

Ajay
Top

RE: Mapping to 'Owner' attribute using Data Migration Manager by BROSSE

BROSSE
Sat Apr 26 00:08:00 CDT 2008

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

"Jeff Wessling" wrote:

> I'm having a problem when I run the Data Migration Manager for MS CRM 4.0. I
> try to map a valid User to the 'Owner' field and I keep getting an error
> that the data is not in the right format. I can assign the user to other
> fields that use User data just not the Owner one.
>
> I've checked that the User has appropriate permissions, and I can change the
> Owner to the User after through CRM, I just can't seem to do it during
> migration.
>
> Anyone have thoughts on this?
>
> Thanks,
> Jeff
>
>
>
>
Top