Create Template File From Blob Data In Btformatblobs Table.
I am trying to read BLOB data from table and create the template file in local file system.
can I use the BLOB as it is in table?
--
Regards,
Minsung
-
Yes you can. Are you having trouble? If so, what version/build of BarTender are you running and what database contains the BLOB field?
0 -
tried the below sql and extracted blob data.
SELECT LibItemBlobs.Data FROM LibFileNodes INNER JOIN LibItems ON LibFileNodes.NodeID = LibItems.NodeID INNER JOIN LibItemRevisions on LibItems.ItemID = LibItemRevisions.ItemID INNER JOIN LibItemBlobs ON LibItemRevisions.BlobID = LibItemBlobs.BlobID
but somehow, I am getting the below error when I open the file.
[attachment=562:7-24-2013 3-31-36 PM.png]
any suggestion?
0 -
Gene Henson
★ BarTender Hero ★
From the Select statement you've sent there, it looks like you're trying to access the BarTender System Database directly. We don't publish or disclose the schema of the BarTender System Database, nor do we support querying it directly. We actually have two SDK's that allow you to interact with the BTSD and Librarian.
You can find information about using BarTender SDK's in the BarTender help documentation. Depending on you're trying to do, you'll want to look into the "Librarian" and the "System Database" SDK's (found under the "Automatic BarTender" section in the BT Help).
If you can't find a way to accomplish your task using either SDK, please let us know and we'll work with our development staff to find a solution.
Regarding the error that you've received there, that is usually an indication that the label format you're using has become corrupted. Please contact you're closest support office directly with the label format and we'll look into it with you.
0 -
Thanks for the reply.
there are multiple print servers and one Librarian Server in our env. currently we are trying to make only valid or the latest version of template available in local print server.
as you mentioned, I can create a template file from Librarian server using Librarian SDK but then I have to copy the files over to the print servers. but I would like to automate this process.
so, I thought I can replicate the BLOB data from Librarian DB to the Database on the print server and create the file from there.
is there a way to acces Librian Server remotel?
0 -
Gene Henson
★ BarTender Hero ★
I'll be contacting you about this directly. I like to discuss this with you a little bit more to find out exactly what your needs are.
0
请先登录再写评论。
评论
5 条评论