Maximo Open Forum

 View Only

Update Specifications via Flat File Load

  • 1.  Update Specifications via Flat File Load

    Posted 4 hours 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
    ------------------------------