(Msg. 1) Posted: Thu Jun 25, 2009 5:03 am
Post subject: Link existing data from drawing to database so it will refresh Archived from groups: microsoft>public>visio>general (more info?)
I want to link the data from a drawing to a database. My original data source
is the information on the shape of the drawing. If I extract this from my
drawing to a database and then link it back Visio wants to give me a new
datagraphic.
Example- (Room#) “XX” “G153” and (name) “Row_1” “Mail” are part of the
original shape. I build the table with this information, and then try to link
it. Visio insists on adding a new datagraphic, I end up with redundant
information. Is there a way to export the data from the shape as linked data
or to link it on the shape sheet manually?
(Msg. 2) Posted: Thu Jun 25, 2009 9:05 am
Post subject: Re: Link existing data from drawing to database so it will refresh [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hello Ken,
What version of Visio are you using? In 2007 (Pro) there's the link to
external data functionality although this is really only intended as a
oneway street - in but not out. There's also the Database Wizard in 2007
and earlier (under Tools / Addons / Visio Extras) which allows two-way
interaction, although you it's not as easy to use as Link to External Data.
A final path, if you're happy with a little VBA, would be to hook things up
manually. You can easily give each shape a GUID (unique ID) which makes
syncing you data reasonably straight forward.
"Ken N" <KenN.DeleteThis@discussions.microsoft.com> wrote in message
news:AA93DB81-31A3-4109-8D91-73EC09555AA6@microsoft.com...
>I want to link the data from a drawing to a database. My original data
>source
> is the information on the shape of the drawing. If I extract this from my
> drawing to a database and then link it back Visio wants to give me a new
> datagraphic.
> Example- (Room#) “XX” “G153” and (name) “Row_1” “Mail” are part of the
> original shape. I build the table with this information, and then try to
> link
> it. Visio insists on adding a new datagraphic, I end up with redundant
> information. Is there a way to export the data from the shape as linked
> data
> or to link it on the shape sheet manually?
>
(Msg. 3) Posted: Thu Jun 25, 2009 9:05 am
Post subject: Re: Link existing data from drawing to database so it will refresh [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I use 2007, could I use the shape key from Visio? Where would I find more on
linking through code?
"John Goldsmith_Visio_MVP" wrote:
> Hello Ken,
>
> What version of Visio are you using? In 2007 (Pro) there's the link to
> external data functionality although this is really only intended as a
> oneway street - in but not out. There's also the Database Wizard in 2007
> and earlier (under Tools / Addons / Visio Extras) which allows two-way
> interaction, although you it's not as easy to use as Link to External Data.
>
> A final path, if you're happy with a little VBA, would be to hook things up
> manually. You can easily give each shape a GUID (unique ID) which makes
> syncing you data reasonably straight forward.
>
> Best regards
>
> John
>
>
> John Goldsmith (Visio MVP)
> www.visualSignals.typepad.co.uk > www.visualSignals.co.uk >
>
> "Ken N" <KenN.DeleteThis@discussions.microsoft.com> wrote in message
> news:AA93DB81-31A3-4109-8D91-73EC09555AA6@microsoft.com...
> >I want to link the data from a drawing to a database. My original data
> >source
> > is the information on the shape of the drawing. If I extract this from my
> > drawing to a database and then link it back Visio wants to give me a new
> > datagraphic.
> > Example- (Room#) “XX” “G153” and (name) “Row_1” “Mail” are part of the
> > original shape. I build the table with this information, and then try to
> > link
> > it. Visio insists on adding a new datagraphic, I end up with redundant
> > information. Is there a way to export the data from the shape as linked
> > data
> > or to link it on the shape sheet manually?
> >
>
>
(Msg. 4) Posted: Thu Jun 25, 2009 10:35 am
Post subject: Re: Link existing data from drawing to database so it will refresh [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Running XP Pro on a Network with Visio 2007:
Under tools I did use the “Database Wizard”
Following the wizard through-
Link shapes to database records
Shapes in drawing
Select shapes
Choose source
Table
Choose Prim-Key Field
Choose default key or click none
If I choose none it does nothing!! If I choose default it changes all to the
default. But neither give me a workable link. No linked table and a error
message when I try to refresh –
--
Ken N
"Ken N" wrote:
> I use 2007, could I use the shape key from Visio? Where would I find more on
> linking through code?
>
> "John Goldsmith_Visio_MVP" wrote:
>
> > Hello Ken,
> >
> > What version of Visio are you using? In 2007 (Pro) there's the link to
> > external data functionality although this is really only intended as a
> > oneway street - in but not out. There's also the Database Wizard in 2007
> > and earlier (under Tools / Addons / Visio Extras) which allows two-way
> > interaction, although you it's not as easy to use as Link to External Data.
> >
> > A final path, if you're happy with a little VBA, would be to hook things up
> > manually. You can easily give each shape a GUID (unique ID) which makes
> > syncing you data reasonably straight forward.
> >
> > Best regards
> >
> > John
> >
> >
> > John Goldsmith (Visio MVP)
> > www.visualSignals.typepad.co.uk > > www.visualSignals.co.uk > >
> >
> > "Ken N" <KenN.RemoveThis@discussions.microsoft.com> wrote in message
> > news:AA93DB81-31A3-4109-8D91-73EC09555AA6@microsoft.com...
> > >I want to link the data from a drawing to a database. My original data
> > >source
> > > is the information on the shape of the drawing. If I extract this from my
> > > drawing to a database and then link it back Visio wants to give me a new
> > > datagraphic.
> > > Example- (Room#) “XX” “G153” and (name) “Row_1” “Mail” are part of the
> > > original shape. I build the table with this information, and then try to
> > > link
> > > it. Visio insists on adding a new datagraphic, I end up with redundant
> > > information. Is there a way to export the data from the shape as linked
> > > data
> > > or to link it on the shape sheet manually?
> > >
> >
> >
(Msg. 5) Posted: Fri Jun 26, 2009 5:05 am
Post subject: Re: Link existing data from drawing to database so it will refresh [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hello Ken,
I see that you also talking to Al Edlund on in another thread. He's pointed
you to the correct info on the Database Wizard.
"Ken N" <KenN DeleteThis @discussions.microsoft.com> wrote in message
news:B9DFD72B-161A-4AAC-8BEF-DD47EE6F8739@microsoft.com...
> Running XP Pro on a Network with Visio 2007:
> Under tools I did use the “Database Wizard”
> Following the wizard through-
> Link shapes to database records
> Shapes in drawing
> Select shapes
> Choose source
> Table
> Choose Prim-Key Field
> Choose default key or click none
> If I choose none it does nothing!! If I choose default it changes all to
> the
> default. But neither give me a workable link. No linked table and a error
> message when I try to refresh –
>
> --
> Ken N
>
>
> "Ken N" wrote:
>
>> I use 2007, could I use the shape key from Visio? Where would I find more
>> on
>> linking through code?
>>
>> "John Goldsmith_Visio_MVP" wrote:
>>
>> > Hello Ken,
>> >
>> > What version of Visio are you using? In 2007 (Pro) there's the link to
>> > external data functionality although this is really only intended as a
>> > oneway street - in but not out. There's also the Database Wizard in
>> > 2007
>> > and earlier (under Tools / Addons / Visio Extras) which allows two-way
>> > interaction, although you it's not as easy to use as Link to External
>> > Data.
>> >
>> > A final path, if you're happy with a little VBA, would be to hook
>> > things up
>> > manually. You can easily give each shape a GUID (unique ID) which
>> > makes
>> > syncing you data reasonably straight forward.
>> >
>> > Best regards
>> >
>> > John
>> >
>> >
>> > John Goldsmith (Visio MVP)
>> > www.visualSignals.typepad.co.uk >> > www.visualSignals.co.uk >> >
>> >
>> > "Ken N" <KenN DeleteThis @discussions.microsoft.com> wrote in message
>> > news:AA93DB81-31A3-4109-8D91-73EC09555AA6@microsoft.com...
>> > >I want to link the data from a drawing to a database. My original data
>> > >source
>> > > is the information on the shape of the drawing. If I extract this
>> > > from my
>> > > drawing to a database and then link it back Visio wants to give me a
>> > > new
>> > > datagraphic.
>> > > Example- (Room#) “XX” “G153” and (name) “Row_1” “Mail” are part of
>> > > the
>> > > original shape. I build the table with this information, and then try
>> > > to
>> > > link
>> > > it. Visio insists on adding a new datagraphic, I end up with
>> > > redundant
>> > > information. Is there a way to export the data from the shape as
>> > > linked
>> > > data
>> > > or to link it on the shape sheet manually?
>> > >
>> >
>> >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other