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
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'
emailmemberid | |
test@fanmaker.com | 1234 |
Note:
Please save your .csv files using the MS-DOS Comma Separated value option for best import results!