Pages

▼

June 13, 2017

MxLoader now supports attachments

I have just implemented the capability to upload attachments straight from MxLoader. This is in response to some requests on my blog and MxLoader support forum.

Starting from Maximo 7.1.1.6 it is possible to import attachments to an object through MIF using Base64 encoding.
MxLoader has the capability to read files from the filesystem, encode them in Base64 and upload them on Maximo. This can be done on any Maximo object that supports attachments but the integration object structure has to be modified to include the DOCLINK object.

In this example the MYASSET object structure has been created with the DOCLINKS child object.



To specify a file to be uploaded you have to prefix the full path of the file with the ‘file:///’ string. Look at the screenshot below for an example of how to add two attachments to an asset.




18 comments:

  1. UnknownJune 21, 2017 at 11:33 AM

    Hi Bruno,In MXloader when I use Classification Hierarchy template,I am trying to send some extra fields but the data is not being updated,Can you please assist.

    ReplyDelete
  2. UnknownJune 22, 2017 at 9:01 PM

    This comment has been removed by the author.

    ReplyDelete
  3. AnonymousJuly 5, 2017 at 8:41 AM

    very useful ! thanks Bruno for sharing!

    ReplyDelete
  4. DawnJuly 24, 2017 at 9:17 PM

    Hi Bruno - thank you for sharing. Hoping you can clear up an issue for me. I did exactly what you have above. However when I load the file - it loads as a number and is unable to open unless it's a pdf or txt. doc and xls will not open. Data is loading to the doclinks object like this - /fxx/app/xxxxx/maximo/IBM/HTTPServer/htdocs/attachments/1500923495164 - when I try to open it doesn't understand the format - when I load through the front door I see this in doclinks - /fxx/app/xxxxx/maximo/IBM/HTTPServer/htdocs/attachments/excelxls.xls - and it opens fine - please help - ty Dawn

    ReplyDelete
    Replies
    1. DawnJuly 24, 2017 at 11:10 PM

      Figured this out. Have to add urlname to the MxLoader before the description column and make it match the description column. Now it updates the url correctly to open.

      Delete
    2. anandOctober 24, 2017 at 1:58 PM

      This comment has been removed by the author.

      Delete
    3. sunk818February 18, 2019 at 10:24 PM

      Order of fields don't do anything for me. I guess unix epoch time stamp as file name. And the contents look like gibberish. Only 1kB seems to be uploaded. File contents look like this: †ÛiÿùšÆ)¨ýÚ –)ä³ø¦j ¬ü#Ò hš–†§z½I

      Delete
  5. anandOctober 24, 2017 at 2:02 PM

    Hi Bruno - I have followed the same procedure. I have modified the object structure by adding doclinks object and modified the MXLoader. I am able to import the attachments but not able to view attachments same as Dawn mentioned in earlier post. I have added urlname before description and followed the same value. When I try to view the attachment it is showing as test1508845063507 with special charaters as text.
    Please help

    ReplyDelete
    Replies
    1. BrunoOctober 25, 2017 at 9:14 AM

      I also has a similar problem trying to upload attachments on a 7.5.
      I have tested on a 7.5 and it works.
      Which version of Maximo do you have?

      Delete
    2. anandOctober 25, 2017 at 10:47 AM

      Bruno - I am using Maximo 7.6.0.8

      Delete
    3. anandOctober 25, 2017 at 10:49 AM

      MXPO PO Sync-AddChange
      PONUM REVISIONNUM SITEID DOCLINKS.ADDINFO DOCLINKS.URLTYPE DOCLINKS.DOCTYPE DOCLINKS.URLNAME DOCLINKS.DESCRIPTION DOCLINKS.DOCUMENTDATA
      1044 0 RAC 1 FILE Attachments test.txt test.txt file:///C:/Temp/test.txt
      I am using this details in MXLoader. please let me know, if i am missing something.

      Delete
    4. Bekantan MoscowFebruary 27, 2018 at 8:05 AM

      have u solve this problem ? same issue here
      THX

      Delete
  6. UnknownApril 22, 2018 at 10:04 AM

    Hi Bruno,

    I am unable to connect my Maximo server through MXLoader. My Maximo server is a cloud environment.While connecting i am getting some error. It is not connecting to the server. What inputs i need to give to connect my cloud cloud server by using MXLoader file. Please help me out on this.

    ReplyDelete
  7. UnknownOctober 13, 2018 at 9:00 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  8. sunk818January 15, 2019 at 5:16 AM

    Is there a maximum file size limit? Or this is Maximo dependent? For example, if Maximo sets it at 10MB that's the limit for MxLoader too?

    ReplyDelete
  9. judgeMay 22, 2019 at 12:20 AM

    hi Bruno..

    regarding attachment for Job Plan app, I've created the Object structure with doclinks
    but could not upload the files through MX Loader, although I use it for many other issues ( failure codes, assets, persons, ... etc)

    please advise
    Thanks in advance

    ReplyDelete
  10. SwaroopJuly 3, 2019 at 6:20 AM

    Hi Bruno..

    Is it possible to update (an existing record) a custom attribute in the DOCLINKS table through integration. When I tried to POST, with action as Change, it would create a new record instead of inserting a new record. Please let me know if there is any way to update the custom attribute inside the DOCLINKS table.

    Thanks in advance.

    ReplyDelete
  11. drwAugust 22, 2019 at 4:07 PM

    Bruno,
    If I load more than about 2000 images, Excel crashes. If anyone is still updating MxLoader, would you make sure the memory is cleaned up after images are loaded into Maximo?
    Thanks

    ReplyDelete

Note: Only a member of this blog may post a comment.