0

I am trying run a python script to update a ppt presentation. I have also tried this a year ago with running a regression and updating a table in SQL and didn't run either. I gave up then as I couldn't resolve it.

I have managed to create a bat file to run R code in windows scheduler and that works.

I have created the bat file and tested it in command prompt and it the py file runs and updates the ppt presentation.

When I run this bat file in windows scheduler is doesn't update the ppt.

Currently the bat file is as follows:

@echo off​
SET log_file=C:\python\logfile.txt

echo on
call :logit >>log_file=%
exit /b 0 ​ 

:logit
call C:\ProgramData\Anaconda3\Scripts\activate.bat
cd C:\python\
python Updateppt.py

These are the things I have tried so far:

  • Added a log file to the bat file. The log file is created and adds the three steps so I know the bat file is run. The log file returns this:
C:\python>call C:\ProgramData\Anaconda3\Scripts\activate.bat 

(base) C:\python>cd C:\python\ 

(base) C:\python>python Updateppt.py
  • Edited the bat file to various combinations based on recommendations from stack overflow. Most of them have worked in command prompt but none work in windows scheduler
  • Check the security settings on the folder where I am saving the information and I have full access
  • Made sure the folder is added to the PYTHONPATH in both system and user sections for environment variables
  • Have an R file that currently runs via a bat file through windows scheduler so have made sure all the general, conditions and settings sections in the properties match that one
  • re-run pip install on all packages to make sure they are accessible and in the right location when the py file runs. This was based on this advice: Cannot schedule a python script to run through Windows Task Scheduler
  • Timed the command prompt and windows scheduler tasks and the command prompts takes 30 seconds whereas the windows scheduler takes 20 seconds
  • Added logging into python file and it logs when script is started and it logs a time when in running in windows scheduler so it is running the python script

Is there anything I can do to get this working? I am really at a loss with this and I can't seem to find a stack overflow response that actual solves the issue I am having

UPDATE

I have added times after each function is run and right before the last function, the log file shows that when it is run in windows scheduler, it doesn't run the last function but instead loops back to the first one. It doesn't do this in command prompt

windows scheduler run log of python

INFO:root:run script started at 2022-04-29 13:18:31.318567
INFO:root:loaded enc data at 2022-04-29 13:18:32.072627
INFO:root:create enc_id at 2022-04-29 13:18:32.075627
INFO:root:agg data at 2022-04-29 13:18:59.782707

INFO:root:run script started at 2022-04-29 13:19:22.904437
INFO:root:loaded enc data at 2022-04-29 13:19:23.225462
INFO:root:create enc_id at 2022-04-29 13:19:23.228464

command prompt log of python

INFO:root:run script started at 2022-04-29 13:20:48.871881
INFO:root:loaded enc data at 2022-04-29 13:20:49.051893
INFO:root:create enc_id at 2022-04-29 13:20:49.054894
INFO:root:agg data at 2022-04-29 13:21:05.040096
INFO:root:run script stopped at 2022-04-29 13:21:05.436125

It should aggregate the data and then export to ppt and the script will stop and run the 'run script stopped' line. Why would it be running it correctly in command prompt but not windows scheduler?

This is the code it's not running

def update_ppt(CHW_daily):
    
    daily_figures = Presentation(ResultPath+'Template/daily_figures_template.pptx')
    
    # CHW table
    slide_CHW = daily_figures.slides[0]
    table_CHW = [shape for shape in slide_CHW.shapes if shape.has_table]
    
    #Then we can update the values in each cell directly from the dataframe:
    for i in range(1,8):
        for j in range(0,6):
          table_CHW[0].table.cell(i,j).text = str(CHW_daily.iloc[i-1, j])
          table_CHW[0].table.cell(i,j).text_frame.paragraphs[0].font.size = Pt(14)
         
   daily_figures.save(ResultPath+'daily_figures.pptx')        
    
    return()
user2963880
  • 45
  • 1
  • 5
  • One option I'd suggest is instead of calling to activate the virtual env, I'd go and explicitly specifying the actual virtual env python binary as (iirc) ```call`` would open a new command prompt and would close it once it goes to the next line.. – ewong Apr 29 '22 at 02:36
  • I have tried removing the call before the activate line and it works in command prompt but not in windows scheduler. I have also tried removing that line and just having python file.py and it's the same issue - works in cmd but not windows scheduler – user2963880 Apr 29 '22 at 02:57
  • Thanks so much Mofi will try all those steps and see if one will get me closer to resolving this – user2963880 Apr 29 '22 at 12:26

1 Answers1

0

The issue was the file wasn't able to save in the Network drive. The error said it couldn't find the file path. I used this code and solved the issue:

from pathlib import Path
ResultPath = Path(r'<network domain name>/Daily figures/')
ResultPath_str = str(ResultPath)
daily_figures = Presentation(ResultPath_str+'/'+Template/daily_figures_template.pptx')
user2963880
  • 45
  • 1
  • 5