Title: Problem with Event Importer Last modified: August 21, 2016 --- # Problem with Event Importer * [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years ago](https://wordpress.org/support/topic/problem-with-event-importer/) * Hi * I have just started using your plugin and configuring events for my pool league. * I am using the events as my league fixtures and wanted to import them in using the csv but, i run through the process and it says completed, but there is nothing in either the front end of in the database (checked directly) but the csv is uploaded ok. * Am i missing something my CSV looks like this: * ``` Date,Time,Venue,Teams 06/11/2014,20:00:00,The Saxons,Saxons A ,,,Golden Lion 06/11/2014,20:00:00,The Turnpike,Steventons ,,,Eight Farmers 06/11/2014,20:00:00,Knights Grange,Knights Grange ,,,Top House 06/11/2014,20:00:00,The Rifleman,Rifleman ,,,The Turnpike 06/11/2014,20:00:00,Boars Head,Boars Head ,,,Red Knights ``` * [https://wordpress.org/plugins/sportspress/](https://wordpress.org/plugins/sportspress/) Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/) * (@themeboy) * [12 years ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4933823) * Hi there, * When importing events, be sure to use the date format yyyy/mm/dd. * Hope this helps 🙂 * Thread Starter [adviceit](https://wordpress.org/support/users/adviceit/) * (@adviceit) * [12 years ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4933983) * I’ll give that a go, them example CSV from the plugin the date format is: * `mm/dd/yyyy` * [massimo.marra](https://wordpress.org/support/users/massimomarra/) * (@massimomarra) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934003) * i have imported a file. it’s ok but not for Yellow Cards and Red Cards * for example this row ,,,,,,Rizzo Giancarlo,2,,1, insted of consider the number 1 as yellow card, it’s put into Assists Column into the database. * and in thi row ,,,,,,Fracasso Giuseppe,1,,,1 the last 1 meand Red Cards and in the database is put into others column. * therefore, i think is need to verify the import program for fields after player * Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/) * (@themeboy) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934006) * Hi massimo.marra, * The player performance (Yellow Cards, Red Cards, Assists, etc) will be inserted in the same order as they are in your events. When creating your events CSV please check that the columns are in the same order as they appear when editing events in wp-admin. * If the issue persists, could you paste the contents of SportsPress > System Status here? (use the “code” button) * [massimo.marra](https://wordpress.org/support/users/massimomarra/) * (@massimomarra) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934070) * dear themeboy, i’ve imported a file qith thie rows 2014/03/05,21:00:00,Club 178 Zona PIP – Tricase,AUXILIUM MIGGIANO,0|2|2,LOSS,,,,, ,,,,,,Martire Antonio, 2,,, ,,,PROCIV SURANO,3|0|3,WIN,,,,, ,,,,,,Rizzo Giancarlo,2,,1, ,,,,,,Fracasso Giuseppe,1,,,1 the last two rows includes one yellow card and one red cards but when i import the yellow card fields is set into assist and red cards fields into another fields. if you tell me that the row is written correct, you can verify ewith your system. thank for this plugin. * Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/) * (@themeboy) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934071) * Hi again! * Could you provide me with the output from SportsPress > System Status? * [massimo.marra](https://wordpress.org/support/users/massimomarra/) * (@massimomarra) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934075) * ``` ### Environment ### Home URL: http://www.usaclipuglia.it Site URL: http://www.usaclipuglia.it SP Version: 0.9.3 WP Version: 3.9.1 WP Multisito Attivato: No Web Server Info: Apache PHP Version: 5.3.3-7+squeeze14 WP Memory Limit: 40 MB - Si consiglia di impostare la memoria ad almeno 64 MB. Vedi: Aumentare la memoria allocata a PHP WP Debug Mode: No Lingua WP: it_IT WP Dimensione Max Upload :32 MB PHP Post Max Size: 32 MB PHP Time Limit: 120 PHP Max Input Vars: 1000 SUHOSIN Installato: No Fuso orario predefinito: Il fuso orario predefinito è UTC fsockopen/cURL: Il server ha abilitato fsockopen cURL è disabilitato. SOAP Client: Il server ha il SOAP class Client abilitato. ### Plugins ### Plugin installati: SportsPress by ThemeBoy versione 0.9.3 ### SP Configuration ### Sport: soccer Event Outcomes: Win (win) [10] Draw (draw) [20] Loss (loss) [30] Team Results: 1st Half (firsthalf) [10] 2nd Half (secondhalf) [20] Goals (goals) [30] Player Performance: Goals (goals) [10] Shots on Goal (shotsongoal) [20] Assists (assists) [30] Fouls (fouls) [40] Fouled (fouled) [50] Yellow Cards (yellowcards) [60] Red Cards (redcards) [70] Table Columns: Punti (pts = $win * 3 + $draw ) [5] Differenza goal (gd = $goalsfor - $goalsagainst ) [8] Partite giocate (p = $eventsplayed ) [20] Vinte (w = $win ) [20] Pareggi (d = $draw ) [30] Perse (l = $loss ) [40] Goal fatti (f = $goalsfor ) [50] Goal subiti (a = $goalsagainst ) [60] Player Metrics: Height (height) [10] Weight (weight) [20] Player Statistics: Appearances (appearances = $eventsplayed) [10] Average Goals per Match (averagegoals = $goals / $eventsplayed) [20] Win Ratio (winratio = $win / $eventsplayed * 100) [30] Draw Ratio (drawratio = $draw / $eventsplayed * 100) [40] Loss Ratio (lossratio = $loss / $eventsplayed * 100) [50] ### SP Taxonomies ### Leghe: Protezione Civile Provinciale Lecce (protezione-civile-provinciale-lecce) Stagioni: 2014 (2014) Luoghi: C.S. Vitale Nuzzo - sp 208 - Castro (c-s-vitale-nuzzo-sp-208-castro) Campo Comunale - Cutrofiano (campo-comunale-cutrofiano) Campo Comunale - Scorrano (campo-comunale-scorrano) Club 178 Zona PIP - Tricase (club-178-zona-pip-tricase) Posizioni: ### SP Post Types ### Eventi : 4 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Calendars: 1 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Squadre: 8 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Tabelle League: 1 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Giocatori: 14 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Lista giocatori: 2 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit Personale: 0 publish 0 future 0 draft 0 private 0 trash 0 auto-draft 0 inherit ### Tema ### Nome del tema: Accessible OneTwo Versione del tema: 0.2 URL Autore: http://daniemon.com/ ### Templates ### Template Overrides: Nessun override presente nel tema ``` * _[Moderator Note: Please post log files between backticks or use the code button.]_ * Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/) * (@themeboy) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934082) * Thank you for that. * I see that there are 7 columns for player performance. The sample CSV file only includes 4 columns, so be sure to change the columns to reflect these. * Instead of: Goals Assists Red Cards Yellow Cards * Add these columns: Goals Shots on Goal Assists Fouls Fouled Yellow Cards Red Cards * That way, the columns will match up and the values should be inserted in the right order 🙂 * [massimo.marra](https://wordpress.org/support/users/massimomarra/) * (@massimomarra) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934084) * dear themboy, i have dropped some fields of table few minutes later because we use your powerful plugin in order to manage some no-profit soccer league. therefore, for every events, we have only goals, yellow and red. no others information can we have, so we are dropped this column. * however i think that in the case of someone droppen any fields, the import process must go on with success with correct insert in the fields. * if you tell me tha name of single program of import events, i try to search the bug. * thanks * Plugin Author [ThemeBoy](https://wordpress.org/support/users/themeboy/) * (@themeboy) * [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934088) * I understand. In that case, you could change the columns to Goals, Yellow Cards, and Red Cards in the first row of the CSV file. * The importer is located in sportspress/includes/admin/importers/class-sp-event- importer.php * Hope this helps 🙂 Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Problem with Event Importer’ is closed to new replies. * ![](https://ps.w.org/sportspress/assets/icon-256x256.png?rev=1252005) * [SportsPress - Sports Club & League Manager](https://wordpress.org/plugins/sportspress/) * [Frequently Asked Questions](https://wordpress.org/plugins/sportspress/#faq) * [Support Threads](https://wordpress.org/support/plugin/sportspress/) * [Active Topics](https://wordpress.org/support/plugin/sportspress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/sportspress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/sportspress/reviews/) * 10 replies * 3 participants * Last reply from: [ThemeBoy](https://wordpress.org/support/users/themeboy/) * Last activity: [11 years, 12 months ago](https://wordpress.org/support/topic/problem-with-event-importer/#post-4934088) * Status: not resolved