Bulk Registration Process: Difference between revisions

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...")
 
No edit summary
 
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