Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Solutions for importing DHCP static assignments

    Scheduled Pinned Locked Moved DHCP and DNS
    3 Posts 1 Posters 2.3k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      cjnazz
      last edited by

      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

      C 1 Reply Last reply Reply Quote 0
      • C
        cjnazz @cjnazz
        last edited by

        What's your preferred/recommended solution?

        1 Reply Last reply Reply Quote 0
        • C
          cjnazz
          last edited by

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

          1 Reply Last reply Reply Quote 0
          • johnpozJ johnpoz referenced this topic on
          • johnpozJ johnpoz referenced this topic on
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.