The convert_xlsx_to_json.js script converts an Excel file to JSON format. The convert_json_to_data.js script transforms the JSON data to adhere to the required format.

• Ensure the Excel file is named in the format report_<campus>.xlsx.

• The sheet name must be Sheet 1.

• The Excel sheet should contain the following column headers (case sensitive):

  CODE	TITLE	TYPE	CREDITS	SLOT	FACULTY	VENUE

1. Use the convert_xlsx_to_json.js script to convert the Excel file to JSON.
2. Use the convert_json_to_data.js script to transform the JSON data into the required format.

• For converting a PDF file to Excel, use ilovepdf.com.

• Add a script to automate the PDF to XLSX conversion (note: this process might change depending on VIT's requirements).