# Adding Counselors or other non Teachers to your event

<span class="rvts21">**Q**:</span><span class="rvts20"> *Our counselors don't have specific student groups assigned in Blackbaud. 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"> to bypass the standard Blackbaud SKY API sync. This allows you to manually define counselor-student relationships.</span>

#### **<span class="rvts0"><span class="rvts24">Step 1: Adjust Your Settings</span></span>**

<span class="rvts20">To allow manual imports while using Blackbaud, you must first disable the automated sync:</span>

- <span class="rvts20">Navigate to </span><span class="rvts21">Global Setup / Business</span><span class="rvts20">.</span>
- <span class="rvts20">In the </span><span class="rvts21">Single Sign On</span><span class="rvts20"> section, </span><span class="rvts21">uncheck</span><span class="rvts20"> the box labeled </span><span class="rvts21">"Use SKY API, Importer.".</span>

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

<span class="rvts20">You will need to create and import three </span><span class="rvts119">Tab-delimited text file (</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: 17.755%;">**<span class="rvts21">File Type</span>**

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

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

</td></tr><tr><td style="width: 17.755%;">[Teacher file](https://pickatime.com/help/TeacherFile.html)

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

</td><td style="width: 57.5587%;"><span class="rvts20">Use their </span><span class="rvts21">BlackbaudID</span><span class="rvts20"> as the </span><span class="rvts117">TeacherID</span><span class="rvts20">.</span>

</td></tr><tr><td style="width: 17.755%;">[Class file](https://pickatime.com/help/ClassFile.html)

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

</td><td style="width: 57.5587%;"><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: 17.755%;">[Enrollment file](https://pickatime.com/help/EnrollmentFile.html)

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

</td><td style="width: 57.5587%;"><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 Blackbaud to link them.</span>

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

</div>#### **<span class="rvts0"><span class="rvts24">Step 3: 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 4: 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>

---

<span class="rvts21">Note:</span><span class="rvts20"> Because you are unchecking the "Use SKY API Importer" box, ensure that any other automated data syncs you rely on won't be negatively impacted during this manual process. Once you complete the import of the data files, you can activate the ‘Use SKY API Importer’ again.</span>