search

votingworks / arlo

GNU Affero General Public License v3.0
141 stars 25 forks source link

Update ES&S CVR parsing to support latest format (as seen in Washington's Thurston County) #1883

Open arsalansufi opened 4 months ago

arsalansufi commented 4 months ago

https://votingworks.slack.com/archives/C013V6CT9H9/p1708479181164829

Washington has since deleted the relevant audit data, so we don't have access to a sample file from Thurston County. But reading the above Slack post, the file format appears to mirror the latest file format seen in Rhode Island, which we've accounted for in our batch inventory CVR parsing logic. The new format is actually simpler. The CVR file contains all the relevant info that we need; information is no longer spread across a CVR file and one or more ballots files.

We should update our ballot comparison audit CVR parsing logic to handle this new file format, too.

Sample file from Rhode Island: COVPPPTest.xlsx

ginvdr commented 2 months ago

WA reached out this week to make sure this is on our radar and requested that it be complete by the end of June. Some files can be found here: https://votingworks.slack.com/archives/CKCVA0F9S/p1715087828353039. One is a CVR and the other is the steps Thurston has been taking to convert them to the old format themselves.