Missing Student Pictures report

0 votes
216 views
asked Apr 10, 2018 in Reports by bismark
Can you provide a report that provides a list of students who don't have pictures or don't have current pictures?

Thank you!

--Yitzchok Markowitz
commented Apr 10, 2018 by yczehn
don't have pictures - yes

don't have current pictures - What do you mean?
commented Apr 10, 2018 by bismark
Thank you!

To your second question.....

If the add date for the photo is older then x time ago, list that student so we can update the photo.

We have guys in 3rd year Bais Medresh with their 9th grade photos!

If this doesn't live in any tables the information can be obtained programmatically from the picture file creation date (or the JPG metadata).

Worst case: we can set a job on the server that runs once a day and writes the file dates for the student photos to a CSV.

eg: N:\JL Database\Attachments\Students>forfiles /d -730 /M *.jpg /C "cmd /c echo @file,"""@fdate""" " >filedates.csv

produces a file (for pix 2 years old or more) like this:

filedates.csv

"0002207.jpg","5/14/2014"
"0002298.jpg","5/14/2014"
"0002623.jpg","5/14/2014"
"0002743_1.jpg","5/14/2014"
"0002872.jpg","5/14/2014"
"0003010_1.jpg","5/14/2014"
"0003078.jpg","5/14/2014"
"0003212.jpg","5/14/2014"
"000392.JPG","5/14/2014"
"1000.jpg","5/14/2014"
"1008.jpg","5/14/2014"
"1009.jpg","5/14/2014"
"1037.jpg","5/14/2014"
"1056.jpg","5/14/2014"
"1064.jpg","5/14/2014"
"1082.jpg","5/14/2014"
"110.jpg","5/14/2014"
"1111.jpg","5/14/2014"
"112.jpg","5/14/2014"
"1125.jpg","5/14/2014"
"1136.jpg","5/14/2014"
"1137.jpg","5/14/2014"
"1140.jpg","5/14/2014"
"116.jpg","5/14/2014"
"1176.jpg","5/14/2014"
"1181.jpg","5/14/2014"
"1221.jpg","5/14/2014"
"1226.jpg","5/14/2014"
"1238.jpg","5/14/2014"
"1265.jpg","5/14/2014"
"1283.jpg","5/14/2014"
"1285.jpg","5/14/2014"
"1286.jpg","5/14/2014"
"1313.jpg","5/14/2014"
"1373.jpg","5/14/2014"
"138.jpg","5/14/2014"
"139.jpg","5/14/2014"
"1398.jpg","5/14/2014"
"1404.jpg","5/14/2014"
"1445.jpg","5/14/2014"
commented Apr 11, 2018 by Admin
Yes, We can get the date from the file.
commented Apr 11, 2018 by bismark
Thanks! So a missing pictures report and an ageing pictures reports that could be queried would be really helpful.

kt/yam

1 Answer

answered Apr 11, 2018 by yczehn
selected Apr 16, 2018 by bismark
 
Best answer
Done, Student List Missing Pictures
commented Apr 12, 2018 by yczehn
Please mark complete if its what you needed, thanks
commented Apr 16, 2018 by bismark
Can it be modified such then when on the mail merge tab one clicks on "use current report" fields like parent's names, address and such appear (with out adding each from the drop down) so that we can mail merge to word?

Thanks!

--yam
commented Apr 16, 2018 by bismark
Also the add to list feature doesn't work on the mail merge tab?
commented Apr 17, 2018 by YakovKantor
It is not possible for this report due to the way it is built. (It loads everyone and hides the ones that are not expired, so all the students would come up)
commented Apr 17, 2018 by bismark
OK, so how can we email or physically mail folks who don't have the photo?

The report alone doesn't help me act.....

Thanks.
commented Apr 17, 2018 by yczehn
We don't have such option.
commented Apr 17, 2018 by bismark
I see that you are calculating the visibility of the detail section on format and understand that the data isn't querible. What about creating a "scratch table" that would get overwritten every time the report is run with the student ID and "Missing" or the date. After running it could be used as a filter for a student list for export, mail merge or email list?
commented Apr 19, 2018 by yczehn
Done, once the report loads paste the clipboard to query the student numbers.
commented Apr 19, 2018 by bismark
Very nice, Thank you!

Let's Welcome our New Members

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

  • samual of Satmar Bloomingburg - Mar 07, 2024

  • lrottenberg of Yeshiva S. Fallsburg - Mar 07, 2024

  • roth of Mareh Yechezkal - Mar 06, 2024

  • lev of UTA BP - Mar 05, 2024

...