How to Export BMS Sections

Owned by Jenna McCarthy
Last updated: Aug 08, 2024
2 min read

Sections Export Instructions

  • Open BMS in a new browser and select ‘Sections’ on the navigation bar on the top.

  • Enter the following criteria and select Search.

    • Note: this should be run for the upcoming semester

image-20240808-184610.png

  • 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 minutes to load

  • Once the export is complete, open the Excel file.

  • Click on the upper left box to highlight ALL data, then double-click on the edge of the 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/8/2024 I would select 2,3,4,5,6,7,8

image-20240808-200501.png

  • 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)