12-14-2010 02:37 AM - edited 12-14-2010 02:52 AM
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).
12-14-2010 02:42 AM - edited 12-14-2010 02:45 AM
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
02-24-2011 03:36 AM
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!
02-24-2011 05:21 AM
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
04-20-2011 10:37 AM
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