Read and write design tables

[Viltry]

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!

 

[sudhakarn]

Hi,

Could you not synchronise the design table as soon as they are modified in the excel?

 

[Viltry]

If I modify the excel file myself it synchronises the design table but as soon as I try to add data in the excel file from catia I lose all associations and I have to rebuild them by hand, which defeats the purpose.

 

[sudhakarn]

Hi,
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.

 

[JeniaL]

works fine for me. i don't lose any associations. i just need to associate newly created parameter to something.

 

[itsmyjob]

you could have some reaction on your driving parameters that will run some VB script that will read your parameters and update the excel file.
the design table would synchronize when it realize the excel file has been modified.

Eric N.
indocti discant et ament meminisse periti ​

 

[Viltry]

you could have some action that will run some script that will read your parameters and update the excel file.
the design table would synchronize when it realize the excel file has been modified.

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.

 

[itsmyjob]

why don't you have macro on network?

my part does see the excel update and i find the new updated value in my design table.

Eric N.
indocti discant et ament meminisse periti ​

 

[itsmyjob]

my scenario:

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

Eric N.
indocti discant et ament meminisse periti ​

 

[Viltry]

I'll try that out, see how it works. What a macro on network? I haven't heard that before.

 

[itsmyjob]

i can't get designTable1.Synchronize to be immediate.

also it would be nice to avoid the synchronize popup windows...

Eric N.
indocti discant et ament meminisse periti ​