Import Teams and Matches

Should have mentioned using TAB delimited data

I’m not 100% sure without looking at it, but there is a problem with the import function as there’s a field missing that is included in the export.

I’m going to be putting out an update soon (although I’ve said that for a week now), that should fix it. If it doesn’t work after that, let me know…

Hi. What is the field that is missing? If we just add that in will it work? Thanks!

I’m trying to import matches and just keep getting “0 Matched Imported”
Is there a template somewhere we can use to correctly format the worksheet to be imported?

I thought I had seen something on the documentation page, but there isn’t, I’ll have to put something together for that (I didn’t write the plugin, so there’s a lot I’m learning about a few things as I go along as well)…

The best way to duplicate the fields is to add a couple of teams and a couple of matches and export each. Open those files in Excel as tab delimited files so that each column ends up as a new column in Excel, then you’ll see exactly what’s needed to import.

The thing that I’m finding is that you have to be very careful that when you import a group of teams or matches that you get the season and the league structure exactly right. If you are working on a league that’s set up for ‘Championship’ mode and you have groups set up, but the file you’re importing doesn’t, you won’t see anything in the admin section. The teams and matches will be in the database, but they won’t show up. If you have groups set up and don’t have any on your teams as they import, that also won’t show up and if you have the wrong spelling for the season, yet another problem.

I have an updated admin.php file that should fix this problem, if you’re willing to test it for me I’ll post it on pastebin tonight. There are a few other things I’m working on in that file, so I’m not ready for a new version yet, but want to get it out this weekend. This is a key fix… If you’d rather wait, that’s fine too, just let me know.

Thanks

Hi I’m working from an exported excel sheet, opened with columns and then saved as Tab delimitated text. They are still not importing. No clue why.

I am willing to try out your new admin.php file. Let me know where I can grab it.

Thanks!

I finally got this to work, but I can’t use Excel, there is something with the formatting. This is what I did.

1. Export a sample file.
2. Open in Excel > convert to columns.
3. input my own data in the columns.
4. Save as Tab Delimitated .txt file.
5. Open original export file in a Text Editor (Text Wrangler). Leave the headings and delete the rest.
6. Open the Tab Delimitated .txt file in a Text Editor. Copy all the match info and paste into the original exported .csv. Save.
7. Import the original .csv with the new match info.

Hope this helps so others!

Seems like a lot of steps, shouldn’t be that difficult, but thank you for the thorough step through, hopefully we can cut the process down a bit… I don’t think this will help that, but here’s that admin.php file with the new import/export routine. The matches routines are a little different in that it adds stadium and groups, so any of the files you’ve exported won’t work and your excel sheet as a template won’t either. Teams are the same and I think have always worked.

https://pastebin.com/bmqkE5W8

This file is the admin.php file that sits in the admin folder. I’d rename the original, drop this one in and test on a new league. Back up your data first, just to be safe.

I have imported matches and it works except the data isn’t right so I assume the data columns aren’t right. DATE, TIME, MATCH_DAY ARE ALL WRONG. Teams data seems ok tho. I used the export as example but as I’ve read above the export isn’t a good example. So if you’ve updated this function can you please advise.

That’s what we are working at fixing. If you feel up to doing a test download the above file and follow the instructions. Do a new export to test the import, the old export for matches won’t be right.

nope got same result. Date and time not being saved.
I’m using the data columns in this order
Date-season-game-home-away-location-time

do I need to include group and/or score? They will be empty or zero.

worked it out. have to put the date in MySQL format YYYY-mm-dd and all worked fine. For those that can’t import I can’t help you other than this is what I had

date – season – matchday – home – away – time

date format: YYYY-mm-dd
Time format: hh:mm

NB: if you’re using CSV then change the TAB option to , in the import page.

Yes, the date and time should be formatted exactly as it is when you do a sample export…

You only need to export the file to see the format, then copy it into Excel. (to have each field in it’s own column). For matches should be:
date – season – matchday – home – away – time
Delete the header line.
Change the date format to yyyy-mm-dd and overlay, or add your new matches you want to import.
Save the file as Windows Comma Seperated (.csv) file.
Then import this file into LeagueManager, changing TAB to ,
Worked perfectly!

i tried all this and noway i can’t import any game…
this is very frustrating.
Should i copy the new admin.php file or this was released already?