Importing Multiple Teams into iScore BB via Admin Website

We will try and answer Questions in this forum. If you are having any issues with iScore Baseball, this is probably the best place to start. You can also search historical posts here.
Post Reply
netgain
Posts: 4
Joined: Fri Apr 27, 2012 6:28 am

Importing Multiple Teams into iScore BB via Admin Website

Post by netgain » Fri Apr 27, 2012 7:24 am

I have 8 teams that I would like to import into iScore Baseball. Is there a preferred structure for the CSV File? What fields are important in what order, and are there any fields which are not intuitive that I should include?
User avatar
mprusak
Posts: 1348
Joined: Tue Jun 29, 2010 7:27 pm
Location: Montgomery, IL

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by mprusak » Fri Apr 27, 2012 7:52 am

Put as many rows of players as you want in the following format:

FirstName LastName Jersey# Position Batting Bats Throws

Only FirstName and LastName are required.
The others are in the order most people have data for.
Position can either be the position # (1 = Pitcher, 2= Catcher, etc) or abbreviation for the position (1B = First Base, LF = Left Field, etc).
Batting can be: Y = Yes, N = No, D = DP, F = Flex.
Bats and Throws can be: R = Right, L = Left, B = Both

For example:

Joe Smith 5 2b y r r
John Doe 8 rf n l r

This would add:

#5 Joe Smith as a second baseman in the batting lineup who bats right handed and throws right handed, and
#8 John Doe as a right fielder not in the batting lineup who bats left handed and throws right handed.
Mark
iScore Baseball 4.533 on iOS8-iPad4 and iPhone 6-Plus

iScore Baseball User Manual:
http://iscoreleagues.com/manual/ <- Check it Out!
User avatar
mprusak
Posts: 1348
Joined: Tue Jun 29, 2010 7:27 pm
Location: Montgomery, IL

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by mprusak » Fri Apr 27, 2012 8:00 am

FTM - am I correct in my understanding that there is no way with this format to skip a field?

i.e. if I want to set the batting to YES, but dont know the positions.

Since it isnt comma deliminated, for example, I cant see a way to let the system to know to skip the position field and read the next value as batting field.

If there is not a way to do this, I think position and batting should be switched. In youth ball, you rarely know the positions (or even care to track them for an opponent), but you know they are all batting.
Mark
iScore Baseball 4.533 on iOS8-iPad4 and iPhone 6-Plus

iScore Baseball User Manual:
http://iscoreleagues.com/manual/ <- Check it Out!
User avatar
FTMSupport
Site Admin
Posts: 13193
Joined: Sat Mar 28, 2009 7:25 pm

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by FTMSupport » Fri Apr 27, 2012 8:26 am

If you put an invalid value for a column it will in effect skip it. So if you don't know positions, you can just put an 'x' in that column for example, and still assign the Batting field.
Check out the new iScore Baseball documentation page!
Includes videos and user manual.
http://iscoresports.com/baseball/training.php#docs
netgain
Posts: 4
Joined: Fri Apr 27, 2012 6:28 am

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by netgain » Fri Apr 27, 2012 8:46 am

Thank you. Can you verify that because I am only loading players I don't need team information? Or should I load players in separate files (by team)? Even better . . . is there a way to include a field for the players "team" so that they are uploaded by team? Or do you have to do that as a separate action after the teams have been established?
User avatar
mprusak
Posts: 1348
Joined: Tue Jun 29, 2010 7:27 pm
Location: Montgomery, IL

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by mprusak » Fri Apr 27, 2012 9:03 am

You batch load players by team.

Either add team from the site or go into existing team on the site, and batch load players from there.
Mark
iScore Baseball 4.533 on iOS8-iPad4 and iPhone 6-Plus

iScore Baseball User Manual:
http://iscoreleagues.com/manual/ <- Check it Out!
netgain
Posts: 4
Joined: Fri Apr 27, 2012 6:28 am

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by netgain » Sun Apr 29, 2012 4:40 am

I have set up Teams and I also have created rosters for each team containing only first and last names (e.g., 2012_WhiteSox.csv). I have tried to import the players. I choose import and next to CSV file I select "choose file" and go to the location where the csv file is located and select it. After I do this the file name appears to the right of "choose file" for a split second but then disappears and no file selected is there. What am I doing wrong? I am using Office 2011 for Mac. Thanks .
User avatar
FTMSupport
Site Admin
Posts: 13193
Joined: Sat Mar 28, 2009 7:25 pm

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by FTMSupport » Sun Apr 29, 2012 8:27 am

The import area you are on is for importing stats data from external systems.

To do a roster import, go to the Teams tab, and either select an existing team you want to import a roster to, or click the "Add Team" button to create a new team. Then click the Roster tab, then the pencil/paper icon to edit the roster. Then click the "Add Multiple" button and you will be given on screen directions on what is expected.
Check out the new iScore Baseball documentation page!
Includes videos and user manual.
http://iscoresports.com/baseball/training.php#docs
netgain
Posts: 4
Joined: Fri Apr 27, 2012 6:28 am

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by netgain » Sun Apr 29, 2012 9:34 am

Thank you FTM. I have 1 remaining issue. When trying to import players I accidentally created a came called season stats which shows up under the games tab on the admin website. Is there a way to delete this game?
User avatar
FTMSupport
Site Admin
Posts: 13193
Joined: Sat Mar 28, 2009 7:25 pm

Re: Importing Multiple Teams into iScore BB via Admin Website

Post by FTMSupport » Sun Apr 29, 2012 10:35 am

If you delete it from your device and then export, it will delete it from the website as well. If you are not seeing it on your device, go to League Manager and make sure the All league has a check next to it, and then check Game Manager again.

If it is actually on the Scorecasts tab, you can remove scorecasts by following the instructions here:

http://iscoresports.com/baseball/kb/faq ... ecasts.php
Check out the new iScore Baseball documentation page!
Includes videos and user manual.
http://iscoresports.com/baseball/training.php#docs
Post Reply