Read and write design tables
Read and write design tables
(OP)
Hello everyone,
I'm currently working on some parametric design and I have reached what seems to be a dead end. I'm trying to avoid having to write macros as much as I can (what I create must be used by as many people as possible, hopefully without having to install macros).
I'm trying to create parameters driven by a design table that is itself driven by modified parameters (simple multiplications and divisions).
The design table will store different parameters for a rectangular pattern repetition. Those parameters are driven by multiple user parameters.
Right now everything is set up with different designs that activate and deactivate depending on the user parameters. I wish to clean that up and have a single design that gets modified through the design table.
So far, from what I've seen, design table seem to communicate with CATIA as a read only object. I was wondering if it would be possible to tell the design table to update automatically with current parameters as soon as the are entered (or when the update button is pressed). That design table would then be used to modify the design.
I tried getting the design to be directly affected by the parameters but there are to many different possibilities (13).
If any of this in unclear, I'll do my best to make it more understandable.
Thank you!
I'm currently working on some parametric design and I have reached what seems to be a dead end. I'm trying to avoid having to write macros as much as I can (what I create must be used by as many people as possible, hopefully without having to install macros).
I'm trying to create parameters driven by a design table that is itself driven by modified parameters (simple multiplications and divisions).
The design table will store different parameters for a rectangular pattern repetition. Those parameters are driven by multiple user parameters.
Right now everything is set up with different designs that activate and deactivate depending on the user parameters. I wish to clean that up and have a single design that gets modified through the design table.
So far, from what I've seen, design table seem to communicate with CATIA as a read only object. I was wondering if it would be possible to tell the design table to update automatically with current parameters as soon as the are entered (or when the update button is pressed). That design table would then be used to modify the design.
I tried getting the design to be directly affected by the parameters but there are to many different possibilities (13).
If any of this in unclear, I'll do my best to make it more understandable.
Thank you!





RE: Read and write design tables
Could you not synchronise the design table as soon as they are modified in the excel?
RE: Read and write design tables
RE: Read and write design tables
Checked it.but it works perfect for me when i edit the design table to enter the excel and add some rows and save to get back and the dt automatically synchronises. Not sure why its not happening for you. all the best.
RE: Read and write design tables
RE: Read and write design tables
the design table would synchronize when it realize the excel file has been modified.
indocti discant et ament meminisse periti
RE: Read and write design tables
That's what I've tried to do but it keeps breaking the link between the design table and the excel file. I'm currently using a work-around that just consists on making all the designs and activating/deactivating them with conditional rules. It's not pretty but it avoids macros. Not I don't want to write a macro, but the macro will have to be installed on all computers that might use this and that's going to take forever.
RE: Read and write design tables
my part does see the excel update and i find the new updated value in my design table.
indocti discant et ament meminisse periti
RE: Read and write design tables
catia open with part
mofify parameter
=> reaction see value update and run VB script that update CATIA cell and save excel file
wait time
design table synch request
part goes red asking for update
i open design table and see new value
maybe the script that change excel could after the save, modify the design table choice +1 then -1 , that might do the synch automatic then update solid
indocti discant et ament meminisse periti
RE: Read and write design tables
RE: Read and write design tables
also it would be nice to avoid the synchronize popup windows...
indocti discant et ament meminisse periti