Re: [ansible-project] Re: Import excel file values to ansible

2018-05-10 Thread SUMIT SAHAY
Hi Brian, I want to read the content of the file using ansible playbook, is there a way to do this. If something is there kindly share the solution. Regards Sumit Sahay On Tuesday, 25 April 2017 01:11:09 UTC+5:30, Brian Coca wrote: > > For an example > http://docs.ansible.com/ansible/playbook

Re: [ansible-project] Re: Import excel file values to ansible

2017-04-24 Thread Brian Coca
For an example http://docs.ansible.com/ansible/playbooks_lookups.html#the-csv-file-lookup The include_vars/vars_file will read JSON (as it is a subset of YAML), Ansible does not support compressed files directly. -- Brian Coca -- You received this message because you are subscribed to

[ansible-project] Re: Import excel file values to ansible

2017-04-23 Thread Suporter
can you post an example to read csv file, and also when i have a compressed json ansible is not able to read it, can i decompress the json to make it work? On Thursday, April 20, 2017 at 2:01:17 PM UTC+5:30, Suporter wrote: > > i have an excel file with 2 columns and multiple rows of data, , bas

Re: [ansible-project] Re: Import excel file values to ansible

2017-04-21 Thread Brian Coca
Ansible has a 'csv' lookup plugin that can read the data, so somthing like: - lineinfile: ... with_csvfile: '/path/to/excel.csv' ... -- Brian Coca -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and

[ansible-project] Re: Import excel file values to ansible

2017-04-21 Thread Suporter
Thanks for the reply On Thursday, April 20, 2017 at 2:01:17 PM UTC+5:30, Suporter wrote: > > i have an excel file with 2 columns and multiple rows of data, , basically > like a key value pair, i want to import those as it is into win_Regedit for > creating registry entries, how can i do it? i wa

[ansible-project] Re: Import excel file values to ansible

2017-04-20 Thread Jordan Borean
You are probably best off using a flat text file for this as Ansible can't natively parse Excel files. A very basic (can't guarantee to work) example of using JSON for this would be JSON File: [ { "path": "HKLM:\\Software\\MyCompany", "name": "hello", "data": "world"

[ansible-project] Re: Import excel file values to ansible

2017-04-20 Thread Suporter
any help? On Thursday, April 20, 2017 at 2:01:17 PM UTC+5:30, Suporter wrote: > > i have an excel file with 2 columns and multiple rows of data, , basically > like a key value pair, i want to import those as it is into win_Regedit for > creating registry entries, how can i do it? i want the colu