25.1.6_2 Import CSV with static dns mappings into DnsMasq

[davidfi01]

What is the format needed for the csv file used to import static dns mappings into dnsmasq?

Thanks in advance.

D

[julsssark]

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.

[davidfi01]

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

[wrobelda]

I wrote a script to convert the ISC mappings to DnsMasq CSV file, hopefully someone finds that useful:

https://gist.github.com/wrobelda/403fe4e7ff542ce14a4bba9a06e40777

[meyergru]

There is also this Github repo, which can be used for much the same purpose.

[julsssark]

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.