Import issues

  • Resolved emm3

    (@emm3)


    10 years, 8 months ago

    Hi I’m struggling with the import of events. The events are importing fine but the ‘TEAM’ field is not allocating the event to two teams? I am getting the event title as ‘TEAM1 vs TEAM 2’ but it’s creating a new team called ‘TEAM1 vs TEAM 2’ rather than Team 1 appearing in one field and Team 2 appearing in the other? Hope that makes sense?

    If I put in an event manually I can make Team 1 the first team and Team 2 their opposition?

    https://ww.wp.xz.cn/plugins/sportspress/

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author Brian

    (@brianmiyaji)

    10 years, 8 months ago

    @emm3 Each team in the event will need to be on its own row. The first row should just say “TEAM1” and directly below that, “TEAM2”. See the sample csv file in sportspress/dummy-data/events-sample.csv for an example.

    Thread Starter emm3

    (@emm3)

    10 years, 8 months ago

    I did try that and I got twice as many events imported, in other words one event with one team and no opponent 🙁

    I’m pretty sure I was importing data that directly matched the teams that are already input but it’s not picking that up, it’s not taking the 1st two events and creating a single event with the 1st two rows as opponents and then moving on to the next? I think that is what you are saying should happen?

    Looking through the forum a lot of people have struggled with this and the sample doesn’t really help in the sense that there is no mention of opponents. Would it not be easier to have a heading ‘HOME TEAM’, and another ‘AWAY TEAM’.

    At the moment I can put TEAM1 vs TEAM 2 and get a ton of events that I have to go into individually to assign teams and then delete all the non-existent teams that the import created. It’s either that or do hundreds of events manually?

    Plugin Author Brian

    (@brianmiyaji)

    10 years, 8 months ago

    @emm3 The importer is something that we’re aiming to improve in the next update. The reason we started with a “Team” column instead of “Home” and “Away” was to accommodate sports with more than 2 teams per event. We’ll still use the current version as a fallback but will be introducing an improve import tool with home and away columns as many users have suggested 🙂

    Thread Starter emm3

    (@emm3)

    10 years, 8 months ago

    Thanks Brian that’s good to hear but as far as my issue goes right now are you saying that there is no way to import an event where the event picks up on the two different teams within that event and assigns them as opponents??

    Plugin Author Brian

    (@brianmiyaji)

    10 years, 8 months ago

    @emm3 With the current version, the following CSV format will work for importing events with multiple teams:

    Date,Time,Venue,Teams,Results,Outcome,Players,Goals,Assists,Yellow Cards,Red Cards
2015/11/11,11:00:00,My Venue,Team 1,,,,,,,
,,,Team 2,,,,,,,
2015/12/12,12:00:00,My Venue,Team 1,,,,,,,
,,,Team 2,,,,,,,
    Thread Starter emm3

    (@emm3)

    10 years, 8 months ago

    Ok I’m being stupid I think. I have tried every which way to no avail.

    I have set out all the Column headings as you have (same capitalisation, same order , some empty fields because we don’t have results).

    In the next row I have filled in the req fields with ‘Team 1’ in the ‘Teams’ column.
    Underneath that I have filled in exactly the same fields as the row above with ‘Team 2’ in the ‘Teams’ column.

    It imports 2 events both scheduled for the same time and place etc but one with Team 1 and no opponent and the other with Team 2 and no opponent.

    I have also tried with “,” where the field information is a duplicate of that above in case that was what you meant but I get one event imported and one not.

    Please can you walk me through this like I’m a five year old because the prospect of doing this manually is out of the question. I’ve got hundreds of events to input, 4 leagues, 6 teams and 2 seasons.

    Plugin Author Brian

    (@brianmiyaji)

    10 years, 8 months ago

    @emm3 Did you fill in any of the other fields in the row with Team 2? All other fields in that row should be empty (not the same as the row above it). This might be the issue.

    Thread Starter emm3

    (@emm3)

    10 years, 8 months ago

    Eureka! that’s it, thank you Brian. Might be a good idea to put that in the help docs for numptys like me 😉

    Plugin Author Brian

    (@brianmiyaji)

    10 years, 8 months ago

    @emm3 Glad to hear that! Yep, we’re still populating the help docs so will be sure to include more details about the import tools.

    Please mark this ticket as resolved 🙂

    Thread Starter emm3

    (@emm3)

    10 years, 8 months ago

    Thanks!

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

The topic ‘Import issues’ is closed to new replies.

Tags