CSV File Setup

[Start here]

Updated over a week ago

Project data must be imported as a CSV file. Standing for comma-separated values, CSV is a standard file format that allows data to be stored as plain-text. Using Excel, Numbers or Google Sheets, simply save your spreadsheet as a .CSV file with UTF-8 encoding. UTF-8 is typically the default file encoding choice for most spreadsheet programs — but not always. If you're prompted to select a format when using your spreadsheet program, be sure it's UTF-8

SEARCH BEHAVIOR

The default search behavior for your Studio Search Page is by Name, ID, or Snapizzi 9-digit code. 

In order for search to function properly, your CSV file must contain columns with properly formatted headers for "First Name" and "Last Name" or a "Full Name" column.

Incorrect formatting will trigger a "Searchability" warning in the Diagnose & Remedy tool. The table below shows the other header name formats that Snapizzi will accept.

Camera Cards are generated in the order listed in your CSV file. Ensure you have them in the order you would like them printed (disregard if using Paperless). Since the data fields for each Project are established by the CSV file, other than the name headers described above, you can include any additional data fields you'd like to have on your Project.

GROUPS

When applicable, Snapizzi will automatically place group photos in their respective Subject's galleries. Adding an asterisk* to the name of the column header of your groups will automatically tell Snapizzi the column defines your groups. It isn't required, but if not done, you'll do it when mapping your CSV fields.

Snapizzi will generate a code for each unique group. Simply photograph the group's code before taking the group photos.

Read this for multi-group Projects (ballet schools, bands, etc.), where a Subject is in more than one group photo.

PASSWORD

If you'd like to require customers to enter a password to view their photos, you must include a column labeled "Password" in your CSV file as well as enable passwording in the Privacy Settings. You can define the passwords however you wish, but if no values are in the password column, Snapizzi will create passwords for you. We recommend that you don't use the letter O or number 0 unless the context is clear for your customers. For example, if using the last name, they know it would be the letter O. Or if using numbers, they know it would be a zero.

You can easily edit passwords at any time.

ShootProof users need to request from the ShootProof support team to have the feature "Hide all Albums in Gallery" enabled for their account. This will give you an extra setting within your ShootProof settings to check to ensure that customers can't access the main gallery.

GALLERY NAME

This is what is displayed on the remote gallery for your customer when they see their photos. The default gallery name for each Subject is the 9-digit code from their camera card. To change it, include a column on your CSV called "Gallery" and paste the Subject names in the cells.

Your header name must be "Gallery" in order to work properly.

Tip 1: To combine data from two separate columns into one, click here. This is useful for combining first and last name fields in order to use the Subject's full name for the remote gallery name.

Tip 2: If you have data in one column and would like to create separate columns for each, click here. This is useful if you have a full name field and would like to create a first and a last name column.


NEXT STEP:
Upload your CSV file

Did this answer your question?