TDC Users Import

TDC Process Guide

This guide walks you through loading TDC users into Fanmaker and linking their TDC IDs. It's two imports: a Create Members load to add the accounts, then a Rewards Identifier load to attach each member's TDC ID.

Why This Matters

TDC IDs have to be in Fanmaker before the system can award TDC points when fans scan tickets at events. Without a TDC ID linked to a member's account, points can't be attributed to them. Get both steps done before any ticketed event takes place.

Prerequisites

• A list of member email addresses

• The corresponding TDC IDs

• Access to Reports & Imports > Imports in the admin

• A spreadsheet application such as Microsoft Excel, Google Sheets, or Numbers

Step 1: Create Members Load

If your fans aren't in Fanmaker yet, import them first.

Prepare Your CSV File

Create a CSV with two columns: email and password.

• email — the email addresses of everyone you're adding.

• password — leave this column blank for every row. Don't enter passwords.

Note on passwords: Fanmaker uses a one-time code login. The first time a fan signs in, a unique alphanumeric code is emailed to them and they use that to log in — there's no password to set up. If you do leave the column blank, a random password is generated behind the scenes and returned in the import's results file; you can safely ignore it.

Existing members are never given a new password by this import — they keep the account they already have.

Save and Upload

1. Save the file as a CSV — any CSV export your spreadsheet app offers will do — or leave it as an Excel .xlsx workbook and upload that.

Note: There's no special save format to hunt for. The importer handles the encodings spreadsheets produce, including the old CSV (MS-DOS) option, and it strips byte-order marks and tidies line endings for you. You can also skip the CSV step altogether and upload an Excel .xlsx file directly — the Imports page reads the first sheet that has data in it.

2. Go to Reports & Imports > Imports in the admin.

3. Choose the Create Members import type and upload your file.

Step 2: Rewards Identifier Load

Once the members exist, link each one to their TDC ID.

Prepare Your CSV File

Create a CSV with three columns: email, identifier, and identifier_type.

• email — must match the addresses already loaded in Fanmaker. This has to be the first column; it's what identifies the member.

• identifier — the TDC ID for that member.

• identifier_type — enter tdc_id on every row.

Tip: The upload window lists every accepted identifier_type value and every accepted first-column lookup key, so you can check your file against it before you upload.

Save and Upload

1. Save the file as a CSV, or upload the Excel .xlsx workbook as it is.

2. Go to Reports & Imports > Imports.

3. Select Rewards Identifier as the import type.

4. Upload the CSV file.

Step 3: Link Your Events to TDC

Attendance scans have to know which TDC event they belong to.

1. Go to Events > Events and open the event you want to track attendance for.

2. Find the Ticketing section of the event form.

3. Beside TDC Events, click + Add.

4. Enter the TDC Event ID and save the event.

You can add more than one TDC Event ID to a single Fanmaker event — attendance scans score against all of them.

Important Reminders

• No special save format is needed. Any CSV export works, and Excel .xlsx files upload directly.

• All uploads go through Reports & Imports > Imports.

• Fans receive a one-time alphanumeric code by email on their first login — no manual password setup is needed.

• Make sure the email addresses in Step 2 match the ones loaded in Step 1.

• Don't skip Step 3. Members can be perfectly loaded and still score nothing if the event has no TDC Event ID on it.