Enhanced Import for SportsPress extends the default SportsPress CSV importers with advanced features, specifically designed to import fixtures with scores and results data.
What This Plugin Does
This plugin enhances the standard SportsPress Fixtures (CSV) and Players (CSV) importers.
For Fixtures it adds support for:
- Score/Results Import: Import match scores directly from CSV files
- Automatic Results Processing: Automatically creates and updates match results using SportsPress’s native results system
- Auto creation of Calendar and League table: Teams are auto assigned to League Table.
- Backward Compatibility: Works with existing SportsPress CSV formats while adding new capabilities
For Players it adds support for:
- Player ID column (update by ID): When a Player ID is provided, the matching player is updated; otherwise a new player is created. Without a Player ID it behaves like the native importer (using the Merge duplicates option).
- Metric columns: All registered metrics (sp_metric) are available as columns, so metric values can be imported into players. Blank metric cells preserve existing values on updates.
Key Features
- Score Support: Import home and away scores directly from CSV
- Outcome calculation: Use native SportsPress functionality to calculate the outcome of an event.
- Auto create League Table and Calendar: Gives the ability to the user to automacally create a new League Table or/and a new Calendar.
- Teams assignment to League Table: Handles teams assignment to League Table to avoid false positives.
Import Fixtures: CSV Format
The enhanced importer for Fixtures adds the following CSV columns:
- Home Score – Home team score (optional)
- Away Score – Away team score (optional)
Example Fixtures CSV
Date,Time,Venue,Home,Away,Home Score,Away Score,Match Day
2024/01/15,19:30,Stadium A,Team Alpha,Team Beta,2,1,GW1
2024/01/20,20:00,Stadium B,Team Gamma,Team Delta,0,3,GW2
2024/01/25,18:45,Stadium A,Team Beta,Team Gamma,1,1,GW2
Import Players: CSV Format
The enhanced importer for Players supports these additional columns:
- Player ID – If provided, updates the existing player by ID; if not, a new player is created. (optional)
- Metric Columns (sp_metric) – All registered SportsPress metrics will appear as columns; you may import metric values for each player. Any blank metric cell will keep the player’s existing value for that metric.
Example Players CSV
Player ID,First Name,Last Name,Team,Goals,Assists,Yellow Cards
1234,John,Doe,Team Alpha,2,1,0
,Jane,Smith,Team Beta,0,0,1
1236,Tom,Johnson,Team Gamma,1,,2