We've made a set of improvements to the End of Draw Tools (EOD Tools) - the services in the Jumbo Lottery Platform (JLP) that handle winner selection. These changes give operators more confidence that entry files have been uploaded correctly, make it practical to run draws with very large entry lists, and add a new control for managing sub-winners after a draw has been processed.
Why this matters
Some draws involve millions of entries that get uploaded as a CSV to EOD Tools before a draw can be processed. As entry counts have grown, three friction points have emerged:
- There was no way to confirm a CSV had uploaded intact, leaving operators unsure whether the file they sent matched the file EOD Tools received.
- Large entry files were impractical to upload because of size limits and short timeouts, forcing operators to workaround platform limits.
- Once sub-draw winners were approved, there was on-platform way to invalidate one if a problem was identified after the draw had run.
These updates address all three.
What's new
File checksum on every CSV upload
EOD Tools now calculates and displays a checksum for every entry CSV that is uploaded. Operators can compare the displayed checksum against the source file to confirm the upload completed intact, and EOD Tools validates the checksum on its side before processing the file.
If the checksums don't match, EOD Tools will not process the file and an error is surfaced on the draw sequence in Admin so the operator can re-upload.
Compressed CSV uploads
EOD Tools now accepts compressed CSV uploads, and Admin compresses the entry file client-side (in the browser) before sending it. EOD Tools has also been updated to accept zip/gzip uploads on its side.
Support for much larger entry CSVs
Compression dramatically reduces the payload, which is what makes very large entry lists practical to handle. Operators don't need to do anything different - the compression happens automatically when an entry CSV is uploaded.
The combination of compression and extended timeouts means EOD Tools now accepts entry files containing over 100 million rows of encoded customer IDs.
To support this, we've:
- Extended the upload timeout to 5 minutes
- Raised the compressed file size limit to 500 MB
Note: Network conditions, the 5-minute upload window, and the 500 MB compressed file size cap are the next practical limits. Operators uploading very large files should ensure a stable connection.
Invalidate a sub-winner in EOD Tools
EOD Tools now supports invalidating a sub-winner after a draw has been processed. This is useful when a sub-winner needs to be removed after the draw has run - for example, due to eligibility issues, supporter ineligibility, or other compliance reasons identified after the fact.
Once invalidated, the result is reflected in EOD Tools and downstream reporting, keeping records consistent across systems.
Who this impacts
These updates apply to partners using EOD Tools on JLP. Commercial lotteries - which supply their winning numbers through their own service rather than EOD Tools - are not affected by the sub-winner invalidation change.
The CSV checksum, compression, and larger-entry-file work benefit any operator scoring draws through EOD Tools, particularly those running large or multi-million-entry draws.