Create/Edit User and Device with CSV file

By importing csv files, user and device information can be created and edited in bulk.

The first line of the CSV file is the header item name, and should be created as specified in the format. Depending on the column you enter, you can register or update the information in the following patterns.

Create/update all information at once (Users and Devices are associated with each other)

Create/update Devices information only

Create/update Users information only

No space is used for the header item name

The CSV file is case sensitive.

★: required

○：In the case of blanks, these are items whose values are not created (*1)

×：If you are creating only users or only devices, these items need to be blank

https://gyazo.com/4ceafc48ce84ba99e8daf7d64bc5c72a

*1: what to do when column "◯" is blank

table:_

csv value create update

blank do not create value clear registered values

not blank use csv value use csv value

table:_

csv value create update

blank automatic generation of random code preserve random code at creation

not blank use csv value use csv value

table:_

csv value create update

blank automatic set 7 days later automatic set 7 days later

not blank use csv value use csv value

Batch updates of managed Devices are handled as follows, depending on the check-in status.

table:_

CHECK IN STATUS ACTION

Enrolling or Expired Values can be updated (outside of os)

Enrolled All columns can be updated except the following (*4)

Withdrawn Unable to update values.

*4: OS, Code, WifiMac, IMEI, MEID, UDID, ExpirationDays, RegistrationEmail

CSV Sample For Creating Devices and Users

code:sample1.csv

UserName,Name,EmailAddress,UserDescription,Identifier,Template,Code,OS,WifiMac,IMEI,MEID,UDID,Serial,ExpirationDays,DisplayName,Description,RegistrationEmail

user0001,Test User 1,user0001@example.com,User description 1,apple001,,,ios,,,,,,,iOS Device 1,,

user0002,Test User 2,user0002@example.com,User description 2,apple002,,,ios,,,,,,,iOS Device 2,,

user0003,Test User 3,user0003@example.com,User description 3,google001,,,android,,,,,,,Android Device 1,,

user0004,Test User 4,user0004@example.com,User description 4,google002,,,android,,,,,,,Android Device 2,,

user0005,Test User 5,user0005@example.com,User description 5,ms001,,,windows,,,,,,,Windows Device 1,,

user0006,Test User 6,user0006@example.com,User description 6,ms002,,,windows,,,,,,,Windows Device 2,,

CSV Sample For Creating Devices

code:sample2.csv

UserName,Name,EmailAddress,UserDescription,Identifier,Template,Code,OS,WifiMac,IMEI,MEID,UDID,Serial,ExpirationDays,DisplayName,Description,RegistrationEmail

,,,,apple001,,,ios,,,,,,,iOS Device 1,,

,,,,apple002,,,ios,,,,,,,iOS Device 2,,

,,,,google001,,,android,,,,,,,Android Device 1,,

,,,,google002,,,android,,,,,,,Android Device 2,,

,,,,ms001,,,windows,,,,,,,Windows Device 1,,

,,,,ms002,,,windows,,,,,,,Windows Device 2,,

CSV Sample For Creating Users

code:sampel3.csv

UserName,Name,EmailAddress,UserDescription,Identifier,Template,Code,OS,WifiMac,IMEI,MEID,UDID,Serial,ExpirationDays,DisplayName,Description,RegistrationEmail

user0001,Test User 1,user0001@example.com,User description 1,,,,,,,,,,,,,

user0002,Test User 2,user0002@example.com,User description 2,,,,,,,,,,,,,

user0003,Test User 3,user0003@example.com,User description 3,,,,,,,,,,,,,

user0004,Test User 4,user0004@example.com,User description 4,,,,,,,,,,,,,

user0005,Test User 5,user0005@example.com,User description 5,,,,,,,,,,,,,

user0006,Test User 6,user0006@example.com,User description 6,,,,,,,,,,,,,

? How to (create|edit) User and Device with CSV file ?