Sections Export Instructions
Open BMS in a new browser and select ‘Sections’ on the navigation bar on the top.
Run search with Enter the following criteria and select Search.
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’ in the top right.
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 minutes to load
Once the export is complete, open in excelthe Excel file.
Click on the upper left box to highligh highlight ALL data, then double-click on the edge of the first column A to auto-adjust all of the columns
Add a filter to the first row (the headings)
Go to the ‘Last Updated’ Column X 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/
128/
20212024 I would select 2,3,4,5,6,
9,10,11,127,8
...
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)