Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2021, 07:59 AM
charlie_graves charlie_graves is offline Automatically create an organisation chart on Visio by importing from Azure Active Directory? Windows 10 Automatically create an organisation chart on Visio by importing from Azure Active Directory? Office 2019
Novice
Automatically create an organisation chart on Visio by importing from Azure Active Directory?
 
Join Date: Dec 2021
Posts: 3
charlie_graves is on a distinguished road
Default Automatically create an organisation chart on Visio by importing from Azure Active Directory?

Hi, I'm looking to automatically create an organisation chart on Microsoft Visio from my company's data which is stored on Microsoft Azure Active Directory. Is this possible?



The only solution I can think of is to manually input the data into Excel and then import to Visio, however, this is obviously very time-consuming and not feasible for a company with 350+ employees.

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 12-25-2021, 03:09 PM
Guessed's Avatar
Guessed Guessed is offline Automatically create an organisation chart on Visio by importing from Azure Active Directory? Windows 10 Automatically create an organisation chart on Visio by importing from Azure Active Directory? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

What do you know about VBA? Can you make a SQL query connection to the AD to return the fields you will need? At a minimum you need the person's name and who they work for.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 12-29-2021, 08:22 AM
charlie_graves charlie_graves is offline Automatically create an organisation chart on Visio by importing from Azure Active Directory? Windows 10 Automatically create an organisation chart on Visio by importing from Azure Active Directory? Office 2019
Novice
Automatically create an organisation chart on Visio by importing from Azure Active Directory?
 
Join Date: Dec 2021
Posts: 3
charlie_graves is on a distinguished road
Default

Hi Guessed,

To be honest with you, I know very little about the software I'm using (I didn't even know Microsoft Visio existed until 3 weeks ago...). From my interpretation of your message, it seems the issue may be to do with a lack of a SQL database connection? Is this something that's needed to connect between Visio and Azure Active Directory to import data?
Reply With Quote
  #4  
Old 12-29-2021, 01:25 PM
Guessed's Avatar
Guessed Guessed is offline Automatically create an organisation chart on Visio by importing from Azure Active Directory? Windows 10 Automatically create an organisation chart on Visio by importing from Azure Active Directory? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

There are multiple ways to work with database content to automate the creation of graphics in Visio. In the case of Organisation charts, you may be lucky because there is an automated wizard available. To get to this particular wizard you need to create a new document using the Organization Chart template (in the Business section). This will open with a series of dialog windows that guides you through connecting to your data source and selecting the necessary fields.
Youtube videos can give you an idea on how that works visio org chart wizard tutorial - Google Search

If this doesn't work for your requirements it is also possible to do it via VBA but it is not anywhere near as simple. If you have the Visio Professional version (rather than Visio Standard) you can import database data into a Visio file and possibly could then turn that into a graphic. I haven't used the Pro version for many years but from memory I think it is likely to be an avenue to explore.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correctly importing shape types Visio 2016 org chart macleodal Visio 1 03-06-2017 01:17 PM
Automatically create an organisation chart on Visio by importing from Azure Active Directory? Push data automatically from Acess or Excel to create a Gantt chart in Project GST2212 Project 3 07-06-2012 12:52 PM
Word 2003 Organisation chart help wambaugh Word 5 04-16-2009 02:27 AM
Active Directory ababc Misc 0 09-19-2006 06:18 AM
Active Directory nukkumatti Misc 0 11-16-2005 08:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft