Student Tracking – TablePress Test

This is an example of a simple Excel spreadsheet imported via the free TablePress plugin. Here’s some information from the TablePress documentation, so it definitely has limitations:

“TablePress supports Microsoft Excel data formats for import (but no export!) of table data. Note that this support is still experimental, and not all data feature, like data types, are supported or available. Also, TablePress can only import the first worksheet of the Excel file. If you have problems importing tables from XLS or XLSX files, it’s recommend to save these tables in Excel as CSV files and try importing those.”

Problem noted: All blank date fields in the original Excel file were populated with a default date (January 1, 1970), and all other dates were imported with incorrect years. I’m not sure how to prevent this from happening, so I’d say this is not an ideal contender.

StudentDate EnrolledDate AssignedClass 1 DateClass 2 DateClass 3 DateCompletion
Student 1May 2, 2015May 9, 2015May 14, 2015June 13, 2015June 19, 2015February 7, 1900
Student 2May 2, 2015May 9, 2015May 14, 2015May 25, 2015June 19, 2015January 1, 1970
Student 3May 2, 2015May 9, 2015May 14, 2015May 25, 2015June 19, 2015January 1, 1970
Student 4May 2, 2015May 11, 2015May 14, 2015January 1, 1970January 1, 1970January 1, 1970
Student 5May 2, 2015May 11, 2015May 14, 2015May 25, 2015June 20, 2015January 30, 1900
Student 6May 2, 2015May 11, 2015May 14, 2015January 1, 1970January 1, 1970January 1, 1970
Student 7May 4, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 8May 2, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 9May 2, 2015May 11, 2015May 16, 2015January 1, 1970January 1, 1970January 1, 1970
Student 10May 4, 2015May 11, 2015May 16, 2015January 1, 1970January 1, 1970January 1, 1970
Student 11May 4, 2015May 11, 2015May 16, 2015January 1, 1970January 1, 1970January 1, 1970
Student 12May 4, 2015May 13, 2015May 16, 2015January 1, 1970January 1, 1970January 1, 1970
Student 13May 4, 2015May 13, 2015May 28, 2015January 1, 1970January 1, 1970January 1, 1970
Student 14May 4, 2015May 13, 2015May 28, 2015January 1, 1970January 1, 1970January 1, 1970
Student 15May 2, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 16May 2, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 17May 2, 2015May 13, 2015May 25, 2015January 1, 1970January 1, 1970January 1, 1970
Student 18May 2, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 19May 2, 2015May 13, 2015May 25, 2015June 12, 2015June 24, 2015February 7, 1900
Student 20May 6, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 21May 6, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 22May 6, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 23May 6, 2015May 13, 2015May 25, 2015June 13, 2015June 20, 2015February 7, 1900
Student 24May 6, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 25May 6, 2015May 13, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 26May 6, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 27May 6, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 28May 2, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 29May 2, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 30May 2, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 31May 2, 2015May 11, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 32May 8, 2015May 13, 2015May 25, 2015June 13, 2015June 20, 2015January 1, 1970
Student 33May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 34May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 35May 8, 2015May 13, 2015May 25, 2015June 14, 2015June 24, 2015January 1, 1970
Student 36May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 37May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 38May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 39May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 40May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 41May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 42May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 43May 8, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 44May 2, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 45May 2, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 46May 2, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 47May 2, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970
Student 48May 2, 2015January 1, 1970January 1, 1970January 1, 1970January 1, 1970January 1, 1970