MxLoader

 View Only
Expand all | Collapse all

Loading attributes value with MX LOADER - Error message because of "LINEARASSETSPECID"

  • 1.  Loading attributes value with MX LOADER - Error message because of "LINEARASSETSPECID"

    Posted 10-27-2021 04:19
      |   view attached
    Hello all,

    I don't manage to load the attributes values of assets' specification with MX Loader.

    The object structure used is "MXAPIASSET". I get an error message (code error: 500) with the following description : "BMXAA1339E - Missing value for LINEARASSETSPECID key. This value cannot be empty. Specify a value for the key and retry the operation."

    I tried several values for "LINEARASSETSPECID" key : "0", the same value as ASSETSPEC.ASSETSPECID, "9999". For all these values, it didn't work and I got the same error message.

    Here is attached the MX Loader file I have used.

    Do you have any idea of how I could manage to load the attributes value with MX Loader?

    Best regards,
    Camille


    ------------------------------
    Camille LECHERF
    SUEZ International
    ------------------------------

    Attachment(s)



  • 2.  RE: Loading attributes value with MX LOADER - Error message because of "LINEARASSETSPECID"

    Posted 10-27-2021 11:19
    Edited by Matt McGuire 10-27-2021 11:19
    Hi Camille,

    I reviewed your MXL file. Try moving your Location column (column I) in front of your child object columns (column E). I've found that objects need to be group together when loading.

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    ------------------------------