Anychart Conversion Package

Welcome!

2009-06-18T13:09:00.000-07:00

Hello and welcome to the site of the Apex Anychart Conversion Package!
On this site you can download the latest version, check out the features, and look at some demo's.

If you don't know where to start, Download the package and look at the Installation Guide. It will tell you exactly what to do. Click here if you'd like to see the Features and Limitations of the ACP. And if you've found any BUGS ! Be sure to report them here!

What is the Apex ACP?
The Apex ACP is a package written in PL/SQL for Oracle Apex, that enables you to convert your Anychart 3.3 charts into Anychart 4.2.1 charts.

The package generates XML that the Anychart 4.2.1 flash files can understand. The big advantage is that you can still use the Oracle Apex wizards and builder to create or maintain your charts.

A full guide of the inner workings of the Apex ACP, will be added to this site soon!

Demo's

2009-06-10T20:03:00.000-07:00

Demo's

Live demos on apex.oracle.com:

Demo 1

Look at some video of the ACP in action:

This video demo shows the Apex ACP Plugin functionality:

This video shows multiple series defined in one query:

Features

2009-06-10T19:28:00.000-07:00

Version 0.6.2 (first bèta release)

Features:

1. Better export functionality (supported by Anychart 4.2.1):
- Save chart to PDF
- Save chart as image
- Print chart directly
2. Better look and feel creating a better overview
3. More grid lines on the chart
4. The use of all standard APEX wizards in the Apex Builder
5. Easy conversion plugin changing your chart with the click of a button
- This uses greasemonkey
6. Convert the following charts from Anychart 3.3 to Anychart 4.2.1 :
- Candlestick
- Horizontal Range 2D Column
- Horizontal Range 3D Column
- Horizontal 2D Column
- Horizontal 3D Column
- Range 2D Column
- Range 3D Column
- Scatter
- Stacked Horizontal 2D Column
- Stacked Horizontal 2D Column (Percent)
- Stacked Horizontal 3D Column
- Stacked Horizontal 3D Column (Percent)
- Stacked 2D Column
- Stacked 2D Column (Percent)
- Stacked 3D Column
- Stacked 3D Column (Percent)
- 2D Column
- 2D Doughnut
- 2D Line
- 2D Pie
- 3D Column

Limitations:

Label rotation degree values must be divisable by "90" (so 45 degrees is not supported yet)
Color schemes are not supported yet
3D Pie chart is not included, it will show a blank region if you convert the chart
No support for Gauges. Anychart 4.2.1 doesn't support gauges yet. This means the standard apex "Dial" cannot be converted
"Use custom XML" is not yet supported, the definiton in the Custom XML field, is the "old" Anychart 3 XML definition

Installation

2009-06-02T06:57:00.000-07:00

Installation Video (the guide is under the video)

You can use the iFrame to view the installation document or open it in a new window:
http://docs.google.com/View?id=dcjrd3tk_58h4jstkhg

&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;br&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt; &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;Your browser does not support iframes.&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;br&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;

Apex ACP installation

2009-06-01T05:29:00.000-07:00

Apex ACP
installation

These steps will guide
you to create the Apex ACP installation. The Apex ACP is designed to be
installed in a parsing schema of an Apex workspace. So if you want to have the
Apex ACP on more workspaces in your framework you can run this installation for
every workspace where you’d like to have the Apex ACP.

You should know

that the script creates an application process and an application item for
every application in the target workspace. This makes sure you can use the
Apex ACP functionality across your entire workspace.

If you create a new application on your workspace, read the “Enabling new applications” section

1. Download the latest Apex ACP here

2. Unzip the files on a location on your server (or localhost) machine

a.
This
location will be referenced as <<install_dir>> in the rest of the
steps

3.
Start an
sqlplus session for the parsing schema

a.
The
parsing schema is the main schema of the workspace

b.
If you
don’t know the name of the schema, go to an application on your target
workspace > Shared Components > Application Definition, you will find the
“Parsing Schema” at the bottom of the first block “Name”

c.
Still
having trouble locating, look at the installation example or the video

4.
Run the
following command

a.
Replace
<<install_dir>> with your install directorty

b.
Or run the
sqlplus session from that directory and remove the <<install_dir>>
from the command

c.
Mind the
slash “ \ ”, for example install dir is c:\apexacp it will need a slash

@<<install_dir>>\v06_install_script.sql

5.
The script
will run and it will give you: “PL/SQL procedure successfully completed.”

Apex ACP plugin
installation

To use the Apex ACP
plugin you need the greasemonkey for Firefox.

So add the addon from: https://addons.mozilla.org/nl/firefox/addon/748

And drag the “greaseMonkey_APEX_ACP.user.js” file into a firefox
window.

Greasemonkey will popup, and ask you if you want to install the
script. You click accept, and viola, the plugin is installed.

You can test this by going to any chart region definition.

Apex ACP without
greasemonkey

No greasemonkey, no
problem. Just:

install the Apex ACP
according to this document
Go to a chart region definition
Paste the following code into the region source and Apply Changes:

width="#WIDTH#"

height="#HEIGHT#"

id="#CHART_NAME#"

align="">

<embed

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="XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.:APEX_ACP:::APEX_ACP_REGION_ID:#REGION_ID#"

src="#IMAGE_PREFIX#flashchart/swf/AnyChart.swf">

</object>

#CHART_REFRESH#

Enabling new applications

Unfortunately, at the
moment it isn’t possible to “auto” enable the Apex ACP with application
creation. So we have to do that ourselves. You can do this in 3 ways:

-
Run the
auto script that enables the Apex ACP for all applications on the workspace

o
This
is done in the installation as well

-
Run a
manual script to enable the Apex ACP for one distinct application

-
Create the
Apex ACP application process and item yourself

Create the Apex ACP application process and
item yourself

In your new application, create an application process called “APEX_ACP”
Set the process text as:

begin

apex_acp.generate_chart(
:APEX_ACP_REGION_ID );

end;

Set the process
error message to

Unable
to generate chart XML:

#SQLERRM#

Set condition type = “Request = Expression 1”
Set Expression 1 to: “APEX_ACP”
Apply changes
Create an application item called: “APEX_ACP_REGION_ID”

!Done, the application can now use the Apex ACP

Run the auto script that enables the Apex ACP
for all applications on the workspace

Open a sql window on any client for the workspace schema or
APEX_PUBLIC_USER

You can go to SQL commands in the SQL builder

Execute the following code:

exec
APEX_ACP_UTIL.create_app_process('AUTO');

!Done, the application can now use the Apex ACP

Run a manual script to enable the Apex ACP for
one distinct application

Open a sql window on any client for the workspace schema or
APEX_PUBLIC_USER

You can go to SQL commands in the SQL builder

Execute the following code (where <<app_id>> is your
application_id):

exec
APEX_ACP_UTIL.create_app_process(‘MAN’, <<app_id>>);

Resetting
chart region to Anychart 3.3 without greasemonkey

Go to a chart region definition

codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"

width="#WIDTH#"

height="#HEIGHT#"

id="#CHART_NAME#"

align="">

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#

Paste the following
code into the region source and Apply Changes:

Anychart Conversion Package

Welcome!

Demo's

Features

Installation

Apex ACP installation

Apex ACPinstallation

Apex ACP plugininstallation

Apex ACP withoutgreasemonkey

Enabling new applications

Resettingchart region to Anychart 3.3 without greasemonkey

Apex ACP
installation

Apex ACP plugin
installation

Apex ACP without
greasemonkey

Resetting
chart region to Anychart 3.3 without greasemonkey