MxLoader

Hi,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

Hi,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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

Original Message:
Sent: 05-09-2023 05:52
From: Manuel Guyot
Subject: Upload Image to IMGLIB for ITEM.

Hi,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

Hi,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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

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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

------------------------------
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,

I am using MxLoader 8.2 with Maximo 7.6.1.2 and try to upload picture connected to ITEM. 
This is my MxLoader:

I can see that the picture is uploaded to Maximo with the right information but the picture is "broken", I can't see it or open it.


I have started the Debug mode in MxLoader and copied the information saved into IMGLIB/IMAGE, pasted it in a Base64 decoder and the picture is the same than the one I uploaded, so what did I do wrong?

Anyone who succeed in uploading picture to ITEM with MxLoader?

Thanks.

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