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:
Sent: 04-14-2026 13:18
From: Allan Henle
Subject: Update Specifications via Flat File Load
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:
Sent: 04-07-2026 13:14
From: Julia Scott
Subject: Update Specifications via Flat File Load
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
------------------------------