Is there a way to upload static leases?

As per the heading, is there a way to upload static leases into the router from say a CSV file?

Conversely is there a way to download the static leases to a CSV file?

Hello,

Thank you for reaching out!

There is no way in WebUI to upload static leases into the router from a CSV file. But since RutOS is based on OpenWRT Linux distribution, there are a few ways how to automate the Static lease configuration:

uci add dhcp host
uci set dhcp.@host[0].name='device_name'
uci set dhcp.@host[0].mac='mac_address'
uci set dhcp.@host[0].ip='ip_address'
uci commit dhcp
/etc/init.d/dnsmasq restart

Best regards,
Kacper

Yes there is. I can’t find the post but someone posted an awk script. See below.

I found the original post and @flebourse was the author.

1 Like

Excellent! Thank you. I’ll give that a go. I keep the static lease information in an Excel file so I’ll create a script to automatically generate the scripts files for the router.

My pleasue … works like a charm … Mike

P.S. I don’t know if it will make a difference but I make sure that the .txt file is saved in the Unix format and not the Windows format. Unix ‘End of Line’ = LF vs Windows = CR + LF (if I remember rightly). Not a problem, as Notepad++ will open up the Windows file and save it in the Unix format if you tell it to.