Importing a fixtures template is a quick and easy way to create fixtures within the BowlsLink application that conform to some custom structure which the application may be unable to "auto" generate.
The BowsLink application expects a fixtures template to be a file of comma-separated values (CSV), where each line of the file represents a single fixture. CSV files are a common way to represent tabular data using only plain text, and many popular spreadsheet applications like Microsoft Excel support saving worksheets as CSV files.
Each fixture is represented using three mandatory values and four optional values. A round-number, a "home" team/opponent number, and an "away" team/opponent number make up a fixture's mandatory values; a time, a day, a green/rink allocation ID, and a section-number make up a fixture's optional values.
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
|=================================|
| Round | Home | Away |
|=============+=========+=========|
| 1 | 1 | 2 |
|-------------+---------+---------|
| 1 | 3 | -1 |
|-------------+---------+---------|
| 2 | 1 | 3 |
|-------------+---------+---------|
| 2 | -1 | 2 |
|-------------+---------+---------|
| 3 | 1 | -1 |
|-------------+---------+---------|
| 3 | 2 | 3 |
+-------------+---------+---------+ |
The template above is a typical representation of a round-robin competition with only 3 teams, where teams play each other only once. The template above includes only the mandatory values for each fixture: a round-number, and two opponent numbers.
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
Round,Home,Away
1,1,2
1,3,-1
2,1,3
2,-1,2
3,1,-1
3,2,3 |
In contrast, the template below is more complex, and includes optional values for each fixture, including a day, time, green/rink allocation ID, and section.
| 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 |
+----------------------------------------------------------------------------------------+ |
Note that in the template above, optional values are just that: optional. A fixture may have a day, but no time; or a time, but no day.
As a CSV file, the template above will look something like:
| 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,
2,1,3,2021-05-21,13:20,,
2,-1,2,2021-05-22,,5367,
3,1,-1,,,,
3,2,3,2021-11-03,,345,
1,1,2,2021-04-01,09:15,4642,2
1,3,-1,,17:30,76,2
2,1,3,2021-05-21,13:20,,2
2,-1,2,2021-05-22,,5367,2
3,1,-1,,,,2
3,2,3,2021-11-03,,345,2 |
It's common for some spreadsheet applications to save CSV files so that all values are delimited by quotation marks - e.g. "1","3","-1". If your CSV file exhibits this trait, don't worry, the BowlsLink importer handles these types of CSV files just fine.
Before attempting to import your own fixtures template CSV file, take note of the following:
...
| Info |
|---|
This page has moved. Click here to visit the page at its new location. |