OTN Discussion Forums : APEX 3.2.1 missing AnyMap.swf? ...

jmallen

Posts: 1
Registered: 08/26/98

APEX 3.2.1 missing AnyMap.swf?
Posted: Aug 31, 2009 6:37 PM

I upgraded to APEX 3.2.1 which is supposed to have AnyMap and AnyGantt support. I have modified region and chart XML to display the world map (world.amap). But in order to get the map to show up I had to reference the AnyChart.swf file in the Region source area. However, a message ("Your license does not include the AnyMap extension") shows across the map and clicking on the message takes you to AnyCharts.com.

There does exist an AnyGantt.swf file, which led me to ask if there is a missing AnyMap.swf.

Also data from the SQL Query does not highlight the countries, but when I replace #DATA# with a hard coded series it does highlight the countries as required:

select null link, country label, people value
FROM
(
select 'United States' country, 303824646 people from dual
UNION ALL
select 'China' country, 1330044605 people from dual
UNION ALL
select 'India' country, 1147995898 people from dual
UNION ALL
select 'Indonesia' country, 237512355 people from dual
UNION ALL
select 'Brazil' country, 191908598 people from dual
)

vs

<data>
<series>
<point name="China" y="1330044605"/>
<point name="India" y="1147995898"/>
<point name="United States" y="303824646"/>
<point name="Indonesia" y="237512355"/>
<point name="Brazil" y="191908598"/>
</series>
</data>

Thanks,

John

jkallman

Posts: 2,974
Registered: 01/10/01

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 2, 2009 7:34 AM

in response to: jmallen

Reply

Hi John,

Thanks for reporting this issue with the license message. I reproduced it myself on apex.oracle.com.

This is an issue with one of the files that was packaged for the AnyChart maps with APEX 3.2.1. I've been in contact with the folks from AnyChart, and when I have a resolution to this problem, I'll post the solution back on this thread and on my blog. It most likely will just involve a single file that needs updated.

Sorry for the inconvenience and thanks again for reporting this.

Joel

mhoys

Posts: 214
Registered: 09/19/06

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 16, 2009 7:27 AM

in response to: jkallman

Reply

Hi,

Any update on this license issue? I did some tests with AnyMap today and I had the following message on my maps:
"Your license doesn't include Maps Extension".

Matthias

jkallman

Posts: 2,974
Registered: 01/10/01

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 16, 2009 7:29 AM

in response to: mhoys

Reply

Matthias,

I'm close to getting this resolved. We're doing final testing now. I'll update this thread in the next day or two when this is rectified.

Joel

mhoys

Posts: 214
Registered: 09/19/06

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 16, 2009 7:37 AM

in response to: jkallman

Reply

OK,

Thanks for the feedback.

Matthias

sowji

Posts: 81
Registered: 12/02/08

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 17, 2009 7:19 AM

in response to: jmallen

Reply

Hello John/Joel,

I have upgraded to 3.2.1 yesterday to get the AnyMap support. I found that it is not exposed through the Oracle Application Express user interface. I am new to APEX. Can you please briefly explain the steps on how to access the MAPS. Should I create a new region then what to change in the region in order to get the world.amap? If there is an example in apex.oracle.com that would be great.

Thanks,
Sowji.

jkallman

Posts: 2,974
Registered: 01/10/01

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 18, 2009 10:28 AM

in response to: sowji

Reply

This is now resolved. Please see http://joelkallman.blogspot.com/2009/09/anymap-updated-in-application-express.html for more information.

John - Thanks for originally pointing out this issue.

Joel

sowji

Posts: 81
Registered: 12/02/08

Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
Posted: Sep 21, 2009 10:39 AM

in response to: jkallman

Reply

I have recently upgraded to Apex 3.2.1 which have the AnyMap features. Actually I am trying to get a map displayed on a page, I have changed region settings to point to AnyChart.swf in 2 places. Now in the Custom XML region, the xml elements of APEX & Anychart are different. In apex the root element is <root> where as in anychart it is <anychart>. I tried to insert <anychart> inside <root>. But nothing is displayed. Below is the code from custom XML i am using to display USA map.
Is there anyother way to get the map displayed?

<?xml version = "1.0" encoding="utf-8" standalone = "yes"?>
<root>
<type>
<anychart>
<charts>
<chart plot_type="Map" name="USA">
<chart_settings>
<title enabled="true"><text>The United States of America</text></title>
<chart_background enabled="True"/>
<data_plot_background enabled="false"/>

<footer enabled="true">
<text>Click on a state to see state's counties</text>
<background>
<border type="Solid" color="#AAAAAA" enabled="True" opacity="0.5"/>
<inside_margin top="5" bottom="5"/>
</background>
</footer>
</chart_settings>
<data_plot_settings>
<map_series source="maps/usa/country/states.amap">

<projection type="orthographic"/>
<undefined_map_region palette="undefPalette">
<label_settings enabled="True">
<format>{%REGION_ID}</format>
<position anchor="Center" valign="Center" halign="Center"/>
</label_settings>
<actions>
<action type="updateChart" view="State" source_mode="internalData" source="State">
<replace token="{$region_amap}">{%REGION_ID}</replace>
<replace token="{$title}">{%REGION_NAME}</replace>
</action>
</actions>

