- This topic has 3 replies, 2 voices, and was last updated 10 years, 2 months ago by
.
-
Posts
-
Hello, I’ve been testing the plugins on a new website for a private school and I say they do work well, and are well thought out. Thank you! I have been trying to figure out if there is any connection or automation possible from an imported CSV for game Schedules, to automatically create the link to an existing Location that has already been pre-entered in the Locations plugin. It would be Really really Really great, for example if the Locations column had a “San Francisco H.S.” in it and it automatically matched it up with the Locations plugin database (of a same named location San Francisco H.S.) to get the link info from it. Otherwise, for the 46 Sports teams schedules I need to import, for each game I need to edit the game and select the location from the drop down for location. That’s somewhere near 700 or 800 games to edit after importing the schedules – yikes!. Thanks, for any answer you can provide.
Hi Richard,
Welcome aboard! Is it a private school in San Francisco? I grew up in El Cerrito and graduated from St. Mary’s in Berkeley. Back in the day we spent a lot of time in SF and Kezar stadium … Riordan, Sacred Heart, SI.I agree something like this is past due. When I first built the CSV import function, there was no hook to Game Locations and I never went back and added one. The good news is that I’m about to embark on a major upgrade to Game Schedules, which will begin some major structural changes to the MSTW framework, and this upgrade is on the list. (There will be a post and e-mail on this soon. As a Gold Member, you’re now on the e-mail list.) I doubt it will be available in time for football season, but it is coming. Sorry I can’t get it done for you sooner.
Regards,
-MarkHi Richard,
Okay, let me understand. Are you:
(a) entering opponents from the Teams table using the Select Opponent field and inheriting the location from there, or
(b) typing the opponent into the Opponent field, then adding a location from the Game Locations table using the Select Location from Game Locations field?Ass-u-me-ing it is (b), I dug into this a bit and here’s the deal … the location from the locations DB is stored in the Games table as the primary key (the ID if you will) for the location record in that table. That’s sort of the normal and natural way to do it, but that key is different on every system. For the exact same schedule, the key on one WP instance will be different than the key on another WP instance. This is an issue I uncovered in building a bespoke app for another customer. I jotted it down as something I need to address in the next upgrade. The same issue will occur with the Teams table in scenario (a).
So stay tuned, I’m thinking about it.
-Mark
- You must be logged in to reply to this topic.