user_agent='daryl.testing', scope=config.get('googleauth', 'scopes'), refresh_token=config.get('googleauth', 'refresh_token')) spr_client = gdata.spreadsheets.client.SpreadsheetsClient() token.authorize(spr_client) docs_client = gdata.docs.client.DocsClient() token.authorize(docs_client) meta_feed = spr_client.get_list_feed(config.get('cscap', 'metamaster'), 'od6') sdc_feed = spr_client.get_list_feed(config.get('cscap', 'sdckey'), 'od6') treat_feed = spr_client.get_list_feed(config.get('cscap', 'treatkey'), 'od6') treatments, treatment_names = util.build_treatments(treat_feed) sdc, sdc_names = util.build_sdc(sdc_feed) """ Okay, we are cross product TIL x ROT x DWN x NIT """ baseheaders = ['UniqueID', 'Rep', 'Tillage', 'Rotation', 'Drainage', 'Nitrogen', 'Landscape', 'PlotID', 'ROW', 'COLUMN'] basecolumns = {'A': 'UniqueID', 'B': 'Rep', 'C': 'Tillage', 'D': 'Rotation', 'E': 'Drainage', 'F': 'Nitrogen', 'G': 'Landscape','H': 'Plot ID', 'I': 'ROW', 'J': 'COLUMN'} letters = ['K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z', 'AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL'] DONE = ['orr',]
client_secret=config.get('appauth', 'app_secret'), user_agent='daryl.testing', scope=config.get('googleauth', 'scopes'), refresh_token=config.get('googleauth', 'refresh_token')) spr_client = gdata.spreadsheets.client.SpreadsheetsClient() token.authorize(spr_client) docs_client = gdata.docs.client.DocsClient() token.authorize(docs_client) meta_feed = spr_client.get_list_feed(config.get('cscap', 'metamaster'), 'od6') sdc_feed = spr_client.get_list_feed(config.get('cscap', 'sdckey'), 'od6') treat_feed = spr_client.get_list_feed(config.get('cscap', 'treatkey'), 'od6') sdc_data, sdc_names = util.build_sdc(sdc_feed) DONE = ['arl', 'lan'] for entry in meta_feed.entry: data = entry.to_dict() sitekey = data.get('uniqueid').lower() if sitekey not in DONE: print 'skip', sitekey continue # This is the folder where synced data is stored colfolder = data.get('colfolder') collect = docs_client.get_resource_by_id(colfolder) leadpi = data.get('leadpi') # Lets go find the Plot Identifiers Table