MarvellousMe

Arbor can be used to populate student and staff data into MarvellousMe through a CSV file export. 

To generate the required CSV file in Arbor, you'll need to create two custom reports. To do this, just follow these steps:

Step 1 - Download the Staff and Student Template files

We have two templates that will speed up the process of generating your Custom Reports.

Click here to download the Staff template.

Click here to download the Student template.

Step 2 - Create your Staff Export

Head to School > Custom Report Writer and click on 'Create New Report'.

MM_.png

 

On the Create Report page, click on 'Import a Custom Report' and use the 'Browse' button to find the Staff template file that you downloaded in Step 1. Once you have selected the file, click 'Upload' to import it into Arbor.

MM2.png

 

Once you've imported the template, a report called MarvellousMe - Staff Export will be created. This will include all your school's currently employed staff, and their main email address. Click the 'Download' button in the top-right of the report, and select Excel format to download the report to your computer.

MM3.png

Step 3 - Create your Student Export

Head to School > Custom Report Writer and click on 'Create New Report'.

MM_.png

 

On the Create Report page, click on 'Import a Custom Report' and use the 'Browse' button to find the Student template file that you downloaded in Step 1. Once you have selected the file, click 'Upload' to import it into Arbor.

MM4.png

 

Once you've imported the template, a report called MarvellousMe - Student Export will be created. This will include all the columns required for MarvellousMe, though STAFF NAME, STAFF EMAIL and MAIN TEACHER EMAIL will all be blank. Click the 'Download' button in the top-right of the report, and select Excel format to download the report to your computer.

MM7.png

Step 4 - Combine your reports in Excel or Google Sheets

Once you have downloaded both the Staff Export and Student Export reports, open them up in Excel/Google Sheets.

Copy all the data from the STAFF NAME and STAFF EMAIL columns on your Staff Export into the STAFF NAME and STAFF EMAIL columns on the Student Export.

MM5.png

MM6.png

 

Carefully copy the appropriate STAFF EMAIL data and paste it into the MAIN TEACHER EMAIL column  - for example, if Class 1S is taught by Mr Smith, copy Mr Smith's email address and paste it into the MAIN TEACHER EMAIL cells for all students in Class 1S. The Student Export is sorted by Registration Forms to make this process easier. MarvellousMe also have documentation available on this process - click here to view it.

2020-05-29_MarvellousMe_-_Student_Export_xlsx_-_Google_Sheets.png

 

Save/Download your spreadsheet in .CSV format, then upload it into MarvellousMe!

1 out of 1 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.