Apex ACP installation

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.



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




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




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




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









Apex ACP without
greasemonkey





No greasemonkey, no
problem. Just:



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

















<object
classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"


width="#WIDTH#"


height="#HEIGHT#"


id="#CHART_NAME#"


align="">


<param
value="#IMAGE_PREFIX#flashchart/swf/AnyChart.swf"
name="movie"/>


<param
value="high" name="quality"/>


<param
value="sameDomain" name="allowScriptAccess"/>


<param
value="all" name="allowNetworking"/>


<param
value="noscale" name="scale"/>


<param value="transparent"
name="wmode"/>


<param
value="XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.:APEX_ACP:::APEX_ACP_REGION_ID:#REGION_ID#"
name="FlashVars"/>


<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



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






begin


apex_acp.generate_chart(
:APEX_ACP_REGION_ID );


end;
















  1. Set the process
    error message to






    Unable
    to generate chart XML:



    #SQLERRM#








  1. Set condition type = “Request = Expression 1”
  2. Set Expression 1 to: “APEX_ACP”
  3. Apply changes
  4. 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



  1. Open a sql window on any client for the workspace schema or
    APEX_PUBLIC_USER
    1. You can go to SQL commands in the SQL builder
  2. 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





  1. Open a sql window on any client for the workspace schema or
    APEX_PUBLIC_USER
    1. You can go to SQL commands in the SQL builder
  2. 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



  1. Go to a chart region definition












  2. <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/#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&FLOW_PAGE_ID.:&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/#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&FLOW_PAGE_ID.:&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#


    Paste the following
    code into the region source and Apply Changes:
Posted by Rutger at Monday, June 01, 2009

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)