| Author |
Message |
CADProSys.
Guest
|
 Posted:
Fri Nov 12, 2004 7:57 pm Post subject:
Drvining relations or parameters from external source |
|
|
Hi everyone,
I'm curently looking for a method to drive ProE relations or parameters from
some external source..for example Microsoft Excel.
Well, I made mathematical model of my machine in Excel file. The output
contain some design parameters wich sould be included in CAD model. My
question is how to make a link between ProE (Wildfire 2.0) and Excel to use
the certain value from Excel worksheet as a ProE design parametar value?
I know this is posible with Pro/Desktop.
Thank you
|
|
| Back to top |
|
 |
Dennie Truren
Guest
|
| Posted:
Sat Nov 13, 2004 7:20 pm Post subject:
Re: Drvining relations or parameters from external source |
|
|
"CADProSys." <cadpro@EUnet.yu> wrote in news:cn2is3$4qr$1@news.eunet.yu:
| Quote: | Hi everyone,
I'm curently looking for a method to drive ProE relations or
parameters from some external source..for example Microsoft Excel.
Well, I made mathematical model of my machine in Excel file. The
output contain some design parameters wich sould be included in CAD
model. My question is how to make a link between ProE (Wildfire 2.0)
and Excel to use the certain value from Excel worksheet as a ProE
design parametar value? I know this is posible with Pro/Desktop.
Thank you
|
A VBA API called Gateway (sold by Rand Worldwide for a reasonable
fee) is available to link Excel to Pro/E. It requires little Visual
Basic skills. |
|
| Back to top |
|
|
David Janes
Guest
|
| Posted:
Sat Nov 13, 2004 7:36 pm Post subject:
Re: Drvining relations or parameters from external source |
|
|
: "CADProSys." <cadpro@EUnet.yu> wrote
: Hi everyone,
:
: I'm curently looking for a method to drive ProE relations or parameters from
: some external source..for example Microsoft Excel.
:
: Well, I made mathematical model of my machine in Excel file. The output
: contain some design parameters wich sould be included in CAD model. My
: question is how to make a link between ProE (Wildfire 2.0) and Excel to use
: the certain value from Excel worksheet as a ProE design parametar value?
: I know this is posible with Pro/Desktop.
:
The only place, still, that Pro/e can use Excel as a table editor is in Family
Tables. So, if you've used Excel to set up some columns with dimension variations
of model parameters, this database can be used from within 'Tools>Family table' as
the table data. You first need at least one row instance inserted in the table
before the File options (Import, Export, Edit with Excel) become active.
Otherwise, its OLE server makes data available to Windows programs so that they
can link, somehow, to Pro/e data and use it in their programs, something I've
heard very little about, but not the other way. Pro/e doesn't accept/use data, in
its native format, from Windows programs.
You can, however, export your Excel spreadsheet to a CSV (Comma Separated Values)
format file and import this into the Family Table editor. Pro/e's built in table
editor will export this way also, so it may be a way of communicating with Excel.
Awkward, I know, but it beats a poke in the eye with a sharp stick.
David Janes
|
|
| Back to top |
|
|
kenny
Guest
|
| Posted:
Sun Nov 14, 2004 9:09 pm Post subject:
Re: Drvining relations or parameters from external source |
|
|
on Sat, 13 Nov 2004 06:36:53 -0800, David Janes said...
| Quote: | : I'm curently looking for a method to drive ProE relations or parameters from
: some external source..for example Microsoft Excel.
:
: Well, I made mathematical model of my machine in Excel file. The output
: contain some design parameters wich sould be included in CAD model. My
: question is how to make a link between ProE (Wildfire 2.0) and Excel to use
: the certain value from Excel worksheet as a ProE design parametar value?
: I know this is posible with Pro/Desktop.
:
The only place, still, that Pro/e can use Excel as a table editor is in Family
Tables.
In 2001 there is 'analysis\excell analysis' that can be used to |
drive parameters. I've never used it but would be interested in
examples of what it can do. |
|
| Back to top |
|
|
David Janes
Guest
|
| Posted:
Mon Nov 15, 2004 12:42 am Post subject:
Re: Drvining relations or parameters from external source |
|
|
: "kenny" <kenny@NOSPAM.com> wrote
: > on Sat, 13 Nov 2004 06:36:53 -0800, David Janes said...
: > : CADProSys. wrote
: > : I'm curently looking for a method to drive ProE relations or parameters from
: > : some external source..for example Microsoft Excel.
: > :
: > : Well, I made mathematical model of my machine in Excel file. The output
: > : contain some design parameters wich sould be included in CAD model. My
: > : question is how to make a link between ProE (Wildfire 2.0) and Excel to use
: > : the certain value from Excel worksheet as a ProE design parametar value?
: > : I know this is posible with Pro/Desktop.
: > :
: > The only place, still, that Pro/e can use Excel as a table editor is in Family
: > Tables.
: >
: In 2001 there is 'analysis\excell analysis' that can be used to
: drive parameters. I've never used it but would be interested in
: examples of what it can do.
Yeah, never heard of this but sounds interesting. My general comments came from
two sources: 1. PTC/Pro-e comment at the time of installation on what the OLE
server can do/not do; 2. the only exception I'd heard of was Family Table data,
but if the one you mention, Kenny, is available, it's quite welcome news. Mostly,
PTC/Pro-e have avoided anything system dependent like the plague because it would
spoil their neat, pristine one-size-fits-all compile/distribution system. It's
written on UNIX and to avoid proprietary claims and incompatibilities between 7 or
8 different flavors, all information beyond the proprietary part information, is
passed in ASCII. Genius, hunh!?! So, basically, nothing follows/compiles to the
Windows API, nothing is licensed from MicroSoft. The little stuff we are talking
about is, far and away, the exception. Of course, SolidWorks is nipping pretty
hard at their rear, and it's gaining market share by being fully MS API
compatible. So, some grudging (necessarily, because, for a decade, they've
resisted going this way, toward two, separate compiles of Pro/e) accomodations are
in order. Don't see what the big deal is about two separate compiles, except that
it would show the UNIX side to be complacent, inbred slackers who never liked or
reconciled themselves to a GUI interface and most definitely nothing to help
average, corporate users. Programmers, in UNIX, are gods; users are scum of the
earth. UNIX dictum to users: don't touch anything!!
Pro/e, if it wishes to appeal to both worlds, should quit denying there's any
differnce and should recognize the differnces of each. TWO COMPILES ~ ONE FOR
UNIX, ONE FOR NT! Some day they may find common ground, but for now, we witness
the beginnings of speciation.
David Janes |
|
| Back to top |
|
|
Rod Giles
Guest
|
| Posted:
Mon Nov 15, 2004 11:59 am Post subject:
Re: Drvining relations or parameters from external source |
|
|
David Janes wrote:
| Quote: | : "kenny" <kenny@NOSPAM.com> wrote
: > on Sat, 13 Nov 2004 06:36:53 -0800, David Janes said...
: > : CADProSys. wrote
: > : I'm curently looking for a method to drive ProE relations or parameters from
: > : some external source..for example Microsoft Excel.
: > :
: > : Well, I made mathematical model of my machine in Excel file. The output
: > : contain some design parameters wich sould be included in CAD model. My
: > : question is how to make a link between ProE (Wildfire 2.0) and Excel to use
: > : the certain value from Excel worksheet as a ProE design parametar value?
: > : I know this is posible with Pro/Desktop.
: > :
: > The only place, still, that Pro/e can use Excel as a table editor is in Family
: > Tables.
:
: In 2001 there is 'analysis\excell analysis' that can be used to
: drive parameters. I've never used it but would be interested in
: examples of what it can do.
Yeah, never heard of this but sounds interesting. My general comments came from
two sources: 1. PTC/Pro-e comment at the time of installation on what the OLE
server can do/not do; 2. the only exception I'd heard of was Family Table data,
but if the one you mention, Kenny, is available, it's quite welcome news. Mostly,
PTC/Pro-e have avoided anything system dependent like the plague because it would
spoil their neat, pristine one-size-fits-all compile/distribution system. It's
written on UNIX and to avoid proprietary claims and incompatibilities between 7 or
8 different flavors, all information beyond the proprietary part information, is
passed in ASCII. Genius, hunh!?! So, basically, nothing follows/compiles to the
Windows API, nothing is licensed from MicroSoft. The little stuff we are talking
about is, far and away, the exception. Of course, SolidWorks is nipping pretty
hard at their rear, and it's gaining market share by being fully MS API
compatible. So, some grudging (necessarily, because, for a decade, they've
resisted going this way, toward two, separate compiles of Pro/e) accomodations are
in order. Don't see what the big deal is about two separate compiles, except that
it would show the UNIX side to be complacent, inbred slackers who never liked or
reconciled themselves to a GUI interface and most definitely nothing to help
average, corporate users. Programmers, in UNIX, are gods; users are scum of the
earth. UNIX dictum to users: don't touch anything!!
Pro/e, if it wishes to appeal to both worlds, should quit denying there's any
differnce and should recognize the differnces of each. TWO COMPILES ~ ONE FOR
UNIX, ONE FOR NT! Some day they may find common ground, but for now, we witness
the beginnings of speciation.
David Janes
David, |
An excel analysis is part of Behavioural Modelling Extension, and has
been available since it came out (2001 I believe). You are able to pass
parameters from ProE to excel cells and retrieve cell values from excel
and assign them to parameters. This sounds exactly what CADProSys is
after. You can also carry out an 'external' analysis, which enables you
to hook into any external program. I know that this can be done with
ANSYS and would like to hear from anyone who's used it.
I have used BMX to do quite a few things, including a excel linked
design for a heat exchanger, where I used excel to do the heat transfer
calculations by passing through surface areas and thickness and
returning performance values as parameters. I then used BMX to optimise
the exchanger.
Regards,
Rod Giles
Pro/Mechanica Users Group UK |
|
| Back to top |
|
|
Dave Bigelow
Guest
|
| Posted:
Mon Nov 15, 2004 11:36 pm Post subject:
Re: Drvining relations or parameters from external source |
|
|
Dennie Truren <dtruren@hotmail.nl> wrote in message news:<Xns95A0CF4A3D2B4dtrurenhotmailnl@213.51.129.36>...
| Quote: | "CADProSys." <cadpro@EUnet.yu> wrote in news:cn2is3$4qr$1@news.eunet.yu:
Hi everyone,
I'm curently looking for a method to drive ProE relations or
parameters from some external source..for example Microsoft Excel.
Well, I made mathematical model of my machine in Excel file. The
output contain some design parameters wich sould be included in CAD
model. My question is how to make a link between ProE (Wildfire 2.0)
and Excel to use the certain value from Excel worksheet as a ProE
design parametar value? I know this is posible with Pro/Desktop.
Thank you
|
p-AdvancedBOM does this right off the shelf - no programming required!
Check it out at: http://www.buydesignautomation.com
Also - Not sure if the Rand product is even supported anymore.
You should look at p-Shell API - http://www.buydesignautomation.com as
a more capable alternative if you are looking for API level access.
Good Luck!
Dave |
|
| Back to top |
|
|
huggre
Guest
|
| Posted:
Tue Nov 23, 2004 8:17 pm Post subject:
Re: Drvining relations or parameters from external source |
|
|
"Dan Richards" <danrich66@hotpop.com> wrote in message news:<Bw4md.20648$Rf1.17760@newssvr19.news.prodigy.com>...
| Quote: | Along with the previously mentioned capabilities, you can also setup excel
to spit out a file that can be imported by Pro-Program. It works very well
in my opinion, but it does require a bit of initial work to setup. You need
to setup a "results sheet" in excel that provides proper output to
Pro-Program and then Pro-Program needs to be setup to accept and utilize the
inputs from the "results sheet" from your spreadsheet.
"CADProSys." <cadpro@EUnet.yu> wrote in message
news:cn2is3$4qr$1@news.eunet.yu...
Hi everyone,
I'm curently looking for a method to drive ProE relations or parameters
from
some external source..for example Microsoft Excel.
Well, I made mathematical model of my machine in Excel file. The output
contain some design parameters wich sould be included in CAD model. My
question is how to make a link between ProE (Wildfire 2.0) and Excel to
use
the certain value from Excel worksheet as a ProE design parametar value?
I know this is posible with Pro/Desktop.
Thank you
|
There is an article in the PTC knowlege Base that describes how to do
this.
The Basics of this method is that you generate a textfile (ASCII)
where you have all your parameters and values listed (Write a small
Excel VBA macro that exports the file)
You can then make pro/e read this file when regenerating.
Hugo |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in