Build Visio FlowChart from XML?

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.
iBincAsked:
Who is Participating?
 
oldvikingCommented:
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
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
iBincAuthor Commented:
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
 
iBincAuthor Commented:
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
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
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
 
iBincAuthor Commented:
Thanks for the links and info...very good information and feedback!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.