Prepare Emporia EV enrollment bulk import
completedSubtask of BOLT-1663. Grace supplied final corrected source Untitled spreadsheet - round2import (1).csv (Slack F0BL229PWL8); expected source count 240. Deduplicate/validate serials, split/normalize addresses, resolve canonical contacts/referenceIds and sites from production, generate import-ready CSV plus exceptions. Do not execute import. Supersedes earlier wrong/partial inputs.
Event Timeline
created
progress
Verified the attached CSV is identical to the July 21 Emporia batch. The canonical completed import job cmrv0xgg701j11smhvudosc21 processed 104 unique rows successfully (104/104; 0 errors). Its reconstructed import-ready CSV already contains canonical reference IDs/sites/addresses. Re-validated required fields: all 104 valid; US country; target program slug. Original had 9 duplicate serial rows and one blank placeholder; none are in the final file.
status_change
in_progress → completed
status_change
completed → in_progress
status_change
in_progress → completed
status_change
completed → in_progress
failed
lease expired — re-queued for retry
in_progress → queued
status_change
queued → completed
status_change
completed → in_progress
status_change
in_progress → completed
status_change
completed → in_progress
status_change
in_progress → completed
status_change
completed → in_progress
status_change
in_progress → completed