Maximo Open Forum

 View Only

Related Content

  • 1.  Update Specifications via Flat File Load

    Posted 7 days ago

    Has anyone ever successfully updated existing specifications with a flat file load?  I either get a duplicated spec row, or I get the error that it already exists:  BMXAA0192E - The combination of Attribute MTRASSETSERIAL and Section already exists for this classification.

    I am using the following load:  

    EXTFLAT SC_METERASSET Change EN                
    ASSETNUM ORGID SITEID MANUFACTURER INSTALLDATE SC_UMAXIMPORT AS_CLASSSTRUCTUREID AS_ASSETATTRID AS_ALNVALUE SORT LINEARASSETSPECID SECTION
    1369913 ABC ABCSITE ACME 2026-03-23T00:00:00 0       1 0 1
    1369913 ABC ABCSITE ACME 2026-03-23T00:00:00 0 5030 MTRASSETSERIAL 123456789 2 0 1
    1369913 ABC ABCSITE ACME 2026-03-23T00:00:00 0 5030 MTUPROGRAMMING MODE 54 3 0 1
    1369913 ABC ABCSITE ACME 2026-03-23T00:00:00 0 5030 MTUTYPE J 4 0 1
    1369913 ABC ABCSITE ACME 2026-03-23T00:00:00 0 5030 MTU FREQUENCY AMI 5 0 1
    1369914 ABC ABCSITE ACME 2026-03-17T00:00:00 0 5030 MTRASSETSERIAL 987654321 2 0 1
    1369914 ABC ABCSITE ACME 2026-03-17T00:00:00 0 5030 MTUPROGRAMMING MODE 54 3 0 1

    <scribe-shadow id="crxjs-ext" data-crx="okfkdaglfjjjfefdcppliegebpoegaii" style="position: fixed; width: 0px; height: 0px; top: 0px; left: 0px; z-index: 2147483647; overflow: visible; visibility: visible;"></scribe-shadow>


    #MaximoApplicationSuite

    ------------------------------
    Julia Scott
    Sarasota County Government
    ------------------------------


  • 2.  RE: Update Specifications via Flat File Load

    Posted 22 hours ago

    Hi Julia,

    I don't have much expertise in flat file loads. My understanding of this error is that the flat file update is attempting to add a new spec row but it already exists. Doing some research using flat file to update Specs can be tricky. I would confirm the attribute values are correct. Be sure you have the correct UniqueID like ASSETSPECID called out. The flat file load you have above is fairly difficult to read, so I believe it is there. 

    Thank you,



    ------------------------------
    Allan Henle
    Naviam
    ------------------------------

    Original Message


  • 3.  RE: Update Specifications via Flat File Load

    Posted 22 hours ago

    Thank you.  Yes, it does appear to think that the row already exists, and it does---I am just trying to update the alnvalue for that spec.  I have yet to find anything definitive online about it.



    ------------------------------
    Julia Scott
    Sarasota County Government
    ------------------------------

    Original Message