Exporting Host Info to CSV

[GTF]

I’ve built a new 1.0.1 server (ubuntu 12.04 LTS) and am migrating our images and hosts over from our .32 server. Using the info here [url]http://www.fogproject.org/wiki/index.php/Manual_Migration_Upgrade_from_0.32_to1.0[/url] I was able to move the images, but can’t figure out how to get the host list into a CSV.

I’ve tried [FONT=Consolas]#mysqldump -u root -p[password] fog hosts > hosts.sql (on .32) and [/FONT][FONT=Consolas]#mysql -u root -p[password] fog < hosts.sql (on 1.0.1) but I get and “ERROR 1064: You have an error in your SQL syntax…” when trying to import.[/FONT]

[FONT=Consolas]So, is there way to get the data into a CSV to import through the new GUI, or can anyone point me in the right direction regarding the syntax error?[/FONT]

[FONT=Consolas]Thank you.[/FONT]

[Junkhacker]

on the hosts page “export hosts”

[GTF]

Sorry, I’m not seeing it…

[ATTACH=full]885[/ATTACH]

[url=“/_imported_xf_attachments/0/885_fog_hosts.JPG?:”]fog_hosts.JPG[/url]

[Junkhacker]

oh, sorry, i didn’t realize that was a new feature
there still should be a way to export the host list from the Reports page
an example file of how the CSV file should be formatted can be downloaded from the 1.0+ Hosts->Import Hosts page

[GTF]

Brilliant! That’s the stuff.

Thanks for your help.

[Wayne Workman]

For future readers: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG