Importing Member Info

This import type will upload more information for users after they have been created. For example account ids, addresses, first name, and last name. 


See her for an example CSV Import file


To import member info into the system, create a CSV file that adheres to the following rules.

  • The first column of your import is how we will look up the user for whom you want to import. The first row should include a header with one of the following values, corresponding with the identifier you use.
    • user_id
    • account_id
    • email
    • username
    • member_id
    • student_id
    • customer_id
    • pid
    • oktaid
    • phone_number - must be 11 digit format with country code, area code, and phone number. Example: 19522177561
  • You may optionally include columns with the headers
student_id, member_id, first_name, last_name, address, city, state, zip, phone, priority_points, relationship_status, ticketmaster_id

Note

  • Imports will NOT create new users. They will just apply to existing users.
  • If you import ticketmaster id numbers, be aware that it may take several hours for the system to resolve the ID and import ticketmaster data.

  • An example entry would look like this:

    This would update the 'test@fanmaker.com' user and set their member id to '1234'

email memberid
test@fanmaker.com 1234

Note:

Please save your .csv files using the MS-DOS Comma Separated value option for best import results!