Hi Larry, Can you help me out. I am attaching one excel file and i want to make my host file like below
[cloudera_master] orion-RHEL-05 ansible_ssh_host=10.48.21.53 host_fqdn=orion-RHEL-05 orion-RHEL-06 ansible_ssh_host=10.48.21.54 host_fqdn=orion-RHEL-06 [cloudera_client] orion-RHEL-05 ansible_ssh_host=10.48.21.53 host_fqdn=orion-RHEL-05 orion-RHEL-06 ansible_ssh_host=10.48.21.54 host_fqdn=orion-RHEL-06 orion-RHEL-07 ansible_ssh_host=10.48.21.55 host_fqdn=orion-RHEL-07 orion-RHEL-08 ansible_ssh_host=10.48.21.56 host_fqdn=orion-RHEL-08 orion-RHEL-09 ansible_ssh_host=10.48.21.57 host_fqdn=orion-RHEL-09 regards parwinder On Sat, Dec 2, 2017 at 10:56 AM, Larry Smith <mrlesmit...@gmail.com> wrote: > 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 a topic in the > Google Groups "Ansible Project" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/ansible-project/YzQCV3D5ZM4/unsubscribe. > To unsubscribe from this group and all its topics, 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 > <https://groups.google.com/d/msgid/ansible-project/d370377e-6f7b-4b5a-8728-1a821f2f7cdd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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/CAEzRYMRUuk0D1QUPO5iWG1ovJ%2BXDo5Tx_S%2B5eyy2y33%2B0H4Sng%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
aaa.xlsx
Description: MS-Excel 2007 spreadsheet
