×
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

how to link design table and "CellAsString" ?

how to link design table and "CellAsString" ?

how to link design table and "CellAsString" ?

(OP)
I have a design table that will be linked to a part, to create a spreadsheet designed part. (per a previous thread, and to be used as an example/FAQ)  The only part that I am stumped on, is how to link the part name to the spreadsheet.

The closest that I can figure is Design Table parameter  "CellAsString".  However, this seems to be specific to one particular row in a table.  I want to be able to maintain any configuration, and update the model.

So once my design table is complete for all other parameters, how can I link a particular cell (with the drawing number) to the text in the title block?

Thanks in advance.

---
CAD design engineering services -  Catia V4, Catia V5, and CAD Translation.  Catia V5 resources - CATBlog.

RE: how to link design table and "CellAsString" ?

(OP)
Maybe a better way to ask this question - how do I create a formula that will make a text field = the part number (at the top of the tree) of a file that links to the drawing?

There is the "part number" parameter - how do I assign that value to a formula in a drawing?

Thank you.

---
CAD design engineering services -  Catia V4, Catia V5, and CAD Translation.  Catia V5 resources - CATBlog.

RE: how to link design table and "CellAsString" ?

Name your column (or row depending spreadsheet orientation) as PartNumber.

Now the parameter of Catia part and spreadsheet column should be automatically associated when inserting design table to a part. However, it is always possible to do associations manually in Associations tab of design table in Catia. Just select Catia parameter and spreadsheet field and push Associate button.

RE: how to link design table and "CellAsString" ?

(OP)
What about associating the title block text to the spreadsheet file? (part number)

I saw someone once do a spreadsheet driven parts catalog, where they had the part name associated to both the tree and the name in the title block.  Is there a way to generate and save files with the part number from a spreadsheet without opening a new CATPart?

Thanks!

---
CAD design engineering services -  Catia V4, Catia V5, and CAD Translation.  Catia V5 resources - CATBlog.

RE: how to link design table and "CellAsString" ?

Solid7 - If you have the field PartNumber in your document - resolve the catalog.  Tools--Options--Infrastructure--Catalog.  Change the Resolved Family Components to have some sort of directory structure of the parts.(Selflube/Gibs) for example.
When you resolve the catalog (done automatically in catalog editor if you use Add Part Family with Resolution mode set to will be resolved)
Part name will in tree and file will equal PartNumber of spreadsheet.

Regards,
Derek

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