linaro-project-management team mailing list archive

[Mounir Bsaibes <mounir.bsaibes@xxxxxxxxxx>]

As I mentioned during our last meeting, I have created a prototype to
automatically create  blueprints from the roadmap cards.
to run the prototype download the attached files and run
roadmaptoBp-v2.py -f linaroRoadmap.csv
or
roadmaptoBp-v2.py -f linaroRoadmapShort .csv for a quick check.

In order to run the program you have to modify the cookies inside the
program with yours.
to do so, from firefox menu edit->preferences-> privacy -> 'remove
individual cookies" -> search for qastaging -> cut an past your cookie into
the program.

Cheers,
Mounir


-- 
Mounir Bsaibes
Project Manager

Follow Linaro.org:
facebook.com/pages/Linaro/155974581091106
http://twitter.com/#!/linaroorg
http://www.linaro.org/linaro-blog <http://www.linaro.org/linaro-blog>

#!/usr/bin/python
# Create Launchpad blueprints base on a csv file exported from Liaro Roadmap Kanban board 
# Author: Mounir Bsaibes <mounir.bsaibes@xxxxxxxxxx>
# Credit: Michael Hope <michael.hope@xxxxxxxxxx>



import optparse
import os
import sys

import csv

from launchpadlib.launchpad import Launchpad
import requests 


    
def createBp(card, lp): 
 numberOfFields = len(card)
 # if number of fields is less than 16, it means the csv line has a problem
 if numberOfFields < 16:
     print "error number of fields in the card is less than 16 skipping the card"
     return
 else:     
  
 # field 3 = card type = group so set project accrodingly
 # 
 
  
  
    
  if card[3] == "KWG":
      url = "https://blueprints.qastaging.launchpad.net/linux-linaro/+addspec";
      project = lp.projects["linux-linaro"]
  elif card[3] == "TCWG":
      url = "https://blueprints.qastaging.launchpad.net/gcc-linaro/+addspec";
      project = lp.projects["gcc-linaro"]
  elif card[3] == "PMWG":
      url = "https://blueprints.qastaging.launchpad.net/linaro-power-kernel/+addspec";
      project = lp.projects["linaro-power-kernel"]
  else:  
      print "Card type (project) not supported"
      return
  print url
  print project
  data = {
            'field.name': "mbTest-"+card[1],
            'field.title': card[4],
            'field.summary': card[4],
            'field.assignee': "",
            'field.drafter': "",
            'field.approver': "",
            'field.definition_status': "DISCUSSION",
            'field.actions.register': 'Register Blueprint'
        }
  print "data field" , data

  print "url is: "
  print url 
  headers = { 'Referer': url }
  cookies = { 'qastaging': 'IQqfbYRIA5y-1oigcX8B1e7ic0oqKbw7leZQ9LjYqBZ.YqzqSdyqcg' }

  # for staging
  #cookies = {'staging': 'klP2lW08Xqtw1IjEJ5BFxHes98wapOhve-NnBYrUJaAIbJ.gPEqEfs'}
  n = requests.post(url, headers=headers, data=data, cookies=cookies)
  #print n.content
  n.raise_for_status()


def parse_csv(file,lp):
  cardReader = csv.reader(open(file, 'rb'), delimiter=',', quotechar='|')
  for card in cardReader: 
    NewBp = createBp(card,lp)
    

def main():
 optparser = optparse.OptionParser()
 optparser.add_option('-f', '--file',
        help='Path to csv file', dest='file', metavar='PATH')
 
 (opts, args) = optparser.parse_args()
 if not opts.file:
    optparser.error('No csv file is given. usage: program -f csvfilename')
 else:
    fileToParse=opts.file
 
 print fileToParse
 lp = Launchpad.login_with(os.path.basename(sys.argv[0]),
                         'https://api.qastaging.launchpad.net/',
                          version='devel')
 
 print  "got lp"
 print lp
 me = lp.me
 print me
 
 parseResults = parse_csv(fileToParse, lp)

if __name__ == "__main__":
    main()

