Is there a way to download the spreadsheet?

I’m afraid not. The files are just that — files on the server. But the spreadsheet is generated each time from the database.

It would certainly be possible to add a “generate spreadsheet file” button, which would create a spreadsheet file without actually forcing a download. But you would still have to generate it first via the web page. For security, the file should probably have a rather complicated name containing random characters as well as the webform identifier. And you would need to pay attention to its date to make sure you had the latest version. Would that be much of an improvement?

Thanks for the response.
Not really. You still have to log to the website.
That defeat the automation objective.
I have automated the process in the local PC, of distributing the images once I get the spreadsheet.
In other words, The only manual work is logging to worldpress go to entrywizard and download the spreadsheet. The rest in the PC is one click away.
It is not much, but I am aiming to total automation.
My system only requires 1 person do everything, of course I need judges.
I am working on automating the process, That even I, get fired.
Just Judges after is started. Almost there!!!
Again, I love your utility.

On a second though, You said “be possible to add a “generate spreadsheet file” button”
You do now save a zip file when the request is for both, the images and the spreadsheet in the uploaded images folder.
If that could be possible, can a spreadsheet file be generated like you do now for only the spreadsheet and save it to the image files location? Any other location, will be OK. too.
The way to make make full automation possible, will be if we create that file daily, by schedule.
How: Let say the closing date for submissions is the 25th.
Every day a file has been created at ex: 1 am server time.
So the 26th, there will be a file sitting there after that time.
I am not a PHP programmer like you. So it will be impossible for me to add any worthwhile code. You on the other are a master and with a tremendous love and dedication to programing and photography; You certainly have demonstrated it; You could.
I did find the following code and I wonder if this could be used to help me reach my goal of total automation. I am sure you and others can benefit as well.
PHP: running scheduled jobs (cron jobs) https://stackoverflow.com/questions/120228/php-running-scheduled-jobs-cron-jobs.
Is this an impossible? Or adding this code, calls for a lot of programing?

Well, yes, it would require time, mainly for debugging and testing. And I really have quite a bit on my plate at the moment. I certainly would not have time before the summer.

If I did it, I would add an option to create the file, and probably only create it when the webform gets closed automatically (creating it puts a load on the server that we don’t want to do any more than we have to).

For security the filename would still have to be something random.

That is great. Correct adding extra burden to the server is not good.
The idea that it can be created after the closing period, it is perfect; the file is not needed until closing anyway. That will be great.
It will put my system back to one click. Whatever time it takes.
Thanks

Josie, just hoping that you get a chance to add the spreadsheet after closing the period of submissions.
Let me know, Ron.

This was done in the last release ( 1.2.27 )
There is an option in the settings to generate the spreadsheet when the webform is closed automatically.

Sorry, I should have posted here when I did it.

Thanks, I will update and try it.
Thanks again.

The option to have the xls with images, is great.
The system I have created works as intended.
Thanks very much for such addition.
I know you are planning a release sometime in the future.
I have to mention that I am testing the placing of the xls in the folder of images.
I have been getting some inconsistence with the xls.
in 5 days try.
1 one time no xls in 5 days try.
2 two times the xls did not have fn, ln or email.
I am repeating this every day.
What I do is delete the xls from the folder of images and open for upload checked and give the next day at 1:00 am.
I will keep you posted.
Since I have seen a lot of inconsistences in these websites, I do not know if it is your program at this point.
But having the xls with the images, has been fantastic.
What a great addition.
No need to log to the website; All I do is one click from my program and my system is ready for competition.
I wish I could download judges as easy.
Thanks again…

When the xls was not in the folder, had the webform actually closed?

If you have not set up your own cron job, WP relies on visits to the website to run that sort of task. See https://tommcfarlin.com/wordpress-cron-jobs/

Addition: to see if the webform actually closed, without actually triggering the close by visiting the site, check your error log file — auto-closing puts a message there.

Truly I have not done those checks.
But to confirm the reading of the link:
A visit or an entry to the website prior closing is sufficient to trigger the cron job.
Correct?
I guess that after I open the site for uploading and gives it a closing date, some one will do some uploading. So I guess that during a normal operation, this should not be a problem.
The problem was created by me as I did turn it on, gave it a closing date and did wait for next day.
Of course no one went back to it.
That could explain the inconsistence. Correct?

There would need to be a visit after the closing time to trigger it. Or you could set up your own cron job — that’s what I do.

It would explain the missing file ( actually, it’s csv, not xls ).
But by “2 two times the xls did not have fn, ln or email” I gather you mean some columns were missing. These are probably columns that refer to wordpress user data, and I need to do some more coding to modify the security around that. Hopefully in the next release.

But with regard to the judge downloads, there is no existing automated job I can piggyback on. Setting up a whole new one is a lot of work, and I’ve far more to do already than I have time for.

Ah I see now, said a blind man once.
It is after the closing, the visit matters.
Ok I will follow.
I think you got it wrong, not a judge program, I meant live judges.
My program is called THE JUDGE.
To do more for downloading, absolutely NO.
You have done a fantastic job.
The way it is now, it perfect.
The JUDGE takes care of everything after the closing.
Your program has done all the work.
All I have to do, is just 1 click. Done.
You do not have anything else to do.
I am working on mind keyboard control.
Oh yes perhaps, can Pizza be delivered with the csv file(peperoni please).
Thanks again…..

After checking for a few days of testing, Yes, the csv file it is produced, whether I visit the website after closing or not before downloading the file.
The problem is that the file does not have the WP user information.
Like fn , ln, emall, wpid and so on.
If I go and download it manually as it is done normally, the file received is correct.
So the settings in the layouts and forms are good.
I read the link you send about cron jobs.
If I have to do some work in my website WP, please advise.

About the missing csv one time, probably, it may have been because I did not save the changes of closing date.