Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 47
Registered: ‎04-28-2009

Discover missing attachments (Free Tool)

[ Edited ]

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

 

Missing Attachment Tool

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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 Smiley Happy

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).

 

 

Highlighted
Copper Elite Contributor
Posts: 47
Registered: ‎04-28-2009

Re: Discover missing attachments (Free Tool)

[ Edited ]

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

Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Discover missing attachments (Free Tool)

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!

Regards, Adam Travers
empath-e Services Limited
Copper Elite Contributor
Posts: 47
Registered: ‎04-28-2009

Re: Discover missing attachments (Free Tool) Source Code

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

Copper Elite Contributor
Posts: 47
Registered: ‎04-28-2009

Re: Discover missing attachments (Free Tool) Source Code

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. Smiley Happy

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