The device registration system only allows IT administrators to register a device one at a time. However, for situations wherein many devices (20+) need to be registered, IT administrators can request OTDI Networking to register the devices in bulk on their behalf.
Preparing the File
The Excel workbook below contains three tabs:
- README: Instructions you should read first before filling out the form
- ImportDevices: Table that will need filled out and saved as a CSV per instructions in the README and below
- Calculated_Fields: Tables used by the ImportDevices tab for calculated values. Do not modify.
Critical Note:
Before requesting a bulk import, realize that the process always generates new Wi-Fi passwords. If devices are to be used for Registered4OSU Wi-Fi network, submitting a bulk registration for already-registered devices will result in a loss of connectivity for those devices until they are reconfigured.
| Fill out rows 11 and onward for each device needing registered, following these guidelines: | |
|---|---|
| Field Name | Value |
| Is Device: | Always “Yes” |
| MAC Address: | 12-character device identifier with dash delimiters (e.g., 11-11-11-aa-bb-cc) |
| Registrant: | name.#a of the IT admin responsible |
| Sponsor Profile: | Choose the option that matches your college or business unit. If it is a personal device, choose OSU DeviceAdmin Personal. |
| Email: | This must be a team email or distribution group so that expiration warnings are not sent to an individual. |
| Device Description: | Free form description field for the IT administrator’s benefit. |
| Role: | Choose the applicable. NOTE: Not all roles are permitted for all colleges and business units. Please discuss with OTDI Networking if you are unsure. |
| OSU Affiliation: | All managed devices by IT administrators should be osu-university. If personal, choose osu-personal. |
| Shared: | If you choose osu-university above, choose No. If you choose osu-personal above, choose Yes. |
| AirGroup Shared User: | Leave blank |
| State: | active |
| Activation: | This should auto populate with today’s date and time |
| Expiration: | This should auto populate with date and time one year from when the file was opened |
| Email field: | |
| Wi-Fi Password: | 1 |
Helpful Note:
Sharing the File
Once you’ve filled out the ImportDevices tab in the Excel workbook appropriately:
- Select rows 10 through the last row you entered data
- Choose Edit > Copy to copy contents to clipboard
- Open a new Excel workbook file and paste contents
- Save file as a Comma Separated Value (.csv) file
- Open a ticket with the IT Service Desk and attach the CSV file, requesting it be assigned to OTDI Networking