| |
Admin Functions
bookmark this: Admin Page
FLOW:
Once an application waiver is in your hand, note the transaction id (bottom middle).
Use Display Pending Records to fill out the additional info such as amt paid and check no.
NOTE: Once you have entered this data (hit the update button), the record is
marked for export. The next time you select "export league records" this record will be
included in the persons.dbf, and will not be exported again. So making further
changes to that record via 'Display all Exported Records' will not be reflected in league
organizer.
All that being said. Normal Flow:
1. Login (to logout, hit the logout button and shutdown your browser.)
2. Display Pending Records. Update records.
3. When ready to download, 'Display Ready for Export Records' shows all records that you have
registered since the last export. 'Click on Export League Records' and print off export
page for auditing
4. Download persons.dbf to floppy drive, save as persons.dbf.
(you will be prompted for your password again)
5. open league organizer, merge personnel file.
6. open personnel and you should see the records you just downloaded...
Munchkin Madness Records are not exported, Paul gets a csv download for email blasts
## munchkin export for Paul
./cgi-bin/munchkins.pl > /tmp/munchkins.csv
database backed up every hour
drano
NOTES FOR NEW ADMIN:
What we use this website for:
field status
rec registration - integrated with league organizer and exports to TSA
skills signup - have Paul provide formatted schedule (import function)
email blasts - need email server (with all spam preventers)
database server (mysql)
news (static pages)
ref scheduling
export from league organizer into game skeds online
stats for sponsors
## STEPS FOR NEW SEASON ##
## update constants to reflect new season
## F05 => S06
## review YEARS in templates (YES REALLY DO THIS)
## review cutoff dates in documentroot/rec/register*
## review /var/www/colsoc/cgi-bin/tmpl/display_waiver.tmpl for date values to change
## clear out pending, make all inactive DON'T DELETE
## update PLAYERS set inactive_timestamp = NOW()
## where mark_for_export is NULL and
## exported_date is NULL and inactive_timestamp = 0;
## clear out exported as well...
## update PLAYERS set inactive_timestamp=NOW() where mark_for_export IS NOT NULL and inactive_timestamp=0;
## via.../home/drano/mysql/pre_season_cleanup.sql (use CSA;)
## now Cody will delete her inactive.dbf via league organizer and inactivate all the previous season players.
## ftp new inactive.dbf file
## RENAME mysql INACTIVE table before next step...
## run /home/drano/bin/import_inactive_prod.pl to take the foxpro inactive file, creates INACTIVE TABLE and populates (MUCH FASTER)
select FNAME,LNAME,SEASON,FPOLICYNUM,CERTIF,TEAM,TYPE,BIRTH from INACTIVE where SEASON like '%S08%' and TYPE='4' order by LNAME;
will show the number of players from previous season (change the like statement)
## BLAST EMAILS....TO REMIND THE PROCRASTINATORS
## /home/drano/blast_email/README.blast
## Once REGISTRATION IS COMPLETE
## get Cody's persons.dbf and team.dbf to generate rosters /var/registration/build_rosters/
## /var/www/colsoc/cgi-bin/roster.pl uses the mysql tables and the teamplayer dbfs and generates
## /var/registration/exports/rosters/[team].html
Rosters
## to load game schedules:
## copy database files into /var/colsoc/imports
## schedule.DBF and teams.dbf
## vi parse_sked.pl for new season and run (read script for updates to sked)
## in test, had to drop tables TEAMS, SKED_{SEASON} as root
## to build team page that links to uploaded schedule
## data is pulled from /var/colsoc/imports (need persons.dbf, teams.dbf and schedule.DBF)
## run build_team_page.pl
[root@server2 cgi-bin]# ./build_team_page.pl -h
Usage: build_team_page -b or -f filename
b = build team list
f = use team list file generated
first run -b to see the list of teams,
redirect to a file and sort as you like
then -f file and the teampage will be sorted in the order of the input file
(not pretty but it works)
## outputs /var/registration/exports/rosters/teampage.html
## copy to DOCUMENTROOT/rec/
###### LOBOS/COUGARS ################
Constants.pm is crucial to all of this ./cgi-bin/Constant.pm
Just Before or After Tryouts
1. Get Office to Review PDF Files to Permission to Roster and modify as necessary
2. move last years registration tables, create new tables LC_PLAYERS, LC_PARENTS, LC_TRANSACTIONS
3. update team/coach assignments in Constant.pm and tmpl/lc/display_fix_entry_form.tmpl
## changed #3 on 24may2009, now all team values are in Constant.pm
## TEAMS (team and coach) and TEAM_LIST_ORDER (order of form pulldown)
4. removed age calculation for team assignment, age bracket is linked to team via Constants.pm
DIVISIONS { U11=>99 etc.....}
### Tryouts Notes ###
copy LC_PLAYERS, LC_PARENTS to laptops to be used.
equipment needed:
2 laptops, wireless router, printer (grab windows and mac printer drivers for anyone
who brings another laptop to field)
Program was modified to make duel db inserts for redundancy. Flag at top of program to disable.
##TO DO ##
Make yeargroup even more obvious in output page (different color)
Misc Notes:
## enhancements for Paul
## email blast cgi
## skills updates
## direct database access
## munchkin export for Paul
./cgi-bin/munchkins.pl > /tmp/munchkins.csv
## academy export for Paul
./cgi-bin/export_academy.pl > /tmp/academy.csv
## how to unexport a player
update PLAYERS set mark_for_export=NULL where player_id='12345';
update PLAYERS set exported_date=NULL where player_id='12345';
|
Rec League