How To: Snl Tables Upload

AS a League Manager you have to make tables for schedules and results. The following explains the current process and the tools you need IF, you want to upload the file yourself. If you do not have the tools or the knowledge necessary then you will need to email the xls file to the USAAC Webmaster.

Tools:

1) Spread Sheet program that can 'save as' or 'export' the finished file as HTML

2) Plain Text Editor OR an HTML editor. Windows Note Pad or Word Pad should work, its only important that the 'editor' you use does NOT add any inline type of coding or formating.

3) An FTP program that supports SSL

Steps to the final product which is: fixture_snl.php

This is the final file that needs to be uploaded to display for SNL Schedule on the WWW.

Step A) Make your xls or spread sheet tables, enter info and save as normal.

Step

Save the xls file in HTML format.

While the program is open as an xls file use the 'save as' or 'export' feature and save the file as: fixture_snl.html . Normally spreadsheet programs don't have an option to save as PHP, so we use HTML which works just fine in our case (or .htm).

Step C) Using window explorer find your fixture_snl.html file and simply change the name to fixture_snl.php. Simply change the extention from .html to .php You may get a system warning that changing the file extension may cause the file to be unusable, do you want to continue. Answer YES

Step D) Now we need to use our editor tool and prepre the fixture_snl.php file with a few additional lines of code. So lets open the file and do the following:

Find

Code: Select all

	<STYLE>
				 <!--
				 BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small }
				  -->
			 </STYLE>

ADD after

Add the following line:

Code: Select all

<link rel="STYLESHEET" type="text/css" href="../airattack_event.css">

Find next

Code: Select all

<BODY TEXT="#000000">

ADD after

Add the following lines:

Code: Select all

<table width="96%" border="2" cellspacing="0" cellpadding="0" align="center">
	 <tr>
		 <td height="6" colspan="3" class="fancy-inner-t"></td>
	 </tr>
	 <tr>
		 <td width="6" class="fancy-inner-s"> </td>
		 <td  align="center">

Find next

Code: Select all

</TABLE>
	 <!-- ************************************************************************** -->

Add after

Add the following lines:

Code: Select all

	</td>
		 <td width="6" class="fancy-inner-s"> </td>
	 </tr>
	 <tr>
		 <td height="6" colspan="3" class="fancy-inner-t"></td>
	 </tr>
	 </table>

Now you are done with all edits and you simply "Save" the file.

Note: You can check this file and view the local version with your browser at anytime.. before or after the edits

Step E) Usuing your FTP client, ftp fixture_snl.php to our webserver. You are now done

You can view the new file simply by using our USAAC website as normal.

Note: The location of where to put the fixture_snl.php file .. this is critiacl and must be located in the "event" directory (folder) /event

Also, it is advised that you store your original xml file on the webserver for the future, or in the event you have a computer problem or loss of your original. Store originals in the folder "/event/SNL_files

Note: If you are experienced or know what you are doing, several steps above can be short cut.

Note: FTP connection information is NOT given here for obvious reasons. If you need FTP access contact the USAAC Webmaster. The FTP client MUST BE SSL complient.