Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment | File | Size | Author |
---|---|---|---|
#12 | NFL2015.gameset.txt | 129.69 KB | tlreiners |
#10 | gameset-2015.txt | 174.06 KB | drubage |
#8 | NFL_2015.gameset.txt | 124.76 KB | drubage |
Comments
Comment #1
Knm_Sports CreditAttribution: Knm_Sports commentedComment #2
jvandervort CreditAttribution: jvandervort commentedWhich 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.
Comment #3
Knm_Sports CreditAttribution: Knm_Sports commentedThanks 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.
Comment #4
drubage CreditAttribution: drubage commentedLet 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.
Comment #5
drubage CreditAttribution: drubage commentedI 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.
Comment #6
drubage CreditAttribution: drubage commentedScratch that, it did import but is not correct yet...
Comment #7
drubage CreditAttribution: drubage commentedOK this should be the correct NFL 2015 Gameset file now.
Comment #8
drubage CreditAttribution: drubage commentedComment #9
Knm_Sports CreditAttribution: Knm_Sports commentedYep 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..
Comment #10
drubage CreditAttribution: drubage commentedI 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
Comment #11
tlreiners CreditAttribution: tlreiners commented@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!
Comment #12
tlreiners CreditAttribution: tlreiners commentedHere 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.
Comment #13
jvandervort CreditAttribution: jvandervort commentedComment #14
jvandervort CreditAttribution: jvandervort commented