Importing teams with schools

[riosportslive]

Hi just getting started with MSWT on a webiste covering regional high school sports for over 100 schools.

I have input all the schools and was looking at importing the teams. I have also already put the leagues in.

I have been able to import teams into the proper leagues with the csv import. But I was hoping to put the school in the csv record and have the team assigned to the proper school at the time of importing.

The wordpress XML export of the the teams uses the field title team_school. So I thought using team_school as the header for a column would work. I did not.

Is what I am trying to do possible?

I apologize in advance, I am a wordpress novice.

[Mark]

Hi, thanks for your post. This is a pretty sophisticated question for a “WP novice”, so it sounds like you are doing great.

Schools was created for sites not unlike your own. They came about primarily so you don’t have to enter all the data like mascots, logos, etc for all the teams in the same school. And the “School Sports” metabox allowed one site to display the schools teams/sports on each school’s page, but that requires custom coding in that theme.

As far as adding teams to leagues, I’m not quite sure what’s going on with WP Import/Export, but here’s some sexy WordPress stuff that could be a hint. The leagues for a team is not a properties (data elements) of the mstw_lm_team custom post type. A league (mstw_lm_league) is a taxonomy (custom category or tag if you will) into which a team can be placed. (You can actually determine that from the Edit Team admin page). That allows each team to be placed into multiple leagues easily, e.g., the 49ers are in the NFL, the NFC, and the NFC West. That may or may not be the best design, but it was done many years ago, so we will have to live with it.

Let me know.
-Mark

[riosportslive]

Using the csv team import I was able to add new teams and have them assigned to the proper leagues. I don’t have a need right now for a league>conference>division set up. But it is nice to know it is there when i might need it in the future.

My real question is there a way I can set up my csv file so that the school is one of the fields? That way (just like you said) the mascot, colors, etc. would be automatically added.

[Mark]

I’m not sure why it doesn’t work, but WP Import/Export apparently doesn’t handle the posts’ categories/tags. At least I haven’t found a way to do it. Sorry.

[Author]

Posts