Meta-Update uses the API and can transfer attachments by reference (or indeed to/from the file system). It can also change file names etc. No staging forms or workflow is needed. Here’s a sample script:
Query = Src, ATT:AttachmentTable, '1' = "$Arg, src$" Update = Tgt, ATT2:AnotherTable, 'Old1' = "$Arg, src$" Assign = asg-sec [asg-sec] AttField1 = Src, AttFieldSrc Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> [email protected] Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Allan See Sent: March-05-15 00:19 To: [email protected] Subject: BMC Remedy Attachments Hi, I need help in understanding what Remedy uses as compression for File Attachments when inserting it to our B tables. Also does anyone know how we can migrate attachments to another table over a DB link. I have recently tried to do this but files that are migrated gets corrupted. thank you, TIA _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org "Where the Answers Are, and have been for 20 years" ----- No virus found in this message. Checked by AVG - <http://www.avg.com> www.avg.com Version: 2015.0.5645 / Virus Database: 4299/9228 - Release Date: 03/04/15 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
smime.p7s
Description: S/MIME cryptographic signature
