1.3.0-RC-13 Can't import Hosts

[Tom Elliott]

@Wayne-Workman Based on the error, I’ll guess nothing comes up.

[Tom Elliott]

Update to RC-14 and importing hosts will be fixed.

[FlareImp]

This post is deleted!

[FlareImp]

This post is deleted!

[Wayne Workman]

@FlareImp I can see the deleted messages, Just to clairify, is your host import working now?

[FlareImp]

I updated to RC-14, tried to import my hosts, its still showing 0 across the board. I then reinstalled Ubuntu, installed Fog RC-14, imported my hosts, 0 were imported.

[Wayne Workman]

@FlareImp I apologize for not looking at the file you sent me. I’m going to do that today. Something has got to be wrong with it.

[FlareImp]

@Wayne-Workman It’s the same file format I have used for my other fog servers. I have even tried using a file from another site that I know works.

[Wayne Workman]

@FlareImp Are you sure you’re on rc-14? What does the cloud say in the top left of the web gui?

Also, can you please run the following two commands to completely clean out the fog web directory and then immediately re-run the rc-14 installer please - and then try again?
rm -rf /var/www/fog
rm -rf /var/www/html/fog
Then re-run installer.

[FlareImp]

The cloud says:
Tue Oct 18, 2016 15:25 pm
Running Version 1.3.0-RC-14
SVN Revision: 5974

I will give those commands a try in the next hour and let you know the outcome.

[FlareImp]

I ran the two commands and then ran the installer. Afterwards I rebooted the server and then tried to import the hosts again with the same result.

Total Rows 0
Successful Hosts 0
Failed Hosts 0
Errors

[Wayne Workman]

@Tom-Elliott The import was working in RC-11.

I have confirmed that the import file that @FlareImp supplied me imported successfully in this commit:

https://github.com/FOGProject/fogproject/commit/d6cff6cfc2272cbde7764217292715129fc8c2a6

And that the issue became present in this commit:

https://github.com/FOGProject/fogproject/commit/3c916866f0f8ddc93c7f54edcf2eb48675606a90

And the issue remained present in RC-12, RC-13, RC-14, and the present working-RC-15 branch.

His CSV file is just two columns of data that are not quoted at all, just separated by a comma. First column is a MAC address, the second column is hostname.

I’ve replicated the format with my computers here at home for you to test with, here it is:
0_1476832244270_host_export.csv

[Tom Elliott]

Added better checking and allowing csv’s to contain equal to field count or less than from the csv.

[Wayne Workman]

@Tom-Elliott I just tried working-RC-15 version 51, its not importing the file I made, nor the file that @FlareImp gave me.

[Tom Elliott]

Sorry had flipped check. I meant to check if the comma fields was greater than what was expected, but was checking that the comma fields was less than or equal to.

This is fixed for sure now.

[Wayne Workman]

Confirmed fixed in rc-15.

@FlareImp you can either wait for RC-15 to be released, or you can message me for instructions on getting rc-15 before release - which may or may not be ideal at the moment, but I can confirm that this particular problem is resolved.

[FlareImp]

@Wayne-Workman Cool, I’m just glad a fix was found, has been driving me nuts! lol

Do you have an idea when RC-15 will go live?

Thanks for all your help on this guys, I really appreciate all that hard work everyone puts into helping us out!

[Wayne Workman]

@FlareImp said in 1.3.0-RC-13 Can't import Hosts:

Do you have an idea when RC-15 will go live?

No idea, but if I had to guess, probably the next weekend.

[FlareImp]

The RC-15 works now for me when trying to import hosts. I am seeing the same issue as posted here though.

In any case my submitted issue will be resolved in the RC-15 release.

Thank you all for the assistance.