Mapping catalog information for cables into visible attributes on dwg´s

[CAD-ICE]

Hi there,

I´m trying to find out how to map catalog information for cables into attributes on dwg´s in my project. I have attached an image that shows what I´m trying to establish. Any hints are deeply appreciated.

Regards, Gary

[Anonymous]

What I would do is use the TEXTVALUE field (under the USERx fields), and would want the RATING1 attribute to be filled with the info you want. To do this, type excatly this in the TEXTVALUE field to achive your specific example result: RATING=4X4 MM² CU

[Anonymous]

for more info see help topic on "TEXTVALUES" - rating and miscellaneous attribute value assignment

[CAD-ICE]

Dear Evan,

I tried that already i.e.. Added a RATING1 attribute to the symbol and inserted as you proposed the following text into the textvalue field "RATING=4X4.0 MM² CU" Instead of inserting the textvalue as expected, the software looks up the catalog conductor list and inserts that into the "Wire/Color Id" field in the insert / edit cable marker (parent wire) dialog box (see attached image) ?? Any comments ??

Regards, Gary

[testsubject]

In the database, each record has a TEXTVALUE field. This is where you would place the RATING1=4X4.0 MM² CU value. Then, when you select that catalog number, the Rating value will automatically be filled in in the Insert/Edit Component dialog box.

Hope that clears it up...

[CAD-ICE]

Dear Bob,

did you read my last post and look at the attached image. Seems like the textvalue field has different behaviour when there are cable markers involved? As can be seen on the image, the insert/edit dialog box does not show up with the Rating field but the Wire Color/ID field which I think is in some way connected to the conductor list for this cable.

Thanks for your comments and help.

Regards, Gary

[vladop · Accepted solution]

As you noticed  RATING1 is used for Wire Color/ID.

Add RATING2 attribute to cable marker block and use RATING2=4X4.0 MM² CU in TEXTVALUE.

[testsubject]

Beat me by 7 minutes. I wanted to test it first... hehe

[CAD-ICE]

Hi Bob,

just one other issue...in order to complete this task I need to reload the data from the component database. Is there a project wide utility to refresh data assigned to components such that the new data are retracted from the default_cat_mdb database?

Thank´s again, Gary

[testsubject]

I am not sure about that one. Just filling in the value using a script will not (afaik) initiate an update from the database. Sorry I could be of more help.

[vladop]

There is a new command in ACE 2012:

Ribbon:  Project tab -> Other Tools panel -> Component Update From Catalog

OR

Command entry: AEUPDFROMCAT.

If you have older version try lisp in attachment.

You can find this lisp in Electrical Help -> API Help -> Samples Index -> wd_get_pinlist 

 

[CAD-ICE]

Hello Vladop and many thanks for your reply.

I´m working with ACADE2012 so I could use the component update from catalog. Seems though that some items are missed by this tool for some reason....but 90% of items are updated. The ones that are missed I simply edit the relevant component and reload the component data with the look upp and the component is updated!

I have no explanation for this behaviour but as mentioned above, only few components are missed.

Thanks again for your valuable input.

Regards, Gary

[vladop]

To update drawings you can use Export/Import spreadsheet data.

On this page 

http://wikihelp.autodesk.com/AutoCAD_Electrical/enu/2012/Help/0818-Reports818/0826-Export_I826

under

Update drawings from spreadsheet data -> Show me - Drawing Settings example

there is a video that explains how to use it.

Regards,

Vlado