ansible_xlsx_inventory

ansible_xlsx_inventory copied to clipboard

Multiple Issues have been reported, But I can not be 100% sure if these are actual problems or the Script working as intended, because there is no testing in place....

KeyboardInterrupt

hostname_col not used for grouping in sheet_to_inventory()

2

Hello, i think in the sheet_to_inventory(), the grouping is assuming that hostname is in column '0' : `groups['_meta']['hostvars'][row[0].value][var_name.value.lower().replace(' ', '_')] = row[idx].value` I think it should be `groups['_meta']['hostvars'][row[hostname_col].value][var_name.value.lower().replace(' ', '_')]...

BenoitCattie

Expected key=value host variable assignment, got: json

1

Hi I am playing with your example files and I am getting mixed results. Some executions work and others do not. Is your excel "hard coded" to only accept certain...

rudimocnik

After running script and getting sheet name errors, had a look. Change1: python3 Change2: try except more specific to track bug Fix1: Strip quotes from config values. config["sheet"].strip('"') Fix2: line...

diepes

Add a README.md Section explaining how to convert xlsx Files into regular Inventorys.

2

I would like to point out in the README.MD That you don't have to live with an SpreadSheet as your Inventory! And that I absolutely don't encourage you to do...

KeyboardInterrupt