Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
Expand all | Collapse all

Adding attachment from Maximo library to Asset or assets

  • 1.  Adding attachment from Maximo library to Asset or assets

    Posted 05/31/21 09:13 AM

    Hello everyone!

    Wanted to know if this is possible to add attachments from Maximo library to assets with MxLoader?

    For example, I have imported attachment from my PC to IBM Maximo with MxLoader or through UI, and now I need to import those attachments to assets, not only one asset but to many assets. How do I need configure MxLoader to be done? By default "Attachment to Asset" there is used DOCLINKS, and in my opinion to get "Attachment from Maximo Library to Assets" there need to be used DOCINFO?

    Version: 7.6.1.2.

    I will be thankful for all the answers.

    Have a nice day!






    #SupportMigration
    #Maximo
    #Support
    #AssetandFacilitiesManagement


  • 2.  RE: Adding attachment from Maximo library to Asset or assets
    Best Answer

    Posted 06/10/21 06:11 PM

    I've never tried adding attachments from the library. I'm somewhat confident you can do what you're asking via SQL by adding records to tables per attachment. Have two sessions of Maximo up. You turn on SQL logging to INFO just before you perform your action, perform your action on the other tab, then turn of SQL logging back to WARN. You'll see the SQL involved with attaching from library. The SQL straightforward although you'd have to use sequence.nextval for the insert ID.

    The safer and supported way is to load attachments with MxLoader 7.52. I put a comment with the specifications in the link below: https://bportaluri.com/2017/06/mxloader-attachments-doclinks.html

    If you upload again, you'd duplicate the attachments and take up extra disk space, but again, that is the safer way without having to interact with the database directly...






    #SupportMigration
    #AssetandFacilitiesManagement
    #Support
    #Maximo