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.

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