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. This article goes into some detail about the format of that 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 email addresses only, with no extra characters.
Good example: pqs665@cornell.edu
Bad example: <pqs665@cornell.edu> or pqs665
The FULLNAME_ column is optional. No commas!
The DATEJOINED_, ADDITIONAL_ and COMMENT_ columns are optional. No commas!
The MEMBERTYPE_ (membership type) column is optional, but 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, but 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 with any questions.
Comments?