Issue
Importing Security Expert controllers' serial numbers will break the import process and result in only creating default templates for the controllers.
Product Line
EcoStruxure Security Expert
Environment
- Security Expert Server
- Security Expert Data Sync Service
Cause
Security Expert controllers' serial numbers are displayed in hexadecimal. However, in the SQL database they are stored as decimal values. So the Data Sync Service is expecting a decimal integer and is instead receiving a string.
Resolution
Convert the serial numbers in the .CSV import file from hexadecimal to decimal. This can be done in excel using the "HEX2DEC" function. E.g. if the controller serial number is "ABCDEF12", it must be converted to decimal value "2882400018" before importing to Security Expert.