Check your data !

It is important to look and check your data from Alexandria in Excel and in the mapping phase in Alexandria to ensure you are not importing bad data. If you are importing for the first time this year, check to make sure that the student information is correct on a few students that you know or perhaps you might want to go into Chancery to look up a student record and compare it to the information you see on the spreadsheet. If you see a teacher's name with commas in it, be aware of the problem that causes when imported into Alexandria. Names with commas come in with quotation marks. This is a problem because it makes it more tedious to search by teacher name. You must type in the name as it appears. It is fairly easy to fix this before you import the data into Alexandria. Right now this is a known problem in the Chancery report for elementary so you will need to learn how to remove the comma in the teacher field before importing into Alexandria.

The Fix - Highlight the column where you see the teachers' names with commas. Select replace and type in a comma in the find field and leave the replace field blank. Printed directions are online under Librarian's resources>Alexandria>Patron Management.