Import 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 here for an example CSV Import file

Import Rules

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

• stripe_cid

Optional Columns

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.

Example Entry

An example entry would look like this:

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

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