Community
Showing results for 
Search instead for 
Do you mean 
Reply

extracting notes table

New Member
Posts: 1
Country: USA

extracting notes table

Help,

 

I have gone through about every option and can't figure out how to do this.  We have Act Sage Premium 2008 (10.0.3.182).  All I want to do is do an export into a delimited file of:

 

1) contacts (which is straight forward)

 

and

 

2) The notes table

 

Is there an easy way for me to extract the notes into a table, where there is a field that links to the contacts table such that I can create a relational database?

Bronze Contributor
Posts: 955
Country: Australia

Re: extracting notes table

There are two options to do this

 

a) Purchase a copy of Oakmerge www.oakmerge.com or

b) Do a search for Exporter as this has the ability to export the contacts with the linked notes

 

No other option internally as export will only export the contacts.

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: extracting notes table

http://www.jltechnical.com/exporter.htm

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

Re: extracting notes table

The ACT Reader Utility should do this as well.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider