Hello everyone,

In Maximo 7.6, we are using MXLOADER to upload data

Our Business has provided Job Plans data and it has formatting for JP Tasks, including Bold, Italics, Numbering
The data is in Excel data templates
Can anyone let us know how this data can be uploaded (again using MXLOADER) so that the data is uploaded with the existing formatting

Thanks in Advance

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.

Hello everyone,

In Maximo 7.6, we are using MXLOADER to upload data

Our Business has provided Job Plans data and it has formatting for JP Tasks, including Bold, Italics, Numbering
The data is in Excel data templates
Can anyone let us know how this data can be uploaded (again using MXLOADER) so that the data is uploaded with the existing formatting

Thanks in Advance

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.

Hello everyone,

In Maximo 7.6, we are using MXLOADER to upload data

Our Business has provided Job Plans data and it has formatting for JP Tasks, including Bold, Italics, Numbering
The data is in Excel data templates
Can anyone let us know how this data can be uploaded (again using MXLOADER) so that the data is uploaded with the existing formatting

Thanks in Advance