Not sure if you figured this out yet or not. But thought I would share with you how I was able to do this and it works really well. I do not use the CSV lookup as it didn't seem to work how I needed it to (or I just couldn't make it work) so I just used the file lookup.
https://everythingshouldbevirtual.com/automation/ansible-parsing-csv-list-hosts-ip-hostnames-mac/ On Wednesday, November 22, 2017 at 8:52:00 PM UTC-5, parwinderjit singh wrote: > > Hi All, > > > I have a excel sheet which contain 1000 server hostname with there IP > address. I have to create a ansible host file from that sheet. My question > is, is there a east way to create a ansible host file or i have to manually > create hostfile for all 100 server ? > > > Thanks & Regards, > > -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscr...@googlegroups.com. To post to this group, send email to ansible-project@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/d370377e-6f7b-4b5a-8728-1a821f2f7cdd%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
