I have a a need to do exactly as the title states. We would like the state of the file to show up on the drawing BOM. However I am unsure how to push that variable from EPDM into SW. Is this possible?
The best way to get any file property to show up in the bill of materials is by adding a custom property to every file. There probably already is a custom property present that holds the file status. Otherwise you can look at the manual on how to add one.
You can then add a column to an existing BOM, left click the column header letter and select Column Property (almost on the right side of all the options). Select Custom Property and then the property of your choice. Save the BOM as the new template and you're good to go.
Thanks Peter, I know how to add custom properties, and I know how to add columns to the Bill and set them to those properties. What I am missing is the "code" of the property that contains the state. I have not been able to find that anywhere.
I belive the only way to add the current state to a variable is to add via a file transition using the value %deststatus%.
You would have to include this on every transition that your file potentially could take so to catch the state that it is going to. Can't think of another way of the top of my head.
Thanks Steven, I actually already have that in place.
I just don't know how to get that to push into the SW drawing...........moste specifically a column on the BOM
Hi Shawn, as Steven Richmond states above, use a set variable action in each transition to get the name of the State written onto a variable on your Datacard. Then make sure that variable is mapped to a custom property in SolidWorks.
That way, when the part/assembly goes through a transition, the state name will appear in the custom properties of the drawing, which your Bill of Materials can pull from.
Hope this helps.
While you are getting valid instruction on how to accomplish this, I am curious as to what your objective is by adding the "State" column to the BOM on the drawing. I can foresee a situation arising where the state of some component files change while the assembly does not, thus making the "State" column information inaccurate. Just some food for thought.
Well I am doing everything everyone is instructing, but its not pushing thru. So I am obviously doing something wrongor missing a link somehow. I will have to continue to trouble shoot. It looks good in EPDM.
In regards to the why, it is more of a helpful FYI for engineers and purchasing. What we have occurring is that our engineers are not remembering to fully release all parts. They are in and out of jobs, putting things on hold, releasing etc.. Then when planning goes into EPDM and opens files (they can not see things on hold or not released). This then causes issues. So the thought was that when the engineers print a drawing and take it out to the shop, this is a nice quick visual if everything is released.
It used to be that people were just always checkmarking to change state on EVERY file in an assy, regardless of needing it or not. That was of course causing bigger issues. So now that habit is somewhat broken. Bottom line, they dont like scrolling thru the SW dialouge box and trying to understand what part numbers need transitioned and what does not. A quick look at the assy drawing they are releasing gives them the information.
I agree with you on the potential issue with sub-assy's. We are just looking at this as something that would "help" alleviate some issues. Not necessarily fix them / be a magic bullet. Unfortunaly we crank out so many parts, drawings and assy's that the method of "you must do this", doesnt work. Thus looking for some kind of visual aid. There is the contains tab in EPDM but we use the "drawing bill" which will not show the state................until I get it on the drawing.
I see what you are wanting to accomplish however I wouldn't recommend using the state in the BOM itself. With the transient nature of the files in PDM always moving through states, that BOM won't be accurate for very long which can create a document control nightmare keeping it synced. You need a tool like ATLAS mobile for PDM that reports the states of your files in the workflow and all your engineers can get the app.
Check out ATLAS mobile here ATLAS
Hope this helps,
Believe in the Q!
Just a point for you using the contains tab. You can add a column in the BoM tab for the current state.
So although not on the drawing you in theory have a table which matches the BoM on the drawing but with the additional column for the current state.
Don't forget to add the variable to your file card.
Retrieving data ...