How to add an xlxs or CSV formatted Organizational Chart ?
R

can someone answer?

Ninox Profile

Take a look at the Accounting template.  Look at the Accounts table.. and notice there is a relationship called Sub Accounts.. Which is a relationship back to itself... thus forming a chart of accounts.. Or.. in your case.. a hierarchy of person to supervisor (another person). 

R

@Mconneen- Can you please provide some details on how exactly to add the chart. Like if you can kindly give the steps so that would be great.? Thanks

Ninox Profile

Create a CSV file that looks like this. 

csvfile

Create a Person (or employee whatever) table that looks like this. 

person

Import the base records..   NOTE.. you will have to fill in the field for the related person.. 

importDev

You will notice that on the first import.. the Supervisor fields will all be BLANK.. that is becuse they did not exist yet. The first import created them... Run the import AGAIN.. same definiton as above. and POOF.. 

TheCEO

Ninox Profile

This is also VERY WELL WRITTEN in the user manual here.. 
https://ninoxdb.de/en/manual/import-and-export/importing-linked-data

R

Thanks Very much for providing this detail understandings. Really appreciated!!

I would go ahead and start using this, while it sort of imcomplete.. I mean, by creating this type of chart in CSV  the CSV also gives the graphical understandings on the relationship of each of the team memebrs from top to bottom, as normally we can find in any organizational chart. I guess this piece is still missing in Ninox. 

Reply