Importing data into Extension Attribute

jwells_Box
New Contributor II

Howdy!

I know what I am trying to do is possible, but i'm strugglin. We just did a very large Zoom AV deployment - we have 100s of iPads deployed as Schedulers and Controllers for the Zoom rooms. I created a Mobile Device extension attribute to store the Red Park MAC address for each iPad in JAMF. I have a spreadsheet with the iPad serial numbers and associated Red Park MAC addresses, I want to import that data into JAMF into the extension attribute that I created.

My Spreadsheet is super simple and can be converted to csv. its formatted like this:
Column 1 Column 2
SERIAL# MAC ADDR
ABC1234 00:xx:00:xx:00:xx

How can i do this without reinventing the wheel?
Thanks in advance!

cf05cb3d00b94cae972ede8e07f60b15

1 ACCEPTED SOLUTION

jamf_sam
Moderator
Moderator

Per @mm2270, API is a great way to do this. The MUT (Mass Upload Tool) might be another way to accomplish this. Now that the MUT supports Extension Attributes, you might find this easy. Find out more about the MUT here.

Our customers have written great guides on deploying Zoom Rooms that you might want to check out.

Best of luck!

View solution in original post

4 REPLIES 4

mm2270
Legendary Contributor III

I think what you're looking for is an API script. The data can be accessed with a script from your csv file, locating each device by it's serial number and the corresponding MAC address, and then the same device's Extension Attribute on the Jamf server can be updated with that value using an API PUT command.

I don't have anything pre-built that does what you want here, especially with mobile device records, but I'm willing to bet there is something already out there that can get you started. I would do some searches here for things like "Updating Extension Attributes using API" or something to that effect and see what you find.

Good luck.

jamf_sam
Moderator
Moderator

Per @mm2270, API is a great way to do this. The MUT (Mass Upload Tool) might be another way to accomplish this. Now that the MUT supports Extension Attributes, you might find this easy. Find out more about the MUT here.

Our customers have written great guides on deploying Zoom Rooms that you might want to check out.

Best of luck!

jwells_Box
New Contributor II

@jamf_sam Thank you so much! MUT was exactly what I needed and saved me hours of work!

joelamate
New Contributor

Refer to this link to import your data to JAMF Pro. You can use Inventory Preload.
https://docs.jamf.com/10.23.0/jamf-pro/administrator-guide/Inventory_Preload.html
For the Extension Attributes, in your csv file use "EA Red Park Mac Address" header.