Schedule

Stutgrtguy · Post by **Stutgrtguy** » Sat Jun 24, 2017 6:46 am

Gettin close to preseason now and work has had me runnin and still havent had time to input the schedule. Has anyone put the schedule in their DB yet?

jhronesz · Post by **jhronesz** » Tue Jul 04, 2017 6:57 pm

I'll be doing mine soon, so I'll post it when I have it done.

jhronesz · Post by **jhronesz** » Wed Jul 05, 2017 5:27 pm

Attached is an excel schedule in a zip file. After you export the excel file, all you have to do is import it into the access database (or sql if you using that). With the change in SD to LA Chargers, you will have to make the necessary changes within your site to name the chargers to LAC and the rams to LAR. It is in several pages and you will also have to rename several css pages and team logo pngs. If anyone needs a list of what files need changed, let me know and I'll try to put one together.

Stutgrtguy · Post by **Stutgrtguy** » Sun Jul 23, 2017 2:24 pm

Thank you jhronesz for your hard work!

Unfortunately I couldnt open the xl file, prob because i still work on 2003 office...lol
So I had a couple days off and spent the 4 hours to just overhaul my whole DB. It needed some attention anyways. I didn't change the chargers yet, I may do so later, but that list would be nice. off hand I'm guessin the css, logo, entry in db...?

I did it last year for the rams, just don't remember all of em, I think the list is posted here somewhere.

Stutgrtguy · Post by **Stutgrtguy** » Sun Jul 23, 2017 2:27 pm

Found it -

[SOLVED] Database updated for 2016/2017 season
Postby 6burgh » Sun Apr 17, 2016 4:37 pm

Here is a copy of the stock database updated for the upcoming 2016/2017 season. Unfortunately, since the Rams moved to LA you cannot just install the database and everything just work this year. I believe I got the right abbreviations from NFL for the new team for it to work with the scoring update. using LA instead of the the old STL abbreviations.

I use the dark theme and have listed the changes I made here. may not be necessary but I like to keep things up to date.
Always have a backup before editing any files! A few edits I have found so far are:

I have made the following edits:
\AspFootballPool_4.0\pool\styles - edit teamLogos.css file ........ replace STL with LA in 1 place
\AspFootballPool_4.0\pool\styles\teams - change file name from STL.css to LA.css and then edit the file to replace STL.jpg with LA.jpg in one place toward the top.
\AspFootballPool_4.0\pool\graphics\teams - Rename file STL.jpg to LA.jpg

Please let me know if something is not correct so I can either correct it or remove it.
Happy Football season!!

edit - Along with the db entry, I'm with jhronesz and guessin LAC, dont know if it really matters, I think the scoring off of nfl would go off "Los Angeles Chargers" instead of LAC...

Mydori · Post by **Mydori** » Wed Jul 26, 2017 6:54 pm

Will you be posting it in dBase format? I'm having trouble with the newer versions of Microsoft Access

Stutgrtguy · Post by **Stutgrtguy** » Tue Aug 15, 2017 6:37 am

I can post it, I'll do it tonight when I get home. I do 21 weeks on mine so I'll have to edit it down to 17 for download.

We might want to sticky how to change teams when they move as we'll be doin the raiders soon...

Edit - sorry so late, been busy at work

ready4football.com · Post by **ready4football.com** » Tue Aug 15, 2017 11:18 am

Also, see post: http://philwojo.com/ASP_Football_Forum_ ... 1198#p1198

Stutgrtguy · Post by **Stutgrtguy** » Tue Aug 15, 2017 9:18 pm

2017-18 Schedule

Copy n paste into your MS DB/Schedule table. I hope everything is correct, if not lemme know, i'll edit

ASP Football Support Forum

Schedule

Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Re: Schedule

Connect with your social network account