Community
Showing results for 
Search instead for 
Do you mean 
Reply

Where is the full History or Notes data

New Member
Posts: 2
Country: United_Kingdom

Where is the full History or Notes data

I'm not an Act developer but want to extract all data from Act before decommissioning.  I tried the export facility but the CSV files seemed messed up by the time they got to Excel.  So I am going the SQL route.  I can see TBL_CONTACT_HISTORY and TBL_HISTORY.  This gives me fields like REGARDING but I cannot locate the full history text.  Any help in locating the full Notes and History text would be appreciated.

Copper Contributor
Posts: 42
Country: Germany

Re: Where is the full History or Notes data

there is a "details"-column which holds the history text as RichText

same for TBL_NOTES

New Member
Posts: 2
Country: United_Kingdom

Re: Where is the full History or Notes data

Thank you.

 

I had seen the DETAILS field but somehow overlooked the text that was wrapped in considerably more meta data than the text I was looking for.  :-)

 

Thanks again.