...
Code Block | ||||
---|---|---|---|---|
| ||||
|=================================|
| Round | Home | Away |
|=============+=========+=========|
| 1 | 1 | 2 |
|-------------+---------+---------|
| 1 | 3 | -1 |
|-------------+---------+---------|
| 2 | 1 | 3 |
|-------------+---------+---------|
| 2 | -1 | 2 |
|-------------+---------+---------|
| 3 | 1 | -1 |
|-------------+---------+---------|
| 3 | 2 | 3 |
+-------------+---------+---------+ |
...
Code Block | ||||
---|---|---|---|---|
| ||||
|========================================================================================| | Round | Home | Away | Day | Time | Green/Rink | Section | |=============+=========+=========+============+==========+================+=============| | 1 | 1 | 2 | 2021-04-01 | 09:15 | 4642 | | |-------------+---------+---------+------------+----------+----------------+-------------| | 1 | 3 | -1 | | 17:30 | 76 | 1 | |-------------+---------+---------+------------+----------+----------------+-------------| | 2 | 1 | 3 | 2021-05-21 | 13:20 | | | |-------------+---------+---------+------------+----------+----------------+-------------| | 2 | -1 | 2 | 2021-05-22 | | 5367 | 1 | |-------------+---------+---------+------------+----------+----------------+-------------| | 3 | 1 | -1 | | | | | |-------------+---------+---------+------------+----------+----------------+-------------| | 3 | 2 | 3 | 2021-11-03 | | 345 | | |-------------+---------+---------+------------+----------+----------------+-------------| | 1 | 4 | 5 | 2021-04-01 | 09:15 | 4642 | 2 | |-------------+---------+---------+------------+----------+----------------+-------------| | 1 | 6 | -1 | | 17:30 | 76 | 2 | |-------------+---------+---------+------------+----------+----------------+-------------| | 2 | 4 | 6 | 2021-05-21 | 13:20 | | 2 | |-------------+---------+---------+------------+----------+----------------+-------------| | 2 | -1 | 5 | 2021-05-22 | | 5367 | 2 | |-------------+---------+---------+------------+----------+----------------+-------------| | 3 | 4 | -1 | | | | 2 | |-------------+---------+---------+------------+----------+----------------+-------------| | 3 | 5 | 6 | 2021-11-03 | | 345 | 2 | +----------------------------------------------------------------------------------------+ |
...
- Ensure your CSV file has a .csv extension; the BowlsLink application may be unable to recognise the file as a fixtures template otherwise.
- Ensure your CSV file's first row represents "column headers" (like 'Round', 'Home', etc), and not a fixture; the BowlsLink template importer is configured to ignore the first row. As such, feel free to use whatever "column headers" make sense to you.
- Ensure every row of your CSV file has values for all three mandatory columns: round-number, "home" team/opponent number, and "away" team/opponent number.
- Round numbers don't have to be contiguous, nor do they have to start at 1; a fixtures template with rounds 5, 21, and 40 is perfectly valid.
- Round numbers do, however, need to be greater than zero (0).
- Like round numbers, team/opponent numbers don't have to be contiguous, nor do they have to start at 1. We recommend, however, that you use team/opponent numbers that are greater than zero (0), as the BowlsLink application reserves numbers less than one (1) for specialised cases (like byes, which are represented using -1).
- Team/opponent numbers must be no greater than 9000.
- Days must conform to the format YYYY-MM-DD.
- Times must use 24-hour time and conform to the format HH:MM.
- Green/rink allocation IDs must identify greens/rinks allocated to the competition to which the fixture(s) belong. The Greens & Rinks Report can be used to generate a list of green/rink allocation IDs per competition.
- Section numbers don't have to be contiguous, nor do they have to start at 1; a fixtures template with sections 7, 2, and 11 is perfectly valid.
- Section numbers do, however, need to be greater than zero (0).
- For any fixture that doesn't define a section number, section ' 1 ' will be used as default.
- For templates that define more than single section, the same team/opponent number must not appear in more than one section. Example: if one section uses team/opponent numbers 1-3, no other section may use these numbers. The exception to this rule is team/opponent numbers below 1, such as -1 (byes).
- A fixtures template that defines more than a single section cannot have its fixtures extrapolated using the Apply the template to how many sections? feature.
...