Community
Showing results for 
Search instead for 
Do you mean 
Reply

Actdiag report missing attachments how to find records

JM
Nickel Contributor
Posts: 584
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
JM
Nickel Contributor
Posts: 584
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

JM
Nickel Contributor
Posts: 584
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