P
Peter Fastré
Hello,
We have the following text file:
Template,"ORGANIZATION CHART.VST",,,,,,
PlacementStyle,1,,,,,,
RoutingStyle,1,,,,,,
Shape,"131437","EXECUTIVE","DIRECTOR",,,,
Shape,"131438","POSITION","MANAGER1",,,,
Link,,"Dotted Line Connector",,"131437","131438",,
Shape,"131439","POSITION","MANAGER2",,,,
Link,,"Dynamic Connector",,"131437","131439",,
We have some custom connector (with different colors/fills), and this
is where our problems start. We cannot use the Org. Chart Wizard,
because it doesn't support changing the connectors between the shapes.
It does work somehow by opening the CSV-file directly. Unfortunately,
Visio 2003 doesn't have the feature File, Open text file. So we use
Visio 2002 now.
There are 2 ways to import this file, and both of them have a problem.
I spent whole day looking for a solution, but now I'm desperately
looking for help.
METHOD 1
--------
File, Open, CSV -> test.csv
This opens the file correctly, but always adds connectors between all
shapes. I only want connectors between the shapes, which I define with
the rows Link. On top of those default connectors, it draws my custom
links, but I just don't want the default connectors. How can we do
this?
METHOD 2
--------
Select the file in explorer, right click on it, open with, microsoft
visio. This doesn't create those default connectors, seems to do it
all correctly. It displays a msgbox indicating that visio has imported
my textfile, not to forget to save it. When you click OK, it replaces
all my custom links (with those colors) with those default connectors.
METHOD 3
--------
Write my own VBA import application. I do have experience with
VB/VBScript, but not those specific Visio stuff. Where can I start? I
found some examples on the net, but almost never they have connections
between shapes. I can successfully place a shape on the grid, but
that's very far of creating a complete orgchart.
I need a solution by tomorrow, hope somebody can give me a hint. I
don't care how or what I have to do, but it must work!
Thanks!
Peter
We have the following text file:
Template,"ORGANIZATION CHART.VST",,,,,,
PlacementStyle,1,,,,,,
RoutingStyle,1,,,,,,
Shape,"131437","EXECUTIVE","DIRECTOR",,,,
Shape,"131438","POSITION","MANAGER1",,,,
Link,,"Dotted Line Connector",,"131437","131438",,
Shape,"131439","POSITION","MANAGER2",,,,
Link,,"Dynamic Connector",,"131437","131439",,
We have some custom connector (with different colors/fills), and this
is where our problems start. We cannot use the Org. Chart Wizard,
because it doesn't support changing the connectors between the shapes.
It does work somehow by opening the CSV-file directly. Unfortunately,
Visio 2003 doesn't have the feature File, Open text file. So we use
Visio 2002 now.
There are 2 ways to import this file, and both of them have a problem.
I spent whole day looking for a solution, but now I'm desperately
looking for help.
METHOD 1
--------
File, Open, CSV -> test.csv
This opens the file correctly, but always adds connectors between all
shapes. I only want connectors between the shapes, which I define with
the rows Link. On top of those default connectors, it draws my custom
links, but I just don't want the default connectors. How can we do
this?
METHOD 2
--------
Select the file in explorer, right click on it, open with, microsoft
visio. This doesn't create those default connectors, seems to do it
all correctly. It displays a msgbox indicating that visio has imported
my textfile, not to forget to save it. When you click OK, it replaces
all my custom links (with those colors) with those default connectors.
METHOD 3
--------
Write my own VBA import application. I do have experience with
VB/VBScript, but not those specific Visio stuff. Where can I start? I
found some examples on the net, but almost never they have connections
between shapes. I can successfully place a shape on the grid, but
that's very far of creating a complete orgchart.
I need a solution by tomorrow, hope somebody can give me a hint. I
don't care how or what I have to do, but it must work!
Thanks!
Peter