Enable AutoKey when inserting new assets in Maximo 7

In Maximo 4.1.1, you could enter a new asset with an auto number by default.  In Maximo 7,  with the default configuration, you aren’t able to generate an auto number when inserting new assets.  The functionality is there for you to use an auto key scheme, you just have to enable it.

First, you can check the Organization level for all the autokey values.  Go to the Organizations module and select your org, then Select Action -> Autonumber Setup -> Organization Level.  You will see a dialog like this:

Autonumber Dialog Enable AutoKey when inserting new assets in Maximo 7

Autonumber Dialog

You can set the seed values here and prefix values if you want.  As you can see, the assetnum autokey is already there and ready to use.

So to enable the autokey for an asset, all we need to do is change some configuration settings.  Go to Database Configuration module and find the Asset object.  Click on the attribute tab and find the ASSETNUM field.  Expand it.  If you look for the field “Autonumber”, you will see that it is already populated with the right autokey.  Now we just need it so that this field uses that autokey by setting the default value.  So enter &AUTOKEY& for the “Default Value” field like so:

Assetnum Autokey Enable AutoKey when inserting new assets in Maximo 7

Assetnum Autokey

Save your changes.  Now you just need to enable Admin Mode and apply your configuration changes.  Now you should be able to enter a new asset with an auto number!

About Chon Neth

I am a Senior Software Engineer at InterPro Solutions, LLC located in Wakefield, MA.

  • nofear

    Can this autokey works with MIF? For example, I have a list of Assets without ASSETNUM and I want them to be auto generated when inserting into MAXIMO DB using MIF. Can it work like this? I tried but it didn’t work that way.

    • http://interprosoft.com Chon

      Yes, if you enable the AutoKey, it will work with MIF.

      • bmello

        Hi Chon,
        I have tried this with contracts, but it didn’t work.
        When I send a message I receive an error about the required field CONTRACTNUM can’t be null.
        Do you have any idea?
        Thanks in advance

        • bmello

          Hi Chon,

          I figured out the solution, I need to remove the tag from the XML, now my problem is: how to do this without a user exit class? I’m using IFACETABLE and I can’t exclude this field.

          Thanks

          • http://interprosoft.com Chon

            Check and see if that field is restricted, if not make it restricted.

  • bpscotty

    for this change you can apply the configuration change without entering admin mode as it is non-structural

  • sisma

    Hi Chon, I have try to insert &AUTOKEY& in the assetnum of my flatfile but didn’t work.
    The new created asset have the assetnum equal to &AUTOKEY&.
    The autonumbering of asset is just enable in maximo but he didn’t work with MIF.

    Any idea?
    Thanks

    • http://interprosoft.com Chon

      You have to leave the field blank or null.

      • sisma

        Hi Chon,

        thanks for your reply.

        If I leave the assetnum field blank the import preview display an error because the assetnum is required.

        Thanks

        • http://interprosoft.com Chon

          Please post this issue in our forum

  • Jgdsh Pudi

    Hi Chon,

    when loading mutiple asset records with assetnum(autonumber enabled) as blank in flat file using MEA it is loading up only the first record.I browse something on ibm site and it looks like there is some issue in this.For reference i’m giving that link.Please let me know the solution if you have any?
    Thanks in advance.

    https://www-304.ibm.com/support/docview.wss?uid=swg1IZ09918