Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3286
  • Last Modified:

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.
0
iBinc
Asked:
iBinc
3 Solutions
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now