User Tools

Site Tools


student:sat_test_scores_import_oct2015_feb2016

This is an old revision of the document!


SAT Test Scores Import (October 2015-February 2016)

The import allows both a fixed-width positional and a comma-delimited (CSV) file import.

  • The Position column indicates the start and end in the positional import file. The program determines that the import is the positional layout if the file length is 2591 or greater, and position 59-62 contains a numeric four-digit year starting with 20.
  • The Column # column indicates the position in the comma-delimited file. The program determines that the import file is the comma delimited if it contains enough commas to be split into at least 449 columns, and the fourth column either contains a numeric four-digit year starting with 20 or the word YEAR to indicate it is a heading row.
SourceTargetComments
FieldStart PositionEnd PositionLengthTableColumn
Last Name72115sr_stu_enrollname_l
student/sat_test_scores_import_oct2015_feb2016.1504557986.txt.gz · Last modified: 2017/09/04 15:46 (external edit)