Correctly importing shape types Visio 2016 org chart
Trying to import a datafile from Excel to build an org chart. There seems to be little or no documentation on this other than the most trivial.
I started by drawing a dummy org chart using all the position types I need (manager, executive, position, vacancy, assistant, etc) and exporting it; Visio creates a column in the data file called "Master_shape" and gives it a number 1, 2, 3 etc for each type. Since there is no documentation, I created my own x-ref (e.g. 0 = 'executive').
I then used my own staff file (names, reporting lines, department etc) and to this I added a column with the same name exactly.. "Master_shape".. and included the numbers 0-5 as above according to which type of position it should appear as.
However. No matter what I put, the import makes all positions the same. The "top exec" is automatically shown as an exec, any position with reports is shown as a manager, and all others (whether assistant, vacancy, consultant, etc) are shown as a regular position.
If I have to manually change all the non-standard positions, I may as well not have an automated import! So there MUST be a way.
Anyone know how to do this?
|org chart, visio 2016|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Visio 2016 diagrams embeded in word 2016 not drawing properly||stubbo66||Visio||2||08-24-2016 05:58 PM|
|Problem with loading a CDialog-window in a Visio Add-on Visio 2016||tknijff||Visio||0||01-08-2016 08:41 AM|
|How do I lock shape positions in Visio 2010||redwards60||Visio||1||08-11-2015 05:41 AM|
|[Visio 2007] How to disable predefined data types?||fsgs||Visio||2||11-25-2010 03:11 AM|
|VISIO - Formatting Shape Data Details TABLE||Lora||Visio||0||07-19-2010 12:15 PM|