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.

[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 <awscl...@gmail.com> 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 jenkinsci-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com.

--

Website: http://earl-of-code.com

[Ivan Fernandez Calvo]

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.

[David Riemens]

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 ?

To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com.

 

[Slide]

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

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.

--

Website: http://earl-of-code.com

[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

To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVcafOG%2BdjeRf0b5b%2BPzPRVrZH_%2B2oA0niTmhbQE%2BYpiEg%40mail.gmail.com.