def extract_job_counts_from_xml(self, files, out_file = None):
if out_file == None:
my_xml.fix_xml_encoding(self.out_file, files)
return ds.DashboardSupport().pull_job_data_from_xml(self.out_file + files)
else:
my_xml.fix_xml_encoding(out_file, files)
return ds.DashboardSupport().pull_job_data_from_xml(out_file + files)
def run_analysis_tool_unconfirmed_queries():
query = ds.DashboardSupport()
query.run_unconfirmed_data_queries("Ryan Data Dashboard List of Jobs not Deactivation Rules 2 year",
"US and Canada",
"Survey PayScale Main",
2)
query.run_unconfirmed_data_queries("Ryan Data Dashboard List of Jobs not Deactivation Rules 4 year",
"US and Canada",
"Survey PayScale Main",
4)
def run_analysis_tool_rollups_queries():
query = ds.DashboardSupport()
query.run_overall_table_queries("Ryan Data Dashboard Job Rollup Counts Two",
"US and Canada",
"Current Rollups.csv",
2)
query.run_overall_table_queries("Ryan Data Dashboard Job Rollup Counts Four",
"US and Canada",
"Current Rollups.csv",
4)
def run_iqr_queries(self):
query = ds.DashboardSupport()
job_files = []
dash_files = os.listdir(self.automated_file_path)
[job_files.append(files) for files in dash_files if "Current Jobs_" in files]
query.run_iqr_queries("Ryan Data Dashboard IQR US PSP Job Rollups",
None,
"Current Rollups.csv",
2)
for i, job_file in enumerate(job_files):
query.run_iqr_queries("Ryan Data Dashboard IQR US PayScale Main " + str(i),
None,
"Current Jobs_" + str(i + 1) + ".csv",
2)
def run_analysis_tool_overall_jobs_reports(self):
query = ds.DashboardSupport()
job_files = []
dash_files = os.listdir(self.automated_file_path)
[job_files.append(files) for files in dash_files if "Current Jobs_" in files]
for i, job_file in enumerate(job_files):
query.run_overall_table_queries("Ryan Data Dashboard Job Counts Two " + str(i),
"US and Canada",
"Current Jobs_" + str(i + 1) + ".csv",
2)
query.run_overall_table_queries("Ryan Data Dashboard Job Counts Four " + str(i),
"US and Canada",
"Current Jobs_" + str(i + 1) + ".csv",
4)
def extract_jobs_from_file():
#TODO: Find out why the tsv version is messed up
return ds.DashboardSupport().temp_pull_current_jobs()
def unzip_all_the_files(self):
for zip_files in os.listdir(self.out_file):
if ".zip" in zip_files:
ds.DashboardSupport().unzip_file(zip_files)
def create_job_csv_files():
ds.DashboardSupport().break_up_jobs_file()
def extract_unconfirmed_profile_data(self, files):
my_xml.fix_xml_encoding(self.out_file, files)
return ds.DashboardSupport().pull_unconfirmed_data_from_xml(self.out_file + files)
def write_breadth_thirty_to_file():
ds.DashboardSupport().create_breadth_thirty_file()
def extract_current_iqr_data(self, files):
my_xml.fix_xml_encoding(self.out_file, files)
return ds.DashboardSupport().pull_iqr_data_from_xml(self.out_file + files)
def extract_job_model_data(self, files):
my_xml.fix_xml_encoding(self.out_file, files)
return ds.DashboardSupport().pull_model_data_from_xml(self.out_file + files)
def pull_current_admin_tool_values():
ds.DashboardSupport().pull_current_admin_data()
def find_tasks_for_rollups():
return ds.DashboardSupport().pull_task_rollup_combos()
def create_all_rollup_dictionary():
return ds.DashboardSupport().full_job_to_job_rollup_map()
def create_breadth_ten_rollup_dictionary():
return ds.DashboardSupport().pull_jobs_and_rollups_to_dict()
def return_no_good_strings_list():
return ds.DashboardSupport().pull_no_good_strings()
def extract_task_sets_from_file():
return ds.DashboardSupport().pull_tasks_from_file()
def extract_breadth_thirty_data_from_file():
return ds.DashboardSupport().pull_breadth_thirty_from_file()
def run_model_queries():
query = ds.DashboardSupport()
query.run_model_data_queries()
import data_dashboard as dd import dashboard_support as ds ds.DashboardSupport().pull_task_rollup_combos()