<tooltip_settings enabled="true">
<format>{%REGION_NAME}</format>
</tooltip_settings>

<map_region_style>
<fill type="Gradient">
<gradient angle="45">
<key color="%Color"/>
<key color="Blend(%Color,Gray,0.9)"/>
</gradient>
</fill>
<states>
<hover color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="0.5"/>
<border color="#204E83" opacity="1"/>
</hover>

<selected_hover color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="0.5"/>
<border color="#204E83" opacity="1"/>
</selected_hover>

<selected_normal color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="1"/>
<border color="#204E83" opacity="1"/>
</selected_normal>
</states>
</map_region_style>
</undefined_map_region>
<effects>
<drop_shadow enabled="True" distance="2" opacity="0.5"/>
</effects>
</map_series>
</data_plot_settings>

<palettes>
<palette name="undefPalette" type="ColorRange" color_count="10">
<gradient>
<key color="#F8FDE9"/>
<key color="#DCDD8C"/>
</gradient>
</palette>
</palettes>
</chart>

<chart plot_type="Map" name="State">
<chart_settings>
<title><text>{$title}</text></title>
<chart_background enabled="True"/>
<data_plot_background enabled="false"/>
<footer enabled="true">
<text>Back to USA Map</text>
<actions>
<action type="updateChart" source_mode="internalData" source="USA"/>
</actions>
<background>
<border type="Solid" color="#AAAAAA" enabled="True"/>
<inside_margin top="5" bottom="5"/>
</background>
</footer>
</chart_settings>
<data_plot_settings>
<map_series source="maps/usa/states/counties/{$region_amap}.amap">
<projection type="orthographic"/>
<undefined_map_region palette="undefPalette">
<tooltip_settings enabled="true">
<format>{%REGION_NAME}</format>
</tooltip_settings>
<map_region_style>
<fill type="Gradient">
<gradient angle="45">
<key color="%Color"/>
<key color="Blend(%Color,Gray,0.9)"/>
</gradient>
</fill>
<states>
<hover color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="0.5"/>
<border color="#204E83" opacity="1"/>
</hover>

<selected_hover color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="0.5"/>
<border color="#204E83" opacity="1"/>
</selected_hover>

<selected_normal color="#FAFFEE">
<hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="1"/>
<border color="#204E83" opacity="1"/>
</selected_normal>
</states>
</map_region_style>
</undefined_map_region>
<effects>
<drop_shadow enabled="True" distance="2" opacity="0.5"/>
</effects>
</map_series>
</data_plot_settings>
<palettes>
<palette name="undefPalette" type="ColorRange" color_count="10">
<gradient>
<key color="#F8FDE9"/>
<key color="#DCDD8C"/>
</gradient>
</palette>
</palettes>
</chart>
</charts>
</anychart>
</type>
#DATA#
</root>

sowji

Posts: 81
Registered: 12/02/08

Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
Posted: Sep 21, 2009 12:14 PM

in response to: sowji

Reply

hello,

Any hint is appreciated.

Thanks.

mhoys

Posts: 214
Registered: 09/19/06

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 23, 2009 3:21 AM

in response to: jkallman

Reply

AnyMap working fine for me now!

Thanks,
Matthias

sowji

Posts: 81
Registered: 12/02/08

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 23, 2009 7:03 AM

in response to: mhoys

Reply

Matthias,

Can you please list the steps needed to get the AnyMap work. Actually, I have done couple of steps listed in my previous posts. Nothing is working. I copied the source XML from the demo examples to display USA states. But now when I try to run the page, I get a loading XML message & it is taking forever. I am unable to see any map. Can you please check the code in my previous posting and see where I did wrong.

sowji.

user11185077

Posts: 3
Registered: 07/01/09

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 23, 2009 11:44 AM

in response to: sowji

Reply

Hi,

I have recently upgraded to Apex 3.2.1 too and I am trying to get a map displayed ont apex page.
I have replaced #IMAGE_PREFIX#flashchart/#CHART_TYPE#.swf with #IMAGE_PREFIX#flashchart/swf/AnyChart.swf in two sections of region source.
I put in chart xml AnyChart Sample XML Gallery. I have got message "loading resources...2%" forever.

Is anyone else has the same issue, is anyone else making any progress?
Thanks

Ahcène

mhoys

Posts: 214
Registered: 09/19/06

Re: APEX 3.2.1 missing AnyMap.swf?
Posted: Sep 24, 2009 1:05 AM

in response to: sowji

Reply

Sowji,

I haven't done anything with APEX and AnyMap yet.
I only created the following 2 files in my OHS images directory on the server:

anychart.html:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>AnyChart Sample Flash Map </title>
<script type="text/javascript" language="javascript" src="/i/flashchart/js/AnyChart.js"></script>
</head>
<body>
    <script type="text/javascript" language="javascript">
    //<![CDATA[
    var chart = new AnyChart( '/i/flashchart/swf/AnyChart.swf');
    chart.width = 600;
    chart.height = 450;
    chart.setXMLFile('anychart.xml');
    chart.write();
    //]]>
    </script>
