Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Build Visio FlowChart from XML?

Posted on 2010-09-03
7
Medium Priority
?
3,156 Views
Last Modified: 2012-05-10
Is it possible to build a visio chart from data automatically? Looking for a tool or software to create a flowchart from a hierarchical query result (parent/child/path) to be displayed or accessible from sharepoint.
0
Comment
Question by:iBinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 9

Accepted Solution

by:
SharePointGirl earned 668 total points
ID: 33602255
0
 
LVL 4

Assisted Solution

by:oldviking
oldviking earned 668 total points
ID: 33602308
You could also do this by writing a macro, read the file and construct yiour diagram from the file. This involves a bit of macro programming.

If you're not that into any programming, then you can look at this ready made solution, where Scott and I explain how an excel file can be input to an org. chart. using the Org. Chart Wizard from a macro: http://www.experts-exchange.com/viewArticle.jsp?aid=2802

But I know that you don't need an org. chart, you need a flow chart. So far I don't know of any automatic solution for creating this.

If you are into programming, another option would be to write a program that constructs the Visio XML structures in an XML file that Visio can read; However this is not a trivial task, but if you are interested in pursuing this I could probably digg up moreinformation on this.
0
 
LVL 31

Assisted Solution

by:Scott Helmers
Scott Helmers earned 664 total points
ID: 33603120
A few additional thoughts following SharePointGirl and oldviking:

Visio does ship with several add-ins that automate the creation of drawings for specific purposes, such as the org chart wizard that oldviking mentions. However, Visio does not provide a generic, built-in way to create a  drawing from data. Consequently, if you want something other than the few cases handled by add-ins, you have to do it yourself.

One of the easiest ways is often to follow a similar path to the org chart wizard -- put your data in Excel and write Visio code to read it and place shapes on the page. I've provided sample code to previous questioners on this topic, perhaps some of it will be useful for you:
  • Check the sample code in this answer
  • A recent Q&A on the subject of XML and Visio
If you want more info about any of this, just ask...

Scott


0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

Author Comment

by:iBinc
ID: 33604935
I'm looking for automation...Oracle sql "connect by" results as a data feed. Could use either a batch program where the chart is saved for later online viewing and updated whenever the data changes or created on the fly as needed.

Do you have any c# examples?
0
 

Author Comment

by:iBinc
ID: 33604981
oldviking...I'll take you up on your suggestion for an example creating an xml file as output from an oracle sql and input to visio. Preferably would like examples in c# but VB is ok too.
0
 
LVL 31

Expert Comment

by:Scott Helmers
ID: 33605162
Sorry, I don't have C# examples. The Visio SDK that SharePointGirl referred you to above does have C# code samples but not for the specific purpose of creating a diagram from data as far as I know.

I'm not a database guy so I can't provide it for you, but you can use the sample code referred to above and read data directly from any SQL-compliant database  -- there's no need to move the data to Excel or XML first.
0
 

Author Comment

by:iBinc
ID: 33607055
Thanks for the links and info...very good information and feedback!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question