Step 2: Update School ID

       

SQLSRV_CURSOR_KEYSET ); if(((isset($_REQUEST['bStep2']) && $_REQUEST['bStep2'] == 'Update School Id') || (isset($_REQUEST['bStep2Reprocess']) && $_REQUEST['bStep2Reprocess'] == 'Reprocess') || (isset($_REQUEST['bStep2Save']) && $_REQUEST['bStep2Save'] == 'Save Changes')) && $step == 2) $sql = "select * from ath_Importdatatable order by id"; //where school_id is null else $sql = "select * from ath_Importdatatable order by id"; $result = sqlsrv_query($conn,$sql,$params,$options); $cnt = sqlsrv_num_rows($result); $i=0; while ($row = sqlsrv_fetch_array($result)) { ini_set('max_execution_time', 300); ?>

Race Level	Round	Sex	Event	Place	Athlete	School	School Id	Time/Distance	Performance data
						Add as: );' /> );' />

   

Step 3: Update Event ID

   

SQLSRV_CURSOR_KEYSET ); /* if(((isset($_REQUEST['bStep3']) && $_REQUEST['bStep3'] == 'Update Event Id') || (isset($_REQUEST['bStep3Reprocess']) && $_REQUEST['bStep3Reprocess'] == 'Reprocess') || (isset($_REQUEST['bStep3Save']) && $_REQUEST['bStep3Save'] == 'Save Changes')) && $step == 3) $sql = "select * from ath_Importdatatable where event_id is null order by id"; else $sql = "select * from ath_Importdatatable order by id"; */ $sql = "select * from ath_Importdatatable where isnull(school_id,0) > 0 order by id"; //isnull(event_id,0) = 0 and $result = sqlsrv_query($conn,$sql,$params,$options); $cnt = sqlsrv_num_rows($result); $i=0; $group_id_change = -1; $group_id_max = -1; while ($row = sqlsrv_fetch_array($result)) { ini_set('max_execution_time', 300); ?>

Race Level	Round	Sex	Event Name	Event Id	Place	Athlete	School	School Id	Time / Distance	Perfomance data
			);' />

   

Step 4: Update Athlete ID

 Stands for sec8 schools result.
 Stands for Chsaa schools result.

     

SQLSRV_CURSOR_KEYSET ); /* if(((isset($_REQUEST['bStep4']) && $_REQUEST['bStep4'] == 'Update Athlete Id') || (isset($_REQUEST['bStep4Reprocess']) && $_REQUEST['bStep4Reprocess'] == 'Reprocess') || (isset($_REQUEST['bStep4Save']) && $_REQUEST['bStep4Save'] == 'Save Changes')) && $step == 4) $sql = "select * from ath_Importdatatable where athlete_id is null order by id"; else $sql = "select * from ath_Importdatatable order by id"; */ $sql = "select * from ath_Importdatatable where isnull(event_id,0) > 0 and isnull(school_id,0) > 0 order by id"; // isnull(athlete_id,0) = 0 and $result = sqlsrv_query($conn,$sql,$params,$options); $cnt = sqlsrv_num_rows($result); $i=0; while ($row = sqlsrv_fetch_array($result)) { ini_set('max_execution_time', 300); //To identify section8 league $sql_sec8_league = "select league_id from ath_schools where id=".$row['school_id']; // isnull(athlete_id,0) = 0 and $league_result = sqlsrv_query($conn,$sql_sec8_league); $schools_league = ""; while ($league_row = sqlsrv_fetch_array($league_result)) { $schools_league = $league_row['league_id']; } //To identify section8 league end ?> style="background-color:#FFCC99;" style="background-color:#FF6;" >

Race Level	Round	Sex	Event Name	Place	Athlete Name	Athlete Id	School	School Id	Class year	Time/Distance	Performance data
					);' /> );' /> );' />				0) { $rowAth = sqlsrv_fetch_array($rsAth); $ath_class_year=$rowAth['class_year']; } ?> />

   

Step 5: Update Performance Time/Distance

   

SQLSRV_CURSOR_KEYSET ); /* if(((isset($_REQUEST['bStep5']) && $_REQUEST['bStep5'] == 'Update Time/Distance') || (isset($_REQUEST['bStep5Reprocess']) && $_REQUEST['bStep5Reprocess'] == 'Reprocess') || (isset($_REQUEST['bStep5Save']) && $_REQUEST['bStep5Save'] == 'Save Changes')) && $step == 5) $sql = "select * from ath_Importdatatable where athlete_id is null order by id"; else $sql = "select * from ath_Importdatatable order by id"; */ $sql = "select * from ath_Importdatatable where ((isnull(athlete_id,0) > 0 and isnull(event_type,'I')='I') or (isnull(event_type,'')='R')) and isnull(event_id,0) > 0 and isnull(school_id,0) > 0 order by id"; //isnull(perform_time,0) = 0 and $result = sqlsrv_query($conn,$sql,$params,$options); $cnt = sqlsrv_num_rows($result); $i=0; while ($row = sqlsrv_fetch_array($result)) { ini_set('max_execution_time', 300); ?>

Race Level	Round	Sex	Event Name	Place	Athlete Name	Athlete Id	School	School Id	Time/Distance	Time/Distance (int)	Performance data

   

Step 6: Insert into performance table

Race Level	Round	Sex	Event Name	Event Id	Place	Athlete Name	Athlete Id	School	School Id	Time/Distance	Time/Distance (int)	Performance data