GUID - Actual Data (SQL CRM Database)

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (0)

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

How are you exporting the data from your source CRM?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Tables are created based on the required fields and then the SQL data is extracted

Was this reply helpful? Yes No
Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

I am not sure.

If you are creating the table, why cannot you add this Account Id column to that table.

Was this reply helpful? Yes No
Suggested answer

Kishor Kumar 3,710 on at

Like (0)

Report

Try to have column for GUID as its more helpful, plus with your required data as you wish

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gopalan Bhuvanesh 11,401 on at

Like (1)

Report

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).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

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)?

Was this reply helpful? Yes No
Suggested answer

Edison Lai 85 on at

Like (0)

Report

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.

Was this reply helpful? Yes No