Troubleshooting Tip: Consideration on How to import DHCP scopes from a CSV file into FortiNAC

[dbu]

Description	This article describes an issue where importing DHCP scopes via CSV file fails to import correctly. After import, the first registration scope begins with question marks '???' or there are blank data fields.
Scope	FortiNAC-F.
Solution	Based on the Admin Guide, the following are the Field Requirements when constructing the CSV file. Must be unique for each route scope imported. If it is not unique, the record with the first instance of the ScopeLabel field is duplicated for each subsequent instance of the identical ScopeLabel. Should not begin with any of these strings: 'REG_', 'REM_', 'AUTH_', 'DE_', 'ISOL_', 'VPN_', or 'HUB_'. These are reserved. Should not contain spaces.  Based on the requirements above, the following CSV file is correct:  Sometimes when importing  this file on FortiNAC  the first entry begins with '???' as below. Hint: Probably file is saved as CSV UTF-8 (Command Delimited) or CSV (Commad Delimited) format. The correct format should be CSV (MS-DOS). Solution:  Delete the imported scopes. Save file in CSV (MS-DOS) format. Import CSV file again. The Registration Scopes should look fine. Next step: In order for the Scopes to appear on the Summary page and Additional Routes to be added, the Interface needs to be configured with IP address, Subnet Mask, and Default Gateway. Another scenario is when after import of the file it shows blank scope data for the entries.  This can happen if there are empty spaces in the Scope name.  Solution:  Delete the imported scopes. Remove empty spaces. Import the CSV file again. The Registration Scopes should now look fine.