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.
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" = 41006Most 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.
A3J Group, LLC is a boutique consulting firm specializing in enterprise asset management systems. Our experts have over 20 years experience in the space. We focus on all aspects of your maintenance projects from Functional to Technical to Executive and more. We are a tech forward company with suites of in-house solutions developed to help maintenance systems deliver the most value possible. Want to learn more? Visit us at www.a3jgroup.com. We look forward to working with you and coupling our expertise with your goals.