WE BLOG ABOUT LOTUS NOTES ... FOR MORE THAN 15 YEARS

Organizational chart from Domino Directory

Stanislav Marszalek  1 March 2014 15:12:27
Using Xpages you can build up an Organizational chart directly from your Domino Directory (names.nsf), which can looks like the picture below:

Image:Organizational chart from Domino Directory


To do this you need a proper data on each person document, mainly Manager's name, which is used to build up a structure from the bottom to the top. Something like this:

Image:Organizational chart from Domino Directory  

For the chart creation we are using Google Organizational Chart, which is accepting data in json, in the form of table.
A table with three string columns, where each row represents a node in the orgchart. Here are the three columns:
  • Column 0 - The node ID. It should be unique among all nodes, and can include any characters, including spaces.
  • Column 1 - [optional] The ID of the parent node. This should be the unformatted value from column 0 of another row.
  • Column 2 - [optional] Tool-tip text to show, when a user hovers over this node.
Each node can have zero or one parent node, and zero or more child nodes. Something like this:

Image:Organizational chart from Domino Directory
So the main task in Xpages is to generate this data structure from Domino directory and send it to chart generator.


Comments

1Palmi  02.03.2014 19:11:33  Organizational chart from Domino Directory

Great , Can you shear the db ?

2Steve Pitcher  03.03.2014 2:47:13  Organizational chart from Domino Directory

I was asking just this past Friday about how to do this. I'd love to get my hands on the code if you'd share please.

3Albert Buendia  03.03.2014 7:49:43  Organizational chart from Domino Directory

Please, share your excellent code in openntf.org Thanks !! Not all the Domino guys are developers ;)

4xchart  03.03.2014 10:37:30  Organizational chart from Domino Directory

here is a sample

5xchart  03.03.2014 10:37:47  Organizational chart from Domino Directory

{ Link }

6Smithe875  29.06.2014 2:45:55  John

Dead written subject material, Really enjoyed studying. cebcedbaeceeeceg

7Smithb553  04.07.2014 8:48:39  John

I've been absent for a while, but now I remember why I used to love this site. Thank you, I'll try and check back more frequently. How frequently you update your site? bddffdcekbdddaka

8Smithf72  25.07.2014 8:58:40  John

I've been absent for a while, but now I remember why I used to love this website. Thanks, I'll try and check back more frequently. How frequently you update your site? eadekaegkkbceeee
TOPlist