Allowing file upload using Clarify ClearExpress

To start, let me provide something to talk to:



Basically how this works is a user adds an attachment to the case via their browser's file upload funcationality.  That file is "parked" on the web server until it is fetched.  After the upload is complete, the user enters a note.  Upon saving the note, all the events fire to get the file from the web server on the public network to the Clarify server on the internal network.

The systematic event to kick this all off is a trigger on the note table with listens for attachment type notes.  This trigger creates a time bomb entry.  The rulemanager picks up the time bomb entry, finds our com_tmplte telling it how to copy the file and then shells out to the command line to perform the copy (via scp) of the file.  Once the file is copied, we place a *.done file on the web server (again via scp).  The web server has a cron entry on it that that looks for *.done files and deletes the corresponding attachment.  And we are done!

The master copy now resides on the internal network and typically we make it accessible via http or in some cases samba to the agents working the case.

Here's the code: ceWebAttach.zip

Posted at 01:10PM Mar 09, 2007 by Robert Eister in Software  |  Comments[0]