Differences

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

--- wiki:bulkupload [2023/07/18 21: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.
-  * decoder: The decoder function or script associated with the device. This function is responsible for decoding the payload received from the device. It should be provided as a string or file reference.
+  * 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 28: / Line 32: @@
   * Each row of the CSV file represents a single device.
   * The first row of the file should contain the column headers, as specified above.
   * Subsequent rows should contain the corresponding values for each column.
   * Ensure that each device has a unique `devEUI`. Duplicate `devEUI` values will cause conflicts during the upload process.
   * Columns are case-sensitive, and all columns must be present in the CSV file. However, you can leave the values empty for optional columns like description, latitude, longitude, and joinEUI (for non-TTN network uploads).
   * Make sure that the CSV file is saved with the appropriate file extension, such as `.csv`.
   * 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.