Import host.csv not working or impatient

[jquilli1]

Server

• FOG Version: 1.3.0-RC-15
• OS: Ubuntu 14.04

Client

• Service Version: 0.11.5
• OS: Windows 10 Pro x64

Description

Importing host.csv doesn’t seem to be importing the whole list - or maybe I’m just impatient.
I’ve downloaded our DHCP client list and only have the MAC, hostname, added image ID, and OSID. When
I import the list only 5 or 6 clients are actually imported. The rest do not show up. There’s about 177 clients
total.

[Wayne Workman]

Hosts don’t have an OSID. Try losing that field. You may also try loosing the image ID field too, it’s not necessary to have.

The minimum you must have is two columns, MAC and hostname. First column is a MAC address, the second column is hostname. These are separated by a comma, and are not in quotes.

The other stuff you can set as you need via the web interface.

[jquilli1]

@Wayne-Workman
Still having issues with this.
My excel spreadsheet looks like this:

Column 1
01:23:45:67:89:10

Column 2
Hostname

I’m saving it as a .csv (comma delimited)
It shows all hosts have imported successfully but will only import the same 6 hosts as before and no one else.

[jquilli1]

@Wayne-Workman
Nevermind it was user error obviously.
The hostnames were way too long and weren’t being imported.

Any chance an error can be thrown in stating that hostnames are too long instead of showing import successfully?
Thanks for the help btw!

[Wayne Workman]

@jquilli1 said in Import host.csv not working or impatient:

Any chance an error can be thrown in stating that hostnames are too long instead of showing import successfully?

I’d like to tell you no because FOG is in release candidate mode, which means bug fixes only. Also should fog throw an error if you’re importing… say 5,000 hosts and one of them is messed up? I want my import of 4,999 computers to go through so I can work. Plus again, release candidate mode.

It’s up to @Tom-Elliott

[Tom Elliott]

The idea of the import is to pull in what can be imported. Those that are invalid are simply skipped. The message should show x number of success vs. x number of failed though, is this not happening?

[jquilli1]

@Tom-Elliott
It would show 177 imported. It would throw an error for a few but I know what’s wrong with those ones in the .csv already. So in a way it’s spitting out errors like “not valid mac address”.

[Wayne Workman]

@jquilli1 If you don’t mind, you could post the file here via google drive or mega or something like that. You could also email it to one of us. I’m going to be busy for a while, message Tom.

[Tom Elliott]

I’m an even worse candidate. I can’t do anything until I get home.

[Quazz]

I’d just like to chime in and discourage using Excel to save csv files.

It tends to fuck up formatting, save large numbers in scientific notation and so forth.