AnsweredAssumed Answered

Can I change the default BOM choice on BOM tab in PDM

Question asked by Brian Stoddard on May 30, 2019
Latest reply on May 30, 2019 by Brian Stoddard

Like • Show 0 Likes0
Comment • 4

I created a new BOM with different columns than the example BOM that someone previously created here. When I go to the Bill Of Material tab when clicking on the assembly file in PDM, the previous BOM choice is the default. Is there a way to set the other BOM created to show by default instead of having to do the drop down and selecting the new BOM every time?

In the attached picture, I want LAN BOM to be the default BOM that displays, not Example BOM. Renaming it to come before Example BOM in PDM Administrator doesn't change anything. I know I could just delete the Example BOM but I don't know if another location is using it.

Using Solidworks 2017 & PDM Professional 2017

Jim Sculley May 30, 2019 2:50 PM

Correct Answer

The .cex file is correct. To import, click File...Open and select the CEX file. It will open a dialog listing everything that was exported. Just drag the BOM you deleted to the 'Bills Of Materials' node in the admin tool. That's it.

See the reply in context

Attachments

PDM BOM CHOICE.jpg55.0 KB

No one else had this question

Outcomes

Jim Sculley May 30, 2019 12:30 PM

Export 'Example BOM'
Delete 'Example BOM'
Import 'Example BOM'

The order of the BOMs is by their ID (ColSetID) in the database table dbo.CustomColumnSet, which is essentially chronological. By deleting and re-importing, the Example BOM will get a new higher ID number which will sort after your new LAN BOM.

Here's the table from my test vault before export-delete-import of the 'Electrical BOM':

and here it is after:

In Windows Explorer, the Electrical BOM used to appear first, but after export-delete-import, it appears last:

Just about any time EPDM doesn't show things in the order you expect it is because the order is driven by an ID column in the database.

Actions

Brian Stoddard @ Jim Sculley on May 30, 2019 1:13 PM

In the Administration tool, I can export but it exports as a .cex Export file. I don't know if this is correct. Also, I don't see any option in the BOM section of Administration to import. I can import the .cex Export file by RMB on the vault but nothing happens by doing that.

Can you help with how to import the BOM? And export if I'm doing that wrong?

Actions

Jim Sculley @ Brian Stoddard on May 30, 2019 2:50 PM

Actions

Brian Stoddard @ Jim Sculley on May 30, 2019 2:59 PM

Thank Jim. Everything is as I need it.

Actions

4 Replies

Jim Sculley May 30, 2019 12:30 PM
Mark Correct
Correct Answer
1. Export 'Example BOM'
2. Delete 'Example BOM'
3. Import 'Example BOM'
The order of the BOMs is by their ID (ColSetID) in the database table dbo.CustomColumnSet, which is essentially chronological. By deleting and re-importing, the Example BOM will get a new higher ID number which will sort after your new LAN BOM.

Here's the table from my test vault before export-delete-import of the 'Electrical BOM':

and here it is after:

In Windows Explorer, the Electrical BOM used to appear first, but after export-delete-import, it appears last:

Just about any time EPDM doesn't show things in the order you expect it is because the order is driven by an ID column in the database.
Like • Show 1 Like1
Actions
- Brian Stoddard @ Jim Sculley on May 30, 2019 1:13 PM
  Mark Correct
  Correct Answer
  In the Administration tool, I can export but it exports as a .cex Export file. I don't know if this is correct. Also, I don't see any option in the BOM section of Administration to import. I can import the .cex Export file by RMB on the vault but nothing happens by doing that.
  
  Can you help with how to import the BOM? And export if I'm doing that wrong?
  Like • Show 0 Likes0
  Actions
  - Jim Sculley @ Brian Stoddard on May 30, 2019 2:50 PM
    Unmark Correct
    Correct Answer
    The .cex file is correct. To import, click File...Open and select the CEX file. It will open a dialog listing everything that was exported. Just drag the BOM you deleted to the 'Bills Of Materials' node in the admin tool. That's it.
    Like • Show 0 Likes0
    Actions
    - Brian Stoddard @ Jim Sculley on May 30, 2019 2:59 PM
      Mark Correct
      Correct Answer
      Thank Jim. Everything is as I need it.
      Like • Show 0 Likes0
      Actions

Can I change the default BOM choice on BOM tab in PDM

Attachments

Outcomes

Related Content

Recommended Content