Import from CSV Files

Currently Venues, Teams, and Games can be imported in bulk via Comma Separated Value (CSV) files. CSV files can be created in Microsoft Excel, and saved in CSV format. Note that if you are working on a Mac, you need to save the files in PC format, NOT the native Mac format.

The following sample CSV files are provided as guides. If you are having problems uploading one of your files, first try to upload one of the sample files. [They work.] Then compare your file against with the sample file, and find what’s different.

  • venues-import.csv Sample Venues CSV format, exported from MSTW Schedules & Scoreboards. It could be created from scratch, and depending on your Excel skills, this is probably faster than entering the venues on the plug’s Venues screen.
  • teams-import-ss-tags.csv Sample Teams CSV format, exported from MSTW Schedules & Scoreboards. Contains some Schedules & Scoreboard data fields which are either not used or converted to the appropriate League Manager fields. Note that this file has no league_slug column, so a league must be specified during the import process, as described below.
  • teams-import-lm-tags.csv Sample Teams CSV format with native League Manager fields. Contains a league_slug column, which allows the import of multiple leagues from the same file. Note that the team_slug field is not required. If it is missing, the team slug will be created from the team_title.

The primary data fields and functions of the CSV Import screen are described and annotated on the screenshot below.

Importing Venues

  1. Venues CSV File. Simply select a CSV file and upload it. Venue files exported from the MSTW Schedules & Scoreboards plugin may be imported without change.

Importing Teams

  1. Select League to Import. If your CSV file contains the teams for a single league, that league may be specified here, rather than in the CSV file. If you want to import multiple leagues from one CSV file of teams, use the .
  2. Teams CSV File. Select the CSV file to upload. Teams files exported from the MSTW Schedules & Scoreboards plugin may be imported without change.
  3. Move Team Logos. If you are importing teams from the same WP site, perhaps exported from the MSTW Schedules & Scoreboards plugin, you DO NOT want to move the Team Logos. They are already on the site, and you DO NOT want duplicates. If you are importing teams from another site, the plugin will move the team logo files for you.

CSV Import Screen