How to assign devices with a CSV file in Mosyle

ID: 152787

Description: While there are a few different ways to assign...

Steps:

  1. To start you'll need to get the CSV file from Mosyle's website. Go to My School > Device Assignment > Spreadsheet Assignment.
  2. Under the section that says Download the template, and click Download CSV
    3. Step image Step image
  3. Once the CSV file is downloaded open it in your spreadsheet program of choice.
  4. The CSV will look something like this, but once we start entering user data you can delete the bottom most row.
    5. Step image
  5. Delete the cells that contain SERIAL_NUMBER_SAMPLE, USER_ID_SAMPLE, and CART_NAME.
  6. Enter the device's serial number in the bottom row first column.
  7. Enter either the User's ID or the Cart name in there respective column's. .
  8. At least one of these need to be filled. Cart Name is optional as long as you have the User ID.
    9. Step image
  9. Once all your data is entered save the spreadsheet as a CSV file and upload the file to Mosyle by clicking Select File on the Spreadsheet Assignment page, and select your CSV file.
  10. It will take Mosyle a bit to process your file. Any errors in user data will be reported once your file is finished uploading.
Back