Rakonza K-ForCE Help

10.0 Import Starting Lineup

One of the more time consuming tasks is to enter the starting lineup for a game. If your favorite team uses the same, or similar, starting lineup, simply import the lineup from a previously scored game. Even if the lineup is different by three or four batters, the lineup can easily be fixed using K-ForCE's cut/paste capability.

10.1 Import Roster

Another time consuming and error prone task is entering the player and team information. Rakonza K-ForCE supports four different file formats as well as a Windows clipboard format allowing copy-paste from Pocket Excel or text editor. The team name will be inferred from the filename. The league name will be inferred as well, if the filename is of the form ‘League.Team.txt’.

The information imported from the roster includes the player’s jersey number, player name, batting side and throwing arm. The ‘batting side’ and ‘throwing arm’ will be defaulted to ‘R/R’ if omitted.

10.1.1 Comma Separated Values – CSV

Comma separated values, or comma delimited format is a commonly used text format for transferring data between programs. Nearly all spreadsheet programs know how to import and export these files, which usually have a CSV extension. The fields for this text file must be listed in the correct order for K-ForCE to correctly interpret them. Below is an example of the various forms of CSV that K-ForCE is able to correctly interpret:

Each of the above examples will yield identical roster entries.

10.1.2 Text File Format – TXT

One of the most common file formats is simple text. Spreadsheet programs usually place content into the Windows clipboard as {tab} delimited. This is similar to CSV but using {tab} characters instead of commas to indicate separate fields. K-ForCE is very flexible regarding the data contained within text format. The most important factor is the ordering of the fields. The Rakonza K-ForCE Game Information window displays player data in a list formatted as “12 – John Smith (R/R)”. K-ForCE requires text files to contain the player fields in the same order. Below is an example of the various forms of TXT that K-ForCE is able to correctly interpret:

Each of the above examples will yield identical roster entries.

The text file format does NOT allow the use of comma as a field separator. This means names can be specified as “Last Name, First Name” and the comma will be preserved in the name.

In this example, K-ForCE will interpret the name as “Smith, John”.

The text file format can also be pasted from the Windows clipboard into the roster edit window within the Import Roster dialog. This allows you to simply enter player information by typing directly into the edit window, or by typing the information into a text editor like Notepad, then copy-paste into the Import Roster edit window. In fact, copy-paste from Excel and other spreadsheets will work as well. The data doesn’t necessarily need to be separated into cells.

10.1.3 Retrosheet Format – ROS

Retrosheet is formatted as a set of comma separated values. This format has the limitation that no jersey numbers are supplied. Player numbers will be assigned sequentially starting at eleven. The Retrosheet rosters list players in alphabetical order; so import will yield the same results unless there is a conflict with an existing roster. Please visit http://www.retrosheet.org for complete information regarding ROS file format.

10.1.4 Rakonza K-ForCE Roster Format – KRS

This is the same file format that K-ForCE uses to maintain team information. When importing a KRS file, only the jersey number, player name, batting side and throwing hand will be honored. This is most useful when migrating a team from one season to the next, where most of the information is the same. As part of the import process, a new league or team name can be specified; and players can be quickly added or removed.

Home Prev Next