Column,ID,Title,Card type,Card color,Priority,Assigned to,External,Description,Size Estimate,Tags,Sponsor,Progress [%],Created at,Archived at
New / Draft,317751,Thermal management on ARM platforms,KWG,yellow,0,"","",https://linaro-public.papyrs.com/public/4136/,0.0,"","","","September 17, 2011 16:26",""

Column,ID,Title,Card type,Card color,Priority,Assigned to,External,Description,Size Estimate,Tags,Sponsor,Progress [%],Created at,Archived at
Legend,295385,Kernel,KWG,blue,0,"","","",0.0,"","","","August 25, 2011 14:40",""
Legend,295371,Toolchain,TCWG,orange,0,"","","",0.0,"","","","August 25, 2011 14:37",""
Legend,295373,Graphics,GWG,green,0,"","","",0.0,"","","","August 25, 2011 14:37",""
Legend,295375,Multimedia,MMWG,light_blue,0,"","","",0.0,"","","","August 25, 2011 14:37",""
Legend,295377,Power Management,PMWG,yellow,0,"","","",0.0,"","","","August 25, 2011 14:37",""
Legend,295367,Android,Android,red,0,"","","",0.0,"","","","August 25, 2011 14:36",""
Legend,295369,Linux & Ubuntu,Linux & Ubuntu,fuchsia,0,"","","",0.0,"","","","August 25, 2011 14:37",""
Legend,295365,LAVA,LAVA,strong_red,0,"","","",0.0,"","","","August 25, 2011 14:36",""
Legend,295383,OCTO,OCTO,white,0,"","","",0.0,"","","","August 25, 2011 14:40",""
Legend,295381,Events & Summits,Summits,turquoise,0,"","","",0.0,"","","","August 25, 2011 14:40",""
New / Draft,295921,Fragment-based Kernel Configuration,KWG,blue,0,"","",Research already started in 2011Q3; see https://blueprints.launchpad.net/linux-linaro/+spec/linaro-kernel-o-arm-config-managment,0.0,"","","","August 26, 2011 06:45",""
New / Draft,317753,EMMC 4.5 Kernel Support,KWG,blue,0,"","",https://linaro-public.papyrs.com/public/4086/,0.0,"","","","September 17, 2011 16:28",""
New / Draft,317705,Initial Cortex-A15 QEMU Support,TCWG,orange,0,"","",https://linaro-public.papyrs.com/public/4105/,0.0,"","Michael Hope, Linaro","","September 17, 2011 09:51",""
New / Draft,317707,First Class PGO Support,TCWG,orange,0,"","",https://linaro-public.papyrs.com/public/4106/,0.0,"","Michael Hope, Linaro","","September 17, 2011 09:52",""
New / Draft,317709,Initial LLVM Engagement,TCWG,orange,0,"","",https://linaro-public.papyrs.com/public/4107/,0.0,QEMU,"Michael Hope, Linaro","","September 17, 2011 09:53",""
New / Draft,317711,End to End STM-based Tracking,TCWG,orange,0,"","",https://linaro-public.papyrs.com/public/4108/,0.0,QEMU,"Michael Hope, Linaro","","September 17, 2011 09:54",""
New / Draft,317759,Graphics benchmark dashboard,GWG,green,0,"","",https://linaro-public.papyrs.com/public/4143/,0.0,"","","","September 17, 2011 16:30",""
New / Draft,317743,UMM-Enabled Camera demo,MMWG,light_blue,0,"","",https://linaro-public.papyrs.com/public/4156/,0.0,"","","","September 17, 2011 16:22",""
New / Draft,317745,UCM for Android,MMWG,light_blue,0,"","",https://linaro-public.papyrs.com/public/4157/,0.0,"","","","September 17, 2011 16:23",""
New / Draft,317747,Struct clock consolidation,PMWG,yellow,0,"","",https://linaro-public.papyrs.com/public/4111/,0.0,"","","","September 17, 2011 16:24",""
New / Draft,317749,Saving power using multi-core scheduling,PMWG,yellow,0,"","",https://linaro-public.papyrs.com/public/4131/,0.0,"","","","September 17, 2011 16:25",""
New / Draft,317751,Thermal management on ARM platforms,PMWG,yellow,0,"","",https://linaro-public.papyrs.com/public/4136/,0.0,"","","","September 17, 2011 16:26",""
New / Draft,317719,Device Tree for Android LEB,Android,red,0,"","",https://linaro-public.papyrs.com/public/4112/,0.0,"","","","September 17, 2011 15:43",""
New / Draft,317721,sched_mc full idle support for Android,Android,red,0,"","",https://linaro-public.papyrs.com/public/4113/,0.0,"","","","September 17, 2011 15:45",""
New / Draft,317723,LEB Acceleration with proprietary binary overlays,Android,red,0,"","",https://linaro-public.papyrs.com/public/4114/,0.0,"","","","September 17, 2011 15:47",""
New / Draft,317725,Linux Developer Tools for Android 1,Android,red,0,"","",https://linaro-public.papyrs.com/public/4115/,0.0,"","","","September 17, 2011 16:07",""
New / Draft,317729,Linux Middleware layer tests,Linux & Ubuntu,fuchsia,0,"","",https://linaro-public.papyrs.com/public/4119/,0.0,"","","","September 17, 2011 16:14",""
New / Draft,317737,Continuous Integration: Images and toolchain packages,Linux & Ubuntu,fuchsia,0,"","",https://linaro-public.papyrs.com/public/4120/,0.0,"","","","September 17, 2011 16:18",""
New / Draft,317739,Multi-touch Linux User Experience,Linux & Ubuntu,fuchsia,0,"","",https://linaro-public.papyrs.com/public/4121/,0.0,"","","","September 17, 2011 16:20",""
New / Draft,317741,Debug and developer friendly Ubuntu images,Linux & Ubuntu,fuchsia,0,"","",https://linaro-public.papyrs.com/public/4122/,0.0,"","","","September 17, 2011 16:21",""
New / Draft,317727,Continuous Kernel Testing in LAVA,LAVA,strong_red,0,"","",https://linaro-public.papyrs.com/public/4116/,0.0,"","","","September 17, 2011 16:07",""
New / Draft,317731,Linaro Dashboard User Experience,LAVA,strong_red,0,"","",https://linaro-public.papyrs.com/public/4117/,0.0,"","","","September 17, 2011 16:14",""
New / Draft,317733,Toolchain testing in LAVA Lab,LAVA,strong_red,0,"","",https://linaro-public.papyrs.com/public/4124/,0.0,"","","","September 17, 2011 16:15",""
New / Draft,317735,LAVA lab hardware test instruments (Part 1),LAVA,strong_red,0,"","",https://linaro-public.papyrs.com/public/4137/,0.0,"","","","September 17, 2011 16:17",""
New / Draft,317755,Hard float ABI benchmarks,OCTO,white,0,"","",https://linaro-public.papyrs.com/public/4109/,0.0,"","","","September 17, 2011 16:29",""
New / Draft,317757,UEFI Kernel compatibility testing,OCTO,white,0,"","",https://linaro-public.papyrs.com/public/4110/,0.0,"","","","September 17, 2011 16:30",""
2011Q3 / Ready,295907,Kernel Consolidation: Phase I,KWG,blue,0,"","","DT, gpio, pinmux, irq_domain, struct clk",0.0,"","","","August 26, 2011 06:39",""
2011Q3 / Ready,295915,Storage Performance: Phase I,KWG,blue,0,"","","",0.0,"","","","August 26, 2011 06:42",""
2011Q3 / Ready,295923,Complete Thumb2 Kernel Support,KWG,blue,0,"","","",0.0,"","","","August 26, 2011 06:49",""
2011Q3 / Delivered,296521,"Linaro Connect - Cambourne, UK
1st - 5th Aug",Summits,turquoise,0,"","","",0.0,"","","","August 26, 2011 13:04",""
2011Q4 / Ready,296517,"Linaro Connect - Orlando, USA
31st Oct - 4th Nov",Summits,turquoise,0,"","","",0.0,"","","","August 26, 2011 12:58",""
2012Q1 / Planned,296523,"Linaro Connect - San Francisco, USA 
6th - 10th Feb",Summits,turquoise,0,"","","",0.0,"","","","August 26, 2011 13:08",""
2012Q2 / Planned,296525,"Linaro Connect - TBA, USA",Summits,turquoise,0,"","","",0.0,"","","","August 26, 2011 13:09",""