topic Re: Import attendance to PS in Community Forum

Import attendance to PS

Powerschool3040 — Thu, 05 Oct 2023 05:56:24 GMT

Hi,

I am unable to import the below daily attendance to PS.

It gives me below warnings. Any suggestions?

I was referring to the import template and has saved daily attendance sheet as tab delimited file before uploading. Dates were also formatted as required before import.

Any luck?

Re: Import attendance to PS

ItsOnlyDoug — Thu, 05 Oct 2023 12:50:30 GMT

Have you verified that those attendance codes match codes in that building?

Re: Import attendance to PS

Powerschool3040 — Fri, 06 Oct 2023 03:38:23 GMT

@ItsOnlyDoug , Thank you for your response.

I tried with the equivalent numeric code as well (E.g. Code 442 for Absent (A) and so on). Still that dint work.

Any suggestions?

Re: Import attendance to PS

Powerschool3040 — Fri, 06 Oct 2023 07:36:27 GMT

Hi,

Any suggestions?

Re: Import attendance to PS

ItsOnlyDoug — Tue, 10 Oct 2023 17:51:32 GMT

Are you importing at the school level or district level?

Re: Import attendance to PS

Powerschool3040 — Wed, 11 Oct 2023 09:37:07 GMT

I am importing at the school level

Re: Import attendance to PS

ItsOnlyDoug — Wed, 11 Oct 2023 13:33:44 GMT

You are using a tab delimited .txt file correct?

Re: Import attendance to PS

Powerschool3040 — Tue, 17 Oct 2023 09:58:31 GMT

@ItsOnlyDoug , Yes I am using tab delimited file. Now the attendance is getting imported. However, it shows a different attendance date time stamp on the screen after import and attendance update done is not getting reflected in PS. I refer to the student attendance screen.

Re: Import attendance to PS

ItsOnlyDoug — Tue, 17 Oct 2023 11:46:11 GMT

Would you be able to send me the file you are importing so I can look at it?

Re: Import attendance to PS

Powerschool3040 — Wed, 18 Oct 2023 03:43:01 GMT

Below is a snapshot of the file

Re: Import attendance to PS

ItsOnlyDoug — Wed, 18 Oct 2023 11:59:16 GMT

Ok, is this EA code set to count towards ADA and Membership?

Also, after you import have you tried running the Refresh Attendance Views operation?

Re: Import attendance to PS

Powerschool3040 — Tue, 12 Dec 2023 06:38:49 GMT

@ItsOnlyDoug ,

Thanks for your reply.

Yes this code is set to count towards ADA and Membership.

I am still not able to import the file again correctly.

Can you please advise?

Re: Import attendance to PS

Powerschool3040 — Tue, 12 Dec 2023 07:01:14 GMT

Hi,

I tried to import one sample record in LIVE and it imported successfully. I added the period ID as well to the import file as below and tried to import. However when I navigate back to the student's attendnace page in PowerSchool, it does not show any results as expected. Could you please advise on how to verify the attendance in PowerSchool after importing the records?

Thanks.

Re: Import attendance to PS

ItsOnlyDoug — Tue, 12 Dec 2023 15:23:33 GMT

I would check the attendance of the specific student you imported. If it worked it should show on the student's attendance pages.

Re: Import attendance to PS

Powerschool3040 — Wed, 13 Dec 2023 05:53:59 GMT

It shows as successfully imported but on the attendance page it does not reflect.
Should we give the period number, section number etc while updating along with the student number and attendance code and attendance date?

Re: Import attendance to PS

huffinea — Wed, 06 Nov 2024 13:55:45 GMT

Did you ever get this one figured out? We are having the same issue. Says the import is successful but when we go back to the student's Attendance Overview, nothing is there.