Hi Michael,
I have had to do a similar thing also. As I understand it, Remedy compresses
all attachments automatically when it attaches them to the database and vice
versa. Assuming this is the case then it is best to use a Remedy based
solution. I found that I was able to extract the filename from the attachment
field and used the run process command PERFORM-ACTION-SAVE-ATTACHMENT to save
the attachment to the file system. I used an escalation to kick off the process
on the server. In the end I created files that were of the same extension, but
named them after the data record they were attached to as my requirement was
for data migration. You may need to do something similar as attachments can
have duplicate filenames.
If you need more details let me know and I can look them up for you.
Rod
________________________________
From: Action Request System discussion list(ARSList) on behalf of Michael Bessey
Sent: Tue 25/09/2007 10:47 AM
To: arslist@ARSLIST.ORG
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"
