To start off with, long descriptions are essential for multiple different reasons. They are often used for extra space to write out a descriptive description or used to map multiple fields from a data migration project. In my case we were mapping multiple different fields into the long description. There are some key steps you must follow for the long description to show up with your values. In my case I followed most steps I found online but missed one crucial step. Let’s breakdown the steps.
Figure out which attribute in Maximo will have the long description tied to. (In my example we will be tying it to the DESCRIPTION attribute.)
We must make sure ISLDOWNER is checked in the database configuration for the specific attribute in the specific object you chose.
Save the changes, then make sure to turn on admin mode and apply the configuration changes.
Next is to insert the long description data. In my case we are inserting from a different database to Maximo
database. (You must have access to Maximo database)
Next is to insert the long description data. In my case we are inserting from a different database to Maximo database. (You must have access to Maximo database)Next is to insert the long description data. In my case we are inserting from a different database to Maximo database. (You must have access to Maximo database)
Ex.
insert into longdescription (ldkey, ldownertable, ldownercol, ldtext, langcode, contentuid, longdescriptionid)
select a.assetuid, 'ASSET','DESCRIPTION','Comments: '|| ld."Cmnt"|| CHR(10) ,'EN', longdescriptionseq.nextval, longdescriptionseq.nextval
from tblAssetHdrs@cmmsdev asset
inner join a3j_vwtblAssetTabCmnts@CMMSDEV ld on asset.EMID = ld.EMID and ld."TABID" = 41006
Most important step is updating the hasld to 1 per records that had long description. This will be an update statement in the database.
This will only update records that have a corresponding record in the long description table.
(Ex. update asset set hasld=1 where exists(select 1 from longdescription where ldownertable='ASSET' and ldownercol='DESCRIPTION' and ldkey = asset.assetuid) );
Now confirm that your long description is showing through the front end of Maximo. Click on the green box to the right of the description to open the long description.
It was successfully inserted above you will see the long description that was inserted.
In conclusion it is important to follow these steps thoroughly. If you miss one of these steps you won’t be able to see the long description from the front end. This could cause more problems if you don’t know which step you missed. Make sure to follow those steps when inserting into the long description.
Be sure to sign up here to be first to hear about any new blogs.
About
A3J Group is a leading solutions and consulting firm based in Tampa, Florida, specializing in Enterprise Asset Management (EAM) with a focus on fully developed Computerized Maintenance Management System (CMMS) solutions like IBM Maximo.
In addition to our suite of proprietary products—including MxMobile, our powerful mobile solution for Maximo—we provide traditional consulting services that help organizations plan, implement, optimize, and support their EAM strategies. Whether clients need hands-on configuration, strategic guidance, or ongoing system support, our team delivers the expertise to drive long-term success.
With over 50 years of combined experience, our specialized team is dedicated to our core mission: to serve as excellent stewards of our clients’ trust and investments, while driving measurable results through tailored, high-impact solutions and intelligent consulting.
Visit us at www.a3jgroup.com. Or drop us a line at info@a3jgroup.com.
