This tutorial walks through the steps to convert course schedule from Excel file into MODX.
- Open up the original Excel file (provided by Deborah), merge multiple faculty into one row, then delete all the empty rows.
- Open up the Course Schedule Sample Excel file
- Copy and paste each column such as Course Title, Credit, and Course Number into the sample Excel file. Do it for both Day and Evening courses.
- Once everything is in place, copy all (except for row 1) from the Excel file to an HTML editor:
<table id="course-schedule" class="sortable" border="1" cellspacing="0">
<th>Num. (Sec.) CRN</th>
<th class="unsortable">Days, Time</th>
<!--SCHEDULE STARTS HERE-->
<!--Paste the table from Excel into here-->
<!--SCHEDULE ENDS HERE-->
- Save as an HTML file and view it in the browser. Clean up all the extra spaces using Search & Replace. For examples:
( 3 cr)to
( 001 )to
- Next, perform Search & Replace for notes items: //, (W), (E), +, and (N.1) to (N.9)
<a href="[[~[[*id]]]]#permission" title="With witten permission of instructor only.">//</a>
<a href="[[~[[*id]]]]#writing" title="This course has been designated as a writing course.">(W)</a>
<a href="[[~[[*id]]]]#experimental" title="This course has been designated as an experiential course.">(E)</a>
<a href="[[~[[*id]]]]#prerequisites" title="This course has prerequisites.">+</a>
<a href="[[~[[*id]]]]#n1" title="See Note 1">(N.1)</a>
Note that (N.1) to (N.9) are different for Day than Evening. For Evening change the anchor
- Copy and paste notes from the original Excel file to the bottom of the HTML page. Reformat the notes to include all the anchor links.
- Once everything looks good, paste into MODX
Change text case
This step is not required, but here’s are tips for change the case of text in Excel.