I meant using Excel solely to maintain a list of scripts, including summary, priority, action, etc., not to store the actual script code in the spreadsheet. The main purpose is to get a high-level understanding before refactoring any individual script.
The key point is I disagree with the approach of moving logic into Condition Expressions using evaluateCondition
. It only makes sense when the condition involves a complex SQL query that's too difficult to interpret within an automation script, or when the query is specifically designed to leverage the database structure and indexes for better performance.
Original Message:
Sent: 05-16-2025 09:30
From: mark robbins
Subject: Refactoring Hundreds of Scripts
I would be wary about using Excel to store the automation scripts.
I have seen cases where Excel silently truncated the script text because it breached the number of characters allowed in a cell.
Consider using a BIRT report to extract the text.
In our case we use a BIRT report to export the script so we can control the format & how it is used.
Then we have an automated process that reads the export and highlights problems etc
------------------------------
mark robbins
Cohesive
IBM Champion 2017-2024 Inclusive
See my blog on Maximo support related topics here:
https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
Original Message:
Sent: 05-15-2025 17:30
From: Viet Tran
Subject: Refactoring Hundreds of Scripts
It's not a direct answer you are asking for, but I suggest you not to do that.
Moving a hard-coded site ID from an IF statement into an Expression Condition is still hard-coding. It just shifts the logic to a different place. It also adds another layer of complexity. Now, instead of reading the logic directly in the script, you have to jump into another application to understand what the condition does, then come back to the script to see how it fits in.
I refactoring automation script all the time. Often, it starts with refactoring one or two scripts when adding a new feature. But I've also done full system-wide refactoring a few times.
My approach usually starts with listing all automation scripts in a spreadsheet. I do a quick high-level review of each to understand what it does and whether it should be removed, refactored, or replaced. Then I prioritize the actions and tackle them one by one.
Once you start, it's often easier than you expect.
------------------------------
Viet Tran
Relia App Development & Consulting
https://relia.app
Original Message:
Sent: 05-14-2025 15:51
From: Victor G
Subject: Refactoring Hundreds of Scripts
Hello everyone!
Our company's been going through some big changes lately, and one of them is removing hardcoded site values from our automation scripts (250 of them). We've started using a conditional expression to check if the site is in a specific list, something like mbo.evaluateCondition("ourcondition")
, and then use that in if
statements and dynamic queries.
The tough part now is testing each script to make sure everything still works the same as before. We're thinking of reading through each script, setting up a scenario, and checking if the outcome matches what it should do-which honestly sounds like a pretty time-consuming process.
I tried using the "Test Script" feature in the Automation Scripts app, but it's missing some key stuff like appname
or interactive
.
Anyone dealt with something similar? How would you go about testing these scripts efficiently?
#Customizations
------------------------------
Victor G
acw
------------------------------