Joel Masci

<p>Reports on the size and structure of your database. Shows where your data is distributed among your database tables.</p>
<p><strong>Note: This plugin is somewhat geared towards developers.</strong></p>
<p>See the FAQ for more info.</p>
<p>Some <strong>screenshots</strong> can be found here for the time being: https://github.com/j-masci/wp-db-analyzer</p>
<h3>Contributors & Developers</h3>
<p>Feel free to suggest or add anything that you might find useful:</p>
<p>https://github.com/j-masci/wp-db-analyzer</p>


Database Analyzer

Reports on the size and structure of your database. Shows where your data is distributed among your database tables.

Savvas

<p><strong>Enhanced Import for SportsPress</strong> extends the default SportsPress CSV importers with advanced features, specifically designed to import fixtures with scores and results data.</p>
<h3>What This Plugin Does</h3>
<p>This plugin enhances the standard SportsPress Fixtures (CSV) and Players (CSV) importers.</p>
<p>For Fixtures it adds support for:</p>
<ul>
<li><strong>Score/Results Import</strong>: Import match scores directly from CSV files</li>
<li><strong>Automatic Results Processing</strong>: Automatically creates and updates match results using SportsPress’s native results system</li>
<li><strong>Auto creation of Calendar and League table</strong>: Teams are auto assigned to League Table.</li>
<li><strong>Backward Compatibility</strong>: Works with existing SportsPress CSV formats while adding new capabilities</li>
</ul>
<p>For Players it adds support for:</p>
<ul>
<li><strong>Player ID column (update by ID)</strong>: 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).</li>
<li><strong>Metric columns</strong>: 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.</li>
</ul>
<h3>Key Features</h3>
<ul>
<li><strong>Score Support</strong>: Import home and away scores directly from CSV</li>
<li><strong>Outcome calculation</strong>: Use native SportsPress functionality to calculate the outcome of an event.</li>
<li><strong>Auto create League Table and Calendar</strong>: Gives the ability to the user to automacally create a new League Table or/and a new Calendar.</li>
<li><strong>Teams assignment to League Table</strong>: Handles teams assignment to League Table to avoid false positives.</li>
</ul>
<h3>Import Fixtures: CSV Format</h3>
<p>The enhanced importer for Fixtures adds the following CSV columns:</p>
<ol>
<li><strong>Home Score</strong> – Home team score (optional)</li>
<li><strong>Away Score</strong> – Away team score (optional)</li>
</ol>
<h4>Example Fixtures CSV</h4>
<pre><code>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
</code></pre>
<h3>Import Players: CSV Format</h3>
<p>The enhanced importer for Players supports these additional columns:</p>
<ol>
<li><strong>Player ID</strong> – If provided, updates the existing player by ID; if not, a new player is created. (optional)</li>
<li><strong>Metric Columns (sp_metric)</strong> – 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.</li>
</ol>
<h4>Example Players CSV</h4>
<pre><code>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
</code></pre>
<h3>Credits</h3>
<ul>
<li>Built for SportsPress by <a href="https://savvasha.com/" rel="nofollow ugc">Savvas</a></li>
<li>Based on the original SportsPress importers by <a href="https://www.themeboy.com/" rel="nofollow ugc">ThemeBoy</a></li>
<li>Licensed under GPLv2 or later</li>
</ul>


Enhanced Import for SportsPress

Extends SportsPress CSV importers with score/results support and enhanced functionality for importing fixtures with match outcomes.

Database Analyzer vs Enhanced Import for SportsPress