</body>
</html>

anychart.xml:

<anychart>
  <charts>
    <chart plot_type="Map">
      <chart_settings>
        <title>
          <text>India Map</text>
        </title>
      </chart_settings>
      <data_plot_settings>
        <map_series source="./asia/india.amap">
          <projection type="mercator" />
          <undefined_map_region palette="default">
            <label_settings enabled="True" />
          </undefined_map_region>
        </map_series>
      </data_plot_settings>
    </chart>
  </charts>
</anychart>

And then I use a browser to display the India map:
http://<servername>:7777/i/anychart.html

Does this work in your environment?

Matthias

mhoys

Posts: 214
Registered: 09/19/06

Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
Posted: Sep 24, 2009 5:28 AM

in response to: sowji

Reply

Sowji,

I now made a working example on apex.oracle.com:
http://apex.oracle.com/pls/otn/f?p=53750:2
username: admin
password: apex

I put this in the region source of the page:

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
	codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"
	width="#WIDTH#"
	height="#HEIGHT#"
	id="#CHART_NAME#"
	align="">
<param name="movie" value="#IMAGE_PREFIX#flashchart/swf/AnyChart.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:2:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#">
<param name="quality" value="high">
<param name="allowScriptAccess" value="sameDomain">
<param name="allowNetworking" value="all">
<param name="scale" value="noscale">
<param name="wmode" value="transparent">
<param name="FlashVars" value="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
 
<embed src="#IMAGE_PREFIX#flashchart/swf/AnyChart.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:2:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#"
       quality="high"
       width="#WIDTH#"
       height="#HEIGHT#"
       name="#CHART_NAME#"
       scale="noscale"
       align=""
       allowScriptAccess="sameDomain" 
       allowNetworking="all"
       type="application/x-shockwave-flash"
       pluginspage="http://www.macromedia.com/go/getflashplayer"
       wmode="transparent"
       FlashVars="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
</embed>
</object>
#CHART_REFRESH#

I put this in the custom XML:

<?xml version = "1.0" encoding="utf-8" standalone = "yes"?>
<anychart>
<settings>
<maps path_type="Absolute" path=""/>
<resources path_type="Absolute" path="" />
</settings>
<charts>
<chart plot_type="Map" use_anychart3_data_model="true" use_sets_colors="false">
<chart_settings>
<title>
<text>World Map - Grid background Image Overlay</text>
</title>
</chart_settings>
<data_plot_settings>
<map_series source="/i/flashchart/swf/maps/world/world.amap" id_column="REGION_NAME">
<projection type="Equirectangular"/>
<zoom factor="1"/>
<grid enabled="True">
<background enabled="true">
<border enabled="False"/>
</background>
<parallels enabled="False"/>
<meridians enabled="False"/>
</grid>
<border color="White" opacity="1"/>
<defined_map_region>
<map_region_style>
<fill enabled="True" opacity="0.45" color="Red"/>
</map_region_style>
<tooltip_settings enabled="true">
<format><![CDATA[Name: {%REGION_NAME}
Number: {%Value}]]></format>
</tooltip_settings>
</defined_map_region>
<undefined_map_region>
<tooltip_settings enabled="True">
<format>{%REGION_NAME}</format>
</tooltip_settings>
<map_region_style>
<fill enabled="True" opacity="0.01"/>
<states>
<hover>
<fill enabled="True" color="Yellow" opacity="0.4"/>
</hover>
<selected_normal>
<fill enabled="True" color="Yellow" opacity="0.4"/>
<hatch_fill enabled="False"/>
</selected_normal>
<selected_hover>
<fill enabled="True" color="Yellow" opacity="0.4"/>
<hatch_fill enabled="False"/>
</selected_hover>
</states>
</map_region_style>
</undefined_map_region>
</map_series>
</data_plot_settings>
#DATA#
</chart>
</charts>
</anychart>

And I added this series (SQL query):

select null link, country label, people value
FROM (
SELECT 'Belgium' country, 10500000 people
FROM dual
UNION ALL
SELECT 'United States' country, 910500000 people
FROM dual
UNION ALL
SELECT 'Germany' country, 510500000 people
FROM dual
UNION ALL
SELECT 'Spain' country, 410500000 people
FROM dual)

Does this work in your environment?

Matthias

sowji

Posts: 81
Registered: 12/02/08

Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
Posted: Sep 24, 2009 7:49 AM

in response to: mhoys

Reply

Matthias,

Thank you very much. I copied your code in a new page and I got the AnyMap working atlast. The only fault I was doing is not adding the code below in custom XML.
<settings>
<maps path_type="Absolute" path=""/>
<resources path_type="Absolute" path="" />
</settings>
If the above code is removed, then map would not display.
Did you write the code in Custom XML or did you copy it from the AnyMap site.

I copied the custom XML code from http://www.anychart.com/products/anychart/gallery/Interactive-Maps.php
I did not get the <settings> node. Is there any other place to copy the code?

Ahcène,

With the help of Matthias, AnyMAp can be succesfully generated in your page. Please see the posts from Matthias on how to generate anymaps.

Sowji