Hi Michael
The easiest way may be to use the User Tool to export the attachments - just create a report and select the attachments and export to .arx file. This will create a directory containing all the attachments with the original name plus a number, like details_23.doc. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Bessey Sent: Tuesday, September 25, 2007 3:48 AM To: [email protected] Subject: Exporting Blob File Attatchments From Remedy ARS V6 Hello Remedy Guru's, Does anyone happen to know of a good way to bulk export file attachments stored in the Remedy Oracle dB out to their individual files with correct file names? We use Remedy as a provisioning system, and we have customers defined in the dB that each have files (like word/pdf/visio/ppt) stored to an attachment form so that users of the system can get to a customers reference material. We are looking for an easy way to export all of the attachments out of the dB without having to use the Remedy client and click on each file and export it manually for each customer in the dB. I know there are Oracle tools out there for exporting Blob's/Clob's, but I'm not an Oracle expert, and trying to get the Blob's associated with the correct file name stored in Remedy doesn't look that easy to do. Thanks, -Mike NTT America Michael Bessey NCC/NCPC Senior OSS Architect E-Mail: [EMAIL PROTECTED] AIM: arch8nglmichael Office: (817)428-7878 Cell Phone: (817)845-3054 ================================= This email message is intended for the use of the person to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. NTT America makes no warranty that this email is error or virus free. Thank you. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
