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
