Community
Showing results for 
Search instead for 
Do you mean 
Reply

Actdiag report missing attachments how to find records

Nickel Contributor
Posts: 597
Country: USA

Actdiag report missing attachments how to find records

Running ACT2011 SP1 HF4.  ACTDIAG Database Reports, Missing Attachments list 7 files missing with the file name.  Is there a way to find out which contact record Document Tab is associated to that missing file?

JM

Copper Elite Contributor
Posts: 514
Country: USA

Re: Actdiag report missing attachments how to find records

You could find it by searching the backend SQL table itself running a SQL query.

Mark Hammer
ACT! Fanatic
Nickel Contributor
Posts: 597
Country: USA

Re: Actdiag report missing attachments how to find records

Mark is that in ACTDIAG running Crystal Reports or a tool I might not have.

Odd I did keyword search based on the report showing the file name to locate DB and found all but TWO contact records that had the bad attachments.

JM

Nickel Contributor
Posts: 597
Country: USA

Re: Actdiag report missing attachments how to find records

Any Sage Rep. can help me with Prem. 2011 HF6, resolve 5 Missing Attachments Report from ACTDIAG?

Two look like this:

alamedaUnified 53b63562-e4c2-46f2-8685-56eba6d058d9.xls  (Note)
CardinalLACityOrders032008 38cca17a-0b03-4776-8935-13511e637972.pdf  (Note)

tmp6932 7ac1b137-8c47-4fb8-8cf4-007e88c15964.msg  (History)

 

I tried all ACT type of searches to find the contact records that are the ones that lost the file in either in Documents Tab or a History record Type. 

FYI I created a custom History Type called "Note" which is another potential placement besides being in a the NOTES Tab.

JM