Creating Lists from Colleague
Only text fields that already exist in Lyris can be used. (See text field dropdown box in Segments)
  1. Download Query to Excel
  2. Make sure all fields exist in Lyris (field names must match exactly)
  3. Make sure there are no blank cells
  4. Save Excel file as CSV
  5. File
  6. Save As
  7. Select CSV as Save As Type

Sample - Lyris Field Names

ACADLEVEL INSTAENDDATE
ACTIVITYID INSTAGRADTYPE
ADDITIONAL_ INSTTYPE
ADDRESS1 ISLISTADM_
ADMISSIONSREP LAST
ADMITSTATUS LIST_
AFFILIATION MAILFORMAT_
APPLICATIONDATE MAJOR
APPLICATIONSTATUS MAJORDESCRIPTION
BESTSTATCONVERTED MEMBERTYPE_
BESTSATM MIDDLE
BESTSATV NICKNAME
BIRTHDATE ORGINCODE
CAREERGOAL PASSWORD_
CHRISTCOLLEGE PROGRAM
CITY PROSPECTSTATUS
COMMENT_ RANKINSTADENOMINATOR
COMMUNICATIONCODES RANKINSTANUMERATOR
CONTACTPURPOSE RANKPERCENT
CONTACTRESULT READSHTML_
CONTACTTYPE SS
CURRENTPOSITIONEMPLOYER ST
DATATELID STARTTERM
DEGREE SUBTYPE_
DENOMINATION TARGET
DOMAIN_ TRANSCRIPTTYPE
EMAIL USERID_
EMAILADDR_ USERNAMELC_
ETHNICCODE VUGRADUATIONYEAR
FIRST ZIP5
FULLNAME_  
GENDER  
GPA  
HIGHSCHOOLGRADUATIONDATE  
HIGHSCHOOLNAME