Focal Point
can not get gif images to display

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

May 08, 2007, 12:31 PM
Jessica Bottone
can not get gif images to display
I just converted from WebFocus 5.3 to 7.1.4 and the gif images in my report no longer display. I get red x's. I believe I simply do not have the path to the image designated correctly since the image is in the folder indicated in the path name and the gif's are not corrupted. I searched Focal Point and found several cases about getting gif images into reports and tried all sorts of variations on getting the path name right, but to no avail. I created a sample of the code using the CAR file and it shows the last thing I tried. And in case you're curious, what I had before that worked looked like this: RED_UP/A80='';

And approot was ibi/apps.

Thanks much!


SET PAGE-NUM=NOLEAD
SET NODATA=''

DEFINE FILE CAR
RED_UP/A80='';
GREEN_DOWN/A80='';
QUESTION/A80='?';
END

TABLE FILE CAR
SUM DEALER_COST
COMPUTE IMAGE/A120=IF DEALER_COST GT 10000
THEN RED_UP
ELSE IF DEALER_COST LT 10000
THEN GREEN_DOWN
ELSE QUESTION; AS ''
BY COUNTRY
BY CAR
END


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:49 PM
Jessica Bottone
The code I included is appearing to show Red x's to be in my forum post too. So I'll try to show you the code in sections:

The first part is the same for what I had and what I last tried:
RED_UP/A80='<

then img

then src=

I had used to have after the equal sign was this:
/approot/Cubes/RED_UP.GIF>';


And the last thing I tried was this:
"http:\\localhost\ibi\apps\Cubes\RED_UP.GIF" >';


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:52 PM
Francis Mariani
Jessica,

Please put your program code between code tags:
[code]
program code
[/code]



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 08, 2007, 12:55 PM
Jessica Bottone
Oh, thank you! I was trying to figure out how to show the code and not have the red x's display. So let's try this again.

What I had that used to work:

RED_UP/A80='<img src=/approot/Cubes/RED_UP.GIF>';


And what I last tried:


SET PAGE-NUM=NOLEAD
SET NODATA=''

DEFINE FILE CAR
RED_UP/A80='<img src="http:\\localhost\ibi\apps\Cubes\RED_UP.GIF" >';
GREEN_DOWN/A80='<img src="http:\\localhost\ibi\apps\Cubes\GREEN_DOWN.GIF" >';
QUESTION/A80='?';
END

TABLE FILE CAR
SUM DEALER_COST
COMPUTE IMAGE/A120=IF DEALER_COST GT 10000 THEN RED_UP
              ELSE IF DEALER_COST LT 10000 THEN GREEN_DOWN
    		  ELSE QUESTION; AS ''
BY COUNTRY
BY CAR
END





Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 12:56 PM
Francis Mariani
The usual way to address an image in an app folder would be to use '/approot/Cubes/RED_UP.GIF'.

When you run the HTML report and get the red X, right click on it to view the image properties to check if the URL has been formed properly. The clue may be in there.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 08, 2007, 01:00 PM
Francis Mariani
This works for me:

TABLE FILE CAR
PRINT
COMPUTE TEST/A100= '<IMG src=/approot/basel/bmo_fn_gp.gif>';
COUNTRY
end


When I right-click on the image and view Properties, I see http://ocdt70070610:8080/approot/basel/bmo_fn_gp.gif.

Verify that the case is correct for the path name and the image name.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 08, 2007, 01:09 PM
Jessica Bottone
Got it.. would you believe it was the difference between GIF and gif? Apparently now it's case sensitive. Thank you.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 08, 2007, 01:45 PM
Francis Mariani
I don't think it's WebFOCUS, you may be using a new or updated web server which may require case-sensitive URLs.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 08, 2007, 02:00 PM
mgrackin
Jessica,

The Microsoft platform does not usually care about upper and lower case. However, unix based OS are case sensitive.

Please update your signature file to reflect your platform and WebFOCUS version.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
May 09, 2007, 09:23 AM
Jessica Bottone
In this case, it's WF 7.1.4 on Windows XP Pro with IIS (don't know which version), and I too did not think case should make a difference and in this case it did. I put in my first entry for this post that I'd upgraded from WF 5.3 to 7.1.4 but did not include the platform. My apologies. I'd intentionally not updated my profile because my circumstances vary depending on the client I'm working for at the time. So that's what I put in my profile and will make sure I include all pertient info when I post in the future.

Thanks to all.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
May 09, 2007, 10:12 AM
Francis Mariani
Mickey,

If the web server is Apache Tomcat, even though it may be running on a Windoze machine, it is case-sensitive - therefore it's a good idea to respect case for folders/files on any platform, just as a precaution.

Cheers.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server