The script to update the data in the itology database within the itologyLoadScripts folder only updates the occStats table. Therefore, whenever you go to the index.php code and change the year to display the updated data in the website the map becomes blank. After further research, the index.php calls srv/www/htdocs/m/IndStats.php. In the IndStats code, there is a select command to be executed against indStateITStats table. But, this table is not updated with the 2011 data. This leads me to believe that there is another update script that needs to be ran to refresh the tables that the website is pulling from. I have contacted Jeremy by email on 3/5/2013 to forward the scripts to Karl. Also, the python code in the itologyLoadScripts folder makes calls to query the itology database but the table names are not matched up. It is possible that the code was in the process of being changed. So when running the code to create csv files, you may get errors such as table not found.
The script to update the data in the itology database within the itologyLoadScripts folder only updates the occStats table. Therefore, whenever you go to the index.php code and change the year to display the updated data in the website the map becomes blank. After further research, the index.php calls srv/www/htdocs/m/IndStats.php. In the IndStats code, there is a select command to be executed against indStateITStats table. But, this table is not updated with the 2011 data. This leads me to believe that there is another update script that needs to be ran to refresh the tables that the website is pulling from. I have contacted Jeremy by email on 3/5/2013 to forward the scripts to Karl. Also, the python code in the itologyLoadScripts folder makes calls to query the itology database but the table names are not matched up. It is possible that the code was in the process of being changed. So when running the code to create csv files, you may get errors such as table not found.