Importing and Exporting Schedules
Sometimes it helps to be able to export a DMB schedule, work on
it in a database or spreadsheet product, and import the modified
schedule back into DMB. Or maybe you have a schedule that you
created in another product and would like to use it in DMB. If you
can get that schedule into a comma-delimited text file in the
format we specify, you can import that schedule.
The user interface for importing and exporting schedules is
pretty much the same. In both cases, the standard Windows file
location window opens, allowing you to find the file you want to
import or specify a file name and location where DMB should write
the export file.
WARNING! If you already have games in the schedule you are working
with, importing a schedule will erase the existing games before
adding the imported games.
Format of the schedule file
An exported schedule file is a plain text file with one
scheduled game per line and commas separating the values that
describe each game. Here are the first few lines of an exported
file:
1,4/5/2000,0,11,7,2,0
2,4/6/2000,0,9,3,2,0
3,4/6/2000,0,1,5,2,0
4,4/6/2000,0,6,8,2,0
5,4/6/2000,0,2,10,2,0
The first item in each row is a sequence
number, starting from 1 and going up to the number of games
in the schedule.
The second item is the date of the
game in a MM/DD/YYYY format.
The third item is the game number within the
day -- 0 for the only game of the day, 1 for the first game
of a double-header, and 2 for the second game of a
double-header.
The fourth item is the ID of the visiting
team and the fifth is the ID of the home
team. You can find team IDs on the Teams tab of the
Organizer window.
The sixth item is the game type, with
the following values:
Game type code
|
Meaning
|
1
|
Pre-season
|
2
|
Regular season
|
5
|
Divisional series
|
6
|
League championship
|
7
|
Org championship
|
In most cases, you should include only pre-season and
regular-season games. The post-season codes are meaningless until
the regular season has been completed and the matchups are
known.
The seventh and last item is the game
status, with the following values:
Game status code
|
Meaning
|
0
|
Unplayed
|
1
|
Completed
|
4
|
Cancelled
|
5
|
In progress
|
If you are building a file to import into DMB, you
should use only the 0 code. DMB will not let you import a schedule
after the season has started.
|