Community
Showing results for 
Search instead for 
Do you mean 
Reply

Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

Accepted Solution Solved
Copper Contributor
Posts: 64
Country: USA
Accepted Solution

Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

I've seen other posts on this topic, but many of them are a while ago for older versions. Is there anyway to export the primary key for a contact without the use of an add-on product?


Accepted Solutions
Solution
Accepted by topic author mjmcpe
‎04-12-2016 05:43 AM
Bronze Elite Contributor
Posts: 1,424
Country: United_Kingdom

Re: Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

Below is a link to a free add-on that will help you do this. You create a new Field in the table you want to export, say ContactUID and then this add-on lets you copy the UID to the new field which you can now export. You can the make this a key field for re-import etc.

 

http://www.freeactaddons.com/free-addons/guid2field

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

Not within the ACT! program itself.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 64
Country: USA

Re: Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

How is it after all these years this still isn't an option? one of the things I like about Act over some other systems out there is its ability to match and merge records on fields other than the primary key, but having a primary key option has its uses.

Solution
Accepted by topic author mjmcpe
‎04-12-2016 05:43 AM
Bronze Elite Contributor
Posts: 1,424
Country: United_Kingdom

Re: Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

Below is a link to a free add-on that will help you do this. You create a new Field in the table you want to export, say ContactUID and then this add-on lets you copy the UID to the new field which you can now export. You can the make this a key field for re-import etc.

 

http://www.freeactaddons.com/free-addons/guid2field

Copper Contributor
Posts: 64
Country: USA

Re: Export Unique ID/Primary Key for Contacts Table (Premium 17.1)

Perfect! Still seems a little silly to require an add-on to get basic information, but as long as I don't have to pay for an add-on I'll give it a try. Thanks.