xls_to_facts yaml

[yansen14]

Hi,

i am following your video how to build evpn by getting information from XLS.

Appreciate if you are able to share yaml to call xls_to_facts module created on your github

i am trying the yaml as below but it still doesn;t work

• name: Import host-specific facts from a XLS file
  xls_to_facts:
  src: "evpn_config_template.xlsx"

• name: Render switch global configuration commands
  template:
  src: spine_global.j2
  dest: "{{configuration_file.type}}"

Thanks,
Best Regards,
Yansen

[mamullen13316]

Hi, i'm sorry for the delayed response. For some reason I did not receive notification of this issue being opened, possibly it went to my SPAM folder. The yaml syntax for the xls_to_facts above is correct. The xls_to_facts.py file has to be copied to the library path specified in the ansible.cfg file. The default library path is: /usr/share/ansible. If the file is copied to the correct location, it should be possible to execute the module using the command line to test:

ansible -m xls_to_facts

You will also need to specify an existing .xls file as the src. The "evpn_config_template.xlsx" would need to be changed to "example.xlsx" which is the file that I provided to test with on Github.

I'm guessing you figured this out since it has been a couple of months. If possible, please let me know if you have resolved the issue and what the resolution was.

Thanks,
Matt