v3.20.0

Getting Started Devices Gateways Integrations Reference
Get The Things Stack

Getting Started

    Overview
  • Quick Start
  • What Is The Things Stack?
  • Console
  • Command-line Interface
  • Installing The Things Stack
  • Upgrading The Things Stack
  • Migrating to The Things Stack
    • Migrating End Devices from Community Edition to Cloud
    • Migrating End Devices from ChirpStack
    • Migrating End Devices from V2
    • Migration Tool
    • Import End Devices in The Things Stack
    • Fine-tuning MAC Settings for End Devices
    • Migrating Gateways
    • JSON File Reference
    • CSV File Reference
    • Migration FAQ
  • The Things Stack Cloud
  • The Things Stack AWS Launcher
  • The Things Network
  • Server Addresses
  • Packet Broker
  • Single Sign-On
  • Users and Organizations
  • Using the API
  • Working with Events
  • Troubleshooting Getting Started

CSV File Reference

The Things Stack has support for importing end devices from CSV (comma-separated values) files. This is useful when batches of end devices are managed in Microsoft Excel or any other spreadsheet or database that can export to CSV file.

The CSV import in The Things Stack uses the following settings:

  • Semicolon (;) as field delimiter. This makes working with Microsoft Excel and other spreadsheets convenient
  • Header row is required
  • On each row, the same number of fields as on the header line
  • Use quotes to use ; in a field value
  • Use double quotes to escape quotes
  • Unknown header columns are permitted and ignored

The following columns are recognized:

Column Required Alias Format Meaning
dev_eui Yes Hexadecimal string LoRaWAN DevEUI
join_eui Yes app_eui Hexadecimal string LoRaWAN JoinEUI (or AppEUI)
id No Alphanumeric string, lowercase with hyphens Device ID (falls back to DevEUI if not set)
name No Free form Name
frequency_plan_id No * See Frequency Plans Frequency plan ID
lorawan_version No * See MACVersion LoRaWAN version
lorawan_phy_version No * See PHYVersion LoRaWAN Regional Parameters version
app_key Yes Hexadecimal string LoRaWAN AppKey
nwk_key No Hexadecimal string LoRaWAN NwkKey
brand_id No Vendor ID string from Device Repository Device brand ID
model_id No Model ID from Device Repository Device model ID
firmware_version No Firmware version from Device Repository Firmware version
hardware_version No Hardware version from Device Repository Hardware version
band_id No See Frequency Plans LoRaWAN Band ID

* If you don’t set this, you must set the fallback value when importing the CSV file. See Importing devices.

Example

Minimal example:

dev_eui;join_eui;frequency_plan_id;lorawan_version;lorawan_phy_version;app_key
1111111111111111;1111111111111111;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;11111111111111111111111111111111
2222222222222222;2222222222222222;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;22222222222222222222222222222222
3333333333333333;3333333333333333;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;33333333333333333333333333333333

All columns for a LoRaWAN 1.0.4 device:

id;dev_eui;join_eui;name;frequency_plan_id;lorawan_version;lorawan_phy_version;brand_id;model_id;hardware_version;firmware_version;band_id;app_key
test-one;1111111111111111;1111111111111111;Device 1;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;the-things-industries;generic-node;1.0.4;1.0;EU_863_870;11111111111111111111111111111111
test-two;2222222222222222;2222222222222222;Device 2;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;the-things-industries;generic-node;1.0.4;1.0;EU_863_870;22222222222222222222222222222222
test-three;3333333333333333;3333333333333333;Device 3;EU_863_870_TTN;MAC_V1_0_4;RP002_V1_0_3;the-things-industries;generic-node;1.0.4;1.0;EU_863_870;33333333333333333333333333333333

Excel Template

Download the Excel template. You can remove all columns that are not required (see above).

To export for The Things Stack, go to File, Save As and select Comma Separated Values as file format.

← JSON File Reference Migration FAQ →

On this page

  • Example
  • Excel Template

The Things Stack

Getting Started

Devices

Gateways

Integrations

Reference

Contributing

GitHub

Forum

About Us

The Things Network

The Things Industries

About this page

Last changed by Nejra Selimović on 01 Jun 2022.
doc: Add instructions to migrate from Community Edition to Cloud (#858)

Edit on Github