THE BPD Blog

From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Jan 29, 2020

The ease and power of automation scripts in Maximo

Many of us in the Maximo space are appreciative of the power of automation scripts, however, might not be entirely familiar with various scripting languages like Javascript, Python and their API.

How is Python different to Java and Script?

Python created by Guido Van Rossum, was first released in 1991 and is currently powering big players like Netflix and Instagram. Guido compares Python to languages like Java or Swift but points out a critical difference between Python and the latter two. He contends that Java and Script are great resources for software developers and programming, but Python should be utilised by those who code to handle data.

~ Netflix and Instagram are both powered by Python ~

Jython – a product of Java and Python

Jython – a value-added version of Python is a language that runs on the JVM. Jython’s pivotal strengths include scripting as well as exploring and debugging code. Jython’s interpreted nature allows users to work simultaneously with Java without a compiler and manipulating live objects on the fly. Essentially, Jython has birthed from merging Java and Python together.

~ Jython is a product of Java and Python ~

One of the key advantages of using automation script is that it allows users to utilise the power of multiple languages. A simple example would be to check if an attribute in Maximo has been set. Sometimes when we call getString(“DESCRIPTION”) we receive a NULL value back and at other times we receive a blank string. In Java we must write both checks like getString(“DESCRIPTION”)!=null and getString(“DESCRIPTION”)!=””. In Jython, this process is simplified as we can just say mbo.getString(“DESCRIPTION”) and it will handle both scenarios.

Below are a few techniques in Jython that were used in a recent Maximo integration project.

1. DateTime formatting

The ‘external’ system would send their date in the format dd/MM/yyyy HH:mm, while Maximo’s MIF would only accept dates in the format yyyy-MM-dd’T’HH:mm:ss.
After conducting some research into this issue, we found that instead of using Python’s date time conversion API, we could use the good old Java’s SDF (Simple Date Format) in the script.

duedate = erData.getCurrentData(“TARGETFINISH”)
dateFormat = “dd/MM/yyyy HH:mm”
sdfServer = SimpleDateFormat(dateFormat)
cTime = sdfServer.parse(duedate)
erData.setCurrentData(“TARGETFINISH”,cTime)

Note that once I have parsed the string into date, all I had to do was set the value. I didn’t have to explicitly format it to yyyy-MM-dd’T’HH:mm:ss. What makes it possible to do that? Contact us for the answer

2. Split a string

The requirement was to split the value from Long Description field based on the sub-string ‘NOTES:’, and it was implemented using the split function of Python.

desc = erData.getCurrentData(“DESCRIPTION_LONGDESCRIPTION”)
desc1,desc2 = desc.split(‘NOTES:’,1)

3. Truncate a string

DESCRIPTION attribute of the object only accepts 100 characters, and hence the incoming value had to be truncated as below.

propdesc = erData.getCurrentData(“DESCRIPTION”)
propdesc = propdesc[:99]
erData.setCurrentData(“DESCRIPTION”,propdesc)

Automation scripting features in Maximo 7.6.1.1

A scripting editor has been embedded in automation script application. The latest version of Maximo has the following features:

  • Syntax highlighting and Line numbers for improved readability
  • Collapsible code blocks
  • JavaScript validations prior to save
  • Auto-complete reserved words, common functions, etc for Python and JavaScript
  • Supports some auto-completion of existing variables and methods
  • Tab will indent the code instead of taking you to the next Maximo Field
  • Supports Ctrl-z for Undo

If you’d like to learn more about automation scripting, here is an IBM link that gives you a list of web pages showcasing various other techniques. Any comments or further queries, please contact me via BPD Zenith.

Zoe Tattersall

Zoe Tattersall

We’re more than just your type. We do awesome, too. And websites, graphics, product photography and video content. Sevah Creative™️ a boutique creative agency bringing our big picture minds for business strategy to awesome design, marketing and content. Whether you’re a services, product or eCommerce business, we create a cohesive brand experience across digital channels, offering slick and compelling touch points that convert and move people to action.

0 Comments

Submit a Comment

Your email address will not be published.

Asset Management for Net-Zero Futures

Asset Management for Net-Zero Futures

Sustainability is not a new concept and BPD Zenith have always strived to be socially responsible, however, it is a critical imperative for today’s business operations – and for the planet... There has been a shift from using digital to improve the bottom line, to...

The Hidden Value of CMMS Master Data

The Hidden Value of CMMS Master Data

Having made a significant investment in your CMMS, advances in Data analytics are prompting rethinks about the Master Data that underpins your ability to launch programs such as Asset performance management, Monitor Asset health and enhance Predictive Maintenance. A...

BPD in Offshore: When the wind blows, our assets perform…

BPD in Offshore: When the wind blows, our assets perform…

London Array Limited (LAL) maintain a critical electricity production wind farm in the Outer Thames Estuary.   Lucy Horner (then Maintenance Strategy Engineer) joined the AiTalks podcast last year to discuss her world of offshore wind provision, the levels of...

Meet the Team – Sourabh Jain

Meet the Team – Sourabh Jain

1. What is your position at BPD Zenith? My name is Sourabh and I’m currently a Senior Maximo Consultant at BPD Zenith, Sydney. 2. What led you to choose this career path? What alternative career path would you have chosen and why? When I was studying programming for...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.