Hi mx pro,

I'm assuming that we are talking about JOBTASK.DESCRIPTION_LONGDESCRIPTION and your object structure is prepared to receive values for this field (check this IBM tech note).

If yes then I think you need to to that in this way:

1. You need to convert job task long description that was prepare by your business from excel cell formatting to html formatting. You can do that by using custom macro function that was described in this stackoverflow post: https://stackoverflow.com/questions/33620147/convert-rich-text-to-html-formatting-tags. I also prepared for you excel file with this macro so you can use it (please find attached ConvertTextToHTML.xlsx file in zip).
   
2. Then you need to copy formatted value into the MXLOADER and upload into the Maximo (please find MxLoader_JOBPLAN.xlsm file in zip)
   
3. After data upload you should see this as a result in Maximo:
   

I hope these steps will help you.

Please use ConvertTextToHTML.xlsm file from this zip ConvertTextToHTMLWithMacro.zip. Old one didn't include macro function.

Hi mx pro,

I'm assuming that we are talking about JOBTASK.DESCRIPTION_LONGDESCRIPTION and your object structure is prepared to receive values for this field (check this IBM tech note).

If yes then I think you need to to that in this way:

1. You need to convert job task long description that was prepare by your business from excel cell formatting to html formatting. You can do that by using custom macro function that was described in this stackoverflow post: https://stackoverflow.com/questions/33620147/convert-rich-text-to-html-formatting-tags. I also prepared for you excel file with this macro so you can use it (please find attached ConvertTextToHTML.xlsx file in zip).
   
2. Then you need to copy formatted value into the MXLOADER and upload into the Maximo (please find MxLoader_JOBPLAN.xlsm file in zip)
   
3. After data upload you should see this as a result in Maximo:
   

I hope these steps will help you.