mike92886 Posted September 14, 2018 Share Posted September 14, 2018 Hi...I am new to SportsEngine and it's complete usability. I went searching for this topic on Google and YouTube and have not been successful in my attempts. What I am trying to do is upload an Excel sheet with Players information in the Players section of the Sport Mgmt tab. First off...I help manage a youth rugby club So Cal. We are required to have each player register through a website called AdeptSoft. They manage all the team/player registrations for Southern California. Which the association we play for is called Southern California Youth Rugby (SCYR)... Ok...AdeptSoft has the ability to export the player information that we have already. I didn't want to have the parents go through another registration site to complete again. The formatted CSV I get from there, I convert to an xls. My problem is, I don't know the format in which SportsEngine is looking for. No matter how i format or change field names...it says it is missing a "team instance id". Not sure how to find that id. I have exported teams from SportsEngine and it gives me a number, but I don't if it is Team Instance ID. I saw in a post that there is an excel format that can be used...but I have been unlucky in finding that excel file. Please help...I will be coming up against over 100 registrations soon and don't think i want to go the manual route. Let me know if you need more info...Thank you in advance...I appreciate any help... Kind regards...Mike Link to comment Share on other sites More sharing options...
jpt_lsjba Posted September 17, 2018 Share Posted September 17, 2018 Hello Mike92886, Have you went to the mapping codes tap under website tools, then schedule upload? There you will find a listing of the league, division, and teams sportsengine id's. When you go to this tab it will ask you for the league, season, and subseason you are wanting information about. Hope this helps. Thanks, jpt_lsjba. Link to comment Share on other sites More sharing options...
mike92886 Posted September 17, 2018 Author Share Posted September 17, 2018 Hi jpt_lsjba, I just went there and I don't have that option...It says I need to contact my account manager. I guess I will start there... Thank you...Mike Link to comment Share on other sites More sharing options...
Moderators—SportsEngine HQ Jessica Christiansen Posted September 18, 2018 Moderators—SportsEngine HQ Share Posted September 18, 2018 Hi Mike. If you have already created your Club and Teams, you can download the template that has the correct team ids in. To do this: Access the Admin Control PanelGo to Sport Mgmt > PlayersSelect the Club > Season > SubseasonClick the Down arrow to download the template for the all teams within the subseasonEach Tab of the spreadsheet will represent each of the teams you have created.You should be able to copy and past from your export the necessary player information. Note - leave the Ngin Id blank....the system will add that if for you after the importHopefully this helps! I can send you some screen captures if that helps too. Jessica Pitzel Product Manager - Competition 1 Link to comment Share on other sites More sharing options...
mike92886 Posted September 18, 2018 Author Share Posted September 18, 2018 Hi Jessica... I actually did download the player sheet for the Specific Team I was testing and received a message onscreen that I had 13 players read from file, 13 players created, 0 Updated, and 1 Team involved. But it never showed any players. I may be doing something wrong. thanks for the reply. Link to comment Share on other sites More sharing options...
MJohnson32 Posted August 29, 2020 Share Posted August 29, 2020 I am getting this same message. I know this thread is several years old but is there any answer to how to fix this? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now