crwdns2933423:0crwdne2933423:0
How to assign devices with a CSV file in Mosyle

How to assign devices with a CSV file in Mosyle

Jacob Mehnert

crwdns2944109:0crwdnd2944109:0Jacob Mehnertcrwdnd2944109:0crwdnd2944109:0crwdnd2944109:0crwdne2944109:0

crwdns2944111:0November 9, 2022crwdne2944111:0

crwdns2931287:02crwdne2931287:0
crwdns2937799:0crwdne2937799:0
crwdns2944444:0crwdne2944444:0

crwdns2915892:0crwdne2915892:0

crwdns2942287:0crwdne2942287:0

While there are a few different ways to assign devices to users in Mosyle, the best way to assign devices to a specific group of users is through Mosyle's Spreadsheet Assignment. If you already have your devices registered in Mosyle, then all you should need is the device's serial number and the user's User ID. You will also need Mosyle's CSV template.

  1. How to assign devices with a CSV file in Mosyle, Preparing your Data: crwdns2935265:01crwdnd2935265:01crwdnd2935265:02crwdne2935265:0 How to assign devices with a CSV file in Mosyle, Preparing your Data: crwdns2935265:01crwdnd2935265:02crwdnd2935265:02crwdne2935265:0
    • To start you'll need to get the CSV file from Mosyle's website. Go to My School > Device Assignment > Spreadsheet Assignment.

    • Under the section that says Download the template, and click Download CSV

  2. How to assign devices with a CSV file in Mosyle, Open the CSV: crwdns2935265:02crwdnd2935265:01crwdnd2935265:01crwdne2935265:0
    • Once the CSV file is downloaded open it in your spreadsheet program of choice.

    • The CSV will look something like this, but once we start entering user data you can delete the bottom most row.

  3. How to assign devices with a CSV file in Mosyle, Enter the user data: crwdns2935265:03crwdnd2935265:01crwdnd2935265:01crwdne2935265:0
    • Delete the cells that contain SERIAL_NUMBER_SAMPLE, USER_ID_SAMPLE, and CART_NAME.

    • Enter the device's serial number in the bottom row first column.

    • Enter either the User's ID or the Cart name in there respective column's. .

    • At least one of these need to be filled. Cart Name is optional as long as you have the User ID.

    • 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.

    • It will take Mosyle a bit to process your file. Any errors in user data will be reported once your file is finished uploading.

crwdns2915888:0crwdne2915888:0

While their are several different ways of assigning devices through Mosyle, CSV assignment is one of the easiest ways of assigning a large group of devices if you already have student information in a preexisting spreadsheet.

crwdns2935229:02crwdne2935229:0

Jacob Mehnert

crwdns2935283:010/18/21crwdne2935283:0

39,240 crwdns2915208:0crwdne2915208:0

crwdns2935297:050crwdne2935297:0

crwdns2915084:0crwdne2915084:0

iFanatics crwdns2935289:0iFanaticscrwdne2935289:0

Community

crwdns2931471:061crwdne2931471:0

crwdns2935297:0194crwdne2935297:0

crwdns2947412:00crwdne2947412:0

crwdns2917038:0crwdne2917038:0

crwdns2936625:0crwdne2936625:0:

crwdns2936751:024crwdne2936751:0 1

crwdns2936753:07crwdne2936753:0 5

crwdns2936753:030crwdne2936753:0 11

crwdns2942667:0crwdne2942667:0 1,035