Cannot import hosts from csv file under Dnsmasq DNS & DHCP, Hosts

Started by danbet, September 26, 2025, 01:58:57 PM

Previous topic - Next topic
September 26, 2025, 01:58:57 PM Last Edit: September 26, 2025, 02:03:02 PM by danbet Reason: Added more information about the version
I created two entries manually and exported them as a CSV file. I added more entries to this file. When I read in the data, each entry is reported as wrong:
f4040reception,1,192.168.200.2,e8:df:70:85:21:f1,0,FRITZ!Box 4040,,,,,
!! Value should be a boolean (0,1).
!! Please specify a valid network segment or IP address.
!! Value must be a colon-separated hexadecimal sequence (e.g., 01:02:f3) or "*".
!! Invalid MAC address.
and so on.
However, I don't see any problem with the MAC address or with specifying 0 or 1.
Version: 25.1.12
I have done this already on an other OPNsense box. Maybe earlier than 25.1.12. Shortly after upgrade in Juli 2025.

I just found the problem. While editing the CSV file with LibreOffice, the columns shifted. I corrected that, and now the import works. Sorry for the interruption.