Employee org chart

Anvil Q&A
1

I am new to Anvil and was wondering if anyone has a script or app that can share that would allow me to build and employee org chart from data in a csv file?

Thanks

2

What columns are in your CSV file, and what do you hope to see displayed in the org chart?

1 Like
3

Thanks for replying to my question. The csv file will have an employee name, job title and a column with the manager’s name. Below is an idea of what I am trying to display:

Hopefully this makes sense.

thanks

Moises

4

@moises_suarez you will want to show what you’ve googled and what you have tried as a result—including code.

5

Okay, you could quite easily use this library and return the outputs as images: C4 · Diagrams

Alternatively, you could look to the JS bridge and play around with D3 or some of the other libraries.

2 Likes
6

Using https://mermaid.js.org/ to do that is now on my to-do list :wink:

2 Likes
7

That’s looks like a great library! I know it’s appallingly nerdy, but I turned the whole of ATT&CK into diagrams not so long back, hence the quick go to!

8

Here’s an Anvil integration of the basic tutorial from the mermaid web site:

Clone:

https://anvil.works/classic-build#clone:4F4P7XJSHF5X3LWK=XNC6RP7PVOTFXXUVOK6SCC3O

5 Likes
9

The static mermaid code in that example can easily be replaced by code that’s dynamically generated using Python in Anvil. That should enable moises_suarez to generate a cool looking employee org chart from the csv file data.

1 Like
10

I briefly updated the static mermaid code in the Anvil example, to draw diagrams that are a bit closer to what you’d want to generate for the org chart (including top-to-bottom, and left-to-right orientations).

(… a fewww hours laterrrrrr…): added a few more examples from the mermaid web site, to demonstrate different sorts of diagrams. That’s fun :slight_smile: