MxLoader

 View Only
  • 1.  Delete an Attribute with MxLoader - is it possible?

    Posted 07-01-2024 23:43

    Hello,

    MxLoader will not allow me to delete an ASSETSPEC.ASSETATTRID.

    Would anyone have any suggestions on how to remove an attribute that I added to the attributes in Classifications that was incorrect?  I have deleted it there, but it still is on all Assets with that classification.

    Thank you,



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------


  • 2.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-02-2024 09:54

    Hi Danny,

    In the configuration you've provided, the "Delete" action is actioning on the the ASSET object (Cell B2) which is the parent object of the MXASSET Object Structure (Cell A1). Thus, delete would delete the Asset record.

    Create an object structure for the ASSETSPEC table. Then create a new sheet with the newly created object structure in A1, ASSETSPEC in B1, Delete in C1, and you can remove "ASSETSPEC." from the column headers in row 2.

    Thanks,



    ------------------------------
    Matt McGuire
    Aquitas Solutions
    https://www.aquitas-solutions.com/
    ------------------------------



  • 3.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-11-2024 15:44

    Thank you @Matt McGuire.  I created the below, and I can Query, but when I Delete, it acts like it was successful but the attribute is still there under the Asset Spec tab.

    Would you have any ideas?

    Thank you,



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 4.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-23-2024 15:15

    Hi @Danny Richardson

    The attributes are associated with the classification. Are the values ​​of those attributes (ALNVALUE or NUMVALUE) the data that you want to delete? Or are it the attributes you want to remove?

    Taking the image below as an example, do you want to remove the SIZE attribute or its value 2.5?

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------



  • 5.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-23-2024 15:44

    Hello @Martin Fabra, it would be the SIZE attribute itself.



    ------------------------------
    Danny Richardson
    Maximo Administrator Manager
    Technimark LLC
    ------------------------------



  • 6.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-23-2024 16:14

    Danny, The SIZE attribute is associated with the classification, in the case of the "PUMP \ CONTROL" example. I was recently working on something associated and it has a complication and it is the CLASSPECUSEWITH table, that is, each attribute is given permission to be used in certain applications and you have to consider that table to be able to delete it. I'll check it and let you know.

    Regards!



    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------



  • 7.  RE: Delete an Attribute with MxLoader - is it possible?

    Posted 07-27-2024 17:30
      |   view attached

    Hi @Danny Richardson!

    I have managed to solve it. I have dedicated a lot of time, but since it was something that many of me needed and I couldn't do it, I needed it too.
     
    The default structure that exists is MXCLASSIFICATION which points to the objects:
    1 - CLASSSTRUCTURE
    2 - CLASSSPEC (CLASSSTRUCTURE/CLASSSPEC)
    3 - CLASSSPECUSEWITH (CLASSSTRUCTURE/CLASSSPEC/CLASSSPECUSEWITH)
    4 - CLASSUSEWITH (CLASSSTRUCTURE/CLASSUSEWITH).
     
    It is a structure that points to the classifications, their permissions in the different applications, their attributes and their permissions in the applications.
     
    I tried every way to query this structure and manipulate it to remove certain attributes and couldn't. Always, when using DELETE and obviously (since the structure points to CLASSSTRUCTURE), deletes the entire classification. and if you use a SYNC deleting an attribute, in my case, it never did anything... the attribute always remains there.
     
    What I did was create a new object structure:
    MF_CLASSSPEC that works on objects:
    1 - CLASSSPEC
    2 - CLASSSPECUSEWITH (CLASSSPEC/CLASSSPECUSEWITH).
    That is, my intention with this was to target the attributes and their authorizations and then try to use DELETE to see if it deleted them.
     
    This worked with this MxLoader that I share.
    Regards!


    ------------------------------
    Martin Fabra
    ARSAT S.A. - Actively seeking employment
    ------------------------------

    Attachment(s)