OPNSense DHCP Import

Overview

This simple script allows you to bulk import DHCP reservations to your OPNSense router.

It currently supports .csv files with a very specific format.

How-to

  1. Generate a .csv file with the columns:
  • macaddr
  • ipaddr
  • hostname
  • description
  1. Put your data into said CSV
  2. Save the file into data/input_reservations.csv
  3. Run opnsense-dhcp-import.py
  4. Import generated XML backup data/output_dhcp_reservations.xml into OPNSense (specify DHCP only!)
  5. Cross fingers, and test!

TODO

  • Actually saving XML
  • Other input formats
  • JSON
  • Other router backups?
  • Testing
  • OPNSense
  • pfSense
  • Maybe update OPNSense directly with API??!