Import a Competition

Contents 1 Import a Competition from an Excel Spreadsheet 1.1 Make a Competition Import File 1.2 Import the Competition 2 Import a Fixture Template 2.1 Save a Fixture Template 2.2 Import a Fixture Template into another database

Import a Competition from an Excel Spreadsheet

From time to time some organisations may find a need to import a single or multiple competition/s into Sportzware Central rather than set the competitions as per normal. This can be done from a MS Excel spreadhseet.

Please note: Only Normal competitions can be imported. Round Robin and Knockout competitions cannot be imported.

Make a Competition Import File

1. From the Navigation Centre, click on the Daily Admin tab
2. Right click on a Competition.
3. Select Create Fixture Export > Excel.
4. The competition fixture will open in an Excel Spreadsheet. Save the file in a suitable location in your computer's directory.
5. If you wish to create a brand new competition in Excel to import into SWC, open the Excel file you have just saved, select all the fixture data and delete it. Now enter the desired competition data into the spreadsheet and save it.
6. Do not change the column headers or their order.
7. Make sure game times are included in the import file. The competition can not be imported into Sportzware Central unless times are present.

Import the Competition

1. From the Navigation Centre, select Import then click Fixture from Excel.
2. Select the import file you have created by clicking on Select Import File. Browse for the file and click on Open.
3. A preview will be shown. Make sure the data in the columns matches the headings.
4. Click on Import.
5. A message may appear that says: 'There is no competition called (comp name) in the database. Would you like to create a new competition of this name?' Click on Yes.
6. A message will appear that says: 'Fixture import data has been verified. Do you wish to proceed with the import of (xx number of) games?' Click on Yes.
7. The fixture will appear in the Edit Fixture screen. You can select any match and edit its details if needed.
8. Go back to the Navigtion Center -> Competition -> Competition Details
9. Select and edit the new competition -> Ladder/Points
10. Select a profile Press Activate this stats Profile
11. Please check all the Competition Details before using the new competition

---

Import a Fixture Template

Save a Fixture Template

1. From the Navigation Centre, click on the Daily Admin tab
2. Click on Full Match Entry
3. Right click on a competition
4. Select Save fixture template.
5. Name the template and click on OK. The fixture will be saved under that name in the database’s fixtures, which can be viewed from the Competitions tab > Custom Fixtures (the folder location on your computer is usually C:/Program Files/Sportzware/Reports).

Import a Fixture Template into another database

1. From the Navigation Centre, click on the Competitions tab
2. Click on Custom Fixtures
3. Right click and select Export Fixture Definition
4. Save the file in a suitable location (eg. flash disk for transfer to another computer, or alternately, you can email the file).
5. On the destination computer, save the file in the following location: C:\Program Files\Sportzware\Reports (or \ Custom Reports).
6. Next time you launch your database, it will automatically add this fixture template to the list of available fixtures.