Import Student
Download Sample File
Import Instruction
- Use the above ‘Sample File’ as a template to import your student data to your school portal - in batches. Download the file & populate it without changing the structure of the .csv file. This means you may perform functions like resize column width, change filename, but . . . DON’T change Column Headings/Titles. Respect the example formatting ie date of birth, M or F (not m or f) for gender, laundry numbers can be alpha numeric, don’t try change left, right or centre alignment, font size etc.
Most spreadsheet apps will do it fine. ie Excel® or Sheets®.
Add your data in accordance with the sample student’s Jess Smith & Bill Jones. You may copy n paste preformatted data (like with colour or different fonts) but then when you save, just ensure you save as a .csv and then you will likely get some warning about the data not remaining the way it currently appears – it won’t, and that is not a problem because it MUST be a .csv, which has no formatting.
The more information (data) you add, the more data you can work with in your school portal. As an absolute minimum, add data to column A,B,C,H, IorJ, P, R, SorT. Do not delete the vacant columns, just leave them blank. Remember the old IT adage GIGO. - You DO need to create a separate CSV file for each:- *for each Class of each Dorm. See video on Website. Filename is your choice, but, it should help you, when naming your various .csv files for upload. For example, filename may be “SrBrownDormGr12”, remember there is a field for gender in the CSV file so you MUST use either M or F. Of course you may have M & F within the same .csv file - that would indicate you have both M & F in the same residence & of course, you have exceptionally astute staff!
The process is easier than it reads – just make a start and you should be fine – Oh and don’t worry about the sample students, Jess & Bill, they should not duplicate but you can also just delete them once you are finished importing.If you are evaluating the system using “Grayleaf Academy” then have a go at creating your own group of students to import – you may even ‘build’ a ‘new’ residence and populate that! Don’t forget to assign your staff to the relevant dorms. Senior Staff can make these changes remotely via the dashboard of the Rollcall App if required at short notice. - Re-read Step 1 & 2
- The process merely requires a little practice, please check the resources on our website and the .pdf manual. Finally support@myboardingwizard.com will respond to your help requests. There is a small equitable charge if you would like us to setup your school for you. Simply request of us a template – a spreadsheet file with, at least the data from point 1, above. You might request us to compile only the CSV files or your whole system – as you prefer. We however, prefer you to do it on your own as that is excellent insight into the system for whomever you choose as your administrator, and we like to think we have designed it very user friendly. Grayleaf Academy should get you there quite easily.
*If you can begin by creating .csv files. One for each Class (year level) of each Dorm and naming them accordingly – your work is done! STEPS
i) Work out how many files you will be needing.
ii) Name them – Write it down.
iii) Take the sample CSV file above – and do a “Save As” function applying each name that you have written down. Be sure that you are “Saving As” keeping the correct Filename, that you wrote down - as well as File Type, namely .csv
iv) Now go and populate each of those csv files you just created! Easiest is to copy n paste from another file that your ever helpful IT department has given you.
v) Maybe your IT support team will be kind enough to populate each of those files for you? All pretty easy considering this is the ‘hardest’ function that the Wizard can throw at you!