Help – User Database, Exporting Members

To export a spreadsheet of Members

  • Click on s2Member (Pro) > Import / Export
  • Click on dropdown User/Member CSV Exportation. Under CSV File Preferences choose Easy-Read (it’s the option under Default)
  • Under CSV File Exportation, change limit from 1,000 to the total number of members (this is stated above)
  • Click on Export Now
  • You will have the option of downloading the file or saving with specific name. You can then sort or specify members within Excel. To sort by role (ie Standard, Corporate etc.) select the equivalent membership level.
  • To exclude the non-members from the spreadsheet filter out “subscriber”, these are non-members. You will need to do this for sending the Science Journal

Membership levels are as follows:

  • Non-Members = subscriber
  • Standard Member = s2member_level1
  • Secondary School Funded (1 teacher) = s2Member_level2
  • Third Level Member = s2member_level3
  • Corporate Member (<120) = s2member_level4
  • Corporate Member (>120) = s2member_level5
  • Student Teacher = s2member_level6
  • Retired Teacher = s2member_level7
  • Lab Technician = s2member_level8
  • Primary Teacher = s2member_level9
  • Primary School = s2member_level10
  • Associate = s2member_level11
  • Honorary = s2member_level12