Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) GUID - Actual Data (SQ...

GUID - Actual Data (SQL CRM Database)

(0) Share

Report

Posted on by Community Member Microsoft Employee

We are trying map the SQL CRM data to a new system. The actual data doesn't appear on the output sheet but numeric values appear which are GUIDs *{879B70A5-4ABC-E411-80C6-000D3A30A90A}. I require the actual data to appear as Employee Id : 120987

Please assist

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Edison Lai 85 on at

Like (0)

Report

RE: GUID - Actual Data (SQL CRM Database)

How many records your have? Try to export it from old system to excel and Data Import in new system, but you should aligned same schema.
Gopalan Bhuvanesh 11,397 on at

Like (0)

Report

RE: GUID - Actual Data (SQL CRM Database)

Hi

It all depends upon how you plan (methods) to do so.

Are you using any tool? How many entities you are going to import (and how many lookup fields in that)?
Community Member Microsoft Employee on at

Like (0)

Report

RE: GUID - Actual Data (SQL CRM Database)

yes that is correct, its a lookup field. How do i get the actual value on the table for that specific look up field? any idea?
Gopalan Bhuvanesh 11,397 on at

Like (1)

Report

RE: GUID - Actual Data (SQL CRM Database)

Hi

I think you are talking about the lookup field.

If your current record is referring another table then you would have the GUID value (foreign key).
Community Member Microsoft Employee on at

Like (0)

Report

RE: GUID - Actual Data (SQL CRM Database)

on the table, when we add a field called employee name, numeric values come up instead of text data.
Suggested answer

Kishor Kumar 3,702 on at

Like (0)

Report

RE: GUID - Actual Data (CRM Database)

Try to have column for GUID as its more helpful, plus with your required data as you wish
Gopalan Bhuvanesh 11,397 on at

Like (0)

Report

RE: GUID - Actual Data (CRM Database)

Hi

I am not sure.

If you are creating the table, why cannot you add this Account Id column to that table.
Community Member Microsoft Employee on at

Like (0)

Report

RE: GUID - Actual Data (CRM Database)

Tables are created based on the required fields and then the SQL data is extracted
Gopalan Bhuvanesh 11,397 on at

Like (0)

Report

RE: GUID - Actual Data (CRM Database)

Hi

How are you exporting the data from your source CRM?