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
