Datacake Docs
  • Welcome
  • Get Started
  • Changelog
  • Best practices
    • Best practices: Getting started
    • Best practices: Resolution (Timeframe)
    • Best practices: Dashboards
    • Best practices: Reports
    • Best practices: Grouping Devices
  • Datacake LNS
    • Getting Started
    • Gateways
      • Milesight LoRaWAN Gateway - UG6x
      • RAKwireless WisGate Edge Light 2
    • Devices
    • Add Devices without Gateway
  • Device
    • Product
    • Configuration
    • Claiming
    • Historical Data
    • Database
      • Configuration Fields
      • Fields
        • Manual input
        • Field Roles
        • Formulas
        • Mapping Fields
      • Data retention & Datapoints
      • Examples
        • Mapping 4-20mA Signals
        • Converting Units
  • Dashboards
    • Global Dashboards
      • Setting Homepage
    • Device Dashboards
    • Multi-Device Dashboards
    • Widgets
      • Value Widget
      • Chart Widget
      • Image Map
      • Map Widget
      • Text Widget
      • SOS Widget
      • Boolean Widget
      • iFrame Widget
      • Downlink Widget
      • Set Value Widget
      • Measurement List Widget
      • Heatmap Widget
      • Table Widget
      • Image Widget
  • Portal
    • Multi-Tenancy (Workspaces)
    • Reports
      • Energy Report
    • Administrators
    • Members
      • API Users
    • Security & Privacy
    • Billing
      • Support Packages
      • VAT Exemption / Tax ID
      • SMS Credits
      • Access Invoices
      • Unused time and Remaining time in Invoices (Prorations)
      • Codes
    • White Label
    • Rules
      • Legacy Rule Engine
        • Sending notifications via Telegram
      • New Rule Engine
        • Rule Engine Table Overview
        • Copy/Paste and Template Functionality
        • Advanced Rule Engine E-Mail and Webhook Templates
        • Time Restrictions
    • Zones
  • Cake Red
    • Get Started
    • Overview
  • LoRaWAN
    • Get Started
      • CSV Import
      • Custom LoRaWAN Device
    • Configuring LNS
      • The Things Stack (TTN / TTI) Automated Setup
      • The Things Stack (TTN / TTI) Manual Setup
      • Loriot
      • Kerlink Wanesy
      • Helium
      • ChirpStack
      • Tektelic
      • Actility ThingPark
      • Senet
      • Milesight Gateway
      • KPN
    • Downlinks (LoRaWAN)
      • Set Time Frame
    • Securing Webhooks
    • Payload Decoders
      • Location and GPS
      • Access Gateway Metadata
      • Access Measurements
      • Global Variables
    • Using Cayenne LPP
    • Converting Payload
  • Generic API Devices
    • HTTP Downlinks
  • Integrations
    • MQTT
    • Particle
      • Get Started
      • Adding Integrations
      • Decoding Payloads
      • Calling Functions
      • Templates
        • Particle Tracker One
    • Incoming Webhooks
    • Outgoing Webhooks
      • Securing Outgoing Webhooks in Datacake
    • Golioth
    • Blues Wireless Notecard
    • Sigfox
    • Swarm Asset Tracker
    • Grandcentrix Modbus Cloud Connect
    • YuDash LYNX IoT Gateway
    • Dragino NB-IoT
      • Changing NB-IoT Bands
    • Hardwario CHESTER
    • 1NCE OS
  • API
    • Exporting Data
    • Record Measurements via API
    • Node RED to Datacake
    • Generate Access Token
    • Internal MQTT
      • Get Started
      • MQTT Documentation
      • MQTT over WebSocket
      • Example Code
    • GraphQL API
      • Using GraphQL
      • Device Creation
      • Tutorials
        • Read Group via Tags
  • Guides
    • Python
    • Send Slack Notifications
    • Forward Data to Cake Red
    • Multiple Data Feeds
    • Automated Dynamic Downlinks
    • Ingesting JSON Data into Datacake API Devices
    • Working with Default HTTP Decoder on API Devices and Code Examples
    • Accessing Measurements in Decoders
    • Connecting Datacake to Notion Using Zapier
    • How to set up and use location on non-GPS devices
    • How to integrate with AWS IoT Core
    • How to Schedule Mass-Downlinks (Multicast) using Datacake Rule Engine
    • How to Map Sensor Values to Ranges or Booleans, Strings using Mapping Fields
    • Understanding Internal vs. External MQTT Brokers on Datacake
    • Sending UDP Messages between 1NCE OS and Datacake
    • Concepts of LoRaWAN Payload Decoders on Datacake
    • How to check if a value stays above or below limits for given time
