redshift_credentials_user = config['AWS_REDSHIFT']['USER']
redshift_credentials_password = config['AWS_REDSHIFT']['PASSWORD']
user = config['LIME_CONFIG']['LIME_USER']
key = config['LIME_CONFIG']['LIME_KEY']
url = config['LIME_CONFIG']['LIME_API_URL']
sid = config['LIME_CONFIG']['LIME_SID_ORDER']
token = config['LIME_CONFIG']['LIME_TOKEN_BASE']
DATE_NOW = datetime.datetime.now().strftime('%Y%m%d')
# Build the API
lime = Api(url, user, key)
export_res_token = lime.export_responses(sid=sid,
status='all',
heading='code',
response='short',
fields='')
OUTPUT_PATH = PATH + "/lime_export_{s}.txt".format(s=sid)
with open(OUTPUT_PATH, 'w') as outfile:
json.dump(export_res_token, outfile)
df = pandas.read_json(OUTPUT_PATH)
ds = pandas.DataFrame()
for row in df.index:
data = pandas.DataFrame(
df.loc[row].loc['responses']).transpose().reset_index(drop=False)
ds = ds.append(data, ignore_index=True)
req_cols = ['id', 'datestamp', 'q01', 'q03', 'q06']
redshift_credentials_password = config['AWS_REDSHIFT']['PASSWORD']
user = config['LIME_CONFIG']['LIME_USER']
key = config['LIME_CONFIG']['LIME_KEY']
url = config['LIME_CONFIG']['LIME_API_URL']
sid = config['LIME_CONFIG']['LIME_SID_RETURN']
token = config['LIME_CONFIG']['LIME_TOKEN_BASE']
DATE_NOW = datetime.datetime.now().strftime('%Y%m%d')
# Build the API
lime = Api(url, user, key)
export_res_token = lime.export_responses(sid=sid,
status='',
heading='',
response='',
fields='')
OUTPUT_PATH = PATH + "/lime_export_{s}.txt".format(s=sid)
with open(OUTPUT_PATH, 'w') as outfile:
json.dump(export_res_token, outfile)
d = pandas.read_json(OUTPUT_PATH)
df = pandas.DataFrame()
for row in d.index:
data = pandas.DataFrame(
d.loc[row].loc['responses']).transpose().reset_index(drop=False)
df = df.append(data, ignore_index=True)
req_cols = [
import base64 # para encodear la subida de surveys
# demo de limesurvey
usuario = 'admin'
clave = 'test'
url = 'http://demo.limesurvey.org/index.php?r=admin/remotecontrol'
lime = Api(url, usuario, clave)
for e in lime.list_surveys():
propiedades = lime.get_survey_properties(e[0], settings='["active"]')
if propiedades['active'] == 'Y':
print "La encuesta %s esta activa" % e[0]
summary = lime.get_summary(e[0])
if summary['full_responses'] != '0':
print summary
datos = lime.export_responses(e[0])
if datos is not None:
decoded_string = base64.b64decode(datos)
print decoded_string
break
else:
print "La encuesta %s no esta activa" % e[0]
# print lime.delete_survey(e[0])
