How to pull parameters from excel sheet and pass it to job

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

How to pull parameters from excel sheet and pass it to job

Devops-warrior
I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

Re: How to pull parameters from excel sheet and pass it to job

slide
I don't think there is a way to do this right now.  https://plugins.jenkins.io/ui/search?query=excel

You may need to do something in a shared library or something similar.

On Wed, Jul 1, 2020 at 12:45 PM Devops-warrior <[hidden email]> wrote:
I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.


--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: How to pull parameters from excel sheet and pass it to job

Ivan Fernandez Calvo
In reply to this post by Devops-warrior
you can pass a CSV file as a parameter or download it from a bucket or something and you can read it with https://www.jenkins.io/doc/pipeline/steps/pipeline-utility-steps/#readcsv-read-content-from-a-csv-file-in-the-workspace so if you convert that excel file to CSV you could read it.

El miércoles, 1 de julio de 2020, 21:44:59 (UTC+2), Devops-warrior escribió:
I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/04961702-ac5a-4d2f-8a04-dd33454e7faco%40googlegroups.com.
Reply | Threaded
Open this post in threaded view
|

RE: How to pull parameters from excel sheet and pass it to job

David Riemens
In reply to this post by slide

Is XLS a requirement?

If not too difficult you could go for a simpler format (INI ?) that you could parse using some relatively simple Groovy code ?

 

 

 

From: [hidden email]
Sent: Wednesday, July 1, 2020 21:56
To: [hidden email]
Subject: Re: How to pull parameters from excel sheet and pass it to job

 

I don't think there is a way to do this right now.  https://plugins.jenkins.io/ui/search?query=excel

 

You may need to do something in a shared library or something similar.

 

On Wed, Jul 1, 2020 at 12:45 PM Devops-warrior <[hidden email]> wrote:

I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.


 

--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com.

 

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/5f0f5621.1c69fb81.ee4cb.492fSMTPIN_ADDED_MISSING%40gmr-mx.google.com.
Reply | Threaded
Open this post in threaded view
|

Re: How to pull parameters from excel sheet and pass it to job

slide
Also, can you show how you would want something like this to work?

On Wed, Jul 15, 2020 at 12:16 PM 'David Riemens' via Jenkins Users <[hidden email]> wrote:

Is XLS a requirement?

If not too difficult you could go for a simpler format (INI ?) that you could parse using some relatively simple Groovy code ?

 

 

 

From: [hidden email]
Sent: Wednesday, July 1, 2020 21:56
To: [hidden email]
Subject: Re: How to pull parameters from excel sheet and pass it to job

 

I don't think there is a way to do this right now.  https://plugins.jenkins.io/ui/search?query=excel

 

You may need to do something in a shared library or something similar.

 

On Wed, Jul 1, 2020 at 12:45 PM Devops-warrior <[hidden email]> wrote:

I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.


 

--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com.

 

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/5f0f5621.1c69fb81.ee4cb.492fSMTPIN_ADDED_MISSING%40gmr-mx.google.com.


--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVcafOG%2BdjeRf0b5b%2BPzPRVrZH_%2B2oA0niTmhbQE%2BYpiEg%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: How to pull parameters from excel sheet and pass it to job

Braj Mohan
Hi All, You can pull the parameter from excel using shell script below is the code please check here i am using a google spreadsheet and fetch the particular field, you can fetch multiple fields also

#URL=https://docs.google.com/spreadsheets/d/e/2PACX-1vTSkSdNFjtRjZGzsf5NO3TJdaMeBNTYplU8EdN0iXUQXFMVIsdmf9N0g6X1eUYFpchxhE4/pub?output=txt

#URL=https://docs.google.com/spreadsheets/d/e/2PACX-1vTSkSdNFjtRjwYt7wpjZGzsf5NO3TJYplU8EdN0iXUQXFMVIsdmf9N0g6X1eUYFpchxhE4/pub?output=txt

RESULT=$(wget --no-check-certificate -q -O - $URL | sed '1 d' | cut -f7 )
echo ${RESULT} >/var/lib/jenkins/workspace/output/FrameWork.txt


RESULT1=$(wget --no-check-certificate -q -O - 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTn0s1SuFDDo6M2C1Ey_hrP9rxlb-Uap2ciD77GZdvjZeWzf_mk0fPrHgVa0W5EYM/pub?gid=1140914179&output=txt' | sed '1 d' | cut -f7 )
echo ${RESULT1} >/var/lib/jenkins/workspace/output/output.txt

hope this will work for you

Thanks

B.M. Wadia


On Thu, Jul 16, 2020 at 1:30 AM Slide <[hidden email]> wrote:
Also, can you show how you would want something like this to work?

On Wed, Jul 15, 2020 at 12:16 PM 'David Riemens' via Jenkins Users <[hidden email]> wrote:

Is XLS a requirement?

If not too difficult you could go for a simpler format (INI ?) that you could parse using some relatively simple Groovy code ?

 

 

 

From: [hidden email]
Sent: Wednesday, July 1, 2020 21:56
To: [hidden email]
Subject: Re: How to pull parameters from excel sheet and pass it to job

 

I don't think there is a way to do this right now.  https://plugins.jenkins.io/ui/search?query=excel

 

You may need to do something in a shared library or something similar.

 

On Wed, Jul 1, 2020 at 12:45 PM Devops-warrior <[hidden email]> wrote:

I have a job which will deploy web, app and DB servers into AWS cloud. As of now we are taking Ip's for each server from Network team and passing manually in build paremeters. Can someone help me? how to pull parameters from excel sheet and pass it on to jenkins job.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.


 

--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com.

 

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/5f0f5621.1c69fb81.ee4cb.492fSMTPIN_ADDED_MISSING%40gmr-mx.google.com.


--

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVcafOG%2BdjeRf0b5b%2BPzPRVrZH_%2B2oA0niTmhbQE%2BYpiEg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Jenkins Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPEKM0puP6c7UdaXGbnYv7t0GSDtqXX%3D11kMWAiibHmiq8LfOg%40mail.gmail.com.