topic Re: Re: Re: Image not displayed from shared drive in QlikView

Image not displayed from shared drive

Mon, 09 Jun 2014 04:45:10 GMT

Hi,

I have ImageId and images field in an excel, I am loading that excel using info load. when I am trying to display image in a text object or straight table its not displayed. However I am getting i on list box of ImageId and I have selected representation to be info as image.

Kindly let me know what I am missing.

Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 04:58:15 GMT

try to use Bundle load

The Bundleprefix is used to include external files, such as image or sound files, or objects connected to a field value, to be stored in the qvw file.

If a piece of external information, such as an image or a sound file is to be connected to a field value, this is done in a table that is loaded with the Info prefix. In order to maintain portability, it is possible to include the external files into the .qvw file itself. To this end use the Bundle prefix. The bundled info files are compressed in the process, but will nevertheless take up additional space both in the file and in RAM. Therefore consider both the size and the number of bundled files before going for this solution.

The info may be referenced from the layout as normal info, via the chart info function or as an internal file via the special syntax qmem:// fieldname / fieldvalue alternatively qmem:// fieldname / < index > where index is the internal index of a field value.

The Info prefix may be omitted when Bundle is used.

Bundle[Info] ( loadstatement | selectstatement)

Examples:

Bundle Info Load * Fom flagoecd.csv;

Bundle SQL Select * From infotable;

Re: Image not displayed from shared drive

Mon, 09 Jun 2014 05:15:40 GMT

Still the text box is blank. I have writtrn the espression as-

if(count(ImageID)='1','qmem://ImageID/105.121.134.201/images/UploadFile/aoe1to55nouern551nxqicnl_999934_531333166974105_1156677466_n.jpg',0)

Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 05:43:06 GMT

can you share the app?

Re: Re: Image not displayed from shared drive

Mon, 09 Jun 2014 05:52:10 GMT

I have attached app and excel also.

Re: Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 06:01:32 GMT

Try to use \ slash instead of /

in this expression

//115.112.134.201/images/UploadFile/aoe1to55nouern551nxqicnl_999934_531333166974105_1156677466_n.jpg

And use BUNDLE LOAD

instead of

BUNDLE INFO LOAD

Re: Re: Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 06:04:44 GMT

And PFA an example

Re: Re: Re: Image not displayed from shared drive

senpradip007 — Mon, 09 Jun 2014 06:13:03 GMT

PFA.

Re: Image not displayed from shared drive

Mon, 09 Jun 2014 06:30:14 GMT

Hi Pradip,

I am able to work it out for local directory but I have to use image from shared network folder such as

//115.112.134.201/images/UploadFile/aoe1to55nouern551nxqicnl_999934_531333166974105_1156677466_n.jpg

Thanks

Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 06:33:29 GMT

you can see in my attached below example that I loaded it from the network resource (it doesn't matter that it was my local drive. I load it form the shared network drive) and use \\.

Just try to use \ slash instead of /

Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 06:35:52 GMT

Windows doesn't understand this / type of slash. It's unix format

Re: Image not displayed from shared drive

Mon, 09 Jun 2014 06:38:39 GMT

where have you attached example?

Re: Re: Image not displayed from shared drive

SergeyMak — Mon, 09 Jun 2014 06:41:18 GMT

PFA once again

Re: Re: Re: Image not displayed from shared drive

senpradip007 — Mon, 09 Jun 2014 06:42:59 GMT

Try somthing like

Image:

LOAD

EventID,
Image As ImageText
FROM
(ooxml, embedded labels, table is Sheet2);

Bundle Info LOAD
EventID,
ImageText
Resident Image;

Here ImageText consists of the Image Information like you have //115.112.134.201/images/UploadFile/aoe1to55nouern551nxqicnl_999934_531333166974105_1156677466_n.jpg

Re: Image not displayed from shared drive

Mon, 09 Jun 2014 08:29:24 GMT

I have tried with / slash but still not working. I think there might be some problem in displaying image from shared network folder..or else some other syntax. As I am trying with

//115.112.134.201/images/UploadFile/aoe1to55nouern551nxqicnl_999934_531333166974105_1156677466_n.jpg

its not working but from my local drive its working