Hi, I am very new to Ansible and rightly or wrongly I am trying to apply my old scripting knowledge to the product which may or may not be the right thing to do! So I was hoping people could steer me in the right direction for the challenge I have.
We are looking to deploy Ansible and Ansible Tower to build out complete infrastructures (SDN, Compute etc). The first challenge I have come across is that I cannot find an easy way to import data from a spreadsheet into Ansible. We will have all the configuration details for X amount of virtual machines, and we don’t want to then have to manually enter these into a web form. I can fairly easily convert the spreadsheet to CSV or XML but will take a fair amount more work to convert it to a yml file, so my preference is to keep it as CSV or XML. I have looked and looked on the web for importing entire CSV files and have had little luck with the lookup(‘csvfile’) command. So my question is:
Is there an easier way of doing this within Ansible am I approaching this incorrectly for this platform?