Focal Point
[SOLVED]Add Image Reference to Metadata

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/15910418

April 14, 2009, 01:32 PM
DJ
[SOLVED]Add Image Reference to Metadata
I am a fairly new user to WebFOCUS, so I apologize in advance if this is a simple question:

How do I add an image to the metadata in the Synonym Editor? I attended a workshop that used a master file with images inside the metadata but did not think to ask how it was done at the time. Thanks for any help you can provide.

This message has been edited. Last edited by: DJ,


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
April 14, 2009, 01:42 PM
<JG>
WebFOCUS does not contain Images in Metadata, No system does.

Metadata points to the source it does not contain the source.

What do you actually want to do?
April 14, 2009, 01:50 PM
DJ
Right.

What I am looking to do is point to the source of an image within the metadata so I can just use it as a variable in a report.

Thank you for your patience as I learn terminology...


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
April 14, 2009, 02:16 PM
<JG>
WebFOCUS can not access or process BLOBS directly, so they can not be accessed via the metadata layer.

An example of what you are trying to do would help a lot to finding a solution.
,
April 15, 2009, 03:42 AM
GamP
The workshop you attended probably used only the datasource to retrieve the address (url or file address) and use that to call up the image in the report(s). That is a method that is supported and used.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
April 15, 2009, 09:26 AM
DJ
GamP,
That is exactly what I saw. So the question remains, what field in the metadata (through the Synonym Editor) do I place the url or file address to make this happen? What data format should I give it - A256?


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
April 15, 2009, 09:37 AM
<JG>
DJ

The field in the metadata is a reference to a column in your data source
and it's format will map to that automatically when the synonym is created.

If you are using a flat file and have to create the synonym manually then
it's what ever length you make that column in your data.
April 15, 2009, 09:48 AM
DJ
Makes sense. However the field would be a virtual or computed field as the flat file does not already contain the url/file address.

I am getting a lot of good information and really appreciate everyones help.


WebFOCUS 7.6.8
zOS 1.9 (Mainframe)
Excel, PDF, HTML, Active HTML
April 15, 2009, 09:55 AM
AG
Create a DEFINE field that refers to the location of the image

example:
DEFINE FILE xxxx
IMG1/A256 = '';
April 15, 2009, 09:57 AM
<JG>
AG can you edit your post and put the code within
code tags
  [CODE]  
[/CODE]
then everyone will be able to see your post
April 16, 2009, 03:11 AM
GamP
This is AG's example code:
DEFINE FILE xxxx
IMG1/A256 = '<img src="/approot/app_folder/img_name.gif">';
END



GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
April 16, 2009, 04:22 AM
<JG>
Problem is that is only giving a single image or if extended using IF-THEN-ELSE
a series of pre-defined images.