Solutions for importing DHCP static assignments

[cjnazz]

I'm new to pfSense, and went looking for a solution for managing DHCP static assignment. Here are the solutions I found from Reddit, Github, and Netgate forum searches. If I had found Uproot before I wrote my own I probably would have tried it out.

Bulk DHCP entries import for pfSense
.csv to pfSense to .xml and then hand edit into the backup config.xml. Ruby
From https://github.com/cmer/pfsense-bulk-dhcp-import

dhcpd_to_pfsense
Convert from hand edited dhcpd.conf to partial pfSense .xml and hand insert into config.xml. Python
From https://github.com/PaaaulZ/dhcpd_to_pfsense

PFsense custom DHCPD configuration
Jam an alternate dhcpd.conf file in place after pfSense boot, then restart dhcpd. Bash script
From https://happy-coder.com/2014/06/27/pfsense-custom-dhcpd-configuration/

Scripting pfSense DHCP static assignments
Excel (.xlsx to .csv) to rebuild of the dhcpd-backup.xml and reload into pfSense. Windows PowerShell
From https://www.chadmccune.net/2020/07/30/scripting-pfsense-dhcp-static-assignments/

UPROOT
uprt (uproot) is a multi-platform (Windows, MacOs, and Linux) command line utility to convert static leases between routers. Dart
From https://github.com/GeekVisit/uproot/

dhcpcsv2pfsense - Merge DHCP static assignments .csv data into pfSense DHCP Server config file
My solution… Masters the static assignments in a .csv file and merges them completely into the pfSense dhcpd-config.xml. Python
From https://github.com/cjnaz/dhcpcsv2pfsense

[cjnazz]

What's your preferred/recommended solution?

[cjnazz]

I just posted dhcpcsv2pfsense V1.0 which supports loading static assignments to multiple VLAN DHCP servers. https://github.com/cjnaz/dhcpcsv2pfsense