Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I have used the following format in excel and its working
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;
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)
can you share the app?
I have attached app and excel also.
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
And PFA an example
PFA.
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
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 /