Over the past few months I have received numerous emails from folks using the original PDMWE Number Generator.  It is such a simple little app that I was pleasantly surprised at all of the nice feedback people gave me regarding it.  To show my appreciation, I have modified the Number Generator to allow it to work with multiple serial number sequences ”on the fly.” 

 You have always had the ability to set up muliple serial number generators in PDMWorks Enterprise but now the user can decide at File/Folder creation time which serial number to use.  An anticipated use case with this improved version of the tools is for users who have multiple categories of parts with numbers being assigned by category.  Note:  Even though the functionality has been expanded, the tool is still very easy to install and configure. 

So how does it work?

The Number Generator is a PDMWorks Enterprise add-in that runs whenever a user presses a command button (from a data card) that is configured to “call” it.  The Number Generator downloads the latest copy of the ListItems.xml file from your vault’s Options folder and checks it for List Items.  Each <ListItem> element in the XML file has a <Name> element and corresponding <Value> element.  The <Name> elements represent what the users sees in the Number Generator’s drop-down list and the <Value> elements represent the Serial Number sequence that is “called” whenever a user selects that item from the drop-down list.  There is no reasonable limit to the number of serial number sequences that can be supported by the Number Generator.  Just add a new <ListItem> node to the ListItems.xml file, being careful to type the exact name of the Serial Number sequence in the <Value> node.

 Don’t be afraid of the xml.  It is really simple.  Here is the xml file that was used to develop and test the Number Generator.  Notice that the text contained in the <Value> nodes of the ListItems are an exact match for the names of the Serial Number sequences in the vault.

Alright…  Ready to get started?  Good.  Here are the high-level installation and configuration steps:

1. Download and unzip the file containing the tool.
2. Create any desired serial number sequences using the PDMWorks Enterprise Administration Tool. 
3. Add the included add-in to the PDMWorks Enterprise Add-ins using the PDMWorks Enterprise Administration Tool. 
4. Using Notepad or (better) an XML editor such as XML Notepad, edit the ListItems.xml file that is included in the Options folder to include your desired serial number sequences.
5. Copy the included Options folder to the root of your PDMWorks Enterprise vault.
6. Checkin the ListItems.xml file, if not done automatically.
7. Give all users Read Only permissions to the Options folder.
8. Add a command button to any data card you wish to run the Number Generator from and configure the command button to “call” the Number Generator.
9. Test it out and if it works well for you, then add some nice feedback to this post.  Otherwise, curse me under your breath and keep it to yourself.

Here are the detailed steps:

1. Download the file containing the tool from here.  Unzip it once it is downloaded.  It should contain two dll files (Interop.EdmLib.dll and NumberGeneratorForPDMWE2008.dll) and an Options folder which in turn contains a single xml file (ListItems.xml).
2. Create any desired serial number sequences using the PDMWorks Enterprise Administration Tool.  Keep track of the names of the Serial Number sequences as you will need this information for step four.
3. Add the included add-in to the PDMWorks Enterprise Add-ins using the PDMWorks Enterprise Administration Tool.  Use the New button to add the Add-in’s dll files to the vault.  Make sure you select BOTH dll files to add.  Don’t worry about the warning message that PDMWorks Enterprise gives you after you add the dlls.  The warning message is just letting you know that you have to reboot when updating the same Add-in to a later version.  I changed the name of this add-in from the previous version so that won’t be an issue here.
4. Using Notepad or (better) an XML editor such as XML Notepad, edit the ListItems.xml file that is included in the Options folder to include your desired serial number sequences.  Notepad can be used but I am partial to XML Notepad as seen below.  XML Notepad is a totally free utility from Microsoft and can be downloaded from here.  If using Notepad, be very careful to preserve the format of the XML file.  Each <ListItem> element tag must be closed by a corresponding </ListItem> element tag.  The same goes true for the <Name> and <Value> element tags. 
5. Copy the included Options folder to the root of your PDMWorks Enterprise vault.  I want to emphasize the “to the ROOT of your vault” part of that.  If your vault’s local view is found at “C:\PDMWE\MyVault” then your Options folder should be found at “C:\PDMWE\MyVault\Options.”
6. Checkin the ListItems.xml file, if not done automatically.
7. Give all users Read Only permissions to the Options folder.
8. Add a command button to any data card you wish to run the Number Generator from and configure the command button to “call” the Number Generator.
9. Test it out and if it works well for you, then add some nice feedback to this post.  Otherwise, curse me under your breath and keep it to yourself.

You can hit the “Copy” button to copy the auto-generated number to the clipboard.  You can then paste it anywhere you want (e.g. filename, data card variable, etc…).

 If you or someone you know use(s) this thing and find it helpful, then give us a holler in the comments section below.  Thanks.

If you enjoyed this post, make sure you subscribe to my RSS feed!