Cheers for getting back, Yeah I did use that salamander tool, and exported by year easily enough. I am not too fussed about using UPN, it's just that, that is the only definable ID when I export my marksheets from my subject classes, I then want to link my pupil pics for seating plans
I really dont mind the pics being instead renamed on export to [sURNAME, name] as seen in registers on SIMS. (this is what losojos tool seems to suggest to do during export of pics) I would deffo do that instead if UPN rules are stringent. I'd rather the easiest yet least issues/hassle route for sure. However I would just use the UPN to match and then delete the UPN once the pics are matched.
Another route is if I could export my marksheet and it contains the admission ID instead of the UPN in column A. I would use that in an instant (as then the pics are already named by admission ID so easy to match, but I fear that is another several steps of which I have no idea how to do.
I have actually been using bulk rename utulities for some time, but that was for previous hobbies/modding pro evo for ps3 lol but additionally I have never exported a .csv from sims or neither used a csv in Bulkrenamer. So let's say for admins/guidelines sake, we ignore UPN. I should export as [sURNAME, forename] as seen in sims, that will be fine i'm sure. Hopefully losojos can help with his 'tool'
In short after reading, perhaps exporting and renaming as [sURNAME, forename] (like the format seen when doing registers in SIMS, would be best or [sURNAME, forename_ADMINSSION ID] to avoid duplicates
Pictures wil not be published publicly anywhere and the aim is for school internal admin/teaching purposes only