Ansible import excel format price list from supplier and export to remote inventory unit how to

[Michael Chan]

Hi I am not sure if this idea even possible, I want to use Ansible to pull price list from suppliers and remotely send and (copy) into designated inventory (remote servers) these update price lists are in excel and once the price list are updated, the cost and budget are also updated based on the latest changes, can someone please help me if there is a module can do such task.

[Stefan Hornburg (Racke)]

It is likely that this is possible, you probably can utilize standard Ansible modules for your project.

"uri" for pulling price lists
"copy" for sending the price lists to the remote servers
"command" to run the updates

Regards
Racke

> --
> 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
> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/18638e9b-857c-48a8-8810-36ffffa9c01e%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/18638e9b-857c-48a8-8810-36ffffa9c01e%40googlegroups.com?utm_medium=email&utm_source=footer>.


--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.

[Michael Chan]

Hi racke

If the web site requires login user/pw for access right, what module I should use?

Thanks

MC

To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/8849a184-27e5-833d-33ce-c76656cbcfe5%40linuxia.de.

[Stefan Hornburg (Racke)]

On 5/17/20 2:08 PM, Michael Chan wrote:
> Hi racke
> If the web site requires login user/pw for access right, what module I should use?
> Thanks
> MC

Hello Michael,

please checkout the examples in the documentation of the URL module:
https://docs.ansible.com/ansible/latest/modules/uri_module.html.

They show how to login and keep the cookie for for subsequent requests.

Regards
Racke

>
> On Thu., May 14, 2020, 1:32 a.m. Stefan Hornburg (Racke), <ra...@linuxia.de <mailto:ra...@linuxia.de>> wrote:
>
> On 5/14/20 8:28 AM, Michael Chan wrote:
> > Hi I am not sure if this idea even possible, I want to use Ansible to pull price list from suppliers and remotely send
> > and (copy) into designated inventory (remote servers) these update price lists are in excel and once the price
> list are
> > updated, the cost and budget are also updated based on the latest changes, can someone please help me if there is a
> > module can do such task.
> >
>
> It is likely that this is possible, you probably can utilize standard Ansible modules for your project.
>
> "uri" for pulling price lists
> "copy" for sending the price lists to the remote servers
> "command" to run the updates
>
> Regards
>          Racke
>
> > --
> > 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

> > ansible-proje...@googlegroups.com <mailto:ansible-project%2Bunsu...@googlegroups.com>
> <mailto:ansible-proje...@googlegroups.com <mailto:ansible-project%2Bunsu...@googlegroups.com>>.

> > To view this discussion on the web visit
> > https://groups.google.com/d/msgid/ansible-project/18638e9b-857c-48a8-8810-36ffffa9c01e%40googlegroups.com
> >
> <https://groups.google.com/d/msgid/ansible-project/18638e9b-857c-48a8-8810-36ffffa9c01e%40googlegroups.com?utm_medium=email&utm_source=footer>.
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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

> ansible-proje...@googlegroups.com <mailto:ansible-project%2Bunsu...@googlegroups.com>.

> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/8849a184-27e5-833d-33ce-c76656cbcfe5%40linuxia.de.

>
> --
> 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
> ansible-proje...@googlegroups.com <mailto:ansible-proje...@googlegroups.com>.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/ansible-project/CAEjfaEfgF_nO3tEyVGakKR%3DtFTri4YBVGgmaNTm%2BDrB7kraLLw%40mail.gmail.com
> <https://groups.google.com/d/msgid/ansible-project/CAEjfaEfgF_nO3tEyVGakKR%3DtFTri4YBVGgmaNTm%2BDrB7kraLLw%40mail.gmail.com?utm_medium=email&utm_source=footer>.