League Administration Software Help File

Label Customize

When you select the menu item [ Personnel.. Labels.. Configure Labels.. Select Label Format ], you can select a default label layout from the many standard Avery (TM) sizes as well as other formats that ship with LAS. Selecting such a format replaces all the settings on this page, including the label contents..

This window allows you to adjust the details of the label format that selected. (The original format will NOT be changed, so you can go back to it in the future.) Choose the margin, width, height, number of labels on a line, etc. Labels are normally printed at 10 characters per inch and 6 lines per inch.

Although used less frequently, you can also customize the content of the label. This requires knowledge of the Foxpro expression syntax and is normally only available to advanced users with a knowledge of Foxpro. To briefly describe what you have available, here is a list of all the fields that you can reference:

LF_INFO -- First line of label... differs depending on the label set selected.
LF_FIRST -- For member labels, contains father's and mother's first name if their last name is the same, and only the father's first name if last name is different. For player labels, this is the player's first name.
LF_LAST -- For member labels, contains the father's last name. For player labels, this is the player's last name.
LF_NAME2 -- For member labels, If the mother's last name is different from the father's last name, this contains the mother's first and last name. Otherwise, it is blank.
LF_BDATE -- Player's birth date.
LF_DIV
LF_TEAM
LF_ADDR1
LF_STREET
LF_HOUSENO
LF_ADDR2
LF_CITY
LF_ZIP
LF_PHN_H
LF_PHN_W
LF_AMT_DUE
LF_AMT_PD
LF_FUNDDUE
LF_FUNDPD
LF_MEM_NO
LF_PLAY_NO

Useful fields that will only be filled for Player labels:

plyreg.pf_unishrt -- Shirt Size
plyreg.pf_unipant -- Pant Size
plyreg.pf_uni_no -- First Uniform Number
plyreg.pf_uni_no2 -- Uniform Number when "Away"
plyreg.pf_socks -- Socks Size
plyreg.pf_shoe_sz -- Shoe Size
plyreg.pf_hat_sz -- Hat Size

Additional Team fields that will be filled for Player and Staff labels:

team.TF_COLOR -- Primary Team Color
team.TF_C_AWAY -- Team color when "Away"
team.TF_C_PANTS -- Color of Pants
team.TF_C_SOX -- Color of Socks
team.TF_C_HAT -- Color of Hats
team.TF_NUMBER -- Team Number

Additional Division detail fields that will be filled for Player, Staff and Umpire labels:

Division.DESC -- Long division description
Division.AGE_BEGIN
Division.AGE_END
Division.WT_LOW
Division.WT_HIGH
Division.GRADE_LOW
Division.GRADE_HIGH
Division.USER_LOW1
Division.USER_HIGH1
Division.SEX
Division.CARRY_TEAM
Division.AMT_CHARGD
Division.FUND_CHARG
Division.USER_LOW2
Division.USER_HIGH2
Division.USER_LOW3
Division.USER_HIGH3
Division.GAME_LEN
Division.PRAC_LEN
Division.BIRTH_MON
Division.BIRTH_DAY
Division.BD_1231
Division.DIV_CODE
Division.LEAGUE_ID

