Make sure the csv file is properly formatted. Use the csv files from the previous semesters as example, strictly apply the same format for name, time, date, etc.
1. ssh into the masonlaw main server
2. su into root
3. cd /home/lawdevlaw/public_html/assets/snippets/
4. change permissions: chmod -R 755 csv_new/
5. cd csv_new
6. upload the csv file (make sure the uploaded csv file is readable).
cd /home/lawdevlaw/public_html/assets/snippets/csv_new
touch zz-spring-2012.csv (new csv file)
vi zz-spring-2012.csv (paste CSV file from TextEdit)
:wq (save file)
7. Copy a convert_schedule_201?_????.php to a file name appropriate for the school year and semester, e.g., convert_schedule_2012_spring.php (Make sure to do this via command line and not upload through MODX).
8. Edit convert_schedule_2012_spring.php. Make sure all the parameters shown below are correct:
$SITE = 'LIVE'; // 'LIVE' OR 'DEV'
$csv_file = ‘./zz.csv’; // CSV files
$xml_file = ‘./schedule2.xml’; // XML definition files
$data_year = 2012;
$data_semester = 1; // 1-spring 2-summer 3-fall
$data_semester_name = ‘Spring’;
$data_instructor_parent = 1812; //this value stays the same
if($SITE==’LIVE’) {
$data_course_parent = 7714; //change this value according to the parent container
…
Note 7714 is the object id in modx, for which all the course instances will be created. Check the other convert files for examples.
9. From your browser, visit the php file you just edited, e.g.: http://law.gmu.edu/assets/snippets/csv_new/convert_schedule_2012_spring.php
10. Note all red lines are errors or warnings. Make sure they are properly dealt with. If the script says it will create a new instructor for you, make sure the newly created instructor does not already exist in the system. Even small typo can trigger the script into thinking we need to add another instructor.
11. Submit the form, until the page shows no error and there is nothing more to do.
12. IMPORTANT! Now you must change back the script permission:
chmod -R 000 csv_new/
Update course descriptions to point to the new semester
Edit “2012_course_info.html” template in (elements/manage files/templates) change the header and the &parent code.
Update course container
1. Inside MODX: Academics -> Course Schedules and Assignments -> Pick the newest course schedules (example: 2013 Course Schedules) –> Pick the newest semester (example: 2013 Summer)
2. Edit the parent. Add URL alias.
3. Edit resource content: [!course_instances? &semester=`2` &year=`2013` &updated_threshold=`0`!] (1-spring 2-summer 3-fall)
4. In setting tab, check “published” and “container”
5. Hit “save.”