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___
