• Resolved Scott

    (@scooter1)


    The CSV files do not appear to work when I choose “baseball”.
    For example, when I import events ( with the date and time in the future) it creates the event at the time I imported the CSV. It also lists the venue as the game time, rather than the venue I already have set up and named in “venues”.
    Help with this would be appreciated very much.

    https://wordpress.org/plugins/sportspress/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author ThemeBoy

    (@themeboy)

    @scooter1 A common issue with the event importer is the date format. Please be sure that the date is formatted as “yyyy-mm-dd”.

    If this is already the case, then it sounds like a column might be missing. The first 3 columns should be: Date, Time, Venue.

    Thread Starter Scott

    (@scooter1)

    Ahhhh. The template I downloaded from the “import” section has the date formatted incorrectly: mm-dd-yyyy

    Can you please provide the proper formatting layouts for importing baseball:

    Events: Date – Time – Venue

    Teams: Name – Leagues – Season

    Players: Number – Name – Positions – Teams – Leagues – Seasons – Nationality

    For players, when I list the position in the CSV, should it be the standard abbreviations: P, C, SS, 1B, 2B, 3B, LF, CF, RF ?

    Thank you again 😉

    Plugin Author ThemeBoy

    (@themeboy)

    @scooter1 You’re right, thanks for letting me know! We’ll fix that in the next update. We’ll also improve compatibility with different date formats (or add an option to choose the date format used).

    Regarding the import formats, here are the basic rules for the events CSV importer:
    1. The order of the columns matter, but the labels don’t. This means that the text in the first row can be anything, as long as there are the right number of columns.
    2. The first 7 columns (for any sport) are: Date, Time, Venue, Teams, Results, Outcome, Players.
    3. Following those 7 columns are player performance. The order of these columns should be the same order as those you see when editing an event.
    4. When listing venues, teams, outcomes, and players, use the full post name.
    5. Multiple Teams, Results, Outcomes, and Players can be added to a cell. Separate values with a vertical bar → |

    The current CSV importer does not accept individual player numbers or positions, which must be entered manually (if they are different from the player’s natural number/position).

    We’re working on a dedicated mini-site that will feature in-depth documentation of the plugin, including the import tool. I’ll let you know when the documentation becomes available, as it will explain things much better than I can here 🙂

    Thread Starter Scott

    (@scooter1)

    Great!

    This help a lot. I’m still testing some things and may have more questions regarding imports via CSV.

    Thanks for the prompt attention to this support portal.

    This plugin is awesome! Can’t wait to have it all configured 🙂

    Plugin Author ThemeBoy

    (@themeboy)

    Glad I could help, and happy to hear you’re enjoying the plugin 🙂

    Thread Starter Scott

    (@scooter1)

    Again. Good work!
    See new topic on CSV

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘CSV import templates for baseball’ is closed to new replies.