Remedy and BLOB data

2006-07-30 Thread Jason McDonald
** 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 ref

Re: Remedy and BLOB data

2006-07-30 Thread Michiel Beijen
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 u

Re: Remedy and BLOB data

2006-07-30 Thread Jason McDonald
** 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 whyyou could not just extract the binary data and open the file. But that's also the reason that a 30MB word doc only occup

Re: Remedy and BLOB data

2006-07-30 Thread Michiel Beijen
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]

Re: Remedy and BLOB data

2006-07-30 Thread Jason McDonald
** - 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 B52CX in the aradmin schema? Also, I wou

Re: Remedy and BLOB data

2006-07-31 Thread Michiel Beijen
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 exa

Re: Remedy and BLOB data

2006-07-31 Thread Jason McDonald
** 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,

Re: Remedy and BLOB data

2006-07-31 Thread Heider, Stephen
, 2006 9:04 AMTo: arslist@ARSLIST.ORGSubject: 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

Re: Remedy and BLOB data

2006-07-31 Thread Jarl Grøneng
tephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason McDonald Sent: Monday, July 31, 2006 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy and BLOB data ** I am actually trying to bypass remedy and directly get the blob content of a fie

Re: Remedy and BLOB data

2006-07-31 Thread Heider, Stephen
: Monday, July 31, 2006 11:42 AM To: arslist@ARSLIST.ORG 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