What is the format needed for the csv file used to import static dns mappings into dnsmasq?
Thanks in advance.
D
I figured it out by creating a test entry and then doing an export. The headers in the export/import file are:
host,domain,ip,client_id,hwaddr,lease_time,ignore,set_tag,descr,aliases
I plan to migrate from KEA v4 over the weekend.
Hi -
1) How did you create the export?
2) can you supply a sample csv? I tried creating several (including one with your headers) and fail on import everytime.
I receive this error for every entry in the csv:
!! A value is required.
!! Option not in list.
best,
D
I wrote a script to convert the ISC mappings to DnsMasq CSV file, hopefully someone finds that useful:
https://gist.github.com/wrobelda/403fe4e7ff542ce14a4bba9a06e40777
There is also this Github repo (https://github.com/meyergru/iscdhcp_to_dnsmasq), which can be used for much the same purpose.
1) I exported the Kea reservations and opened them in Excel. I used all of the column headers as posted earlier (i.e., I left unused entries blank) and left the headers in the same order as posted (the Kea columns are named slightly different and are in a different order). I then copied/pasted the data into the correct columns. Lastly, I saved as CSV format and imported into DNSmasq.
2) Sorry, I did not save the import file. I deleted it after importing.