Welcome Gary:

This list needs updating, but I believe it's the last one we have
regarding "what needs to be done" (numbers are previous message numbers
in this group):

==========================
> PRIORITY 1 - Handle ASAP
> Type:
> (1) any item that contains errors in data
> (2) data that existed, and is now missing
> ==========================
> HOF ERRORS
> 1235
> 1237
> 1238
> (Sean Forman handling.)
>
> BATTING ERRORS
> 1233
> (KJOK posted corrections.)
>
> PITCHING ERRORS
> 1216-1220
> 1232
> (KJOK posted corrections.)
>
> STINT ID
> 1215
> 1227-1228
> 1230-1231
>
> PLAYER/MANAGER ERRORS
> 1212
>
> DATA ERRORS
> 1129
> 1144
> 1186
> 1191-1194
>
> NEW FILES - errors
> 1091
>
> Positions - Existence/Loss
> 988 - 990
> (We used to have some PR/PH data. We don't anymore.)
>
> ==========================
> PRIORITY 2 - Handle Very Very Soon
> Type:
> (1) Organizational, procedural items for handling BDB
> ==========================
> DISTINGUISH BETWEEN OFFICIAL/UNOFFICIAL ERRORS
> 1241
> (Some are known accepted errors.)
>
> POW-WOW / organizational direction
> 1112-1113
> 1170
> 1202
> (CVS, roles/responsibilities. No movement.)
>
> SCRIPTS / FILE STRUCTURE
> 1092-1093
> 1095-1097
> 1101
> 1109
> 1111 (proposal/accepted)
> 1173 (proposal)
> (Derek to write some of the scripts.)
>
> FAQ - SYNTAX RULES - field delimiters
> 987
> 1032-1037
> (To be used for above.)
>
> Access - 97/2000/XP
> many (macro only confirmed to work with Access 2000)
> 1079
> 1084-1085
> (Tom needs to create the latest schema.ini file, and give direction
> as to producing it programmatically. Scripts may need to be
written.)
>
> ==========================
> PRIORITY 3 - Handle Very Soon
> Type:
> (1) Primary Tables
> ==========================
> EXTRA DATA
> 1110
> 1114
> 1142-1143
> 1208
> (Should be incorporated. Status unknown. Is Derek's XREF for
> Retro/Player ID updated?)
>
>
> ==========================
> PRIORITY 4 - Handle Soon
> Type:
> (1) Design Issues, normalization, keys
> (2) XREF to other databases
> (3) Standards
> ==========================
> SIZE OF FIELDS
> 1213
> (Try to imrpove sizing of DB.)
>
> STINT ID
> 1196
> (Use is inconsistent or wrong.)
>
> PARKS
> 1117-1120
> 1161
> 1181-1182
> 1223
> (Tom/KJOK updated and uploaded. The BDB/TEAMS table should be
updated
> so that it references the new PARK ID, and not the Park NAME.)
>
> TEAMS / FRANCHISES - XREF to retrosheet
> 1145-1147
> 1174-1175
> 1183-1184
>
> http://groups.yahoo.com/group/RetroList/message/1904
> 1907-1911
> (Paul, KJOK reviewing. Discussions to follow. Tom to upload mid-
> Jan.)
>
>
> DESIGN - leagues - create table
> 1055-1062
> 1068-1075
> 1077-1081
> (Paul, KJOK, Tom should propose something.)
>
> DESIGN - normalization - teams/franchises
> 1042
> 1045
> 1049
> 1051-1053
> (Should be implemented, unless more discussions required.)
>
> DESIGN - keys - manager table
> 1043
> (Should be implemented. This is in ERROR.)
>
> DESIGN - keys - lg ID
> 1044
> 1048
> (Should be implemented. This is in ERROR.)
>
> Place Names - ISO standards
> 940
> 950
> 952
> 956
> 960
> 967-969
> (Proposal/resolution required.)
>
>
> ==========================
> PRIORITY 5 - Handle At Some point
> Type:
> (1) Cool add-ons
> (2) Secondary (tertiary?) data/tables
> ==========================
> POSITIONS
> 1178
> 1239-1240
> (Need someone to program the determination of primary positions.
Tom
> has uploaded complex query, but it could be improved.)
>
> Umpires/HOF/Coaches/Executives/no-hitters
> 876
> 879
> 881
> 883-886
> 888-889
> 891-898
> 1133
> 1136-1139
> 1185
> 1199-1201
> (Mike Crain: Umps working on. HOF completed and integrated.
Coaches
> near completion. Executives ongoing.)
> (Derek: working on no-hitters from Mike.)
>
> END-USER INTERFACES
> 1203-1206
> 1209-1210
> 1214
> (Ongoing work by a few individuals.)
>
>
> 19th-century transactions
> 1224
> (Mike uploaded.)
>
> ==========================
> PRIORITY 6 - Unknown
> ==========================
> INSIDE THE PARK HR
> 1163
> (On hold.)
>
> MASTER - DOB
> 1054
> (No one has stepped forward to handle. Not critical.)
>
> Negro League data, Japanese League data, Minor League data,
Executives
> (No note. No one has stepped forward to handle. Not critical.)


--- In baseball-databank@yahoogroups.com, "Gary" <gcohen33@y...> wrote:
>
> Hello,
>
> I'd just like to introduce myself to this group and offer my time. I
> am a lifelong baseball fan, SQL developer, and stat geek. I've been
> known to spend hours on baseballreference.com just for the fun of
it.
> I have just recently learned of the existence of this group and would
> love to contribute in any way, whether it be loading data,
> programming, quality control or otherwise.
>
> If anyone could give me some direction re: what is needed and what
> would be helpful, I would love to hear it.
>
> Thanks,
>
> Gary Cohen