EL League Database (Or Like)

**dahamsta** · 28/04/2003, 10:15 AM

We have Longford in progress. Joe said he'd do City too, but he's disappeared since we last talked about it. Anyone else?

adam

**Xlex** · 28/04/2003, 10:54 AM

Can we have standard acyroyms for positions

GK - goalkeeper
RB - Right Back
LB - Left Back
CB - centre - back
SW- Sweeper
CM - Centre Midfield
RM - Right-Midfielder
LM - Left-Midfielder
FW - Forward
ST - Striker etc...

Squads...

Senior
U-21
and if we're using CSV, will we putt spaces between clubs rather than comma's??

**joe** · 28/04/2003, 10:56 AM

would it be better to just keep it to GK, DF, MD, FW

might get a bit complicated with the more versatile players otherwise?

**sadloserkid** · 28/04/2003, 11:00 AM

Well you could go down the Championship Manager route Joe...

e.g: Frank Browne D/DM L

or Paul Finucane D LC

**dahamsta** · 28/04/2003, 11:25 AM

Originally posted by Xlex
and if we're using CSV, will we putt spaces between clubs rather than comma's??

Nah, Excel will automatically quote/escape fields that contain commas. Using spaces wouldn't work for clubs like Galway United anyway, would it?

adam

**Xlex** · 28/04/2003, 11:29 AM

yeah copped that... used '/'

**Dodge** · 28/04/2003, 2:49 PM

Just a couple of points. Think we should leave out the middle name bit and also the Squad field. Its unlikely the middle names will be widely available and it might look bad if some have it and others not. Also surely at the start we should limit it to first team squad members (or am I getting this bit wrong)

And while I'm at it Cork are the only club using squad numbers...

Oh and how many previous clubs will we go for? One Pats player has quite a few while others only have Leinster Senioir League clubs, some have reserve/youth team in UK only...

Actually one more thing. Should it have a nationality field. Seems strange it wouldn't in multi-cultural Ireland

**Dodge** · 28/04/2003, 3:11 PM

Hate replying to myself but... I think the fields should be

Surname

First name(s)

Nationality

DateOfBirth

Place of birth

Club

Position

Previous Club (last club)

Signed (date)

Height

Caps (For up to Youth level give only youth, for u21 and over give amount of caps)

**dahamsta** · 28/04/2003, 3:32 PM

Appreciate the feedback Dodge, but as a general response I'm going to leave the fields the way they are for now. I concede that they're not perfect, but if we start fiddling about with it now it's almost guaranteed that someone will be along later to complain that they had already started, or that something else is wrong. My goal is to get a relatively static dataset that I can build around, we can tweak fields later and mods will have an opportunity to correct data from a proper interface then. More specific responses are inline...

we should leave out the middle name

The middle name is optional, but if we have 'em, I don't see any reason not to fill them in.

Its unlikely the middle names will be widely available and it might look bad if some have it and others not.

I don't see why it would look bad, but if nobody fills 'em in we can say bye-bye to the field. If some people fill 'em in, we can keep the field and not display the data for the moment.

Also surely at the start we should limit it to first team squad members (or am I getting this bit wrong)

Obviously first teams are the priority, but I'm not setting a hard limit on it. If someone wants to fill in the details of every professional, semi-professional and amateur player in the country, I'm not going to stop them.

And while I'm at it Cork are the only club using squad numbers...

I thought another club was using them. No matter, Foot.ie welcomes squad numbers, and will display them prominently on their website to encourage other clubs to take up the practice. Joe, it's your turn to write the press release.

Oh and how many previous clubs will we go for?

Many as you like. I'll be putting all Premier and First Division clubs in a separate table in the database, so when I suck this data into a database, I'll be converting all eL club names to their associated keys in that table. Everything else will be listed as a name. I guess historical order will do for the moment, I can munge the data to suit later.

Should it have a nationality field.

It should, but I'm not adding it in now. When we're done with this stage of the, uh, project, I'll consult again on fields and add ones like this to the table. Then the mods will be able to login to the system and update data. Fairy Nuff?

adam

**Dodge** · 28/04/2003, 3:49 PM

Course its fair enough, its not my baby, just throwing in my tuppence 9and the nationality one is the only one I feel strongly on). Its just that the fields are fairly ambigous (Most goals - for who/what?) and could do with clarifying but if you're doing this later, fair enough...

Oh and BTW munge is my new favourite word....

**dahamsta** · 28/04/2003, 4:16 PM

Yeah, been one of my favourites for years.

adam

**dahamsta** · 02/05/2003, 10:07 AM

Thanks to Xlex for taking on and delivering the Longford spreadsheet. Only 9 more to go. Or 21, possibly.

adam

alanb · 09/05/2003, 10:05 PM

i've the galway sheet in progress. will forward it soon lads... best of luck with this!

**dahamsta** · 09/05/2003, 10:37 PM

Thanks Alan. Also thanks to UCD_4_Life, who sent me a spreadsheet for UCD.

adam

**Xlex** · 09/01/2004, 9:22 AM

what happened this?

**A face** · 09/01/2004, 6:59 PM

I will have time soon so i could lend a hand alright ??

It would be great to get something going !!

**EireBadBoy** · 10/01/2004, 3:45 AM

Even I forgot about it.....

A few months before the new Season might be an idea to get it up and running before then.

I'd need to get off my fat arse and do the Derry City one then, considering I queried doing it.

Something useful to do at last!