PDM Pro Droplists Connected to Excel

EmailFacebookLinkedInTwitterShare

Everyone loves SOLIDWORKS PDM’s data cards, they are used in so many ways. One limitation though is their values in drop-lists is rather limited. You can control the lists based on one other variable, but if you need something more advanced you are going to need PigeonHole. It can make your drop-lists significantly more advanced. A lot of people like PigeonHole for its ability to have SOLIDWORKS PDM Pro’s droplists filter each other. As an example if you were selecting a […]

Read More

Multi-language in Enterprise PDM

EmailFacebookLinkedInTwitterShare

In SOLIDWORKS Enterprise PDM, I do not like the idea of mixing languages within the same Enterprise variable. I want to be able to run reports and see BOMs in a chosen language.  Multi-language reports and BOMs are difficult for users. I like adding a suffix to each variable name for each language, i.e. “Finish” is broken in to multiple languages: “Finish-English”, “Finish-French”, etc… Then define different BOM column sets pointing to each corresponding language. Same concept for search cards, […]

Read More

Multi-language in Enterprise PDM

EmailFacebookLinkedInTwitterShare

In SOLIDWORKS Enterprise PDM, I do not like the idea of mixing languages within the same Enterprise variable. I want to be able to run reports and see BOMs in a chosen language.  Multi-language reports and BOMs are difficult for users. I like adding a suffix to each variable name for each language, i.e. “Finish” is broken in to multiple languages: “Finish-English”, “Finish-French”, etc… Then define different BOM column sets pointing to each corresponding language. Same concept for search cards, […]

Read More

The Cost of a Big EPDM Data Card

EmailFacebookLinkedInTwitterShare

I’ve seen little SOLIDWORKS Enterprise PDM data cards, and I’ve seen huge data cards. Tab controls within tab controls, more than 100 buttons, boxes and lists…amazing! How do you decide what you should put on a data card? It is fun watching new EPDM administrators when they first see the value of data cards -like a kid on Christmas morning. They want to create a variable for everything! There are some basic performance issues you’ll run into if you have […]

Read More

The Cost of a Big EPDM Data Card

EmailFacebookLinkedInTwitterShare

I’ve seen little SOLIDWORKS Enterprise PDM data cards, and I’ve seen huge data cards. Tab controls within tab controls, more than 100 buttons, boxes and lists…amazing! How do you decide what you should put on a data card? It is fun watching new EPDM administrators when they first see the value of data cards -like a kid on Christmas morning. They want to create a variable for everything! There are some basic performance issues you’ll run into if you have […]

Read More

Give each EPDM project its own part numbering scheme

EmailFacebookLinkedInTwitterShare

A few weeks ago I was at a customer’s site where they wanted each of their projects files to have their own serial number. i.e. They wanted part numbers for project “A” to be “0010”, “0011”, “0012”, “0013”, etc. and part numbers for project “B” to “10456”, “10457”, “10458”… [Not the file name, just the part number.] Each of their customers had their own part number schema that they were to follow. My first thought was to make a new […]

Read More

Give each EPDM project its own part numbering scheme

EmailFacebookLinkedInTwitterShare

A few weeks ago I was at a customer’s site where they wanted each of their projects files to have their own serial number. i.e. They wanted part numbers for project “A” to be “0010”, “0011”, “0012”, “0013”, etc. and part numbers for project “B” to “10456”, “10457”, “10458”… [Not the file name, just the part number.] Each of their customers had their own part number schema that they were to follow. My first thought was to make a new […]

Read More

IF/Then Logic for your EPDM Data Card

EmailFacebookLinkedInTwitterShare

There are lots of ways to build some pretty cool logic to populate your SOLIDWORKS Enterprise PDM data cards. Automatic transitions with conditions, unique data cards based on location or file types are the most typical methods. They work, but the more complex your logic needs to be, the more difficult it is to set up. Since PigeonHole can connect to SQL’s logic engine, you can use SQL to do some pretty fancy things with “English like” logic. As an […]

Read More

IF/Then Logic for your EPDM Data Card

EmailFacebookLinkedInTwitterShare

There are lots of ways to build some pretty cool logic to populate your SOLIDWORKS Enterprise PDM data cards. Automatic transitions with conditions, unique data cards based on location or file types are the most typical methods. They work, but the more complex your logic needs to be, the more difficult it is to set up. Since PigeonHole can connect to SQL’s logic engine, you can use SQL to do some pretty fancy things with “English like” logic. As an […]

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