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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|