I am trying to import several host using the bulk import feature. It has worked many times before. I am running the RAW version 2.1.0p 22 on Ubuntu 22.04. I have tried several different CSV files. I have even pasted 10 hosts and IP and tried it and still get the following error:
Invalid value in column 1 (ipaddress) of row 0: Invalid host address. You need to specify the address either as Host- or DNS name, IPv4 address.
Maybe if you can show us the data we could see where the issue is.
That is it. Like I said it has worked before. Not sure why it stopped or why I am getting the error.
Not to push, and without having checked the ‘werks’, but 2.1.0p22 is not the ‘latest’ as in releases regarding the 2.1.0pX -series of CMK, so have you considered upgrading to a newer release ? (as latest available is 2.1.0p37)
Background:
If ( which i cannot confirm atm) there was a problem with bulk import and it was detected it surely would have been fixed in later releases.
Seeing you at 2.1.0p22 means you are potentially missing those.
Also what is unclear (to me) is when you say “it has worked before”, was this on the same version/patch-level?
…just trying to rule out possible causes here.
Hi @pbrogers,
maybe some blanks in the IPv4 address column?
Karl
Please show the unedited CSV in a code block. You use RFC1918 addresses anyway, so no need to hide them.
I was able to upgrade to the last version 2.1.0p37.
Here is the data that I tried to simple past and still get the same error. I am not sure what code block is.
Hi,
A code-block can be made by using the 
icon when creating a post.
This will create the following:
Paste the content of the file between the tickboxes (replacing the line “type or paste your code here”)
As example :
The result (see below) is the shiney markup from my test-csv-file.
I have tried to recreate the issue which you are facing, and made the following .csv-file:
testimport01,192.168.1.201
testimport02,192.168.1.202
testimport03,192.168.1.203
testimport04,192.168.1.204
testimport05,192.168.1.205
testimport06,192.168.1.206
testimport07,192.168.1.207
testimport08,192.168.1.208
testimport09,192.168.1.209
testimport10,192.168.1.210
Then offered/uploaded it to my CRE 2.1.0p37 setup via Upload.
By default the checkbox for “has title line” was on, but as you see above i did not make one, so the 1st line was not seen in the preview, unticked it, clicked Update Preview, and the 1st line is also there.
Then selected the correct column-name for both the hostname and the ipv4 address from the drop-down.
So this scenario did not produce the error.
Went a bit further by adding a header line with column-names:
Hostname,IPv4 address
testimport01,192.168.1.201
testimport02,192.168.1.202
testimport03,192.168.1.203
testimport04,192.168.1.204
testimport05,192.168.1.205
testimport06,192.168.1.206
testimport07,192.168.1.207
testimport08,192.168.1.208
testimport09,192.168.1.209
testimport10,192.168.1.210
Again did the import, left option has title line checked, this was accepted without getting the error you have seen.
I tried the same with pasting the content directly, and (both cases) i was unable to reproduce your error.
So as @r.sander suggested, please share your csv-file in the post.
I finally got a CSV file uploaded and imported. I played around with the file in Notepad ++ and got all of the spaces out. Thanks for all of the assistance.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.