file_name = GSTUDIO_INSTITUTE_ID_SECONDARY + '-' + GSTUDIO_INSTITUTE_ID + '-' + group_name + '-' + dt + '.csv' GSTUDIO_EXPORTED_CSVS_DIRNAME = 'gstudio-exported-users-analytics-csvs' GSTUDIO_EXPORTED_CSVS_DIR_PATH = os.path.join('/data/', GSTUDIO_EXPORTED_CSVS_DIRNAME) if not os.path.exists(GSTUDIO_EXPORTED_CSVS_DIR_PATH): os.makedirs(GSTUDIO_EXPORTED_CSVS_DIR_PATH) file_name_path = os.path.join(GSTUDIO_EXPORTED_CSVS_DIR_PATH, file_name) column_keys_list_addons = [] # dict to keep new name key and _id as value # {'<activity name or altnames>': <activity _id>} column_keys_dict_addons = {} all_activities_cur = Node.get_tree_nodes(group_obj, field_name='collection_set', level=1, get_obj=True) # print all_activities_cur.count() if all_activities_cur: for each_act in all_activities_cur: column_key_name = each_act['altnames'] if (each_act['altnames'] and each_act['altnames'].strip()) else each_act['name'] column_key_name += " [" + unicode(each_act._id) + "]" # if column_key_name not in column_keys_list_addons: column_keys_list_addons.append(column_key_name) column_keys_dict_addons[column_key_name] = each_act['_id'] # column_keys_dict.update({column_key_name: 0}) # each_row_dict[column_key_name] = analytics_data["counter_obj"]["visited_nodes"].get(unicode(each_act._id), 0) # print column_keys_list_addons # FLAGS: header_written = False csv_created = 0
file_name = GSTUDIO_INSTITUTE_ID_SECONDARY + '-' + GSTUDIO_INSTITUTE_ID + '-' + group_name + '-' + dt + '.csv' GSTUDIO_EXPORTED_CSVS_DIRNAME = 'gstudio-exported-users-analytics-csvs' GSTUDIO_EXPORTED_CSVS_DIR_PATH = os.path.join('/data/', GSTUDIO_EXPORTED_CSVS_DIRNAME) if not os.path.exists(GSTUDIO_EXPORTED_CSVS_DIR_PATH): os.makedirs(GSTUDIO_EXPORTED_CSVS_DIR_PATH) file_name_path = os.path.join(GSTUDIO_EXPORTED_CSVS_DIR_PATH, file_name) column_keys_list_addons = [] # dict to keep new name key and _id as value # {'<activity name or altnames>': <activity _id>} column_keys_dict_addons = {} all_activities_cur = Node.get_tree_nodes(group_obj, field_name='collection_set', level=1, get_obj=True) #print all_activities_cur.count() if all_activities_cur: for each_act in all_activities_cur: column_key_name = each_act['altnames'] if (each_act['altnames'] and each_act['altnames'].strip()) else each_act['name'] column_key_name += " [" + unicode(each_act._id) + "]" # if column_key_name not in column_keys_list_addons: column_keys_list_addons.append(column_key_name) column_keys_dict_addons[column_key_name] = each_act['_id'] # column_keys_dict.update({column_key_name: 0}) # each_row_dict[column_key_name] = analytics_data["counter_obj"]["visited_nodes"].get(unicode(each_act._id), 0) print column_keys_list_addons # FLAGS: header_written = False csv_created = 0
''' Script which updates the reources with corresponding group_id ''' from gnowsys_ndf.ndf.models import node_collection,triple_collection,Node from bson import ObjectId OER_GROUPS = ['Mathematics','Science','English'] grp_gst_id = Node.get_name_id_from_type('Group','GSystemType')[1] oergrp_nds = node_collection.find({'_type':'Group','member_of':grp_gst_id,'name':{'$in':OER_GROUPS}}) for eachnd in oergrp_nds: units_under_modules = Node.get_tree_nodes(eachnd._id,'collection_set',2,True) for each_unit in units_under_modules: