none
Excel data import to create a Visio brainstorming diagram RRS feed

  • Question

  • Need to create a Visio brainstorming diagram from excel data. 

    I do not want to link data to a brainstorming diagram.

    I only want to create an initial "blank" Visio brainstorming diagram from an excel sheet.

    When I use the Brainstorming pull-down menu to export data from an existing Brainstorming diagram, both the word and excel export features are disabled.  Only the XML export feature is available.  It sure would  be nice to know why these are disabled and/or how to enable them. 

    In addition, no matter what I do to try to import data from excel, all I get is the error message, "Brainstorming:  Unable to import file.  Import file does not contain a valid schema".  And when searching the web I can find nothing about a "valid schema" definition so that I can create one to use to format an excel import to create a Visio Brainstorming diagram. 

    Of course there is an org chart wizard I could use.  The problem with it is that everytime you use the org chart wizard it places the org chart boxes in a completely differnt order.  I've heard that the brainstorming diagram function will put the boxes in the same place everytime a diagram is created from excel to create a Visio brainstorming diagram.  Of course I cannot find a way to do this.

    I am using Visio 2007 and Excel 2010

    Ideas?  Suggestions?  Education Links?

    Thanks,

    Don


    lundi 28 mai 2012 00:50

Réponses

  • Just to put it into perspective, Visio add-ons usually work with the current version of office (i.e. v2007 uses o2007 products, v2010 uses o2010 products) and vice-a-versa. The schemas can be deduced by looking at the raw xml export/import for those that might want to build their own solutions.

    al


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Al Edlund Visio MVP

    lundi 28 mai 2012 01:58

Toutes les réponses

  • Just to put it into perspective, Visio add-ons usually work with the current version of office (i.e. v2007 uses o2007 products, v2010 uses o2010 products) and vice-a-versa. The schemas can be deduced by looking at the raw xml export/import for those that might want to build their own solutions.

    al


    If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Al Edlund Visio MVP

    lundi 28 mai 2012 01:58
  • Al,

    This question still stands for Visio 2013. I can export to Excel/XML, but cannot import that same exported file to a new Visio Brainstorm diagram.

    Is there a non-developer method for doing this? How do I get my hands on the XSD?

    Jeff

    vendredi 31 juillet 2015 23:13
  • The usual technique I use is to create a drawing, export it (so that it has the correct format), and then attempt to import what I just created as a new drawing. When I tested v2010 it would only export XML.

    I then went to the control panel, programs, and attempted to change the install by 'adding' features. I reinstalled all of the solutions (execute on system) and was able to export a 'brainstorming' diagram as excel (it's an xml image by the way). I then was able to import the file I had just exported.

    al edlund

    ps I was able to open the file in excel.


    Al Edlund Visio MVP

    dimanche 2 août 2015 01:08