MAD PUCK Inc.

Add Players manually

To enter each player manually within the Mad Puck app:

​

• Open Mad Puck

• Check that your team is selected in the title bar, if not click on the title bar to change teams.

• Select the “Roster” tab from the bottom of the screen.

• With the "Players" or "Subs/APs" tab selected, select the Add Player (+) menu item

• Select "Add Player"

• If you plan to add several players at once, enable the "Create another player" toggle. After saving each player, you will remain on the add screen.

• Enter the player information. Tip: After entering the first name and last name hit enter on the keyboard to move quickly to the next field.

• Click the Add/checkmark (top right) to save the record or Cancel/X (top left) to discard

Import players with csv file

​

1. First create a CSV file

• Download our CSV template

​

​

​

​

• Open the file in any text editor

• The first row of the CSV file is the header row and should be left unchanged. It will be ignored during import. The header row tells you what Mad Puck expects to be entered for each row following.

• Add each of the players information one row per player. For example the second row of the template shows an example (which you should replace with your own player):

  • ​John,Smith,16,forward,left,N,Y,N

    • Players first name is John, last name is Smith, uniform number ​is 16, they shoot left, play forward, are not an "AP" player (so they are rostered), John is the captain and not an assistant.

​

The columns are:

1. Players first name (required)

2. Players last name (required)

3. Uniform number (defaults to no number if left empty)

4. Position - one of: {forward/defense/goalie/left wing/right wing/center/left defense/right defense} (defaults to forward if left empty)

5. Shoots - one of: {left, right} (defaults to left if left empty)

6. Affiliated player {Y,N} (defaults to no if left empty)

7. Captain {Y, N} (defaults to no if left empty)

8. Alternate captain {Y,N} (defaults to no if left empty)

​

CSV file formatting tips:

• Keep the 1st row (header row). It will be ignored during import. Delete any blank rows

• If you don't enter a value for a column, make sure you still include the comma so the other fields stay correctly aligned. If a value is missing it will use a default value. For example you could use "John,Smith,16,forward,left,,,Y" which is missing 2 values - in this case this player won't be a AP or captain but will be an alternate captain.

• First name and last name are required fields

• If you leave 'uniform number' blank, no number will be associated with that player (starting in Mad Puck 3.9)

• If you open with a spreadsheet tool be careful the format is not altered when saving. It would be best to verify the format in a text editor after saving from a spreadsheet tool, but most spreadsheets should offer a method to export in a CSV format.

• If you can't figure out why your file doesn't import correctly, send us your file to info@madpuck.com and we will fix it up for you (free!)

​

2. Make the CSV file accessible to your device

​

There are a number of ways to make the CSV file accessible to your device. One method is to copy the file to a cloud storage service such as Google Drive or iCloud Drive. Another method is to email the file to an address you use on your device, open the email and then download the file locally to the device (take note of the file name and location you stored the file).

​

3. Import the CSV file into Mad Puck

​

• Open Mad Puck

• Check that your team is selected in the title bar, if not click on the title bar to change teams.

• Select the “Roster” tab from the bottom of the screen.

• With the "Players" or "Subs/APs" tab selected, select the Add Player (+) menu item

• Select "Import players"

• Find the CSV file using the file picker

• That's it! The players are imported into Mad Puck. At the bottom of the screen you will see a message "Player import complete. N players imported". If you see "Y players failed to import" then you either have duplicate players or there are some formatting issues with your file - check out the CSV file tips below.

​

​