# Adding Counselors or other non-Teachers to your event

#### **<span class="rvts21">Q:</span><span class="rvts20"> Our counselors don't have specific classes with students. Can we mass-import a custom list of "counselors” (teachers), </span><span class="rvts53">as well as class-teacher and class-student associations, into pickAtime?</span>**

---

<span class="rvts21">Yes</span><span class="rvts20">, you can achieve this by using the </span><span class="rvts21">pickAtime Importer</span><span class="rvts20">. This allows you to manually define counselor-student relationships.</span>

#### **<span class="rvts0"><span class="rvts24">Step 1: Prepare Your Data Files</span></span>**

<span class="rvts20">You will need to create and import three </span><span class="rvts119">Tab-delimited text files (</span><span class="rvts120">\*.txt</span><span class="rvts119"> or </span><span class="rvts120">\*.tsv</span><span class="rvts119">)</span><span class="rvts20">:</span>

<div class="rvps10" id="bkmrk-file-type-requiremen"><table style="width: 100%;"><tbody><tr><td style="width: 11.7998%;">**<span class="rvts21">File Type</span>**

</td><td style="width: 12.9834%;">**<span class="rvts21">Requirement</span>**

</td><td style="width: 75.2168%;">**<span class="rvts21">Key Instruction</span>**

</td></tr><tr><td style="width: 11.7998%;">[Teacher file](https://help.pickatime.com/books/pta-setup-guide/page/step-two-import-data-files)

</td><td style="width: 12.9834%;"><span class="rvts20">List of Counselors</span>

</td><td style="width: 75.2168%;"><span class="rvts20">Use your school’s existing staff IDs as the </span><span class="rvts118">TeacherID</span><span class="rvts20">. If your counselors do not have internal IDs, you may generate custom IDs for them. Please ensure each </span><span class="rvts21">TeacherID</span><span class="rvts20"> is unique and consists only of alphanumeric characters.</span>

</td></tr><tr><td style="width: 11.7998%;">[Class file](https://help.pickatime.com/books/pta-setup-guide/page/step-two-import-data-files)

</td><td style="width: 12.9834%;"><span class="rvts20">"Counselor Classes"</span>

</td><td style="width: 75.2168%;"><span class="rvts20">Create a unique </span><span class="rvts117">ClassID</span><span class="rvts20"> (e.g., </span><span class="rvts117">smith\_counselor</span><span class="rvts20">) and </span><span class="rvts117">ClassName</span><span class="rvts20"> (e.g., </span><span class="rvts118">Counselor John Smith</span><span class="rvts20">) for each counselor. </span>

</td></tr><tr><td style="width: 11.7998%;">[Enrollment file](https://help.pickatime.com/books/pta-setup-guide/page/step-two-import-data-files)

</td><td style="width: 12.9834%;"><span class="rvts20">Student Rosters</span>

</td><td style="width: 75.2168%;"><span class="rvts20">Use the </span><span class="rvts117">ClassID</span><span class="rvts20"> from Step 2 and the </span><span class="rvts21">StudentID</span><span class="rvts20"> from the student file you imported earlier. to link them.</span>

</td></tr></tbody></table>

</div>If you have only a few counselors, you can simply manually add them in the Admin UI, and import the enrollment file. To manually add a counselor go to the Class Editor page. Select Add Teacher/Team &gt; Add Teacher. In the dialog box that comes up search for and select your counselor, or select the Add option to add a new counselor. Once completed you will see your counselor listed on the left-hand side of the Class Editor page. Select the counselor and then select the Add Class button. Give your class a name that you will then use on the Enrollment file to link your students to this class.

<div class="rvps10" id="bkmrk--1"></div>#### **<span class="rvts0"><span class="rvts24">Step 2: Run the Import</span></span>**

1. <span class="rvts20">Go to the </span><span class="rvts21">Importer</span><span class="rvts20"> page.</span>
2. <span class="rvts20">Set </span><span class="rvts21">Data Type</span><span class="rvts20"> to "School".</span>
3. <span class="rvts20">Select your specific event from the </span><span class="rvts21">Event</span><span class="rvts20"> dropdown.</span>
4. <span class="rvts20">Upload the files one by one in this order: </span><span class="rvts21">Teacher → Class → Enrollment</span><span class="rvts20">.</span>
5. <span class="rvts20">Click </span><span class="rvts21">Select File and Import</span><span class="rvts20"> for each.</span>

#### **<span class="rvts0"><span class="rvts24">Step 3: Verification</span></span>**

<span class="rvts20">Once the imports are complete, open your event in the </span><span class="rvts21">Admin UI</span><span class="rvts20"> and navigate to the </span><span class="rvts21">Class Editor</span><span class="rvts20">. Here, you can verify that the counselors are correctly linked to their assigned students.</span>