In this Oracle docum, scroll down to section 5.7.3.  But, I have not personally tried it.

https://docs.oracle.com/cd/E50306_29/otn/pdf/integration/html_agaap/output/chapter_5.htm

I agree with Raj that the user refresh can happen automatically with LDAP.  I also set up an event that runs once a day and looks for any new users created in Agile, makes them Active and also adds them to a User Group.  I can send you that Groovy script if you wish.  Email me at mathison at hotmail dot com.

Nevermind.  I found an example in the SDK documentation.

Thank you Raj and Kevin.  I added more roles to the Event Handler and then it worked.  And I also needed to change  IAttribute  to  String .  I had found that code somewhere, maybe in one of these forums.  When a user gets created from LDAP, it is automatically giving it the Roles ‘Creator can read and discover object he or she created’ and ‘My User Profile’.  Now, I also want to update the User Category to ‘Concurrent’ and also add the user to a User Group.

For our Agile system, internally, the dates on the database records are always stored in GMT time zone.  So, if you are in Agile, in US Eastern time, and you save a date and time at 11pm on Sep 30, the value in the database record will say 4am (or 5am) on Oct 1.  GMT is 4 or 5 hours ahead of EST.   Your personal user settings time zone  decide how the date is displayed when you look at it in Agile.

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:  https://myagileplm.com/questions/groovy-script-to-update-an-item/

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’.

PART,PART_TYPE

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

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.

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.

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.