Weldments and Bill of Materials

EmailFacebookLinkedInTwitterShare

There are many different ways to create structural frames.  One method might be creating it as an assembly with many individual parts.  Another method, which is my preferred  way, would be as a single multibody part…as a Weldment. The Weldment way allows for easy design changes, automatic structural member trimming/extensions, and creation of cut lengths.  This however is typically just a portion of the overall design.  There might be many more pieces that go on the frame.  This is when […]

Read More

Hiding buttons so PigeonHole runs once per data card

EmailFacebookLinkedInTwitterShare

We have a few customers who are using PigeonHole as middleware. Users click a button on the SOLIDWORKS Enterprise PDM data card, PigeonHole connects to an external database, reads the information, and populates several fields on the data card. We have a former SyteLine customer who was updating “Description”, “Material”, and  “Treatment” on his  data card from this older system, but wanted his users to only be able to update the data card once. i.e. If later, someone changed the data […]

Read More

Update your EPDM Data Cards with ODBC

EmailFacebookLinkedInTwitterShare

New, in in the advanced features section of PigeonHole 1.6, you have the ability to connect your SOLIDWORKS Enterprise PDM data cards to your ODBC compatible databases. Now you have three choices to connect to databases: Connect to a SQL server given: Server, Database, User name and Password (The user name and password are not required if the user has a trusted connection to the database) Connect to an ODBC database through an ODBC DSN (data source name) With this choice; […]

Read More

Add information from external databases to EPDM data cards

EmailFacebookLinkedInTwitterShare

It is always fun to see how people use applications in a different way than originally designed. PigeonHole was originally written to help people populate complicated data cards with drop lists from a grid type decision tree or from a SQL query. However, if PigeonHole is populating the drop lists with a SQL query AND there is only one result, PigeonHole doesn’t bother presenting the user with any choices, it simply populates the SOLIDWORKS Enterprise PDM data card with the […]

Read More

Smarter EPDM Drop Lists Using SQL

EmailFacebookLinkedInTwitterShare

Out of the box SOLIDWORKS Enterprise PDM gives you the ability to populate your drop lists based on SQL query results. I use this functionality all the time to give my users a list of qualified suppliers from a purchasing database, lists of users in a specified group, choices of product type, etc. The limitation is that these queries are all based off of constant values. These queries are run by the EPDM server on a predefined interval, and the results are […]

Read More

Smarter Droplists with SOLIDWORKS Enterprise PDM

EmailFacebookLinkedInTwitterShare

Today I was doing some consulting work for a SOLIDWORKS Enterprise PDM customer of another VAR. Look at this screen shot of the number of lists they were using for their data cards. Each of their customers have their own list of cities, countries, contacts…it’s very nice because their data cards are very accurate -great for searching! Lots of lists!…this is just what I was able to fit on the screen, they have at least twice this many. Takes effort […]

Read More

Display a graphical history on your data card

EmailFacebookLinkedInTwitterShare

I thought the idea of putting an image of the workflow on a SOLIDWORKS Enterprise PDM data card was rather clever. Yesterday, I received an email from a customer in Dayton who has taken the concept one step further: They put data card controls on top of the image. As files go through transitions, the transition puts the values into the controls. Users can now quickly see the history of the file in a nice graphical form. You don’t have control over the order […]

Read More

Include the file’s workflow in its data card

EmailFacebookLinkedInTwitterShare

Recently I saw a SOLIDWORKS Enterprise PDM data card similar to this one created by one of our customers in Indiana: At the bottom of their data cards, they include a [static] picture of the file’s workflow. I thought it was a rather clever idea.  

Read More

Put the version number on your EPDM datacard

EmailFacebookLinkedInTwitterShare

Editor’s Note: As of EPDM 2012 SP4, this method works great when checking in a group of files individually. However there is an issue with Dispatch that will make this method not work when checking in files as references. However this method does work if you change the conditions from “just before checkin” to “just after checkout”. This will update the version as soon as you check it out, making the setting the version variable to what the version is going […]

Read More

Group Members for your Datacard

EmailFacebookLinkedInTwitterShare

You’ve designed the perfect folder datacard for your SOLIDWORKS Enterprise PDM setup. It is a great little folder card listing project due date, description and even have a nice little droplist for your users to pick the proper project manager. But wait! You’ve noticed there is no way to get a list of just your project managers! What’s a girl to do?! The solution is easy with Engineering Data Specialist Man! Create a new list, make it a SQL query and […]

Read More