Strat Draft

Administrator's rights required

Figure 1

Figure 1 shows the Import Auxiliary Players screen which you can use to either import and/or create players not in the Strat Draft database.  To use the import facility, you must get the Export Auxiliary Players report, update it with your information, then import that updated file.  Get the report at Administrative Tools -> League Players ->Import/Export-> Export Auxiliary Players.

Figure 2

TIP:  Using this import facility is not required. Check out auxiliary player status (figure 2) and choose whichever looks easiest for you.

click the area of which you require more information

Figure 3

now you can import auction information!

 

Both the export and import files are represented in standard comma separated data files i.e., .csv files. The best way to create a .csv file is to allow the spreadsheet to save it in a comma separated file.

Figure 3 shows a spreadsheet representation of the export file available from the system. The import file format must be identical to the export file that you receive from this system. Columns A through F show the information that will be exported for any league. Columns H through P shows optional information and may be exported depending on your league settings.  Each player in the export file need not be in the import file, but each player in the import file must be sorted by PlayerID and match the export file in columns mlbTm and player.

Information Specific to Auctions: Players that will be placed in an auction must be designated as x-fa in the origOwner column. They also can not have an x in the available column

team: This is the major-league team that the player was a member of.  May be left blank.

finalOwner: This is the team the system has assigned the player to.  He may be assigned to the team due to the draft or because he was assigned to that team originally and was not placed in the draft.  To assign a player to a team, use the originalOwner column.  Players assigned a team in originalOwner with "inLeague" checked while "available and "fa" are not checked, will show the originalOwner as the finalOwner in the export file.

lastName: The player's last name.

firstName:  The player's first name.

h/p:   Indicates hitter or pitcher.  Enter xh for hitter or xp for pitcher.

ab/ip: Number of innings pitched or at bats.  May be left blank.

fielding/endurance: May be left blank.

inLeague: An 'x' must be placed here to indicate this player is in the league, either in the draft or assigned to a team without being in the draft.

originalOwner:  The same meaning as 'origOwner' in the Strat-O-Matic Standard Player Status page.  If this player is already owned by a team in the league, the column "In League" must have an 'x' in it. The originalOwner column is the current owner and must be represented as an abbreviation as specified in the owners page.  Players in auctions should be marked as x-fa,

available: The same meaning as 'In Draft' in the Strat-O-Matic Standard Player Status page.  An 'x' indicates that this player will be available in the draft.  No entry in this column indicates that the player will not be available.  If the player is already owned by another team and is not offered in the draft as a free agent, leave this column blank.  If however the player is already owned by another team and will be offered in the draft as a free agent, place an 'x' in this column.  Do not place an x in this column for players in an auction.

GroupA:  The same meaning as 'group A' in the Strat-O-Matic Standard Player Status page.  An 'x' or no entry are the only valid entries in this column. Indicates if this player is a member of group A.

GroupB:  The same meaning as 'group B' in the Strat-O-Matic Standard Player Status page.  An 'x' or no entry are the only valid entries in this column. Indicates if this player is a member of group B.

GroupC:  The same meaning as 'group C' in the Strat-O-Matic Standard Player Status page.  An 'x' or no entry are the only valid entries in this column. Indicates if this player is a member of group C.

salary:  The same meaning as 'salary' in the Strat-O-Matic Standard Player Status page.  A number indicating the salary of this player in leagues that allow a salary option.

delete:  If this player is to be deleted, place an 'x' in this column.

auctionFutureStartDate:  The same meaning as 'Start Date' in the Assign Player to Auction page.  The date and time an auction for this player will begin. This entry must be a future date and time rather than a date and time in the past. The player must have an x in the inLeague column, x-fa in the OrigOwner column and blank in the columns available, fa and pullback. The original export of standard players may have either "In Progress" or "Completed" in this column which is a valid value to be imported. Auctions imported containing "In Progress" will be paused for up to 10 seconds as that auction date/time is modified to reflect the value imported. Auctions containing "Completed" may not be altered here but must be canceled through 'Auction Cancel if a change is needed.

auctionEndDate:  The same meaning as 'End Date' in the Assign Player to Auction page.  The date and time an auction for this player will end.

auctionMinYears:  The same meaning as 'Enter Minimum' in the Assign Player to Auction page.  This field may be blank or zero or a number less than or equal to the 'Maximum Contract Length' as defined for your league in League Options. This will indicate the minimum number of contractual years this player will accept. Only one of auctionMinYears, auctionMinDollars and auctionMinPerceivedValue may contain a value greater than zero.

auctionMinDollars:  The same meaning as 'Enter Minimum' in the Assign Player to Auction page.  This field may be blank or zero or the minimum dollars per year this player will accept. Only one of auctionMinYears, auctionMinDollars and auctionMinPerceivedValue may contain a value greater than zero.

auctionMinPerceivedValue:  The same meaning as 'Enter Minimum' in the Assign Player to Auction page.  This field may be blank or zero or the minimum this player will accept for perceived value as defined by '# years preference'. Only one of auctionMinYears, auctionMinDollars and auctionMinPerceivedValue may contain a value greater than zero.