I can't figure out how to embed PDF files using bundle info load, to create a self-contained .qvw that can be distributed as a single file. Here is a sample that resembles my load script:
bundle info load * inline [
After saving and reloading this, I have a listbox object which shows the "i" info icon in the caption. Ideally, I want to reference the embedded test.pdf using a link expression in a straight table, so that I can click on the link for any name and open the corresponding pdffile, something like this in a table expression:
=name & '<url>qmem://name/' & name
But, even in the listbox, the pdf file will not open. Instead, when I click on the info icon, I get a dialog box with this:
In the straight table expression, first I get a Yes/No dialog box with this:
Approve application for launch? - qmem://name/test
then when I click Yes, I get an OK dialog with this:
Failed to Launch qmem://name/test
The QlikView Reference Manual doesn't offer any help (pp 495-496). Does anyone know how to get this to work?
The Blobs page makes it possible to bundle so-called Blobs, Binary Large Objects, in a QlikView application. It is usually a picture, a text file or similar, stored as a single entity in a database management system. The i icon indicates that the field contains a blob. The blobs in the database are listed together with size, in KB, and type in the Blob Viewer. The Blob is previewed next to the list if it is an image. QlikView supports jpg, png, bmp, pdf and rtf blobs.
The Bundle... button opens the Bundle dialog where the Key Field for the Blob data is selected and the blob can be resized to fit in the table cell if it is an image. Mark Shrink Images and apply pixel width and height to resize the images to fit. The setting does not handle aspect ratio.
Note: It is only possible to bundle Blobs using ODBC.
Once you have made your selections of table and fields you may click OK to insert the select statement(s) generated at the cursor position in the QlikView script. Pressing Cancel will abandon changes.
Note! The ODBC driver can usually interpret far more complicated select statements than the ones which can be produced by this dialog. An alternative way to generate a more complex select statement is to use a query tool, e.g. Microsoft Query, and graphically make your select statement there. When this is done, copy (CTRL+C) the select statement and paste it (CTRL+V) into the QlikView script. (In MS Query, click the SQL button.)
Unfortunately, we can't move these PDFs into a blob column in a database without also building an interface for our end users. That would be a lot of work. Currently, they simply drop new PDFs into a shared, network folder and these should be bundle info loaded into the .qvw.
My follow up question is same as @ivan_will: can we do the load from a directory on a filesystem, rather than from ODBC?
Klaus -- Thank you for your suggestion. This similar to what we ended up doing; we used a file URL in a link field, instead, but achieved a similar result. We would have preferred to embed the PDFs into the .qvw, because we need to distribute the .qvw to remote users. Now we must distribute not only the .qvw, but all the PDFs in an accompanying folder. This is more complex and prone to error.