
If anyone is interested, I'll knock together some documentation for it (thought it's very simple, just a couple of arguments on the command line - I could put a simple GUI together if people would prefer)i am a teacher who has been getting more involved in the IT side since more and more reliance has been made on iPads and idoceo and emerge. It can also add the name in a small box below the photo if you want (as part of the final image) and resize on the fly.

I wrote a small program a while back that pulls the photos out of SIMS and saves them as either name, UPN, ID or admission number. I've posted my rename script on here somewhere before

Thing is if you get the extractor to work you don't need a dos list you just need a sims report that gives both columns out to a file, if it a csv then a two line batch script will rename using the for command and you won't need to mess with concatenation. In theory the SQL can be scheduled to auto run and output to file which is something i do for updating the library system. So if you're comfortable running SQL on your DB just run that and save as text file and supply to utility or save as bat and run.
BATCH FILE RENAME CONCATENATE DOS CODE
You could put your rename code in their if you prefer that. I just have all the concatenation in that. I now just build my mapping file that the utility requires straight in SQL.

To make a decent dos list use /w, /b I think for better formatting and also redirect it straight to a text file with a "> list.txt" I think I was doing staff though.ĭid you go through the readme file? you need a local connect.ini and a user with permissions.Īll the Dos tips and excel are good, I did it for years, but since moving to a utility I will never go back. I'm sure I ran the exporter recently and it was fine.
