There are many scenarios where you may want to update the subject data in an existing private gallery. Maybe the school sent you new information like email addresses or teacher names. Perhaps you want to use existing images as reference photos. This article will address how to append data to an existing private gallery for both scenarios by uploading an updated CSV file.
Appending Data with an Updated CSV file
Whether you have entirely new subjects or new columns of information, you can easily do so by downloading your CSV file, editing it with new information, and re-uploading it to the private gallery.
Export the current subject data from the job.
Follow these Export instructions and select "Subject Data" to prepare a CSV file.
Once you've prepared and downloaded the CSV export, open it on your computer.
Edit the CSV as needed.
Example: If you need to add a column of Email Addresses, create a new column in the CSV titled “Email Address,” add the email address content to each subject.
Example: If you need to add a new subject, create a new row in the CSV with the subject's information.
Return to the job's Subjects Data page.
Click Add > CSV file > and select the edited CSV from your computer.
Important note: When re-uploading a CSV file into your job, make sure the main qualifiers (student ID, first name, last name) have not been adjusted. If these main qualifiers are adjusted, the re-upload of your edited CSV will create issues rather than just append the new data.
Using Existing Images as Reference Photos
Another reason you may want to append data is if you already have reference photos for each subject. This could come in handy if you have access to or took last year’s yearbook photos, if you didn’t use the Capture App, or if you’re having trouble syncing, you can grab the Capture photos right from your device’s camera roll.
Important note: When using this workflow, all subjects will automatically be checked in.
For this example, let’s assume you photographed a school in the fall and want to use the same reference photos for spring photos.
Here’s how to do that:
Prepare the CSV for the job.
Gather the yearbook photos you're going to use as reference photos.
Create a new column in the CSV titled “Image Name.” Then add the reference photo's filename to each subject accordingly. The image name must match the actual image name exactly, and it is case-sensitive. Alternatively, if you already have this data export from another software, you can simply import and map all fields accordingly.
Create this year's job in PhotoDay.
Upload the CSV, then upload the reference photos to the job, and it will populate and match everyone accordingly!
Then (if desired) you can delete the uploaded reference photos from the actual gallery and move on with your workflow like normal.
See in action here. Want to dive into all of the ins and outs of Private Galleries? Check out the webinar.