Importing leagues - Editing matches

Any league can now be exported to a CSV file which can be opened in Microsoft Office Excel or other spreadsheet app.

When the correct file opening settings are chosen, you'll see a result like this:

-

NOTE: The column headings are critical, the text must remain the same as the template, i.e. Home_team not Home_Team.

-

NOTE: In Excel the dates can appear masked by ##### symbols, try making column C wider by clicking the right edge of the column header:

-

NOTE: Excel can sometimes convert the date format from YYYY-MM-DD to DD/MM/YYYY which will result in errors on import. If you see this, select the date column and change the data format to YYYY-MM-DD.

.

All matches are listed in their own row.

The teams are numbered to match the team export (See the article on Editing teams)

The most important thing about this feature is the complete freedom to edit the match dates, sessions and rinks, into any pattern necessary, simply edit the numbers to a valid value.

You can even add extra rounds.

-

Some obvious limitations:

• You cannot set dates outside of the season you select on the import page
• You cannot double-book a rink
• You cannot allocate a rink that doesn't exist i.e. Rink 7 on a 6-rink club
• You cannot allocate a team number that doesn't exist i.e. Team 13 in a 12-team league

-

Divisions

The divisions column will be populated with letters A,B,C etc. These will correlate with the team numbers and round numbers to define the matches.

-

Double rinks

If you want matches to occupy 2 rinks, this is called Sub-teams or Double rinks in Bowlr.

Use the Sub_team column to define one of 3 options:

• 0 = This is a default normal league, 1 rink per match, no sub-teams
• 1 = Sub-team 1 plays this rink
• 2 = Sub-team 2 plays this rink

Example: