NTW Logo (Black)

About IEEE

IEEE Membership

Products and Services

Conferences

IEEE Organizations

 

IEEE Nav Bar

 

 

http://www.ieee.org/graphics/onepixel.gif

http://www.ieee.org/graphics/onepixel.gif

 

IEEE Signal Processing Society Santa Clara Valley Chapter


http://www.ieee.org/graphics/onepixel.gif

http://www.ieee.org/graphics/onepixel.gif

 




Administrative Tools for IEEE Santa Clara Valley Chapter Officers


Generate Guest List from Eventbrite Event Report (CSV)

Here are the steps to follow:

  1. Download the Eventbrite Event Report (CSV)
      - make sure that event has a survey question "Are you an IEEE member?" with "Yes"/"No" as choices
      - goto Eventbrite.com Event Page
      - goto Manage -> Analyze -> Event Reports
      - goto Export to CSV: this will get you CSV file, like "report-2015-09-01T2100.csv"

  2. Generate Guest List
      - click here to open the tool in a browser window
      - open Eventbrite Event Report (CSV), using choose file and selecting "report-2015-09-01T2100.csv"
      - to save Guest List, select "export" and it will download a CSV file, like "20150901-210030-checkin.csv"
      - to print Guest List, select "print" and print the webpage
      - to check-in guests, just keep selecting guests as they check-in and "export" at the end
        (can be used from smartphone too)


Export Eventbrite Event Report (CSV) to listserv.ieee.org

Here are the steps to follow:

  1. Download the Eventbrite Event Report (CSV)
      - goto Eventbrite.com Event Page
      - goto Manage -> Analyze -> Event Reports
      - goto Export to CSV: this will get you CSV file, like "report-2015-09-01T2100.csv"

  2. Download "wa-report.csv" from listserv.ieee.org using Report Format "CSV Format (All)"
      - login to listserv.ieee.org
      - goto List Management -> List Dashboard
      - click [View] for the mailing-list
      - select Report Format as "CSV Format (All)"
      - click "submit" to download "wa-report.csv"

  3. (optional) Keep the list of e-mail addresses to discard from mailing-list
      - keep the list of e-mail addresses in "listservDiscardList.txt" (one e-mail address per line)

  4. Generate e-mail body and send it to "listserv(at)listserv.ieee.org"
      - click here to open the tool in a browser window
      - open Eventbrite Event Report (CSV), using choose file and selecting "report-2015-09-01T2100.csv"
      - open Listserv (CSV), using choose file and selecting "wa-report.csv"
      - if available, choose file and select "listservDiscardList.txt"
      - click "Generate Message" to generate e-mail body to be sent to listserv.ieee.org
      - click "Export Message" to save the message into a text file, like "ListservAdd-emailbody.txt"
      - replace "SCV-SPS" with your mailing-list name in "ListservAdd-emailbody.txt"
      - replace "PASSWORD" with your listserv.ieee.org account password in "ListservAdd-emailbody.txt"
      - compose an email to "listserv(at)listserv.ieee.org" and contents of "ListservAdd-emailbody.txt" as e-mail body
        (can be used from smartphone too)


http://www.ieee.org/graphics/onepixel.gif