Our HR dept currently uses a proprietary software to create and maintain org charts. They want a better solution, and I was thinking about using something to pull this info from active directory. We already have job titles, managers, direct reports, etc in AD, so it seems like it would make sense to use this data instead of duplicating it.
I did some research online and saw that Visio 2010 has the ability to import data from an exchange address list, but I can't seem to make it work. When I run through the wizard it asks me who I want at the top of the list, so I select our CEO. In AD / OAB, if I pull him up and go to the organization tab I see all of his subordinates listed there, but none of this pulls into Visio. The end result of the import wizard is a single box with our CEO's name in it.
Please see the attached file for screenshots.
What am I doing wrong? What do I need to do to make this work?