1051
Points
Questions
25
Answers
144
-
There’s a couple of “Agile Angels” on this site that actually can help with consulting work. As I mentioned, the same Steve Jones that replied to your comment is one. I believe I remember seeing Patrick Lawrence on this site can as well. Sandra Campbell is a local in the Washington State area that a lot of us medical/aerospace companies in the Pacific NW call to. I’m sure there are others as well.
- 1582 views
- 5 answers
- 0 votes
-
I was referring to a Web Service Extensions. Not sure if it’s useful or possible in your case, but they have their own functionality and here it would extract Agile data and present it to the user a bit better format than a database inquiry would. I haven’t done my own WSX either yet, so I’m not as familiar with them either but the Agile 9.3.x SDK Developer guide has a whole chapter about them.
- 1668 views
- 6 answers
- 0 votes
-
As Steve mentioned, I advise updating to Agile to 9.3.5 or 9.3.6, which both support Oracle database version 12. See the Agile user guides, Agile 9.3.6 Database Upgrade Guide and Installation guides for all of the steps involved. For more help, such as if you don’t have the time to upgrade yourself, seek out contractor support from companies such as Xavor, GoEngineer, or even from individuals like Steve Jones, The PLM Doctor, himself (as one of my previous companies did).
- 1582 views
- 5 answers
- 0 votes
-
Good call adding a break and continue statement – that was one of the options I thought of yesterday (because you’re telling Agile to stop iterating through the rest of the BOM once it’s found a chemical item).
Another idea that I’ve done is to add a boolean flag to my script. For example, up at the very top of the try block add a “boolean b = false” line just to define ‘b’ (or call the variable “boolean is_there_a_chemical_item = false” if that’s easier). Later in your script, if the BOM is a chemical item, set b to true and break from the loop. After the script is done iterating through the BOM, if b is true, then have Agile separately get the sites table, iterate through it, and update Text01 to the item number. Else if after iterating though the BOM, boolean ‘b’ is still false, have Agile get the sites table, iterate through it, and update Text01 to the ‘N/A’ value. Using this logic, Agile won’t have the infinite loop.- 2724 views
- 6 answers
- 0 votes
-
Take a look at your overall syntax and logic of this script. There’s some structural issues here.
As you have it, when triggered, Agile will get the item dataobject that you’re working on (iProd, in your script), then get the BOM for the item and start scanning through it. For each item on the BOM, Agile will update the Sites table Text01 to either the BOM item or N/A, depending on if it’s a chemical item or not. I recommend trying this asynchronously and seeing what you get because just because it’s Post doesn’t mean Agile has completely finished with the event action when starting your script.
How many Sites do you normally have on the Sites tab? I ask because Agile should be, as your script is written, updating each Site’s Text01 for every item on the BOM. If you’ve got 100 items on a BOM then Agile will log entries for the 100 times it’s updating the Sites tab with N/A or the BOM item number. I take it that’s not your goal, so try playing around with your script a bit more.- 2724 views
- 6 answers
- 0 votes
-
You’re referring to three total User Groups, correct (Senior CA group, CA group, and the Common CA Group)? I’ve mapped it out and it seems Agile is working the way we expect. User1 is not part of the Change Analyst User Group, right? Therefore, this user is not the change analyst on your ECR, hence wouldn’t see the “In Review” line.
- 1100 views
- 2 answers
- 0 votes
-
Yes, if you can’t get the criteria to work you’ll have to use a Groovy Script or Java PX for this. Note that you’ve described two different Events (triggers) here though, sending notification on Part creation and upon ECO submission.
I’m surprised that a Criteria isn’t working for you though – I figured you could set something up for that using the [Affected Items.Item Type].- 1460 views
- 1 answers
- 0 votes
-
That’s done using Character Sets on the Agile Admin tab.
Step 1: Define a specific character set with what you’ve specified in your question.
Step 2: Define the specific field (such as your Page 2 field or Item Description field) to use only that set of Characters.
One last note though, as I haven’t done this before: test this in your test environment to see what happens to all of your item descriptions with the now-invalid characters. I’m not sure.
- 1690 views
- 3 answers
- 0 votes
-
Click on the item itself, make sure you’re at your intended Rev (either pending ECO rev or currently released rev), then go to the Actions menu up top and then Export. If you need ECO redlines, see the Change Package Report.
This answer accepted by Anubismom. on May 3, 2024 Earned 15 points.
- 2954 views
- 2 answers
- 0 votes
-
- 2942 views
- 4 answers
- 0 votes