Notes on CSV File Content with E-list Member Lists (Lyris)
One way to add multiple members to a list is by importing a CSV file. Most spreadsheet apps, like Excel, can create this kind of file.
This article applies to: E-lists (Lyris)
Your data must not include any commas.
Each column must have a column heading.
The EMAILADDR_ column is required. This column should contain complete email addresses only, with no extra characters.
- Good example:
pqs665@cornell.edu - Bad example:
pqs665or"pqs665@cornell.edu"
The FULLNAME_ column is optional. No commas!
The DATEJOINED_, ADDITIONAL_ and COMMENT_ columns are optional. No commas!
The MEMBERTYPE_ (membership type) column is optional; only the following values are permitted:
- normal
- unsub
- held
- private
- expired
- held
- needs-goodbye
- needs-hello
- needs-confirm
The SUBTYPE_ (subscription type) column is optional; only the following values are permitted:
- digest
- index
- nomail
- mimedigest
All other columns should be deleted unless you know exactly what you are doing. Contact the IT Service Desk if you have any questions.
Comments?
To share feedback about this page or request support, log in with your NetID