Solved

How to get GUIDs in CRM

Posted on 2010-09-10
7
1,108 Views
Last Modified: 2013-11-24
I wanted to get a set of GUIDs of the customers that i have just imported. to explain my requirement,
Let's say i have just inserted 1000  records of customers(accounts). Now I need to export the customers details along the each customer GUID. Is this possible? If possible please explain how to achieve this task.

0
Comment
Question by:MaduKp
7 Comments
 
LVL 7

Accepted Solution

by:
stacko111 earned 167 total points
ID: 33644961
The easiest way is to do an Advanced Find for the records then Export them to Excel. The GUIDs will be automatically exported in the first column (Excel sometimes hides this column).

This is for onpremise CRM 4.0 with at least rollup 9 installed.
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 33645271
In sql you can type following query
select accountid
from account
0
 
LVL 10

Author Comment

by:MaduKp
ID: 33652214
Thanks stacko111, give me some time to check this out.
rakeshAgarwa, Sorry, I don't get you. How can i use SQL to this task? Could you please elaborate the solution?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Assisted Solution

by:Aftab_Khateeb
Aftab_Khateeb earned 167 total points
ID: 33658708
Hi MaduKp

Generally the data that gets imported is stored in one of the database which starts with organization name so it would "<OrganizationName>_MSCRM". In order to extract the data that you have imported with GUIDs the easiest apporach would be to fetch details from the database.

Now I am not sure how your infrastructure is, but i would make an assumption that you have access to SQL Server.
In order to fetch the details of the 1000 accounts you could use any of the below queries to fetch the GUIDS

Make sure you select  your organization_MSCRM database before you execute this query

select name as 'Account Name',accountid as 'Account GUID', createdon as 'CREATED ON'
from filteredaccount
order by name


You can try to fetch using date as well, I am substituting with a dummy date here, so substitute with the date that you have imported those records

select name as 'Account Name',accountid as 'Account GUID', createdon as 'CREATED ON'
from filteredaccount
where createdon between '2010-07-07 00:00:00' and '2010-07-07 23:59:59'
order by name

Once you have done this in SQL you can export the results in a CSV or excel, select all the results  "Ctrl +A' and then right click on the results window. You would see an option called "Save results as" and this would allow you to save the results in to a file


Hope this helps. Let me know if you need any further clarification
0
 
LVL 1

Assisted Solution

by:h3753M
h3753M earned 166 total points
ID: 33662966
An easy way from the interface would be to do an advanced narrow down to find the records you created and then export the records as a dynamic worksheet.
 When you export as a dynamic worksheet, the guid of the records are on the spreadsheet in a HIDDEN column at the end of the data set.
Unhide the column, save the file as a .csv (to break the dynamic link to CRM), open the file in excel and save as an excel file.
wes
0
 
LVL 8

Expert Comment

by:Aftab_Khateeb
ID: 33687899
Hi would like to know if you were able to execute the steps i mentioned? If you require any further help let me know
0
 
LVL 10

Author Closing Comment

by:MaduKp
ID: 33763421
Excellent!
Thanks stacko111, Aftab_Khateeb,  h3753M and rakeshAgarwal.  
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question