Community
Showing results for 
Search instead for 
Do you mean 
Reply

Conversion of ACT! 2005 to ACT! 2009. Corrupted Attachments folder

Copper Contributor
Posts: 23
Country: United States

Conversion of ACT! 2005 to ACT! 2009. Corrupted Attachments folder

Here's my challenge:
I am working with a client who has ACT! 2005 Premium v7.0.4. They had a "bad" conversion from their previous ACT6 database. The files in the Attachments folder became doubled, tripled,..., and in the case below, 13 times, with computer generated file names. Please  see the example below. The multiple file copies actually exist in the Attachment folder. I want to clean up the Attachments folder by finding and deleting unnecessary files in the Attachment folder before upgrading to ACT! 2009. Too much time has gone by to

go back to the original ACT6 database.

 

Is there any way to print the file names of attached documents that an ACT 2005 database has recorded in it? If I can print the file names that are legitimately linked, I can delete the others. Or is it better to do the cleanup in ACT! 2009?

 

\Example of file name replication in the Attachment folder:
03148.DOC
03148 07de0906-b8fc-448a-9b0b-8d08c2340dba.DOC
03148 10477fb7-af12-40c9-bf68-b0ccfde80da6.DOC
03148 24ecd76e-be61-479b-aced-ce8016a5f13a.DOC
03148 276c0415-4f01-4ce1-8ea1-43d8888da176.DOC
03148 3f787149-0fff-4e06-8785-ae74b13d2397.DOC
03148 55ccdbb1-3574-4ed5-8370-9db5dbbc4b42.DOC
03148 71d2ef53-5355-48e1-b65d-6c85de74ab32.DOC
03148 a6502212-011c-45a6-a97c-5beb1e5aecc9.DOC
03148 b740c737-05b1-4231-8cf9-4baf8d910b38.DOC
03148 bdaf678b-adce-420b-a4f1-aa598b187a4c.DOC
03148 d348b885-5ab3-406e-a9af-e6c145589ae4.DOC
03148 e47afccc-2a2d-4e63-9040-1739e2e8e334.DOC

Thanks for your help.


**bleep** Dernberger
ACT! Certified Consultant
ddernberger@jcscomputer.com

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Conversion of ACT! 2005 to ACT! 2009. Corrupted Attachments folder

There is no function in ACT! that can print a list of files that are correctly attached (maybe a SQL tool can do that), but you can print a MIssing Attachments report from ActDiag to see which files do not have a valid link in the Attachments table. From the database list in ActDiag, right-click your database, select Database Reports, then Missing Attachements.

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 23
Country: United States

Re: Conversion of ACT! 2005 to ACT! 2009. Corrupted Attachments folder

This report looks extremely helpful. Thank you so much.

\**bleep** Dernberger