Clone the repository to a work folder.

Open a Powershell window with the work folder as the current directory. You will run scripts from there.

Run python scripts\makeEDT.py C:\AVI6\{datafolder}\MASTER.AVI in the work folder (substitute the name of a valid AviSys data folder for "{datafolder}"). This will create MASTER.EDT in the work folder; rename it as MASTER.OLD.EDT. It also creates Hawaii-only.txt which may be of interest but is not otherwise used.

Download Clements checklist in CSV format to the work folder. Note: I have sometimes found the provided CSV format checklist to have improper encoding. For better results, I download the XLSX file and create my own CSV format file. Make sure that the file name matches the pattern "Clements-Checklist*.csv" and is the only match.

Download the current ABA checklist in CSV format to the work folder. Make sure the filename matches the pattern 'ABA_Checklist-*.csv' and is the only match.

Check for any changes in the format of either CSV file and update clements.py and/or ABA.py accordingly.

Run python scripts\clements.py. Six files will be created in the work directory:

If the results show that there are any new names that differ between AOS (ABA) and Clements (eBird), update AOS diffs.csv and run clements.py again.

Edit MASTER.EDT to shorten names listed in longnames.txt, if any. Examples:

Run python scripts\makeUpdate.py to create MASTER.UPD. For informational purposes, the file non-ABA.txt is also created to list non-ABA species found on state checklists. Check to make sure that none of the "non-ABA" species are listed because of a name change. If there are such names, correct checklists and rerun makeUpdate.

Run python scripts\jerry.py subspecies.txt encode to produce subspecies.txt.jerry; rename it as SSDATA.AVI

Edit changes.csv

1. Sort on column "Clements change". Cut the lines with "name change - English name" and paste them into a new spreadsheet. In the new spreadsheet, delete all the columns except "text for website" and "English name". Edit each "text for website" value and delete everything except for the old English name, so that you end up with just two columns, old names in column A and new names in column B. Save the new spreadsheet as NEWNAMES11.AVI.CSV.

2. Delete all remaining lines from changes.csv except for those where the "Clements change" mentions "lump" or "split", or other species changes such as "new species", "species deletion", "reassign subspecies", etc., and save changes.csv for later.

3. Run python scripts\makenewnames.py to create NEWNAMES11.AVI from NEWNAMES11.AVI.CSV.

Copy MASTER.UPD and NEWNAMES11.AVI to the data folder, and SSDATA.AVI to the main folder, and run the update. Resolve any conflicts and rerun as necessary.

Then run python scripts\makeEDT.py C:\AVI6\{datafolder}\MASTER.AVI in the work folder again to get the final version of MASTER.EDT. This version will have any changes in N.A. status applied, needed for bandcode generation.

Update bandcode.exceptions.csv as necessary

Run python scripts\bandcodes.py to create BANDCODE.new.AVI and BANDSEL.new.AVI. Compare new with old to check for new conflicts. If there are any, update bandcode.exceptions.csv and run bandcodes.py again. Rename the new files as BANDCODE.AVI and BANDSEL.AVI.

Edit BANDSEL.AVI to sort each list with most likely species first.

Update jump lists if necessary. If any changes in aliases, run python scripts\makealias.py WORLD to create jump tables\Walias.avi and python scripts\makealias.py N.A. to create jump tables\Alias.avi. Beware the AviSys support for jump table aliases is buggy and it may take some trial and error to get a table that works for each alias. That's why I have some dummy entries.

Generate world codes and append these special cases to WLDCODE.AVI, then sort the file. Species marked "dup" must also be added to WORLDSEL.AVI, along with their duplicates. (Also check for any new duplicates).

daba d'arnaud's barbet     dup
doct d'orbigny's chat-tyrant
bobe böhm's bee-eater
bofl böhm's flycatcher
fubo fülleborn's boubou
fulo fülleborn's longclaw
lubu lühder's bushshrike   dup
rubu rüppell's bustard     dup
ruch rüppell's chat        dup
rugr rüppell's griffon     dup
rupa rüppell's parrot
rurc rüppell's robin-chat
rust rüppell's starling
ruwa rüppell's warbler
ruwe rüppell's weaver      dup

Copy (or move) these files to folder NSIS:

`Alias.avi`
`Alpha.avi`
`BANDCODE.AVI`
`BANDSEL.AVI`
`Famfile.avi`
`SSDATA.AVI`
`Walias.avi`
`Wfam.avi`
`Wfam2.avi`

Copy (or move) these files to folder NSIS\DATA:

`MASTER.UPD`
`NEWNAMES11.AVI`
`WLDCODE.AVI`
`WORLDSEL.AVI`

Package the update files folder for distribution via NSIS.

Documentation: Edit changes.csv again, and also NEWNAMES11.AVI.CSV.

1. NEWNAMES11.AVI.CSV: Tabulate name changes in renames.html.

2. changes.csv: Tabulate splits and lumps in changes.html. This is a time-consuming step and I am no longer doing it as of 2019, since the information is all available in the Clements summary anyway.

Run the entire update to test it.