Heritage Import
Views:
- Run MyEureka report (Heritage import Year 1.iqr)
- Export as Excel file (Heritage import Year 1.xls)
- Open in Excel
- Format. Remember to use the right date format (dd-mmm-yy) and to have an empty cell at the end so it put a comma in the CSV file at the end of each line. Also, cut down the student code to 5 digits.
- Open CSV and finish formatting. Get rid of redundant columns, and order columns for import (see template)
- Save as CSV and rename as TXT
- In Heritage, pick up the right import routine and edit
- Match column headers to columns in CSV. CAREFUL!
- To change the default next reader ID, go to ‘File Data’ -> READER and set the next default
- Make sure you overwrite existing records
- GO! GO! GO!
