This discussion is archived
1 2 Previous Next 20 Replies Latest reply: May 31, 2010 3:20 AM by 776202 RSS

APEX 3.2.1 missing AnyMap.swf?

71502 Newbie
Currently Being Moderated
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
  • 1. Re: APEX 3.2.1 missing AnyMap.swf?
    jkallman Employee ACE
    Currently Being Moderated
    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
  • 2. Re: APEX 3.2.1 missing AnyMap.swf?
    MatthiasHoys Explorer
    Currently Being Moderated
    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
  • 3. Re: APEX 3.2.1 missing AnyMap.swf?
    jkallman Employee ACE
    Currently Being Moderated
    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
  • 4. Re: APEX 3.2.1 missing AnyMap.swf?
    MatthiasHoys Explorer
    Currently Being Moderated
    OK,

    Thanks for the feedback.

    Matthias
  • 5. Re: APEX 3.2.1 missing AnyMap.swf?
    673536 Newbie
    Currently Being Moderated
    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.
  • 6. Re: APEX 3.2.1 missing AnyMap.swf?
    jkallman Employee ACE
    Currently Being Moderated
    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
  • 7. Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
    673536 Newbie
    Currently Being Moderated
    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"/>
                   <font color="#404040"/>
              </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>
                        
                        <pushed color="#FAFFEE">
                             <hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="1"/>
                             <border color="#204E83" opacity="1"/>
                        </pushed>
                        
                        <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>
                   <font bold="True" underline="True"/>
                   <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>
                        
                        <pushed color="#FAFFEE">
                             <hatch_fill enabled="True" type="Percent50" color="#204E83" opacity="1"/>
                             <border color="#204E83" opacity="1"/>
                        </pushed>
                        
                        <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>
  • 8. Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
    673536 Newbie
    Currently Being Moderated
    hello,

    Any hint is appreciated.

    Thanks.
  • 9. Re: APEX 3.2.1 missing AnyMap.swf?
    MatthiasHoys Explorer
    Currently Being Moderated
    AnyMap working fine for me now!

    Thanks,
    Matthias
  • 10. Re: APEX 3.2.1 missing AnyMap.swf?
    673536 Newbie
    Currently Being Moderated
    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.
  • 11. Re: APEX 3.2.1 missing AnyMap.swf?
    709686 Newbie
    Currently Being Moderated
    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
  • 12. Re: APEX 3.2.1 missing AnyMap.swf?
    MatthiasHoys Explorer
    Currently Being Moderated
    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
  • 13. Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
    MatthiasHoys Explorer
    Currently Being Moderated
    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
  • 14. Re: APEX 3.2.1 missing AnyMap.swf? -- How to access AnyMap?
    673536 Newbie
    Currently Being Moderated
    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
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points