Reply To: CSV setup for multiple images/composites of the same player

[Angelo McComisParticipant]

Glad it worked out, Justin!

Not sure what system is generating the original CSV for you… but, here’s what I do… and I’m only telling you this now (after you’ve already solved it, lol) so that you might have an easier time with the next one.

I use PhotoDay, and I use Private Galleries.  That means I start with a roster. Each person has a name + email (+other details). Each person at the shoot gets checked in on an iPad, by checking their name, and snapping a photo of them.  Then, once everyone is checked in, when I get the photos completed (even if it’s rough quick JPG exports… don’t have to be finished ones!), I upload those to PhotoDay, and it sorts the players into what faces appear in each photo.  I can then download a CSV file from PhotoDay with each name and an image – one image per line.  If a player’s face appears in 5 images (even sibling/buddy/team ones…) that name + image filename appears on a row.  For me, and not to get too advanced here, but let’s say I’m making a composite layout where I want each person’s single photo only.  But teams, groups, buddy pics are in the CSV, so how do we avoid that?  Simply add a field to Excel, and do a “countif” statement for how many times THAT filename appears with a count of 2, you know it’s a buddy pic. If it shows with a count of 12, you know it’s a team pic.  FILTER the sheet to get rid of any values other than “1”, and you have all the single player images. Voila.