Sections Export Instructions
Open BMS and select ‘Sections’ on the navigation bar on the top.
Run search with the following criteria
Note: this should be run for the upcoming semester
Once sections are loaded (which may take up to 30 minutes) , click ‘Michelle’s Super Secret Export’
Both the sections search and export can be run in the background while you are doing other tasks
The export may take 30-45 mins to load
Once the export is complete, open in excel
Click on the upper left box to highligh ALL data, then double-click on the edge of the first column to auto-adjust all of the columns
Add a filter to the first row (the headings)
Go to the ‘Last Updated’ Column and click on the filter
Deselect all of the data so that all check boxes are blank
Drill down on the current month by click the ‘+’ sign
Select all of the dates from the previous week including today
Example: If I’m running the export on 8/12/2021 I would select 5,6,9,10,11,12
Scroll back to top of the sheet and save the file as
“BMS Updates as of X.XX.XXXX”
Be sure to save as excel not CSV (.xlsx)