Community
Showing results for 
Search instead for 
Do you mean 
Reply

Viewing ACT! Data in SQL

Accepted Solution Solved
New Member
Posts: 2
Country: USA
Accepted Solution

Viewing ACT! Data in SQL

I have ACT! 16, and my company wants to view data in an analytical tool. When I view my ACT! contact data in SQL (using SQL Mgmt Studio 2014), I can view the ACT! fields. However, there is a field in ACT! that stores numeric values, but when viewed in SQL, the value is different. For example, through the ACT! UI, the value is 38254, but the field in SQL shows a value of 3633. Anybody know what the reason is?

 

FYI, I need to use SQL as I need the ACT! contact ID as a field, and using ACT! exports, I am unable to view or export the Contact ID (unless there is something I am unaware of).

 

Thanks


Accepted Solutions
Solution
Accepted by topic author Kaloof
‎10-08-2015 06:32 PM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Viewing ACT! Data in SQL

You would be able to extract the information including contact ID with a report and save the report output to text or RTF. The ACT! reports can do it but a cleaner way would be to use the Durkin Impact Reports.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author Kaloof
‎10-08-2015 06:32 PM
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Viewing ACT! Data in SQL

You would be able to extract the information including contact ID with a report and save the report output to text or RTF. The ACT! reports can do it but a cleaner way would be to use the Durkin Impact Reports.

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

Re: Viewing ACT! Data in SQL

Thanks Roy. This is helpful. I would not have the other foreign keys, but this would help me get started. Much appreciates.