Uploading Data into Booked
Data can be imported into Booked using one of three methods: the Wonde integration platform, a Spreadsheet, or by reusing data from a Past Event.
This page is about how to put your parent, student, class and teacher information into Booked.
To link a Wonde subscription, which cost your school nothing, to Booked to enable you to pull data from your administration system directly to Booked , or into a spreadsheet, please contact Booked Support.
Go to: Data > Upload data
To upload data into Booked, use one of the following three options:
Option 1 - Wonde Data Transfer
1. Click Continue to Wonde data transfer For more information on using the free Wonde integration tool please use the below link. |
| |
2. Choose whether you want utilise your admin system identifiers or Wonde created identifiers (eg. student code etc.)
3. Choose how many parents for each student to include in the data. These are determined by their Wonde priority.
4. Select the field name to be utilised by Wonde for the Student Sort Code (SSC).
5. Choose whether you wish to import All Classes or data from a Specific Group. |
| |
6. If ‘All classes’ was selected in point 5, proceed to point 7. Refer to the items below if ‘Specific Groups’ was selected | ||
| a. Choose the group type from the dropdown. b. Select the required members Groups, by clicking the checkbox/es c. Click ‘Add Selected’ to include the selected groups in the data for Booked. d. If there are Groups in another Group Type to add, repeat from point 5a for the additional groups that belong to different types. | |
7. Select Next to validate your data and transfer the data from your admin system directly into Booked via Wonde, OR Select Download to Excel if you wish to download the selected data into a spreadsheet. |
| |
8. Booked will validate the data. If there are any items that need to be Fixed, correct the errors in your admin system, or download to Excel make the necessary adjustments and re upload it. If there are any items needing Review, you can still proceed, but take note of the issues so that they can be corrected afterwards, if required.
It is important you review any issues Booked raises and consider what Booked is telling you regarding each issue, as these issues have the potential to interfere with the smooth running of your planned event. |
| |
9. When all issues are Fixed, and any remaining Review items are deemed in order (or will be reviewed post data upload) you should check the Tick Box acknowledging the remaining review item still exists. Take advantage of the option of emailing yourself a copy of the remaining Review items for future reference if required. Once the Check Box is ticked (if visible at all), the green Next button will be enabled, and it can be selected to populate your data into Booked. | ||
10 . Your upload will be confirmed, and the results of the uploaded students and grades displayed.
From here, you can either click: Go To View and Edit data. OR Go to Checklist, to review the next task on your Checklist |
Option 2 - Upload Spreadsheet
For information on extracting your data from your student management system, refer to Extracting data for Booked.
1. Click Continue to Upload spreadsheet |
|
2. Click Choose File or Drag and Drop your Excel data file in the box 3. Then click the green Upload file to Booked button and Booked will check the file to ensure:
4. When you are ready to proceed, click Next.
|
|
5. Booked will then validate your data. If there are any items that need to be Fixed, correct the errors in your admin system, or by downloading to Excel and making the necessary adjustments. If there are any items needing Review, you can still proceed, but take note of the issues so that they can be corrected afterwards, if required.
It is important you review any issues Booked raises and consider what Booked is communicating to you regarding each issue, as these issues have the potential to interfere with the smooth running of your planned event. |
|
6. When all issues are Fixed, and any remaining Review items are deemed in order (or will be reviewed post data upload) you should check the Tick Box acknowledging the remaining review items still exist. Take advantage of the option of emailing yourself a copy of the remaining Review items for future reference if required. Once the Check Box is ticked (if visible at all), the green Next button will again be enabled, and it can be selected to populate your data into Booked.
|
|
7. Your upload will be confirmed, and the results of the uploaded students and grades displayed.
From here, you can either click: Go To View and Edit data. OR Go to Checklist, to review the next task on your Checklist |
Option 3 - Past Event
| |
2. Select your desired Past Event data from the drop-down list It is important to remember any changes in your actual school Admin System data will not reflect in this reused data. However, once reloaded manual editing of this data can be undertaken. |
|
3. Next click the Check Box to acknowledge the date of your requested Past Event data is correct, and you understand that:
|
|
4 . Your upload will be confirmed, and the results of the uploaded students and grades displayed.
From here, you can either click: Go To View and Edit data. OR Go to Checklist, to review the next task on your Checklist |
For general information about preparing the data in spreadsheet format, refer to Standard Event Spreadsheet Layout.
For general information about preparing the data in spreadsheet format, refer to Setting Up Booked for Different Types of Events
For specific information about extracting data from your school’s chosen administration system, refer to Extracting data from individual school administration systems