mrmathison's Profile
Agile Talent



  • Agile Talent Asked on May 1, 2019 in Agile PLM (v9).

    I’m not sure if this will help your privilege issue, but I had a question about Groovy, and it is working.  This was my post:

    This answer accepted by stevend17. on May 1, 2019 Earned 15 points.

    • 2 answers
    • 0 votes
  • I got it to work with the Import tool by changing the preferences.  

    Your csv file should look like this if you open it with Notepad.  In this example, all 3 parts currently have a subclass of ‘Standard Part’.  I am changing 2 of them to ‘Product ID’ and 1 to ‘Product SKU’.


    5601013-012,Product ID

    5601013-A,Product ID

    5601013-A-E,Product SKU


    Using the Import tool, click the Preferences button

    Business Rule

    Smart Rules Warning Violation Behavior: Reject Objects

    Reference Designator Qty Mismatch Behavior: Reject

    Behavior upon non-existing objects: Reject

    Change Mode: Authoring

    Default Types

    Default Item class: Parts

    Default Part type: Product SKU    — this may not be necessary to change, but it worked for me


    Hit Save to save the preferences.   Hit Next.   Choose Item only.   Hit Next.


    Data Mapping:     ( o )  Define attribute mapping in next step

    Data Transformation:    ( o )  No transformations are necessary

    Redline Options:    ( o )  Updates do not require redlining


    Hit Next.

    For the mapping

    Part       –>  Parts > Title Block > Number

    Part_Type  –>  Parts > Title Block > Part Type


    Hit Next and then Import

    • 6 answers
    • 0 votes
  • Sorry folks.  But the above answer is INCORRECT.  My test was successful because another user logged in to Agile and converted my 3 test parts BEFORE I ran my test import file.  So, the subclass matched what they had changed it to earlier in the day.  My next test FAILED.   So, I guess we will need to convert each manually in the web client.

    • 6 answers
    • 0 votes
  • Keep in mind that once I hit that Import button, every attribute on Page Three will be wiped out and deleted for each of those parts being updated.  So, I am going to extract the PAGE_THREE table for these parts first and save to a file before I do the Import.

    • 6 answers
    • 0 votes
  • Thanks for the suggestions, but Agile does something behind the scenes that you cannot see in the workflow or the criteria.  Let’s assume there are 3 approvers.  The first guy approves the MCO at 3pm.  The second guy approves at 4pm.  And the last guy approves at 5pm.  At 5pm, Agile notices all the approvals are done and sends an email to the Analyst/Component Engineer who is defined on the Cover Page of the MCO.  Only one user can be defined there.  This logic cannot be seen or edited in the workflow.  It is part of Agile’s functionality.  The Notification defined in Agile is a ‘Default Notification’.  It is part of the Agile installation.  I can edit the message body, but not the email recipients.  How do I add another recipient?   I understand how I can edit the Notify upon Entry or Exit in the workflow/criterias, but in this scenario we are not entering or exiting a workflow status.

    • 4 answers
    • 0 votes
  • Agile Talent Asked on January 11, 2019 in Agile PLM (v9).

    Try this db query to display the current BOM.

    • 7 answers
    • 0 votes
  • Agile Talent Asked on January 11, 2019 in Agile PLM (v9).

    I am having trouble pasting code or attaching text file with code.  You can email me at mathison at hotmail dot com.

    • 7 answers
    • 0 votes
  • I said I resolved this issue.  But not entirely.  When I press the LDAP sync button on the Users screen from the Agile Java client, it did pull in and create users from all 3 groups.  However, when I try to log in to the web client, I think the authentication goes through Weblogic.  It tells me invalid user or password.  So, now I am wondering what is wrong.  Could it be the SecurityRealm LDAP settings in Weblogic?   Here are the 3 AD User Groups that I want.  Notice they are all in different sub-levels, under the OU=Groups level.  Any ideas out there on how to configure this?

    distinguishedName: CN=All Employees,OU=Test,OU=Groups,DC=corp,DC=mydomain,DC=com
    distinguishedName: CN=Contractors,OU=Managed-Scripted,OU=Distribution Groups,OU=Groups,DC=corp,DC=mydomain,DC=com
    distinguishedName: CN=Agile Vendor Users,OU=Security,OU=Groups,DC=corp,DC=mydomain,DC=com

    • 3 answers
    • 0 votes
  • Okay, here is an update.  I seem to have got it working now.  I went into Weblogic and included that “or” filter in both Group filters.  Now it accepts my LDAP credentials when I login to Agile.  Here are the settings in Weblogic  (sensitive company info was replaced with “mydomain”).

    WebLogic > Security Realm > “nameofrealm” > Providers > “nameofprovider” > Provider Specific


    Host:  (note: do not put ldap:// in front of host)
    Port: 389
    Credential:  whatever the pwd is
    Confirm Credential:  whatever the pwd is
    [ ] SSLEnabled


    User Base DN: DC=corp,DC=mydomain,DC=com
    All Users Filter: (objectclass=user)
    User From Name Filter:   
    User Search Scope:  subtree
    User Name Attribute: sAMAccountName
    User Object Class:  user
    [ ] Use Retrieved User Name as Pricipal


    Group Base DN: OU=Groups,DC=corp,DC=mydomain,DC=com
    All Groups Filter: (|(CN=All Employees)(CN=Agile Vendor Users)(CN=Contractors))
    Group From Name Filter: (|(CN=All Employees)(CN=Agile Vendor Users)(CN=Contractors))
    Group Search Scope: subtree
    Group Membership Searching: unlimited
    Max Group Membership Search Level: 0
    [ ] Ignore Duplicate Membership   (not checked)
    [ ] Use Token Groups For Group Membership Lookup

    Static Groups

    Static Group Name Attribute:  cn
    Static Group Object Class: group
    Static Member DN Attribute: member
    Static Group DNs from Member DN Filter: (&(member=%M)(objectclass=group))

    Dynamic Groups

    < all fields left blank>


    Connection Pool Size:  6
    Connect Timeout: 0
    Connection Retry Limit: 1
    Parallel Connect Delay: 0
    Results Time Limit: 0
    [ ] Keep Alive Enabled
    [x] Follow Referrals
    [ ] Bind Anonymously On Referrals
    [ ] Propagate Cause For Login Exception
    [x] Cached Enabled
    Cache Size: 32
    Cache TTL: 60
    GUID Attribute: objectid

    • 3 answers
    • 0 votes
  • I was able to resolve this and got it to work.  I made some changes to the LDAP search criteria, both in Agile and in WebLogic settings.

    Group Path:        OU=Groups,DC=corp,DC=mycompany,DC=com
    Group Scope:     SUB_TREE
    Group Filter:       (|(CN=All Employees)(CN=Agile Vendor Users)(CN=Contractors))

    The “|” pipe symbol in the Group Filter is an “or”.  CN means Common Name.

    • 3 answers
    • 0 votes