A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

using visio to input datavalues into the already created sql dB/ex



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2009, 07:39 AM posted to microsoft.public.visio.general
Tushar
external usenet poster
 
Posts: 7
Default using visio to input datavalues into the already created sql dB/ex

Is it possible to use the parameters on visio flowsheet/diagram as input to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked it to
sql database, is it possible to use this visio flowsheet to function as an
input interface to an external software or even as a point of input to sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function through
visio to simulate working of a factory, so for that i need to model 'what if'
kind of scenario. So i want the user to have the flexibility to make changes
on the flowsheet itself and see what happens if he does so. Hence for that i
need to dynamaically link the flowsheet data to excel or database, from where
the simulator product will extract data and make further calculation. the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database
  #2  
Old May 19th, 2009, 04:22 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default using visio to input datavalues into the already created sql dB/ex

dynamically roundtripping data (to/from visio) requires custom code to be
written.
al


"tushar" wrote in message
...
Is it possible to use the parameters on visio flowsheet/diagram as input
to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked it
to
sql database, is it possible to use this visio flowsheet to function as an
input interface to an external software or even as a point of input to sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function through
visio to simulate working of a factory, so for that i need to model 'what
if'
kind of scenario. So i want the user to have the flexibility to make
changes
on the flowsheet itself and see what happens if he does so. Hence for that
i
need to dynamaically link the flowsheet data to excel or database, from
where
the simulator product will extract data and make further calculation. the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database


  #3  
Old May 20th, 2009, 05:27 AM posted to microsoft.public.visio.general
Tushar
external usenet poster
 
Posts: 7
Default using visio to input datavalues into the already created sql d

so should i create macro for that? can you elaborate on the code please.
thanks

"AlEdlund" wrote:

dynamically roundtripping data (to/from visio) requires custom code to be
written.
al


"tushar" wrote in message
...
Is it possible to use the parameters on visio flowsheet/diagram as input
to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked it
to
sql database, is it possible to use this visio flowsheet to function as an
input interface to an external software or even as a point of input to sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function through
visio to simulate working of a factory, so for that i need to model 'what
if'
kind of scenario. So i want the user to have the flexibility to make
changes
on the flowsheet itself and see what happens if he does so. Hence for that
i
need to dynamaically link the flowsheet data to excel or database, from
where
the simulator product will extract data and make further calculation. the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database



  #4  
Old May 20th, 2009, 12:39 PM posted to microsoft.public.visio.general
AlEdlund
external usenet poster
 
Posts: 468
Default using visio to input datavalues into the already created sql d

Decisions to be made,
What will be the data/source sink
What code will you write in (vba is in the product, visual studio
express is free)

Skills
Gathering data from shapes (and handling visio events), a lot of this is
in the visio sdk
If you use sql server, how are your sql skills? (sql express is free)

Reading and writing from shape property examples are in the sdk, there
are a ton of
examples on moving data back and forth between sql and user code on various
microsoft sites.

al


"tushar" wrote in message
...
so should i create macro for that? can you elaborate on the code please.
thanks

"AlEdlund" wrote:

dynamically roundtripping data (to/from visio) requires custom code to be
written.
al


"tushar" wrote in message
...
Is it possible to use the parameters on visio flowsheet/diagram as
input
to
an external software/ or sql database?

I want to know that suppose i have a visio flowsheet and i have linked
it
to
sql database, is it possible to use this visio flowsheet to function as
an
input interface to an external software or even as a point of input to
sql
database which will use this data entered for further functioning?

To be clear i would like to state that I want to design a function
through
visio to simulate working of a factory, so for that i need to model
'what
if'
kind of scenario. So i want the user to have the flexibility to make
changes
on the flowsheet itself and see what happens if he does so. Hence for
that
i
need to dynamaically link the flowsheet data to excel or database, from
where
the simulator product will extract data and make further calculation.
the
result of these calculations would have to be displayed on the visio
flowsheet via excel or database.
so basically i need to dynamically export and import data from visio to
excel or database



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.