There is no MD formatting in slack so this is the best option. What im trying to achieve in slack is similar to if i just copy and pasted from excel xlsx file. Wo = pd.read_json (r'C:\WO_CSV\WorkOrderExport.json') Os.remove("C:\WO_CSV\WorkOrderExport.json")ĭf.to_json('C:\WO_CSV\WorkOrderExport.json') If os.path.exists("C:\WO_CSV\WorkOrderExport.json"): Response = requests.post(web_hook_link, headers=headers, data=data)ĭf = pd.read_csv (r'C:\WO_CSV\WorkOrderExport.csv')ĭf = df.sort_values(by='Scheduled Start Date', ascending=False)ĭf = df.drop(columns=) #value = pd.read_json('C:\WO_CSV\WorkOrderExport.json') the criticality index of each activity, and the density functions of the duration of the project. ![]() Os.remove("C:\\WO_CSV\\WorkOrderExport.csv")ĬSVButton = driver.execute_script("return document.querySelector('body > ez-rme-app').shadowRoot.querySelector('#content > main > ez-work-order-list-page').shadowRoot.querySelector('div > mwc-button:nth-child(1)').shadowRoot.querySelector('#button')") The free slack of an activity can be calculated as. If os.path.exists("C:\\WO_CSV\\WorkOrderExport.csv"): SingleSignOnButton = driver.execute_script("return document.querySelector('ez-rme-app').shadowRoot.querySelector('ez-login-page').shadowRoot.querySelector('ez-login').shadowRoot.querySelector('#sso-login').shadowRoot.querySelector('#button')") SignInASButton = driver.execute_script("return document.querySelector('ez-rme-app').shadowRoot.querySelector('ez-login-page').shadowRoot.querySelector('ez-login').shadowRoot.querySelector('mwc-button:nth-child(4)').shadowRoot.querySelector('#button')") ![]() Options.add_experimental_option('prefs', prefs)ĭriver = webdriver.Chrome(options=options) So far this is what i came up with but am finding it hard to get the data into a format that i can send. ![]() Then post this info into slack using a webhook. Then convert it using pandas and remove unnecessary columns. What im looking to achieve is pulling a csv file from a workorder app that we use.
0 Comments
Leave a Reply. |