Issue 6: Data consilidation and ranking mapping
Status:  Accepted
Owner:
Project Member Reported by rui.m...@gmail.com, Jan 7, 2009
Consolidate data retrieved from USNews and Petersons.

Map the ranking of major from USnews  to programs in the database.


Jan 12, 2009
Project Member #1 rui.m...@gmail.com

1. RankingParser.py to generate USNews ranking in /home/rma/qifei/ranking

2. Execute 'stale_prognames.sql' to adjust stale school names in programs

2. Run 'python runclr.py' to change schools in USNews to the same in Petersons

3. Run 'python change_ranking.py' to adjust some non existing ranking

4. Run 'ProgAdder.py' to duplicate programs whose majors don't exsit. Run
TestlogMatcher.py to check if there are still majors which have not duplicated. 

5. Lastly, run 'RankingUpdater.py' to update all the rankings to programs table.

Jan 12, 2009
Project Member #2 rui.m...@gmail.com

1. RankingParser.py to generate USNews ranking in /home/rma/qifei/ranking

2. Execute 'stale_prognames.sql' to adjust stale school names in programs

2. Run 'python runclr.py' to change schools in USNews to the same in Petersons

3. Run 'python change_ranking.py' to adjust some non existing ranking

4. Run 'ProgAdder.py' to duplicate programs whose majors don't exsit. Run
TestlogMatcher.py to check if there are still majors which have not duplicated. 

5. Lastly, run 'RankingUpdater.py' to update all the rankings to programs table.

Jan 28, 2009
Project Member #3 rui.m...@gmail.com
When built from scratch, remember to import the new mapping (major_map.sql) before
assigning ranking. 
Jan 28, 2009
Project Member #4 rui.m...@gmail.com
Total assigned programs: 27208