MxLoader

Hi, I tried this method and getting below error:

Internal Server Error
Error 500: BMXAA4211E - Database error number 2601 has occurred when operating on IMGLIB :  Unique Id=12,233. Report the error to the owner of the deployment.

I created integration script for MXITEM with your code for inbound processing. In MXLOADER I've tried two different object structures, MXITEM adn MXLITEM (created new) but getting the same error. 

I'd really appreciate if you can provide your insights.

Cheers

Hammad

------------------------------
Hammad Najeeb Ghumman
Keolis Downer
------------------------------

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

I need support with the steps how to utlize the above mentioned script in MXloader, I am also trying to load item records with images and getting message: "Upload of bynary files is not yet supported for REST APIs." Please guide with the steps

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

I was able to upload without the script. This is what I did

1. Create a new OS by duplicating the OOB MXITEM OS
2. Keep only ITEM and IMGLIB as the objects in the OS
3. Under the More Actions select the Configure Object Structure security
4. Check the "Use Object Structure for Authorization Name"
5. Go to the Security Group of the user which will be used to upload the images and under the Object Structure tab provide access to the above newly created OS
6. In the MxLoader Config tab, I used the service as OS and Authentication as API
7. Used the below in the MXLoader Sheet
8. 
9. I was able to upload the image by following the above steps

I need support with the steps how to utlize the above mentioned script in MXloader, I am also trying to load item records with images and getting message: "Upload of bynary files is not yet supported for REST APIs." Please guide with the steps

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

I was able to upload without the script. This is what I did

1. Create a new OS by duplicating the OOB MXITEM OS
2. Keep only ITEM and IMGLIB as the objects in the OS
3. Under the More Actions select the Configure Object Structure security
4. Check the "Use Object Structure for Authorization Name"
5. Go to the Security Group of the user which will be used to upload the images and under the Object Structure tab provide access to the above newly created OS
6. In the MxLoader Config tab, I used the service as OS and Authentication as API
7. Used the below in the MXLoader Sheet
8. 
9. I was able to upload the image by following the above steps

I need support with the steps how to utlize the above mentioned script in MXloader, I am also trying to load item records with images and getting message: "Upload of bynary files is not yet supported for REST APIs." Please guide with the steps

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

It worked for us on MAS 9 too.

------------------------------
Priyaranjandas Kolambkar
COSOL Global
------------------------------


Original Message:
Sent: 01-01-2026 02:10
From: Arshiya Sultana
Subject: Upload Image to IMGLIB for ITEM.

------------------------------
Arshiya Sultana
TCS


Original Message:
Sent: 01-01-2026 01:53
From: Priyaranjandas Kolambkar
Subject: Upload Image to IMGLIB for ITEM.

I was able to upload without the script. This is what I did

1. Create a new OS by duplicating the OOB MXITEM OS
2. Keep only ITEM and IMGLIB as the objects in the OS
3. Under the More Actions select the Configure Object Structure security
4. Check the "Use Object Structure for Authorization Name"
5. Go to the Security Group of the user which will be used to upload the images and under the Object Structure tab provide access to the above newly created OS
6. In the MxLoader Config tab, I used the service as OS and Authentication as API
7. Used the below in the MXLoader Sheet
8. 
9. I was able to upload the image by following the above steps

------------------------------
Priyaranjandas Kolambkar
COSOL Global


Original Message:
Sent: 12-29-2025 10:21
From: Arshiya Sultana
Subject: Upload Image to IMGLIB for ITEM.

I need support with the steps how to utlize the above mentioned script in MXloader, I am also trying to load item records with images and getting message: "Upload of bynary files is not yet supported for REST APIs." Please guide with the steps

------------------------------
Arshiya Sultana
TCS


Original Message:
Sent: 12-01-2025 03:14
From: Manuel Guyot
Subject: Upload Image to IMGLIB for ITEM.

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

------------------------------
Manuel Guyot
Husqvarna AB

I have attached  config details from Mxloader, anything needs to corrected?

It worked for us on MAS 9 too.

I was able to upload without the script. This is what I did

1. Create a new OS by duplicating the OOB MXITEM OS
2. Keep only ITEM and IMGLIB as the objects in the OS
3. Under the More Actions select the Configure Object Structure security
4. Check the "Use Object Structure for Authorization Name"
5. Go to the Security Group of the user which will be used to upload the images and under the Object Structure tab provide access to the above newly created OS
6. In the MxLoader Config tab, I used the service as OS and Authentication as API
7. Used the below in the MXLoader Sheet
8. 
9. I was able to upload the image by following the above steps

I need support with the steps how to utlize the above mentioned script in MXloader, I am also trying to load item records with images and getting message: "Upload of bynary files is not yet supported for REST APIs." Please guide with the steps

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

Hi,

With Maximo MAS, things changes and when you try to send a picture you get the message: "Upload of bynary files is not yet supported for REST APIs." (Message from MxLoader), for those who are creating own VBA scripts, this can be done by easy way:

In my script I write in the IMGLIB.IMAGE column the referens to the file like:

Picture:/D:\Temp\JPG\Image.jpg

Then in my script I detect the "Picture:/" and then send the encryption like:

PictureB64 = Chr(34) & "image" & Chr(34) & ": " & Chr(34) & EncodeFileToBase64(Right(value, Len(value) - 9)) & Chr(34)

The Function is:

Public Function EncodeFileToBase64(filePath As String) As String
    Dim fileStream As Object
    Dim xmlObj As Object
    Dim fileBytes() As Byte

    ' Read file as binary
    Set fileStream = CreateObject("ADODB.Stream")
    fileStream.Type = 1 ' Binary
    fileStream.Open
    fileStream.LoadFromFile filePath
    fileStream.Position = 0
    fileBytes = fileStream.Read
    fileStream.Close

    ' Convert to Base64
    Set xmlObj = CreateObject("MSXML2.DOMDocument").createElement("b64")
    xmlObj.DataType = "bin.base64"
    xmlObj.nodeTypedValue = fileBytes
    EncodeFileToBase64 = xmlObj.Text
End Function

I don't know if it can help someone but I put it here so that it can give some hints or help on the way, I got it working perfectly with my script.

I'm the author of MxLoader and I was following this interesting thread. I have decided to improve the file handling in MxLoader that was somewhat incomplete.

MxLoader 8.5 now provides a better support for the FileTxt/FileEnc tags for uploading and downloading files from Maximo.

Details are available in this blog post.

Please let me know here if this solves your issues.

------------------------------
Regards
Bruno Portaluri (MaximoDev)
------------------------------