Skip to content

Latest commit

 

History

History
20 lines (10 loc) · 586 Bytes

README.md

File metadata and controls

20 lines (10 loc) · 586 Bytes
Raw

NAWS Spreadsheet updater

The NAWS import spreadsheet from NAWS no longer imports directly into BMLT due to changes in the NAWS database as of August 2022. This script fixes up some problems so that it can be imported.

Later, we could change the NAWS import code in the BMLT root server to accommodate the new format.

  1. Install the PHP spreadsheet package using this command:

composer install

  1. Run this command:

php update.php origfile.xlsx newfile.xlsx

where origfile.xlsx is the original spreadsheet file from NAWS. This will create or overwrite newfile.xlsx.