Hello
Has anyone written a bulk document uploader in C# or VB to import multiple documents into T_CUST_DOC?
I've written the uploader, but the PDF files are being inserted with the incorrect encoding/type, so the client cannot open them up.
When I upload a file using the client, the doc_contents column is showing the file prefixed with a large amount of hex, which does not happen when I upload using my C# process. The first few hex values on the client upload indicate it is a MS Office file, even though a PDF was uploaded, so it looks like the client is preprocessing the byte string before storing it into the database.
I have over a thousand files to upload, once only, and would dearly love to not have to upload them all manually through the client.
Thanks!
The Tessitura client application stores constituent documents as OLE objects. This technique embeds additional data (the additional bytes at the start and end of the file you are seeing).
It would be difficult to replicate this storage using C# or VB such that the document will open in Tessitura (but not impossible, I imagine.) It may well take less time to just upload them manually using the application.
Hope this helps.