Bulk E-mailing

Did this on my home machine and it seems to work:

• ​https://rianjs.net/2013/08/send-email-from-linux-server-using-gmail-and-ubuntu-two-factor-authentication

Spreadsheet Editing

Various ways of reading Excel spreadsheets in Perl. Best one seems to be ​Spreadsheet::Read. This seems to work well on .xls (open and Save As in Excel 2010) files but not so well on the supplied .xlsx.

HOWEVER the utility xlscat supplied with Spreadsheet::Read stops after 2^{14 rows.}

Data and tools SVN: ​http://edf.bu.edu/svn/edf/EricHome/BrooklineVote

Database Work

• SVN: ​http://edf.bu.edu/svn/edf/EricHome/BrooklineVote/DB/

2018-03-10

Wrote script ​import_csv.pl to import CSV to SQLite db. Seems to work but dates are not handled correctly. Now all data is in voters.db. Dump to sql using sqlite3 CLI .dump.