How to export data of successfull build to excel

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

How to export data of successfull build to excel

dursun.julide
Hello,

I wanted to know whether it is possible to export certain data from jenkins to excel when a build is successful. The excel data is saved in a specific directory and has 3 columns. The email-adress (column 1)  of the owner of the successful build, the name of the task (column 2) and 100 points (column 3) should get exported from the jenkins build to the excel file.

How can I do this? Do you have any advices? I would be very thankful :)

--
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/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: How to export data of successfull build to excel

Richard Ginga
i did something similar to gather build time info and it was simply to append to some accessible .csv file in a shell or batch script :)

On Mon, Jul 31, 2017 at 10:47 AM, <[hidden email]> wrote:
Hello,

I wanted to know whether it is possible to export certain data from jenkins to excel when a build is successful. The excel data is saved in a specific directory and has 3 columns. The email-adress (column 1)  of the owner of the successful build, the name of the task (column 2) and 100 points (column 3) should get exported from the jenkins build to the excel file.

How can I do this? Do you have any advices? I would be very thankful :)

--
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/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Dick Ginga
Build Engineer

--
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/CAL3PpaWDmD4WQaSceqpOsSOaT%2B7ZzkGpmKPmRpmw6%2BBo1govtg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: How to export data of successfull build to excel

dursun.julide
And how are you doing it exactly?

Am Montag, 31. Juli 2017 16:59:06 UTC+2 schrieb Richard Ginga:
i did something similar to gather build time info and it was simply to append to some accessible .csv file in a shell or batch script :)

On Mon, Jul 31, 2017 at 10:47 AM, <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="SnmJvmBXAgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">dursun...@...> wrote:
Hello,

I wanted to know whether it is possible to export certain data from jenkins to excel when a build is successful. The excel data is saved in a specific directory and has 3 columns. The email-adress (column 1)  of the owner of the successful build, the name of the task (column 2) and 100 points (column 3) should get exported from the jenkins build to the excel file.

How can I do this? Do you have any advices? I would be very thankful :)

--
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 <a href="javascript:" target="_blank" gdf-obfuscated-mailto="SnmJvmBXAgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">jenkinsci-use...@googlegroups.com.
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/jenkinsci-users/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com?utm_medium=email&amp;utm_source=footer" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/msgid/jenkinsci-users/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/msgid/jenkinsci-users/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com?utm_medium\x3demail\x26utm_source\x3dfooter&#39;;return true;">https://groups.google.com/d/msgid/jenkinsci-users/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.



--
Dick Ginga
Build Engineer
<a href="javascript:" target="_blank" gdf-obfuscated-mailto="SnmJvmBXAgAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">rgi...@...

--
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/1a925865-fdb2-488a-ae26-2d3c2036bf93%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: How to export data of successfull build to excel

Richard Ginga
As I remember, we wrote a perl script to append a line containing dozens of step timings from out builds to the end of the file. but this should work:

echo "$OWNER, $TASK, 100" >> some-network-path/Test.dat

On Mon, Jul 31, 2017 at 2:52 PM, <[hidden email]> wrote:
And how are you doing it exactly?

Am Montag, 31. Juli 2017 16:59:06 UTC+2 schrieb Richard Ginga:
i did something similar to gather build time info and it was simply to append to some accessible .csv file in a shell or batch script :)

On Mon, Jul 31, 2017 at 10:47 AM, <[hidden email]> wrote:
Hello,

I wanted to know whether it is possible to export certain data from jenkins to excel when a build is successful. The excel data is saved in a specific directory and has 3 columns. The email-adress (column 1)  of the owner of the successful build, the name of the task (column 2) and 100 points (column 3) should get exported from the jenkins build to the excel file.

How can I do this? Do you have any advices? I would be very thankful :)

--
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/a20add41-82ea-4141-8ba7-7610a2f9bc9a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Dick Ginga
Build Engineer

--
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/1a925865-fdb2-488a-ae26-2d3c2036bf93%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Dick Ginga
Build Engineer

--
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/CAL3PpaWferdQGD2Qhh78yevJZPigK5%2Bbwa1-iwHEPNu8G_Go-A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.