Differences

This shows you the differences between two versions of the page.

--- wiki:bulkupload [2023/07/27 15:51] – mbrauer
+++ wiki:bulkupload [2023/08/01 19:50] (current) – mbrauer
@@ Line 5: / Line 5: @@
 **CSV Column Requirements**
-The CSV file should contain the following columns in any order:
+The CSV file should contain the following columns:
   * devEUI: The device EUI (Extended Unique Identifier), which serves as a unique identifier for the device. It should   be in hexadecimal format (e.g., `0123456789ABCDEF`).
@@ Line 15: / Line 15: @@
   * joinEUI: The join EUI of the device. The join EUI is a globally unique identifier used during the device activation process. It should be in hexadecimal format (e.g., `0123456789ABCDEF`). This column is only used for TTN network server configurations.
-  * udtName: The UDT name associated with the device. This initializes the correct UDT instance in the selected tag provider and associates an existing decoder with the device. Options for UDT Names can be found in your existing UDT Definitions, or you may specify one type of UDT for the entire upload.
+  * udtName: The UDT name associated with the device. This initializes the correct UDT instance in the selected tag provider and associates an existing decoder with the device. The LoRaWan/Regional Parameters versions are also specified by the UDT. Options for UDT Names can be found in your existing UDT Definitions, or you may specify one type of UDT for the entire upload by selecting the //Single Device Type// option on the bulk upload menu.
   * description: A brief description of the device. This field can contain additional information or notes about the device. The value can be a string of characters.
@@ Line 22: / Line 22: @@
   * longitude: The longitude coordinate of the device's physical location. It should be a decimal value representing the device's longitude on the Earth's surface.
+**Alternate Formats**
+  * Alternate formats are supported, such as the device export format from the TTN, where the column names available are dev_eui, join_eui, name, app_key, and description instead of the ones mentioned above. However, a single device type would need to be specified or an extra column (denoted udtName) added to the csv with the correct UDT definition names for tags to be created for each device.
 **Formatting Guidelines**
@@ Line 40: / Line 44: @@
   * There should be no additional columns or data beyond the required columns specified above. Any extra columns will be ignored during the upload process.
+         * There are several UDTs that are currently supported by the SiteSync module: Dragino, TWTG-Pressure-V3, TWTG-Temperature-Transmitter-V4, TWTG-Vibration-V3, TE, Vutility-HotDrop, TEConnectivityPressure-US8900, TEConnectivityVibration-8391N, Abeeway, Adeunis, Aloxy, RadioBridgeVoltage, RadioBridgeMoisture, RadioBridgeTemperature, RadioBridge4-20ma, RadioBridgeAccelerometer, RadioBridgeContactSensor, RadioBridgeVibration, RadioBridgeHumidity, RadioBridgeLevel, RiotWirelessLevel, SushiVibration, SushiTemperature, SushiPressure, TektelicTracker, TektelicTundra, VegaAir, VoBoGP-1, Ellenex-PDS2-L, and Tekelek888. You may use these as options for the udtName column if a single device type is not specified.
+         * You can also upload a custom UDT in the Data Manager, and use the name of a this UDT in the udtName column of the CSV file for bulk uploading.
 **Conclusion**
 By adhering to the specified format and guidelines outlined in this documentation, you will be able to successfully perform bulk device uploads using a CSV file. Ensure that your CSV file contains all the required columns and that the values are correctly formatted.