Bulk Import of Custom Attribute Values

About this task

SOTI Connect allows administrators to bulk import custom attribute values for multiple devices simultaneously. This simplifies large-scale updates or assignments of custom attribute data.
Important:
  • Existing values are overwritten by values in the bulk import file.
  • If duplicate entries exist in the import file, the last processed entry is used.
  • Rules trigger once at the end of the upload for all applicable devices.
  • This feature does not automatically create custom attributes. It assigns values only to attributes that already exist in the system.

Procedure

  1. From the SOTI Connect main menu, navigate to Devices > View All Devices.
  2. Select the Bulk Import Custom Attribute Values icon.
  3. The Bulk Import Custom Attribute Values window opens.
  4. Select Upload to import the bulk custom attribute import file. See File Format for the Bulk Custom Attribute Values Import File for details.
  5. Select Submit to upload the file.
  6. Review the results. The status of the bulk import displays, including the number of successful assignments and a table containing diagnostic information about any custom attribute value assignments that were not processed. One column per failed row in the bulk import custom attribute values file displays in red and includes an Information icon. Select the information icon in each row to view diagnostic details. Selecting the Information icon opens a pop-up display with diagnostic information on why this row was not processed.
    Results of the bulk import
  7. Resolve any errors using the diagnostic information, then select Retry to re-upload the corrected file.
    Successful bulk import
  8. Once the import is successful, select Close.

Results

The custom attribute values are successfully imported and applied to the corresponding devices in SOTI Connect.

File Format of the Bulk Custom Attribute Values Import File

About this task

Review the following information on the file format requirements for importing Bulk Custom Attribute Values.
  • The import file must be in .csv format.
  • Administrator permissions are required to perform this operation.
  • The .csv file must follow this column order:
    serial number, device type name, property name, property value
    Note: Headers are optional but the column order must be maintained.
  • The Device Type Name must match the one associated with the given serial number.
  • Maximum file size: 100,000 rows.
  • Supported value types: Text, Integer, Float, Boolean, Datetime, Geolocation, and IPv4 Address.
Value Format Examples
  • Datetime accepted formats: YYYY-MM-DDTHH:MM:SS.sssZ, YYYY-MM-DDTHH:MM:SS, YYYY-MM-DD. For example, 2023-10-17T22:33:10.054Z or 2023-10-17
  • Geolocation accepted format:latitude;longitude;altitude (values separated by semicolons). For example, 27.2;35.6;409.
Note: Use the American numeric format for decimal values (for example, 25.5, not 25,5).