Export defect query results to file via command line?
I'm trying to find a programmatic way to export queried defect information to a local file. I know I can export defect information from a defect query in the web client by clicking the "export to .csv" feature.
Is there any way to do this via the command line? I need a way to export defect information to a local text file without using a GUI interface. For instance, ClearQuest includes a cqperl executable that can be run via command line where I can open a session with the CQ server and export to a local file. Looking for something in Jazz that will give me similar results. Thanks in advance! Jarett |
3 answers
I'm trying to find a programmatic way to export queried defect As the export functionality is available using plain HTTP, you could use 'curl' to download the CSV. The export URL looks as follows: https://server:port/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_7yQNQLYnEd29gJkOCv4V6Q?_mediaType=text/csv If your server is using form-based auth, you need to log in explicity (curl's -u parameter doesn't work here): COOKIES=./cookies.txt USER=user PWD=password HOST=https://localhost:9443/jazz curl -k -c $COOKIES -d j_username=$USER -d j_password=$PWD $HOST/j_security_check Then you can do the export: curl -k -b $COOKIES https://localhost:9443/jazz/resource/itemOid/com.ibm.team.workitem.query.QueryDescriptor/_7yQNQLYnEd29gJkOCv4V6Q?_mediaType=text/csv -- Regards, Patrick Jazz Work Item Team |
|
Patrick,
Thanks for the reply. I think this will work perfectly for what I need. I'm having some trouble getting the first command to work. When I try it like this: > curl -D -k -c "d:\cookies.txt" -d "j_username=username" -d "j_password=mypassword" https://server:9943/jazz/j_security_check I get an error from the site: HTTP Status 408 - The time allowed for the login process has been exceeded. If you wish to continue you must either click back twice and re-click the link you requested or close and re-open your browser. I get this same error on two different Jazz installs, each running TomCat. I haven't gotten the second command to work yet because the login isn't working yet. Any ideas? Thanks again, Jarett Stein |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.