Wednesday, January 6, 2010

APEX 4.0 EA1 Plugins - Google Visualization: Organizational Chart

APEX 4.0 EA1 Plugins - Google Visualization: Organizational Chart (click on the "Download Google Visualization Organizational Chart" link)

How it works:

1) Install the plugin

2) Region "Organizational Chart"







Voilà!



12 comments:

Patrick Wolf said...

Really nice! Very easy to get a ORG chart of an organization!

I have sent you an e-mail with some nodes about the plug-in code.

Regards
Patrick

Stew said...

Great job! Now I'm looking for a way to use this in some application!

Thanks

Kris said...

This is a great idea in theory, but user be ware. I was using the Google Organizational Chart in my Apex 3.1 environment. It works great until you get into large organizational charts. There is a limitation because they are using HTML tables to create the chart. There is a browser limitation for the colspan attribute of 999. The minute have a colspan > 999, the chart will not display. See this link to view the issue I opened with Google.

Organizational Chart Issue

The Google code needs to be updated to use DIVs. But then you have the issue of printing DIVs. So, either keep your org charts small or use DIVs and not be able to print them easily. Here is a website that uses DIVs for org charts, and they work very nicely, even for large charts.

www.cogmap.com

However, this uses javascript to generate the charts, and when you start getting into large org charts like I am dealing with, IE chokes. It will eventually load the chart, but it can take several minutes, and in the middle of the load, the browser will pop up a warning message telling you that a script running on the page is taking a long time to run, and do you want to let it finish. Oh, did I mention that Firefox will load the same org chart in about 10 seconds.

Hughie said...

I tried this but i never have the source region displayed.
What do i do wrong?
downloaded and installed plugin.
I created a blank html page.
Add a region from plugin type.
and then no region source possible.

please leave a commetn.

Louis-Guillaume Carrier-Bédard said...

Hughie,
I need to work on a new version of this plugin for APEX 4.0 (not the early adopter version).

Raphael said...

I had same problem that Hughie. I wanted to try this plugin because I need something looking this. Already exists a new version this plugin?

Louis-Guillaume Carrier-Bédard said...

Raphael,

You can try this plugin. I didn't try it myself.

http://www.apex-plugin.com/oracle-apex-plugins/region-plugin/google-visualizations_29.html

Thanks for you interest in my blog.

Jack said...

Hi! When trying to install the plugin I get the following error:

Error GET_BLOCK Error.
ORA-20001: Execution of the statement was unsuccessful. ORA-06550: line 3, column 1: PLS-00306: wrong number or types of arguments in call to 'CREATE_PLUGIN' ORA-06550: line 3, column 1: PL/SQL: Statement ignored ORA-06550: line 107, column 1: PLS-00306: wrong number or types of arguments in call to 'CREATE_PLUGIN_ATTRIBUTE' ORA-06550: line 107, column 1: PL/SQL: Statement ignored ORA-06550: line 123, column 1: PLS-00306: wrong number or types of arguments in call to 'CREATE_PLUGIN_ATTRIBUTE' ORA-06550:

Is there a way to make this work? Also, does the plugin work only on certain browsers?
I use APEX 4.1. Please let me know. Thanks

Louis-Guillaume Carrier-Bédard said...

Hi Jack,

The plugin was a proof of concept for APEX 4.0 EA1 (early adopter 1). This is you can't install it.



Jack said...

is there no possibility then to make this run on 4.1 version?

Louis-Guillaume Carrier-Bédard said...

Yes, it's possible and quite simple in fact. I have to copy/paste code to an APEX 4.1 plugin wizard and use the new APIs/data types.

Unfortunately, I don't have spare time available to upgrade the plugin. I am currently working on the next release of APEXFramework for APEX 4.2.

If your organization is looking for coaching on building plugins, I can hook you up with a colleague.

Thanks for your interest.
LG

hellounni said...

Hi LG,
I was able to successfully implement and get output from the Org-Chart plugin. Now I need to click on one node and the get a hierarchy START WITH that node. Could you please help me on getting details of a node while clicking it?

Krishna