Import attendance to PS

[Powerschool3040]

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?

[ItsOnlyDoug]

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

[Powerschool3040]

@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?

[Powerschool3040]

Hi, 

Any suggestions?

[ItsOnlyDoug]

Are you importing at the school level or district level? 

[Powerschool3040]

I am importing at the school level

[ItsOnlyDoug]

You are using a tab delimited .txt file correct? 

[Powerschool3040]

@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.

[ItsOnlyDoug]

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

[Powerschool3040]

Below is a snapshot of the file

[ItsOnlyDoug]

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? 

[Powerschool3040]

@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?

[Powerschool3040]

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.

[ItsOnlyDoug]

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

[Powerschool3040]

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?