Comments

1 comment

  • Official comment
    Avatar
    Jay Schupp

    The following things should be checked for PowerSchool AutoComm errors when importing Illuminate extracts (MSDS, Early On, Placement) into PowerSchool.

    I.
    Execution was successful with some validation errors.
    Error on line 1: Validation error for field: students.studentnumber Value(localstudentid) - Value may not contain more than 13 character(s). AND Validation error for field: students.studentnumber Value(localstudentid) - Value must be a number AND Validation error for field: students.studentnumber Value(localstudent_id) - Value must be an integer

    -> This is due to the header row that is present on line 1. This error can be ignored.

    II.
    Ensure that the file name in the AutoComm path does not have a tab_ prefix. Example...
    msdsstateextract14030.txt is the correct file name.
    tab_msdsstateextract_14030.txt is the old file name from the legacy extract.

    III.
    If the AutoComm does not appear to be importing data ... verify that the AutoComm Record Delimiter is set to 'LF' instead of 'CR/LF'.

Please sign in to leave a comment.