Yes, today. If anyone else thinks this enhancement would be beneficial to their organization, please consider submitting an enhancement request.
Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Monday, July 31, 2006 11:42 AM To: [email protected] Subject: Re: Remedy and BLOB data I guess you already sent this as an enhancment request? -- Jarl On 7/31/06, Heider, Stephen <[EMAIL PROTECTED]> wrote: > ** > > > My $0.02. > > I think it would be great if BMC used the ubiquitous zip format to > compress attachments. This would provide a couple advantages: > > 1. Directly accessible to third-party products, such as WinZip, 7-Zip, > etc., and also zip format libraries for development in other > programming languages without the ARS API. > > 2. Administrator or Developer could set the desired compression level > (Maximum, Normal, Fast, Super Fast, None). This would allow the > balancing of performance vs compression ratio. Ideally, this setting > would apply to individual forms instead of global. Certain forms you > may want to have maximum compression, and other forms fast > compression. Even better, allow the setting of the compression ratio by field. > > Stephen > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Jason McDonald > Sent: Monday, July 31, 2006 9:04 AM > To: [email protected] > Subject: Re: Remedy and BLOB data > > > ** > I am actually trying to bypass remedy and directly get the blob > content of a field. > > I thought this was possible via special tools but since remedy is > compressing them, they are of no use. I will give the c program a shot. > > Do you have any other alternative solutions? > > Thanks.. > > > On 7/31/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: > > Jason, > > > > You should check out the ARGetEntryBLOB call, and check sample > > scripts provided with the API. > > Also refer to the documentation for the API, there are two PDF's > > about this included in the v7 documentation. > > But it would not be the easiest thing to do if you do not have C > experience. > > > > What exactly are you trying to accomplish? You might also want to > > look in to exporting records using runmacro. > > -- > > Michiel > > > > On 7/30/06, Jason McDonald <[EMAIL PROTECTED]> wrote: > > > ** > > > > --------------------------------------------------------------------- > > > OK thanks. > > > > > > I downloaded the > > > http://arswiki.org/dist/ars/api/api_win_en_700_000.zip > from > > > the web. > > > > > > Now, how do I write a C program to display a BLOB file (PDF) from > > > the > table > > > B52CXXXXXXXXX in the aradmin schema? Also, I would like the > > > program to automatically know the MIME type (its stored in B52 > > > table)...so the C program must query the B52 table and find out > > > the MIME type and then > open it > > > in a suitable program. Any pointers? > > > > > > Thanks. > > > > > > > > > > > > On 7/31/06, Jason McDonald <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > OK thanks. > > > > > > > > I downloaded the > > > http://arswiki.org/dist/ars/api/api_win_en_700_000.zip > from > > > the web. > > > > > > > > Now, how do I write a C program to display a BLOB file (PDF) > > > > from the > > > table B52CXXXXXXXXX in the aradmin schema? Also, I would like the > program to > > > automatically know the MIME type (its stored in B52 table)...so > > > the C program must query the B52 table and find out the MIME type > > > and then > open it > > > in a suitable program. Any pointers? > > > > > > > > > > > > Thanks. > > > > > > > > > On 7/30/06, Michiel Beijen < [EMAIL PROTECTED] > wrote: > > > > you could use it from a C program, or from java, or other langages. > > > > See > > > http://arswiki.org/wiki/index.php?title=API_Programming > > > > -- Michiel > > > > > > > > On 7/30/06, Jason McDonald <[EMAIL PROTECTED] > wrote: > > > > > ** > > > > > Could you please explain how to use the API? > > > > > > > > > > Thanks > > > > > > > > > > > > > > > On 7/30/06, Michiel Beijen < [EMAIL PROTECTED]> wrote: > > > > > > > > > > > they are not exactly encrypted, but they ARE compressed. > > > > > That's why you could not just extract the binary data and open > > > > > the file. But that's also the reason that a 30MB word doc only > > > > > occupies a fraction of that once stored in the database... > > > > > If you'd extract the attachment using the API it would > > > > > uncompress > the > > > > > file nicely. > > > > > -- > > > > > Michiel > > > > > > > > > > On 7/30/06, Jason McDonald < [EMAIL PROTECTED]> wrote: > > > > > > ** > > > > > > Hi All, > > > > > > > > > > > > I wanted to know how Remedy ( 7.0) stores LOB data. I was > > > > > > trying > to > > > extract > > > > > > directly from the database a BLOB field (attachment in > > > > > > remedy ; in > > > this > > > > > case > > > > > > it was a PDF file) but although I knew the MIME type and > > > > > > opened it > in > > > a > > > > > > special tool designed to extract BLOB data, Acrobat Reader > > > > > > refused > to > > > open > > > > > > it (it said invalid file). > > > > > > > > > > > > Further, following the same process as above, even if I open > > > > > > a > 'text > > > file' > > > > > > attachment, the contents seem to be encrypted and I see junk > > > > > > data > when > > > > > > opening it in Notepad. > > > > > > > > > > > > Are attachments encrypted by Remedy before storing it in the > database? > > > If > > > > > > so, how do I bypass remedy and view BLOB data? > > > > > > > > > > > > (Dev Env) > > > > > > ARS 7.0 > > > > > > Oracle 10g > > > > > > OS - Windows > > > > > > > > > > > > Thanks, > > > > > > Jason __20060125_______________________This > posting > > > was > > > > > > submitted with HTML in it___ > > > > > > > > > > > > > > ______________________________________________________________________ > _________ > > > > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > > > > > > __20060125_______________________This posting was submitted > > > > > with HTML in it___ > > > > > > > > > > > > ______________________________________________________________________ > _________ > > > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > > > > > > > > > > > > > __20060125_______________________This posting was submitted with > > > HTML in it___ > > > > > ______________________________________________________________________ > _________ > > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > > > __20060125_______________________This posting was submitted with HTML > in it___ __20060125_______________________This posting was submitted > with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
