Linking Sharepoint data to Visio

[Arnold]

Hello,
I am looking into the Database possibilities of Visio Professional 2007.
I managed to connect Sharepoint to Visio, but only in one way. So Sharepoint
is leading and Visio follows. Is there a way to make the connection two
ways, so that is Visio is changed, Shairepoint will follow ?
Thanks,
Arnold

 

[Al Edlund]

I'm going to assume that you have linked data to sharepoint via
datarecordsets. Data recordsets can roundtrip information but it has to be
done with custom code. Data recordsets can be read/updated in the document
using xml. The export then has to be coded based upon the target you want to
work with. I found it was easier just to update the target source and then
refresh (as in delete and redraw) the document.
al

 

[Arnold]

Al,

In the Visio 2007 new Data menu (I hope it is called Data in the English
version of Visio. I use Dutch) I have used the "linking data to shapes'
wizzard. That only works one way. Via the 'Data wizzard plugin' I managed to
link to Excel two ways, but I do not have direct access to the MSDE (SQL)
database Sharepoint is using.
So I defenitely need another way of doing this.

Have you got any experience with building such an XML code file? Would you
happen to have an example XML file that I can adjust for my situation?

Arnold

 

[Al Edlund]

Yes, I have some vba code that might be of assistance. Can you send me an
e-mail with a return address to edlund60014 lives at yahoo dot com.
al