Messy asset import project
The hardware lead supplies a messy spreadsheet with padded serial numbers, an updated existing asset, a new asset, and a row without a serial. Import it into Assets without duplicating the existing record. Done means trimmed keys, the existing asset updated, the new asset inserted, the blank-key row ignored, and a repeat run preserving identities.
You are responsible for a complete asset data import handoff. The person receiving it needs a result they can use and explain. Read the brief, then follow the work through each dependent step. The instance carries your saved work forward.
Each step changes the same deliverable or adds evidence to it. Keep earlier conditions, assignments, and definitions unless the task asks you to replace them. The final check includes the completed state and the decision supported by it. Watch for a result that looks plausible while using the wrong table, an overly broad condition, or a duplicate relationship. Those errors can survive a quick visual review and change the operational conclusion.
The hardware lead supplies a messy spreadsheet with padded serial numbers, an updated existing asset, a new asset, and a row without a serial. Import it into Assets without duplicating the existing record. Done means trimmed keys, the existing asset updated, the new asset inserted, the blank-key row ignored, and a repeat run preserving identities.
Build and verify a complete operational deliverable.