CSV Import/Export

You can export/import device information csv.

CSV Export

Only devices shown at device management page will be exported. The number of devices may vary depending on your searching conditions. There are two CSV formats: "one printed normal device information" and "one printed app installation information".

CSV Layout

Normal Device Information

Name Description Required
id Device ID
access_token Access Token
hardware Name of Hardware
description Description of a device. This includes in metadata, too
metadata Meta data
devicekey Device key
os Kind of OS installed on a device
osVersion Version of OS installed on a device
region Location of a server to which a device connects
status Status of device's activeness
wifi_mac_address MAC address of Wifi
ether_mac_address Mac address of Ethernet
createdAt Date when a device is registered

App Installation Information

This is the format friendly with CSV import(We mention about this below this page). If you wish to export a CSV in this format, it's required that you've searched devices before and app id contains in searching conditions. From app to app, options required at installation time are different. We want to keep the CSV layout, or say, the number of column consistent.

Name Description Required
obniz_id Device ID
app_id App ID installed on a device
description Description of a device
Option values required at app installation time

※Different app has different number of options required at installation time.
Exaple follows.

Temperature Measuring app that needs options of a temperature to send notification(temperature_limit) and notification way(notification_way)
Name Description Required
obniz_id Device ID
app_id App ID installed on a device
description Description of a device
temperature_limit Temperature to send notification
notification_way Notification way
Sample toy app made by your seven year old nephew that takes no options
Name Description Required
obniz_id Device ID
app_id App ID installed on a device
description Description of a device

CSV Import

You can install an app to multiple devices by one single csv import operation. Installation acts like a 'registration' for a device that's not been installed any app and 'updation' for a device that's already installed the very app you're just intending to install. Options that's required at installation time differ from app to app, so before carring out CSV import it's recommended to search devices by conditions including app id and export them as an app information CSV. You can use this CSV to import.

CSV Layout

Name Description Required
obniz_id Device ID
app_id App ID installed on a device
description Description of a device
Option values required at app installation time

関連の質問