Don,
Am I to assume that you resolved the issue with your xml response which arises because SHOWSQL="YES" dumps out the SQL statements into the returned xml?
BTW - I notice you are qualifying all you cgi requests with the full url.
Common practice is to specify only the relative path since the browser will automatically pad relative urls out to a full urls derived from the page on which the relative url appears.
Static urls like those for .js .gif and .swf need to be full urls when the containing page is delivered via cgi but a more flexible approach for these is to code variables for common paths in a %define block.
This makes coding simpler since "/web/FusionCharts/FusionChartsFree/Contents/Images/BtnViewXML.gif" can become "$(path)/Contents/Images/BtnViewXML.gif" or even "$(imagePath)BtnViewXML.gif"
Furthermore, if the path variable is itself populated from an INI file via dtw_getinidata() then the same code will run on different servers e.g.
http://dev/...
http://tst...
http://prd...
Plus, this makes version control easier since you need only change an entry in the INI file and all you pages will point to a different version.
Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Thursday, 9 December 2010 6:10 a.m.
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Fully seamless job stream via Net.data
Peter,
This is a great solution - exactly what I was looking for. Net.data is
the right tool for me at this time and in this case.
Thank You, and thanks to all others who advised!
Don C.
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Peter Connell
Sent: Tuesday, December 07, 2010 7:37 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] Fully seamless job stream via Net.data
Don,
I should have done the SQL option since it's real easy.
I have installed FusionCharts into my /www folder, so my directory
structure is like -
=>www
=>FusionCharts
=>Charts
=>Contents
=>JSClass
The (entry) macro just has a starting link.
The (graph) macro is essentially a cut and paste of the Fusion
column3D.html demo example with the relative urls changed to absolute.
The nice thing is that you no longer have to create a stream file
containing the xml data for the url "Data/Column3D.xml" to pick up.
Instead of a static url like "Data/Column3D.xml" you simply specify the
name of the macro containing your SQL, in this case "get_xml".
The (get_xml) macro could not be an easier. No stream file, just
dynamically return the necessary lines of xml.
You just need to create a DB2400 table with the columns PERIOD,AMOUNT
and COLOR and populate it with a row for each month (PERIOD) of the
year.
Here's the source member -
%html(entry) { <h3>Existing Macro<h3/>
<p><a href="graph">3D Graph</a>
%}
%html(graph) {
<html xmlns="
http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/> <title>FusionCharts Free Documentation</title> <link rel="stylesheet"
href="/www/FusionCharts/Contents/Style.css" type="text/css" /> <script
language="JavaScript"
src="/www/FusionCharts/JSClass/FusionCharts.js"></script>
</head>
<body>
<table width="98%" border="0" cellspacing="0" cellpadding="3"
align="center">
<tr>
<td valign="top" class="text" align="center">
<div id="chartdiv" align="center">FusionCharts. </div>
<script type="text/javascript">
var chart = new
FusionCharts("/www/FusionCharts/Charts/FCF_Column3D.swf", "ChartId",
"600", "350");
chart.setDataURL("get_xml")
chart.render("chartdiv");
</script>
</td>
</tr>
<tr>
<td valign="top" class="text" align="center">
<a href="get_xml" target="_blank"><img
src="/www/FusionCharts/Contents/Images/BtnViewXML.gif" border="0" /></a>
</td>
</tr>
</table>
</body>
</html>
%}
%function(dtw_sql) buildXml() {
select * from fusiontst0
%report { <?xml version='1.0' encoding='UTF-8'?>
<graph caption='Monthly Unit Sales' xAxisName='Month'
yAxisName='Units' decimalPrecision='0' formatNumberScale='0'>
%row { <set name='$(V_PERIOD)' value='$(V_AMOUNT)' color='$(V_COLOR)'
/> %}
</graph>
%}
%}
%html(get_xml) { @buildXml() %}
Cheers, Peter
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Don Cavaiani
Sent: Tuesday, 7 December 2010 9:29 a.m.
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Fully seamless job stream
I have the FusionCharts set up correctly to output a graph from data in
an IFS file which is in XML format - named data.xml. What methods can I
use to replace that data on the fly just before graphing takes place -
possibly via an SQL statement in a net.data macro, and then somehow
copied/written BACK OVER the top of the data in the data.xml file ...
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Jim Oberholtzer
Sent: Monday, December 06, 2010 6:00 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Fully seamless job stream
Having read this thread, I'm wondering why no one suggested Query?
WebQuery can produce the exact results your looking for. If you don't
own Query then a PHP, Javascript, or Java solution would work but
require quite a bit of care and feeding over time making the Query look
better.
Jim Oberholtzer
CEO/Chief Technical Architect
Agile Technology Architects, LLC
On 12/5/2010 6:57 PM, Aaron Bartell wrote:
Wouldn't it be best if IBM i solutions were sought out first?
AaronBartell.com
On Dec 5, 2010 3:25 PM, "Maurice O'Prey"<Maurice.Oprey@xxxxxxxxx>
wrote:
Checkout the free Chart Control in .NET 4
-----Original Message-----
From:web400-bounces@xxxxxxxxxxxx
[mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: 05 December 2010 19:34
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Fully seamless job stream
Check out RPG Chart Engine at MowYourLawn.com. It is completely
open source, uses data queues to talk to Java from RPG, and uses
JFree Chart as the chart "engine".
Aaron Bartell
www.MowYourLawn.com/blog
www.OpenRPGUI.com
www.SoftwareSavesLives.com
On Sat, Dec 4, 2010 at 6:11 PM, Don
Cavaiani<dcavaiani@xxxxxxxxxxxxx
wrote:
Jim,
I am looking at downloading JreeChart and using it SOMEWHAT
similar
(directions?) to how I use jscalendar inside the net.data macro
- is that logical?
Don C
-----Original Message-----
From:web400-bounces@xxxxxxxxxxxx
[mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Jim Franz
Sent: Saturday, December 04, 2010 3:38 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Fully seamless job stream
How are you doing your web presentation? php, cgi, websphere...
This thread from 2009 discusses several options
http://archive.midrange.com/web400/200901/msg00154.html
The Excel option is also possible, assuming the web user has
Excel (then you have to worry about various levels of Excel 2003
or 2007 or 2010).
Scott Klement has some published tools (free) to generate excel
with formulas).
jQuery and many other toolkits& plugins are an option (and
mostly
free-)
Jim Franz
----- Original Message -----
From: "Don Cavaiani"<dcavaiani@xxxxxxxxxxxxx>
To:<web400@xxxxxxxxxxxx>
Sent: Saturday, December 04, 2010 11:03 AM
Subject: [WEB400] Fully seamless job stream
> Is this possible:
>
> IBM i job stream which calculates supplier delivery
performance
'on-time
> %' statistics for past 12 months - a data file which I have
already > created, and then have that calculated 12 month data
auto transferred
to
> an Excel spreadsheet which shows a month by month line graph
(which > would be accessed by a Web Page click - which I know
how to do).
>
> Some other way easier?
> --
> This is the Web Enabling the AS400 / iSeries (WEB400)
mailing list > To post a message email:WEB400@xxxxxxxxxxxx >
To subscribe, unsubscribe, or change list options, >
visit:http://lists.midrange.com/mailman/listinfo/web400
> or email:WEB400-request@xxxxxxxxxxxx > Before posting,
please take a moment to review the archives >
athttp://archive.midrange.com/web400.
>
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
Visit our website www.vedaadvantage.com. It has a new design with
improved navigation and search capabilities; and customer friendly
interface with more relevant insights and solutions to help you make
informed decisions.
########################################################################
#############
This correspondence is for the named person's use only. It may contain
confidential or legally privileged information, or both. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this correspondence in error, please immediately delete
it from your system and notify the sender. You must not disclose, copy
or rely on any part of this correspondence if you are not the intended
recipient.
Any views expressed in this message are those of the individual sender,
except where the sender expressly, and with authority, states them to be
the views of Veda Advantage.
If you need assistance, please contact Veda Advantage on either :-
Australia 1300-921-621 or New Zealand +64 9 367 6200
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.
midrange.com
