KEA DHCP reservations - format of CSV for batch import

[Jiheffe]

Sorry if I missed the obvious in the help documentation...

What is the format of the CSV file to use for uploading DHCP reservations?
I tried the following format:

Code Select Expand

192.168.2.0,192.168.2.22,02:92:f7:19:8b:78,VM-HomeAssistant,'Node 100 on proxmox-main'
and also

Code Select Expand

192.168.2.0/24,192.168.2.22,02:92:f7:19:8b:78,VM-HomeAssistant,'Node 100 on proxmox-main'
But I get these errors for each line:

Code Select Expand

192.168.2.0,192.168.2.22,02:92:f7:19:8b:78,VM-HomeAssistant,'Node 100 on proxmox-main'
[hw_address] Duplicate entry exists.
[subnet] A value is required.
[ip_address] Address not in specified subnet

Subnet 192.168.2.0/24 has been properly declared in the "Subnet tab" with a pool set to 192.168.2.241-192.168.2.254 (I only need few "floating" addresses, all others are assigned through reservations).

Migrating my DHCP from a Pihole to OPNsence and discovering all its potential, please bear with me :-)

[meyergru]

Why don't you try to export reservations to see what the format is?

You will find this structure:

ip_address;hw_address;hostname;description;option_data;option

[nero355]

Subnet 192.168.2.0/24 has been properly declared in the "Subnet tab" with a pool set to 192.168.2.241-192.168.2.254 (I only need few "floating" addresses, all others are assigned through reservations).

At least that's good! :)

Migrating my DHCP from a Pihole to OPNsence and discovering all its potential, please bear with me :-)

Pi-Hole's FTLDNS = DNSmasqd + Extra features

So you could use DNSmasqd in OPNsense with a lot of the same config lines ;)

This is how my Export from ISC DHCP Server looked like and Imported without any issues into KEA DHCP Server :

Code Select Expand

ip_address,hw_address,hostname,description
192.168.1.2,b8:27:eb:20:f4:03,unipi,"Raspberry Pi 3B - UniFi Controller & Pi-Hole"The rest of the lines look like line #2 as well.