← Back to Articles
Format a parameter list CSV File
Last Updated: July 07, 2026

To format the CSV configuration file in Excel with parameters listed down Column A and devices listed across in Row 1:

  1. Open the saved CSV file in Excel [to access a CSV file, All Files (*.*) must be selected in the Files of type field]:
  2. Stretch Columns A and B to display the data fields

    .

  3. Seven rows must be inserted above the identSerialNumber parameter.
    • Highlight Row
    • Click Insert.
    • Select Rows.
    • Repeat for each added row.
  4. Populate Column A with seven titles as shown in the illustration. The title Parameter in Cell A1 is needed to indicate Column A contains a list of parameters. The remaining six titles are SDM required parameters for every device.
  5. Trim the spreadsheet by deleting all of the parameter rows that have acceptable default data.
  6. Delete Column B, as the values are no longer needed to determine what default parameters can be trimmed from the spreadsheet.
  7. Add devices of the same type starting in Cell B1. Type the IP address or name (name must be listed with IP address in the \etc\hosts file).
  8. Populate the retained parameters.
  9. Save as completed spreadsheet. The type must be a CSV (for example, new_devices.csv). Click Yes

    to the format pop-up that is displayed:

  10. Use Notepad or another text editor to verify the CSV file.
    Parameter,193.1.15.2,193.1.15.3,193.1.15.4
sdmIdentModel,OM-1000,OM-1000,OM-1000
sdmIdentDeviceFirmware,3.4.1,3.4.1,3.4.1
sdmIdentDeviceIPAddress,193.1.15.2,193.1.15.3,193.1.15.4
sdmIdentDeviceSubnetMask,255.255.255.0,255.255.255.0,255.255.255.0
sdmIdentDeviceMACAddress,00:0f:0a:11:22:33,00:0f:0a:11:22:36,00:0f:
0a:11:22:39
sdmIdentDeviceGateway,193.1.15.1,193.1.15.1
identLocationRack,LocRacka,LocRackbLocRackc
identLocationShelf,LocShelfa,LocShelfb,LocShelfc
  11. Continue with Uploading the CSV File.