Tuesday, 02 April 2013 19:24

Create a Custom AutoNumber Source

Written by

Sometimes the AutoNumber facility in Agile PLM does not offer the level of sophistication needed to produce a truly intelligent part number. Fortunately, Agile provides an extension point to create custom AutoNumber sources.  This blog will outline the steps needed to create the code for the custom source and get it installed in Agile so it is ready to use.

Wednesday, 30 January 2013 17:35

Trying to find the workflow status in the database?

Written by

Hint - Workflow status' aren't list values...

Our help desk recently fielded a support ticket from a company looking for assistance with their extraction of PSR content.  Specifically, they could not identify how to extract the PSR number, the workflow name and workflow state.  One can be very quick to jump to the conclusion that workflow states are list items and should reside in the listentry table, but that is not the case.

Friday, 11 January 2013 15:12

Does Agile PLM need Digital Rights Management?

Written by

Protect your Agile PLM attachmentsIs there value in adding Digital Rights Management capability to Agile attachments when viewed by third parties?

Today I got in a conversation with some people about third party access to Agile and it seems like there is a great deal of trust that is extended to the employees of that third party. While the relationship with the vendor may be outstanding, there is no guarantee that the resource with access is as honest or concerned about the protection your content.

This left me wondering if there be value in adding DRM capability to content, delivered as attachments, to users with specific roles/privs? The immediate vision is to allow specific users to discover attachments but go through an extension to receive them.  The extension would package the content and deliver it as a piece of controlled content. Obviously there would be a lot of details to work out but I always see the value in protecting a company's intellectual property.

If you also see value in this, please contact me as I would like to explore the concept further and see if there is justification to pursue development.

Friday, 04 January 2013 16:02

Is File Load Taking Too Long?

Written by

Consider using a custom vault

If your company is in the midst of a data migration to Agile PLM and has been around for a while, chances are you have quite a few attachments to migrate over. While the mechanics of file load are not difficult, it can be a time consuming process. This blog aims to speed up your import by walking through the use of a custom file vault.

Wednesday, 28 November 2012 00:00

Fix Agile PLM Attachment File Sizes

Written by

Using the Fix Vault tool

Agile PLM's FixVault Tool

Have you recently gone through an upgrade or noticed that Agile PLM is reporting incorrect file sizes on attachments?  Personally I have only noticed this on upgrades but I imaging there are other scenarios that can cause the situation.  Regardless, don't fret, its an easy fix.

My test Agile PLM system is 9.3.1.2 and is on a windows platform, thus the instructions will show windows paths.  Here is how to solve the problem:

Unlock your Agile PLM system

Ever import a dump file and have your Agile PLM system refuse to start?  Even if it imports and starts up, have you ever been unable to log in?  Do not get discouraged, the fix is an easy one!

While you could do it from SQL Plus, I recommend downloading and installing SQL Developer from Oracle because it’s free and a lot easier to read the output.

Now for the fix…

Page 3 of 4