Solved

Build Visio FlowChart from XML?

Posted on 2010-09-03
7
2,618 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

822 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