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 [email protected]. To post to this group, send email to [email protected]. 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.
