AutoCAD Electrical

[#1]

Is there a way to associate additional part numbers to the catalog numbers used in AutoCAD electrical. We have our own stock numbers for a lot of components and it would be really nice if I could add them to the BOM. Sorry if this has been addressed already, but I'm not sure what to search for. Thanks.

[#2]

Among all of the fields available for each component enty in the parts database catalog are three that are labeled USER1, USER2, and USER3. You can put your stock number in one of those. When you run the BOM remport, change the column heading from USER1 to STOCK NUMBER.

[#3]

Thanks. Is Access required for this since it's an mdb database?

[#4]

MS Access is only required if you want to edit the database directly. Adding your own part number to one of the user fields can be done in the Lookup dialog from within ACADE, by selecting the part and clicking Edit. If you have Access 2000 or later, you can go into the database, usually default_cat.mdb unless you have renamed it, and change the column names of User1, User2, or User3 to Internal P/N, Isle, Bin, or whatever you wish.

[#5]

I changed the user field to our internal part number and accidentally moved it location . Do you think it will mess everything?

I am stuck here - When I insert a component and use the  secondary catalog with the user field which I changed to include our part number, the user field column I changed doesn't update or fill the attribute properties  in the enhanced attribute. Also, when I select my catalog info from the secondary catalog, the ok is greyed out. 

This is really holding me up . Please let me know what I am doing wrong?

Thanks,,

[#6]

ACE reserved the first 16 fields for their catalog table structure.

3 user fields are available which you can rename the field column name if necessary but

do not edit the first 16 fields structure in term of order or data type format as these are reserved and can caused error in ACE.

But you can add any additional fields after these 16 fields.

For your secondary catalog, I suspect that there are no any records in the particular family table, so the button is greyed.

Thanks.

[#7]

I rename the field and move it to the left.

The secondary catalog has a family table for the component but not the default. Or I need to add it to the default catalog too?

[#8]

Rename the user column name is fine but do not changed the order of the column for the first 16fields.

For the family code if it is a self user defined or it is only used in your secondary catalog, I think you dont need to add them in the default catalog.  

[#9]

Can someone advise why the DR(Drives) database is starting with a USER2 field instead of a USER1 . I usually use the USER1 field for my internal part but with this, it makes it difficult.

Also, when I rename the field to USER1 it still doesn't work. What's the best approach to fix this please? Thx

[#10]

Hi Justin,

In Drives "Options" actually uses the User1 field.

You could move the "Options" Column to the user 2 location (move it over to the right).

Then rename the User2 column to your part number.

Before I get a comment that it might bust the connection to the column... yes it probably will, but there are only a few of the drives that actually use that options field so it shouldn't really matter.

(you should still be able to access it in the BOM using User2 after moving it)

I hope this helps,

James Alger