Create Template File From Blob Data In Btformatblobs Table. S’abonner

0
Avatar
Legacy Poster

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

5 commentaires

0
Avatar
Ian Cummings
Modérateur
Actions pour les commentaires Permalien

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
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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
Avatar
Gene Henson
Actions pour les commentaires Permalien

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
Avatar
Legacy Poster
Actions pour les commentaires Permalien

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
Avatar
Gene Henson
Actions pour les commentaires Permalien

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.

Vous devez vous connecter pour laisser un commentaire.