Discover missing attachments (Free Tool) [ Edited ]

[lrichter]

Dear Administrators,

Dear Business Partners,

Dear Community,

The Missing Attachment Tool is free for use for Business Partners and Administrators!

A fast discovery is essential, because one day in the future, one very important

attachments is missing and a very important person is looking for it. Of course,

very urgently, but the attachment cannot be found anymore. This is the time

when this user or the administrator is calling you…  I hope this tool will safe you!

Send a daily report about missing attachment to the Administrator or to SLX-Users

You can send manually and automatically an html e-mail with a list of all missing

attachments to the Administrator, directly to the SLX users or copy to the

clipboard and create an html report.

Additional features:

- No installation needed (detailed guide for configuration included)

- Check if there are missing attachments on your Remote Office or Remote Database

- This tool is Multilanguage capable (English and German are already included)

- The html e-mail messages for Admin and Users can be edited individually

- Description of actual and known defects and phenomenas

Messages of missing attachments:

This is the LAN-message of a lost attachment: The requested file image.jpg was not found.

This is the WEB-message of a lost attachment: The file requested: !QDEMOA00001image.jpg

was not found on the server.

Any feedback is welcome

Best regards,

Lukas Richter

Ambit AG

Additional Information:

PS: Special thanks to Reto, Vanja, Markus und Marco! Without their help this tool would not exist!

PPS: The shortest attachment joke: There is no attachment missing

PPPS: There will be a more advanced support tool for Administrators in the future for sale with

much more features (Attachments, Sync Server, RemoteOffice, Disk Space, TEFs and more).

AMB_Attachment_missing v10.0.zip

[lrichter]

PPPPS: This vb script can help you to check if files are really uploaded and saved correctly

and if not, that the created record in the attachment table is deleted properly...

Function Attachment_Exist_on_Database(strAttachID) '--Return True/False

Dim strAttachPath

Dim strFileName

Dim fso

    Attachment_Exist_on_Database = False

    strAttachPath = Application.BasicFunctions.GetAttachmentPath

    strFileName = "" & GetField("FILENAME", "ATTACHMENT", " ATTACHID = '" & strAttachID & "'")

   Set fso = CreateObject("Scripting.FileSystemObject")

   If (fso.FileExists(strAttachPath & strFileName)) Then Attachment_Exist_on_Database = True

End Function

This is where the attachment is added:

            '—If an attachment could not be saved correctly the created record also needs to be deleted

            If Attachment_Exist_on_Database(objClsAttach.ATTACHID) = False Then

                MsgBox "The attached file could not be saved on the Server!" _

                    & CHR(13) & CHR(10) & "The attachment record has been deleted." _

                    & CHR(13) & CHR(10) & "Please try again, otherwise contact your Saleslogix Administrator.", 48

                Dim objCon

                Set objCon = application.GetNewConnection

                    objCon.execute "Delete From ATTACHMENT Where ATTACHID = '" & objClsAttach.ATTACHID & "'"

                objCon. close

                set objCon = Nothing

[AdamTravers]

Hi Lukas,

I have just implemented your Missing Attachment Tool and it is excellent! One of our customers reported that since they have upgraded to v7.5.3 several attachments (49 in fact) have gone missing

.
By running your tool I have been able to locate the missing attachments and verify by the date that in fact the issue has been since the upgrade.

I will certainly be running this on other sites now too.

Thanks again!

[lrichter]

Hi Adam

Great to hear :-) Thank you for your feedback! You are happy 49 is very little. We normaly

have three or four-digit numbers of missing attachments.

Attached you can find the source code for the tool. This version is written in vb6.

We also have developed a .net solution. It has much more features, but it will be for sale.

It is also running automatically and is checking SyncServer, RemoteOffices, RemoteUsers,

TEF, DiskSpace, missing Attachments and much more). It is the perfect tool for an Admin.

If anybody is interesed please contact: rbeuter@ambit.ch

I wish you a great day!

Best regards,

Lukas

SDK_VB6_AMB_Attachment_missing v10.0.zip

[lrichter]

Good evening

This evening is my last working day at Ambit AG. After over 6 years

working for Ambit AG and a successful completion of my 4 year

part-time course of study in Business Information Technology FH,

I'm looking forward to travel, before I take a new challenge.

You can still reach me via Xing and… it's a small world!
http://www.xing.com/

Thank you for the successful cooperation and many greetings

Lukas Richter