INSTALL

INSTALL

Note: It may be necessary to make Linux shell scripts executable before running them i.e. $chmod +x 'scriptName.sh'

1) Copy Retrosheet folder to C:/Retrosheet and browse to it

2) Create empty file/database retrosheet.db

3) Insert the years you wish to download into ./Year.txt each on separate lines

4) Run 
       $sqlite3 retrosheet.db '.read retrosheet-schema.sql'

4b) Browse to ./data/unzipped and run clean.sh and browse to ./data/parsed if it exists and run rm *.csv, otherwise create data/parsed

5) Browse to ./data/zipped and run 'gen_zip_files.py'

6) Run 'get_zip_files.batch' (Windows) or 'get_zip_files.sh' (Linux)

7) Windows:
       i) Download latest chadwick tools binaries and place in comon/program

   Linux:
       i) Download latest version of chadwick tools and unzip into data/unzipped
        
       ii) Compile the tools using ./configure; make in the chadwick directory

       iii) Copy the compiled tools (or create symlinks) cwevent, cwgame, cwsub into the comon/program directory

7) Browse to data/unzipped amd run 
   Windows:
       i) '$cwevent.bat' then '$cwgame.bat' then '$cwsub.bat' 

   Linux:
       i) 'cwevent.sh' then 'cwgame.sh' then 'cwsub.sh'

7b) Run clean.sh to clean for next time the program is run (in ./data/unzipped)

8) Browse to ./loaders and run 'events.py' then 'games.py' then 'subs.py'

9) Browse to . and run
         $sqlite3 retrosheet.db '.read partition.sql'
		 $sqlite3 retrosheet.db '.read lookup_codes.sql'

10) Can also optionally run $sqlite3 retrosheet.db '.read extras/id_split.sql'
		 
11) Can now delete events_bck and games_bck tables i.e.
         $sqlite3 retrosheet.db 'DROP TABLE events_bck;'
		 $sqlite3 retrosheet.db 'DROP TABLE games_bck;'
		 
12) Run python extras/teamIds.py to insert a team Id cross reference table

13) Run python extras/playerIds.py to insert a player Id cross reference table