Not really sure how pl/sql can help since the blob is compressed with a proprietary compression algorithm.
The easiest way would be with Meta-Update where you can control the output file names as desired. You can also use any API programming language such as Perl, Java, c, etc and write your own code. You can also, run some workflow through an escalation or whatever trigger you like. A filter can export an attachement to the file system on the server. An AL can export it to the client. Of course you'll have to deal with file names, directories, slash vs backslash etc. See the special "process": PERFORM-ACTION-SAVE-ATTACHMENT <field_ID> [<file_name>] Cheers Ben Chernys www.softwaretoolhouse.com >----- ------- Original Message ------- ----- >From: Icarus4 <[EMAIL PROTECTED]> >To: arslist@ARSLIST.ORG >Sent: Wed, 1 Oct 2008 02:50:01 > >Hello, > >Here is a link that may help you. However if you >are really not familiar >with Oracle PL/SQL basics, you should request a DBA >to help you. > >http://www.oracle-base.com/articles/9i/ExportBlob9i >.php > > > >Michael Bessey wrote: >> >> 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. >> >> >> >___________________________________________________ >____________________________ >> UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org ARSlist:"Where >> the Answers Are" >> >> > >-- >View this message in context: >http://www.nabble.com/Exporting-Blob-File-Attatchme >nts-From-Remedy-ARS-V6-tp12872301p19757311.html >Sent from the ARS (Action Request System) mailing >list archive at Nabble.com. > >___________________________________________________ >____________________________ >UNSUBSCRIBE or access ARSlist Archives at >www.arslist.org >Platinum Sponsor: www.rmsportal.com ARSlist: "Where >the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
