Recent content by geoB

@garlin Thanks for your comment. I had indeed wandered off the reservation with too many iterations. I've updated and tested my script with the more proper method. All is well.

After a whole bunch of poking around, I was able to turn the solution into 7 lines! The "magic" is in dfinke's Import-Excel. The Task Scheduler components: Program/script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe Arguments: -command & G:\workspace\apples\temp-forecast.ps1...

I was truly overzealous. The 5 line solution was posted without a test. Test failed. Lesson = Be excruciatingly precise when asking AI how to do something. When so applied I got a 29 line solution that actually worked. Do I need to try to shrink it? No. I'm just noodling. Here's what AI said and...

When in Rome Microsoft, do as the Romans PowerShells do. The entire ps1 script is only 5 lines vs 29 of python. See below: $data_url =...

@Try3 I think the key piece here is whether a script can run from Task Scheduler. I tried running a script with different imports (because xlwings is suspect). The script's expected output was a list of data. The python script yielded data, the Task Scheduler yielded nothing. So I'm going to...

@Try3 : Clearing "Run whether or not logged in" results in a prompt to identify an executable. Let's just say that's not compatible with scheduling the task for 3 AM. And yes, I've checked "Wake your computer to run this task" as the system is in sleep mode at the time.

@pepanee , @garlin : Thanks for the suggestions. Much appreciated. I tried the ps1 option - no change. And Google's gemini gave me the cmd.exe solution. Same result. I'd just found a stackoverflow q&a that suggests that the culprit is python's xlwings. I'll poke at that tomorrow and report back.

As I try to teach myself python, I built a script to do a daily update of an Excel spreadsheet. I've not yet stumbled on a workable Task Scheduler configuration. Scheduler: Run whether or not logged in: Checked Highest privileges: Checked Action...

@Try3 Thanks for the directions. Minor change: Instead of "Offer ..." it's now "Get tips and ..." Easy fix. Thanks.

My system was logged in to my Microsoft account when that notice appeared.

On logging in this morning I get a notice that Windows wants to Setup my computer. It did not at all look like it was optional. I'm used to updates; the notice seemed more adamant. What, if anything about it, is mandatory? Optional?

And the reason why 127... failed is because the instructions said to use localhost:8000.... in the command to start a PHP website. And then use 127.etc. to access the website. As though 127.0.0.1 and localhost were equivalent. Not always so. Live & learn.

Tenacity. I kept poking around, trying to make sense out of sulu's documentation. Just for the h*** of it, instead of trying to use `127.0.0.1:8000` (which would never connect) I tried `localhost:8000` and BINGO! Access was gained. Documentation, however, remains relatively opaque. But issue is...

I'm abandoning efforts to experiment with sulu. When I worked around the port issues I ran into issues with the sulu code itself. Just not up for tracking those down. Calling the question resolved.

@bar_foo Were you able to access before? I don’t have the luxury of prior success. May have to try to make some sense out of proxy.