how to link design table and "CellAsString" ?

[solid7]

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.

 

[solid7]

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.

 

[eklunja]

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.

 

[solid7]

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.

 

[DBezaire]

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