MxLoader

 View Only
  • 1.  How to update existing doclinks urlname for locations by MXLoader?

    Posted 11-28-2024 06:18

    Here are contents of MXLoader sheet.

    When I execute "change" option, it will add new doclinks record (see picture below), not update existing record.
    Has anyone occur same issue before and solved the problem?



    ------------------------------
    Ari Saaranluoma
    Fortum
    ------------------------------


  • 2.  RE: How to update existing doclinks urlname for locations by MXLoader?

    Posted 11-29-2024 09:57
    Edited by HENRIK SÖDER 11-29-2024 09:57

    Hi Ari!

    Doclinks and docinfo are a problem.
    We have almost the same problem as you do.

    Easiest way as I see it during our MX roll-out is to use sql tool and just delete the old record. ( doclinks.docinfoid=docinfo.docinfoidid )
    Then we just load it as a new doc.

    Maybe thats not possible in your case?

    Good luck and Merry christmas!



    ------------------------------
    HENRIK SÖDER
    Quale Consulting AB
    ------------------------------



  • 3.  RE: How to update existing doclinks urlname for locations by MXLoader?

    Posted 12-02-2024 02:32

    --- Solved ---

    I found solution to this issue. Finally solution was easy.

    1) create new object structure to DOCINFO table, check that all fields are included (persistent)
    2. include all DOCINFO fields to MXLoader template and query data.
    3. update new urlname data to existing urlname into Maximo.

    In begin, I had problem when in MXLoader template not all fields included. 
    When trying to update, I received error message " Docinfo records not exists in Maximo database..."



    ------------------------------
    Ari Saaranluoma
    Fortum
    ------------------------------