×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Read and write design tables

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!

RE: Read and write design tables

Hi,

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

RE: Read and write design tables

(OP)
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.

RE: Read and write design tables

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.

RE: Read and write design tables

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

RE: Read and write design tables

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

RE: Read and write design tables

(OP)

Quote (itsmyjob)

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.

RE: Read and write design tables

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

RE: Read and write design tables

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

RE: Read and write design tables

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

RE: Read and write design tables

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources