Automate uploading workload results on to results spreadsheet
Automate the process of uploading workload automation results on to google spreadsheet.
1. workload automation tool generates results.csv file which contains all mode of results. which needs to be populated on to Google spreadsheet.
2. LAVA daily job runs workload automation testing and generates Job_output file. This Job_output file contains all the execution stdout log along with each mode results. This job_output file needs to be parsed and generate results.csv file which should be similar to results.csv file generated from manual test. which needs to be populated on to Google spreadsheet.
Blueprint information
- Status:
- Complete
- Approver:
- Milosz Wasilewski
- Priority:
- High
- Drafter:
- Naresh Kamboju
- Direction:
- Approved
- Assignee:
- Milosz Wasilewski
- Definition:
- Approved
- Series goal:
- None
- Implementation:
- Implemented
- Milestone target:
- None
- Started by
- Milosz Wasilewski
- Completed by
- Milosz Wasilewski
Whiteboard
[nkambo May 3 2013] notes here
[nkambo May 3 2013] LAVA handled the task of adding a API to download job file. which is done now.
https:/
[mwasilew May 5 2013] Google Data API doesn't allow to format cells in the spreadsheet. Only value modification is possible. So the worksheet needs to be created before the data is populated from LAVA or from .csv file.
[mwasilew May 20 2013] Initial verision of the script available in bzr https:/
Meta:
Roadmap id: big.LITTLE Project
Headline: Automate the process of populating workload automation results on to Google spreadsheet.
Acceptance: Daily workload automation results should be populated on to Google spreadsheet automatically.
Work Items
Work items:
Create an API to download lava job_output : DONE
write a script to download job_output of a given job id : DONE
Write a script to parse lava results : DONE
write a script to parse results.csv file and populate results on to Google spread sheet: DONE