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  2.3.2014 19:11:33  Organizational chart from Domino Directory

Great , Can you shear the db ?

2Steve Pitcher  3.3.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  3.3.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  3.3.2014 10:37:30  Organizational chart from Domino Directory

here is a sample

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

{ Link }

6Smithe875  29.6.2014 2:45:55  John

Dead written subject material, Really enjoyed studying. cebcedbaeceeeceg

7Smithb553  4.7.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.7.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

9Mariusz  28.3.2019 12:11:50  Organizational chart from Domino Directory

Trying to achieve the same since days - no luck :-(

Can You share this nsf please ?

RSS

Latest articles

Archive

TOPlist