Re: Remedy and BLOB data
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 B52CX 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 B52CX 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
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 scriptsprovided with the API. Also refer to the documentation for the API, there are two PDF's aboutthis 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.--MichielOn 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 B52CX 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 B52CX 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 extractdirectly from the database a BLOB field (attachment in remedy ; in this caseit was a PDF file) but although I knew the MIME type and opened it in aspecial tool designed to extract BLOB data, Acrobat Reader refused to openit (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? Ifso, how do I bypass remedy and view BLOB data? (Dev Env)ARS 7.0Oracle 10gOS - Windows Thanks,Jason __20060125___This posting wassubmitted 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___
Re: Remedy and BLOB data
** 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 languageswithout the ARS API. 2. Administrator or Developercould 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 McDonaldSent: Monday, July 31, 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. 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 scriptsprovided with the API. Also refer to the documentation for the API, there are two PDF's aboutthis 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.--MichielOn 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 B52CX 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 B52CX 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. Butthat'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 thefile 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 extractdirectly from the database a BLOB field (attachment in remedy ; in this caseit was a PDF file) but although I knew the MIME type and opened it in aspecial 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 10gOS - 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
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: arslist@ARSLIST.ORG 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 B52CX 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 B52CX 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___
Re: Remedy and BLOB data
** 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 occupies a fractionof that once stored in the database...If you'd extract the attachment using the API it would uncompress thefile 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___
Re: Remedy and BLOB data
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
Re: Remedy and BLOB data
** - OK thanks. I downloaded the http://arswiki.org/dist/ars/api/api_win_en_700_000.zipfrom 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 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.zipfrom 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 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-- MichielOn 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___