I'm trying to retrieve the documents that show in the research tab from Tessitura in their original format (e.g., .jpg, .doc, .ppt, et al). Is this even possible? If so, how would I go about doing so on the SQL side, rather than one at a time, pulling up the document in Tessitura and saving it to the hard drive, I presume.
Thank you for your help, Tessiturians.
BONUS WHAT-MIGHT-HAVE-BEEN TRIVIA: In his youth, Bill Cosby was good enough as a football player to be offered a trial with the Green Bay Packers.
Unfortunately, because T-SQL doesn't support writing its Binary Large Object data directly to files, you must write an application (in a .Net language, or Visual Basic with ActiveX Data Objects, for example) to do so. There are several articles in Microsoft's Knowledge Base that include code samples.
There's one other complication, however, that's a bit more difficult to work around. The documents stored in t_cust_doc are stored as "OLE objects"; this is what enables them to be opened, from Tessitura, in their native applications. As a result, an "OLE header" is added to the stream of data stored in the doc_contents column. Long story short: this header would have to be identified and removed to finally end up with a true ".JPG" or ".DOC" file (or whatever binary file format is stored).
Hope this helps a bit, and isn't too discouraging! It can be done, but it's certainly not a trivial undertaking.
Don't suppose anyone out there in the community has written such an application they're proud enough of to share? I'd be happy to tell everyone how awesome you are if so...
In all seriousness, any help would be appreciated. Thanks.
Hey, Matt. I was just looking into this same question... don't suppose you've solved this in the last few months and would be willing to share?
Thanks!
Emily Levada