Difference between revisions of "Bulk Registration Process"

From Norwescon Wiki
Jump to navigation Jump to search
(Created page with "== Step 1 - CM == frameless|right|Screenshot 01 * Log into CM * Go to CSV Export under Filtering * Select filter ''(Jeri Lynn Cornish) All active registere...")
 
 
Line 1: Line 1:
 
== Step 1 - CM ==
 
== Step 1 - CM ==
 +
=== Export .csv ===
 
[[File:CM 001.PNG|frameless|right|Screenshot 01]]
 
[[File:CM 001.PNG|frameless|right|Screenshot 01]]
 
* Log into CM
 
* Log into CM
* Go to CSV Export under Filtering
+
* Go to CSV Export under 'Filtering' in the left navigation bar
 
* Select filter ''(Jeri Lynn Cornish) All active registered members''
 
* Select filter ''(Jeri Lynn Cornish) All active registered members''
 
* Click ''Load Filter''
 
* Click ''Load Filter''
Line 12: Line 13:
 
* Membership info for (NWC43E2)
 
* Membership info for (NWC43E2)
 
* Membership Code
 
* Membership Code
 +
* reg number
 
* Badge Display Code
 
* Badge Display Code
 
* The first email address on file - IGNORING Spam Setting
 
* The first email address on file - IGNORING Spam Setting
 +
 +
Then
 +
* Click Export
 +
* Save to your local drive
 +
 +
=== convert data ===
 +
 +
* Open the file you just exported
 +
* Copy all rows (except for headers)from that file into ''Airmeet Data Trx.xlsx''
 +
* Copy Columns J, K & L form ''Airmeet Data Trx.xlsx''' into Columns A, B, C in ''sample_attendee_list.csv''
 +
* Copy City, Country, & origination to all lines
 +
* SAVE
 +
* Upload to airmeet

Latest revision as of 09:00, 31 March 2021

Step 1 - CM

Export .csv

Screenshot 01
  • Log into CM
  • Go to CSV Export under 'Filtering' in the left navigation bar
  • Select filter (Jeri Lynn Cornish) All active registered members
  • Click Load Filter

Verify that the following is checked:

  • First Name
  • Last Name
  • Fan Name
  • Membership info for (NWC43E2)
  • Membership Code
  • reg number
  • Badge Display Code
  • The first email address on file - IGNORING Spam Setting

Then

  • Click Export
  • Save to your local drive

convert data

  • Open the file you just exported
  • Copy all rows (except for headers)from that file into Airmeet Data Trx.xlsx
  • Copy Columns J, K & L form Airmeet Data Trx.xlsx' into Columns A, B, C in sample_attendee_list.csv
  • Copy City, Country, & origination to all lines
  • SAVE
  • Upload to airmeet