PDF Viewer Reading PDF From Database?

Hi Guys,

I have been playing around with Ignition for a while and seem to be stuck on this one issue, I have a SQL Database setup in which I was able to load different pdfs into it using a simple script within Ignition:


However my issue comes with using the PDF Viewer within Perspective to read the data from the database, I have been using the .loadPDFBytes function which I was able to find from an old Ignition tutorial however it seems to be giving me this error:

Error2

If I had to guess it seems that this function to load the PDF Bytes no longer exsists in this version of Ignition and as such this method may not work, if anyone has any other sugestions that would greatly be appreciated.

It looks like you are trying to access a file directly from your desktop using a web browser. You're saying that you were able to do this prior to updating?

The File has been inputted into the SQL Database as shown:

Database

The problem arrises when I try to run the following script to input the byte data into the PDF Viewer:

I am assuming its because the .loadPDFBytes function may not be usable so was hoping theres another way to go about this issue or maybe I have missed something.

.loadPDFBytes() is a method on Vision's PDF viewer. Consider using my Blob Server module to deliver your PDFs to viewers. (Free.)

Most of the examples on the forum are for images, but the same techniques should work for PDF blobs, too.

3 Likes

Thank you I will take a look at this.

I am doing something similar but I am getting my BLOB data from a webserver. You can just write the byte data to a tag then link the source of the PDF viewer to that tag.

Had to do some research on Base64 to get this working but maybe you will find this solution useful

data:application/pdf;base64,JVBERi0...........
Screenshot