search

KimleyHorn / SigOpsMetrics

GNU General Public License v3.0
0 stars 1 forks source link

Corridors_Latest xlsx improvements #60

Closed markKHA closed 3 years ago

markKHA commented 3 years ago

1) We want a Lambda to run nightly and dump the contents of Corridors_Latest.xlsx to a SQL table. 2) We want to modify the Signals controller to read from this SQL table instead of the xlsx.

markKHA commented 3 years ago

You should be able to get the SQL credentials in the code, but let me know if you have problems. It's MySQL, so I use DBeaver to connect