How to import teams and rosters from a spreadsheet

When your teams and their players are already in a spreadsheet, import them instead of adding them one by one. Each import fills one division, and nothing is created until you’ve checked a preview of what the file will do.

Before you start

• You need to manage the event.
• Importing needs a subscription, or a plan bought for this event.
• The teams aren’t locked. See how to lock parts of your event.

Prepare your file

Each row of the file is one player: their team’s name, first name and last name, then their jersey number and email if you have them. A team with ten players takes ten rows, each with the team’s name. The first row names the columns. ดาวน์โหลดเทมเพลต, in the นำเข้าจาก CSV menu, gives you a file with the columns already named.

• The team’s name, first name and last name are required. A jersey number is a number.
• A team name that matches a team already in the division, whatever its capitals, adds the players to that team instead of creating another.
• An email that belongs to a Dodgeball Hub account adds the player as that person. The import emails nobody.

From your spreadsheet app, save or download the sheet as a CSV file.

Steps

1. In your event’s planner, click การลงทะเบียน in the sidebar.

   

2. Click นำเข้าจาก CSV above the list of the division the teams go to.

   

3. Click อัปโหลดไฟล์ CSV and choose your file. To paste the file’s contents instead, click วางข้อมูล CSV.

   

4. Check that each field is matched to the right column of your file. ชื่อทีม, ชื่อ and นามสกุล are required. A field with no column shows ไม่นำเข้า and stays empty. Click ถัดไป.

   

5. The preview lists the file’s teams. ทีมใหม่ creates the team. ตรงกับทีมที่มีอยู่แล้ว adds its players to the team of that name already in the division. มีหลายทีมที่ตรงกับชื่อนี้ asks you to pick which, or สร้างเป็นทีมใหม่. A new team the division has no room for is marked จะถูกใส่ในรายชื่อสำรอง.

   

6. A row with a problem, such as a missing name, a jersey number that isn’t a number or an email that isn’t valid, is flagged แก้ไขแถวนี้หรือยกเว้นเพื่อดำเนินการต่อ and left unticked. Point at the flag to see what’s wrong. Fix the row in your file and upload it again, or leave it out. A player already on a matched team is marked อยู่ในทีมนี้แล้ว and left unticked too, so importing the same file twice adds nobody twice.

   

7. Type a missing jersey number in the หมายเลขเสื้อ column if you have it, and untick any row you’d rather leave out.

   

8. Click นำเข้า. It stays greyed out while a ticked row is flagged, or while a team that matches several teams waits for your choice.

   

9. The summary counts the teams created and updated, and the players added or linked to their accounts. If some couldn’t be imported, ดาวน์โหลดรายงานปัญหา lists them with the reason. Click เสร็จสิ้น.