The CSV file format is very simple, but formatting errors are the source of most import problems. I suggest you start with the sample files in the plugin’s
/csv-examples directory. Import the one that appears closest to your needs first; then modify it to suit your needs.
The CSV file format starts with a “header row” (the first row of the file) that defines the meaning of each of the columns, then contains one or more rows, each of which will become a data table row. The SPELLING of the header row entries IS VERY IMPORTANT; it MUST be correct. The order of the columns is not important.
TEAMS CSV FILE FORMAT
The TEAMS CSV file format contains the following fields:
team_name – This field should always be present, but if it’s missing, the import function will attempt to use the team_slug field as the team’s name.
team_slug – If present, it will be used as the team slug. If missing, the import function will attempt to create a slug from the team_name field.
team_description – Fills the taxonomy’s Description field for the team (term).
team_link – Links the Team Rosters team to a team in the MSTW Schedules & Scoreboard teams table. This field must be a slug for a team in the MSTW Schedules & Scoreboards teams table. It is not verified on import, but it won’t work if it’s not a valid slug. Note that this field is NOT created by the MSTW CSV Exporter when exporting Team Rosters 3.1.2 data because it did not exist in version 3.1.2. You can add the column to a teams CSV file should you so desire. To reiterate, this column contains SLUGS for teams in the MSTW Schedules & Scoreboards Teams table.
PLAYERS CSV FILE FORMAT
The PLAYERS CSV file format contains the following fields. The Loading Rosters from CSV Files man page describes the interactions between the
player_title -The player title (the player CPT title) is used on the admin side only.
player_slug – The player slug. The software will attempt to create this field if it is missing.
player_photo – The URL of a photo file for the player. This field is discussed on the Loading Rosters from CSV Files man page.
player_teams – A semi-colon separated list of team slugs. (A player can be on more than one team.) This field is discussed on the Loading Rosters from CSV Files man page.
The following fields fill the corresponding fields in the players table, and require no further explanation: