OPNsense Forum

English Forums => 25.1, 25.4 Series => Topic started by: danbet on September 26, 2025, 01:58:57 PM

Title: Cannot import hosts from csv file under Dnsmasq DNS & DHCP, Hosts
Post by: danbet on September 26, 2025, 01:58:57 PM
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.
Title: Re: Cannot import hosts from csv file under Dnsmasq DNS & DHCP, Hosts
Post by: danbet on September 26, 2025, 02:18:34 PM
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.