You can always reference all the Member fields:
MemReg.SEASON, MemReg.MF_NO, MemReg.MF_REGISTR, MemReg.MF_REG_DAT, MemReg.MF_M_FIRST, MemReg.MF_M_LAST, MemReg.MF_M_CHCRT, MemReg.MF_M_CHDAT, MemReg.MF_M_OFFCT, MemReg.MF_M_OFFDT, MemReg.MF_M_HELP, MemReg.MF_M_YRSRV, MemReg.MF_F_FIRST, MemReg.MF_F_LAST, MemReg.MF_F_CHCRT, MemReg.MF_F_CHDAT, MemReg.MF_F_OFFCT, MemReg.MF_F_OFFDT, MemReg.MF_F_HELP, MemReg.MF_F_YRSRV, MemReg.MF_LASTYR, MemReg.MF_PLAY_YR, MemReg.MF_AMT_DSC, MemReg.MF_AMT_ADJ, MemReg.MF_AMT_DUE, MemReg.MF_AMT_PD, MemReg.MF_PAY_CMT, MemReg.MF_FUNDDSC, MemReg.MF_FUNDADJ, MemReg.MF_FUNDDUE, MemReg.MF_FUNDPD, MemReg.MF_FUNDCMT, MemReg.MF_F_USAEX, MemReg.MF_M_USAEX, MemReg.MF_LEAGID, MemReg.ModDate, Member.MF_NO, Member.MF_M_FIRST, Member.MF_M_LAST, Member.MF_M_ADDR1, Member.MF_M_ADDR2, Member.MF_M_CITY, Member.MF_M_STATE, Member.MF_M_ZIP, Member.MF_M_PHN_H, Member.MF_M_PHN_W, Member.MF_M_PHN_E, Member.MF_M_PHN_F, Member.MF_M_PHN_C, Member.MF_M_OCC, Member.MF_M_SSN, Member.MF_M_BDATE, Member.MF_M_BGCHK, Member.MF_M_BGOK, Member.MF_M_CMT, Member.MF_M_LAT, Member.MF_M_LNG, Member.MF_F_FIRST, Member.MF_F_LAST, Member.MF_F_ADDR1, Member.MF_F_ADDR2, Member.MF_F_CITY, Member.MF_F_STATE, Member.MF_F_ZIP, Member.MF_F_PHN_H, Member.MF_F_PHN_W, Member.MF_F_PHN_E, Member.MF_F_PHN_F, Member.MF_F_PHN_C, Member.MF_F_OCC, Member.MF_F_SSN, Member.MF_F_BDATE, Member.MF_F_BGCHK, Member.MF_F_BGOK, Member.MF_F_CMT, Member.MF_F_LAT, Member.MF_F_LNG, Member.MF_LEAGID, Member.MF_M_PHN_P, Member.MF_F_PHN_P. Member.ModDate

You can reference all the other player fields for player labels, too:
PlyReg.SEASON, PlyReg.PF_NUMBER, PlyReg.PF_MF_NO, PlyReg.PF_MF_F, PlyReg.PF_FIRST, PlyReg.PF_LAST, PlyReg.PF_LL_AGE, PlyReg.PF_GRADE, PlyReg.PF_YR_EXPR, PlyReg.PF_LASTYR, PlyReg.PF_REGISTR, PlyReg.PF_REG_DAT, PlyReg.PF_REG_NUM, PlyReg.PF_TRY_DIV, PlyReg.PF_TRY_NUM, PlyReg.PF_TRY_COD, PlyReg.PF_TRY_POS, PlyReg.PF_LASTDIV, PlyReg.PF_LASTEAM, PlyReg.PF_DIV, PlyReg.PF_TEAM, PlyReg.PF_AS_DIV, PlyReg.PF_AS_TEAM, PlyReg.PF_UNISHRT, PlyReg.PF_UNIPANT, PlyReg.PF_UNI_NO, PlyReg.PF_UNI_NO2, PlyReg.PF_SOCKS, PlyReg.PF_SHOE_SZ, PlyReg.PF_HAT_SZ, PlyReg.PF_RATING, PlyReg.PF_PLAY_YR, PlyReg.PF_SORT3, PlyReg.PF_PASSPRT, PlyReg.PF_AMT_DUE, PlyReg.PF_AMT_DSC, PlyReg.PF_FUNDDUE, PlyReg.PF_FUNDDSC, PlyReg.PF_LEAGID, PlyReg.PF_USAEXPD, PlyReg.MODDATE, Player.PF_NUMBER, Player.PF_MF_NO, Player.PF_MF_F, Player.PF_FIRST, Player.PF_LAST, Player.PF_BDATE, Player.PF_BCERT, Player.PF_WEIGHT, Player.PF_TALL_IN, Player.PF_SEX_BOY, Player.PF_COMMENT, Player.PF_SCHOOL, Player.PF_SORT1, Player.PF_SORT2, Player.PF_SS_NMBR, Player.PF_INS_NUM, Player.PF_EMERGEN, Player.PF_INS_CO, Player.PF_DOCTOR, Player.PF_DOCPHON, Player.PF_LEAGID, Player.MODDATE

Here are some examples that may be useful to you in adjusting the label content are:

"string"+"string" -- Use a plus sign to concatenate strings
"literal string" + 'literal string' -- Use Double Quotes or Single Quotes to enclose a literal string
ALLTRIM( LF_FIRST ) -- Trim off any spaces before and after the string
"{ALIGN=CENTER}"+ALLTRIM(LF_FIRST)+ALLTRIM(LF_LAST)+"{/ALIGN}" -- Center the name on the label
alltrim(lf_addr2); -- Lines ending in ";" will be removed if the content is blank
PADR( cString, nWidth )
PADL( cString, nWidth )
SUBSTR( cString, nStart, nLength )

All American SportsWare 1245 Jarvis Lane Lansdale, PA 19446-6515
info@AllAmericanSportsWare.com Telephone: 800-869-8435