Powered by GitBook
On this page
  • Information
  • Structure
  • File Example
  • Tags
  • Datacake LNS

Was this helpful?

  1. LoRaWAN
  2. Get Started

CSV Import

How to import LoRaWAN devices via .CSV File

Last updated 8 months ago

Was this helpful?

Information

With Datacake, you can easily import LoRaWAN devices through a .CSV file. Just drag and drop the file into the designated upload area outlined in step 3, labeled "Device".

Structure

To ensure proper formatting, the .CSV file must adhere to the following row structure.

DevEUI;Device Name;Device Location description;Tag 1,Tag 2,Tag 3

If you only wish to share the DevEUI and Device Name, it's not necessary to include the Device Location and Tags.

DevEUI;Device Name;;Tag 1,Tag 2,Tag 3

DevEUI;Device Name;Device Location;

DevEUI;Device Name;;

File Example

Please ensure that your .CSV file is structured exactly the same as the provided example.

123456789abcdef1;Device 1;Room 101;Temperature,Humidity,Pressure
aabbccddeeff1122;Device 2;Room 202;Light,Occupancy,Safety
f0e1d2c3b4a59687;Device 3;Room 303;CO2,Smoke,Fire
0123456789abcdef;Device 4;Room 404;Noise,Vibration,Shock
fedcba9876543210;Device 5;Room 505;Water,Level,Flow

Avoid using a header on the first line of the CSV. This can cause confusion for the importer.

Template File

Tags

To attach tags to your devices, simply include them in the 4th column of the CSV file.

123456789abcdef1;Device 1;Room 101;Temperature

Please remember to separate multiple tags with a comma.

123456789abcdef1;Device 1;Room 101;Temperature,Humidity,Pressure

Datacake LNS

You can also batch import devices to the Datacake LNS. For that you will have to drag and drop a file with the following structure:

DevEUI;Device Name; AppEUI(or JoinEUI); AppKey/NWKKEY; Frequency; Device Class; Location description;Tag 1,Tag 2,Tag 3

Make sure that your CSV file doesn't have a header with the titles (it should simply start with the first device). Otherwise the platform will return an Error message.

If you want, you don't need to include the Device Location and/or Tags. The structure is then the following:

DevEUI;Device Name; AppEUI(or JoinEUI); AppKey/NWKKEY; Frequency; Device Class;;Tag 1,Tag 2,Tag 3

DevEUI;Device Name; AppEUI(or JoinEUI); AppKey/NWKKEY; Frequency; Device Class; Location description;

DevEUI;Device Name; AppEUI(or JoinEUI); AppKey/NWKKEY; Frequency; Device Class;;

We currently support the following frequencies:

  • EU_863_870_TTN

  • US_902_928_FSB_2

And the devices classes:

  • A

  • C

Remember that DevEUI and AppEUI are strings 8 bytes long. AppKey is a 12 byte string. All of them should be provided by your device manufacturer.

4954957556556566;Device 1;cd1a75ae5818dcbe;c39ebd8578c3d7ac6dfef73afb60dfba;EU_863_870_TTN;A;Room 101;Temperature,Humidity,Pressure
aabbccddeeff1122;Device 2;cd1a75ae5818dcbe;f171b14be6e3494ce6da3dd8e67cbb8c;EU_863_870_TTN;A;Room 202;Light,Occupancy,Safety

Template file for the Datacake LNS auto-importer:

1KB
lora_devices.csv
Example CSV-File as Template
239B
device_data_datacakelns.csv
Step 3 - Add Devices manually or via CSV-File