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

Based on the Importing DHCP Scopes, 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.

• Using a domain name that already exists in the production network should be avoided; otherwise, DNS resolution may not function correctly.

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 the file is saved as CSV UTF-8 (Command Delimited) or CSV (Command Delimited) format.

The correct format should be CSV (MS-DOS).

Solution: 

1. Delete the imported scopes.
2. Save file in CSV (MS-DOS) format.
3. Import the CSV file again. The Registration Scopes should look fine.

Next step:

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 importing the file, it shows blank scope data for the entries. 

This can happen if there are empty spaces in the Scope name. 

Solution: 

1. Delete the imported scopes.
2. Remove empty spaces.
3. Import the CSV file again. The Registration Scopes should now look fine.