Hello
Just wondering if anyone is keeping up with the Gamesets? If not can someone tell me how to create the gamesets? I have been trying to import directly into database but have noticed that the dates are integer and I am not that experienced in SQL to know how to convert.

Wanting to use import function but as noted not sure how to create the Gameset correctly. I have the schedules which include weeks and games.

Thank you

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Knm_Sports’s picture

Issue summary: View changes
jvandervort’s picture

Which sport? The last several years @tlreiners has created the NFL sets. If you are talking NFL, send him a message and see if he is creating 2015 or not.

Yep, the datetimes are unix seconds. I'm not sure if it is worth the effort running a sql dump because there are a lot of collateral tables that would have to be updated as well. Thankfully there are only 256 games or so:) Total pain, I know, that's why we should all send @tlreiners a round of beers.

Knm_Sports’s picture

Thanks Jvandevort for the quick response. I like how the module works, just not to good at unix language or how to create things for it. I will reach out to tlreiners and see what the plans are, or if he will share how he is does it, and will see if I can find a way to make it work.. I was thinking of trying baseball and hockey, and when I saw I could not load the schedule I decided to wait to see if there was others already providing updates, or at least the method on how to do it.. :)

Thanks again for the input.

drubage’s picture

Let me know if you guys hear anything about a 2015 NFL gameset file as we would greatly appreciate having one. If we end up making one we'll post it here for sure but we might end up doing it week by week instead.

drubage’s picture

FileSize
137.51 KB

I think I was able to make the NFL file for this year if anyone else wants to test it out! Remember to rename the file NFL_2015.gameset.

drubage’s picture

Scratch that, it did import but is not correct yet...

drubage’s picture

OK this should be the correct NFL 2015 Gameset file now.

drubage’s picture

FileSize
124.76 KB
Knm_Sports’s picture

Yep it loaded. What are you using to create the file? I and am sure everyone here appreciates the work everyone does.. Just wanting to be able to help and assist if possible :).. Thank you again..

drubage’s picture

FileSize
174.06 KB

I was able to get an XML feed of the NFL schedule for free from here:

http://www.fantasyfootballnerd.com

I then used some sample gameset file from I think 2013 that I massaged and then replaced data with the game data from 2015. For some reason this data already had some pre-set team ids and game ids and things and the import sort of used them but not exactly but this should get you 90% of the way there. Attached is a file I wrote to help generate this data.

-Drew

tlreiners’s picture

@Knm_Sports, I usually manually create the gameset file through the pickem admin GUI using the NFL template.

@drubage, I've downloaded the gameset posted above and will do some testing. Thanks for sharing the gameset!

tlreiners’s picture

FileSize
129.69 KB

Here is an export of the gameset with the logo fix mentioned in #10. I checked 3 random weeks, and the full Denver Broncos schedule from the schedule grid. All looks good.

jvandervort’s picture

Title: New Gamesets » NFL 2015 Gameset
jvandervort’s picture

Issue tags: -Game sets