Solved

Build Visio FlowChart from XML?

Posted on 2010-09-03
7
2,681 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
7 Comments
 
LVL 9

Accepted Solution

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

Assisted Solution

by:oldviking
oldviking earned 167 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 30

Assisted Solution

by:Scott Helmers
Scott Helmers earned 166 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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 30

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 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