> For the complete documentation index, see [llms.txt](https://dcyf.gitbook.io/cmshandbook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dcyf.gitbook.io/cmshandbook/upload-tool/step-by-step-instructions-for-uploading-data/upload-attendance-for-individual-activities.md).

# Upload Attendance for Individual Activities

{% stepper %}
{% step %}
**Ensure that Individual Activities have been created in CMS.**
{% endstep %}

{% step %}
**Run the ‘Participant, Parent & Staff Extract’ from the CMS *****Data Extracts***** tab.**
{% endstep %}

{% step %}
**Run the ‘Activity Extract’ from the CMS *****Data Extracts***** tab.**
{% endstep %}

{% step %}
**Filter for “Individual” in the Activity Extract under the Activity Type column (Column F).**
{% endstep %}

{% step %}
**Download the ‘Individual Attendance Upload template’ from the *****Resources***** tab – *****Upload***** section.**
{% endstep %}

{% step %}
**Enter Person IDs, Activity Instance IDs and Attendance Dates for the attendance you wish you upload.** 

Populate the Attendance Date column by entering each date each participant attended each activity. Populate the Attendance Date column by entering each date each participant attended each activity. To populate the Person ID and Activity Instance ID columns in the template, pull Person IDs from the Participant, Parent & Staff Extract and Activity Instance IDs from the Activity Extract. Column A, Attendance ID, is populated only when you are making updates to attendance records.
{% endstep %}

{% step %}
**Populate the Minutes Attended column (column F).**
{% endstep %}

{% step %}
**(Optional) Populate the Staff ID column by pulling Person IDs for staff from the ‘Participant, Parent & Staff Extract’.**
{% endstep %}

{% step %}
**(Optional) Populate Columns G through K.**
{% endstep %}

{% step %}
**Save the file to your computer.**
{% endstep %}

{% step %}
**Click on the *****Upload***** tab in the left-hand menu in CMS.**
{% endstep %}

{% step %}
**Click on the *****Choose File***** button in the Data Upload Tool.**
{% endstep %}

{% step %}
**Select the upload template file you would like to upload. This will upload the file to the Data Upload Tool.**
{% endstep %}

{% step %}
**Select the ‘Individual Attendance Upload (Site-level)’ for Type.**
{% endstep %}

{% step %}
**Click on the *****Begin Upload***** button in the Data Upload Tool.**
{% endstep %}

{% step %}
**(If applicable) Review any error messages, make the appropriate changes and repeat steps 11-15.**
{% endstep %}
{% endstepper %}

## **Update attendance records in Individual Activities:**

You may need to update or change attendance records you have uploaded. For example, you may have accidentally left out referral information or uploaded the incorrect number of minutes. Instead of making these changes manually (i.e. going into the attendance record in CMS), you will need to use the Data Upload Tool.

{% stepper %}
{% step %}
**Run the ‘Participant Attendance Extract’ from the *****Data Extracts***** tab in CMS.**
{% endstep %}

{% step %}
**Download the ‘Individual Attendance Upload template’ from the *****Resources***** tab – *****Upload***** section.**
{% endstep %}

{% step %}
**Pull Attendance IDs for the attendance record you would like to update from the ‘Participant Attendance Extract’.**
{% endstep %}

{% step %}
**Enter the Attendance IDs for the attendance record you would like to update into the upload template.**
{% endstep %}

{% step %}
**Enter the information you would like to upload into the appropriate columns.**
{% endstep %}

{% step %}
**Save the file to your computer.**
{% endstep %}

{% step %}
**Repeat steps 11-16 above for Individual Activities.**
{% endstep %}
{% endstepper %}