Hi
I've previously successfully installed the Maani XML/SWF charts using the information and package on Dene's example pages Link This was on XE and 10g releases, possibly even 9i.
I'm trying to get this to run on a local 11g database and I can't get the chart to load. The package has been installed successfully and I've followed Dene's instructions again, exactly the same as I remember doing it before. But the flash chart will not load on the page. The region eventually turns orange with the message Loading <xml_chart_pkg.chart_region_pr?app_user_id=ANONYMOUS&app_id_in=106&session_id_in=
I had downloaded the zip file from the Maani website, which I noticed was a newer version to the one I previously installed. So I've tried copying the old files to the /i/ directory, but this has the same result.
I've also tried following the instructions on the Maani website, rather than using the database package. This involves taking the code in the sample.html file and modifying it. However, I can't get the code in the sample.html file to work through APEX. If I create a HTML region with an iframe tag that references /i/sample.html then the chart is displayed within the iframe on the APEX page. But if I take the code from sample.html and paste this into the HTML region adding /i/ to the front of the paths to reference the javascript and flash files then just the rectangle for the chart background is displayed.
I didn't install 11g on my laptop but as far as I'm aware it's just a basic installation, nothing fancy. And the APEX version I'm running is 3.1.2. The code from the sample.html file that I've pasted into my HTML region and doesn't work is below. I think if I can get this working it should resolve all the problems, but any help either with correcting this code or getting the package to work is appreciated. I'm sure I've done something silly, I just can't spot it!
Thanks
Sara
<script language="javascript">AC_FL_RunContent = 0;</script>
<script language="javascript"> DetectFlashVer = 0; </script>
<script src="/i/AC_RunActiveContent.js" language="javascript"></script>
<script language="JavaScript" type="text/javascript">
<!--
var requiredMajorVersion = 9;
var requiredMinorVersion = 0;
var requiredRevision = 45;
-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
if (AC_FL_RunContent == 0 || DetectFlashVer == 0) {
alert("This page requires AC_RunActiveContent.js.");
} else {
var hasRightVersion = DetectFlashVer(requiredMajorVersion, requiredMinorVersion, requiredRevision);
if(hasRightVersion) {
AC_FL_RunContent(
'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,45,0',
'width', '400',
'height', '250',
'scale', 'noscale',
'salign', 'TL',
'bgcolor', '#777788',
'wmode', 'opaque',
'movie', 'charts',
'src', 'charts',
'FlashVars', 'library_path=/i/charts_library&xml_source=/i/sample.xml',
'id', 'my_chart',
'name', 'my_chart',
'menu', 'true',
'allowFullScreen', 'true',
'allowScriptAccess','sameDomain',
'quality', 'high',
'align', 'middle',
'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
'play', 'true',
'devicefont', 'false'
);
} else {
var alternateContent = 'This content requires the Adobe Flash Player. '
+ '<u><a href=http://www.macromedia.com/go/getflash/>Get Flash</a></u>.';
document.write(alternateContent);
}
}
// -->
</script>
<noscript>
This content requires JavaScript.
</noscript>