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 <[email protected]> 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 > [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 > <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 [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/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
