Your Project data must be imported as a CSV file. CSV, standing for comma-separated values, is a standard file format that allows tabular data to be stored in a series of plain-text numbers and letters. Using Excel or Google Sheets, simply save your .XML or .XMLS file as a .CSV file.

In order for the search function to work properly, the headers for the Subject names must be "First Name" and "Last Name". Click here to learn how to create First and Last name columns from a single column.

Camera Cards are generated in the order listed in your CSV file so be sure to have the list sorted 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, you can use whatever field headers you'd like. It doesn't need to be formatted like our sample CSV file.  

You can edit your CSV file to add/update Subject data at any time.

Snapizzi automatically places Group photos in Subject 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

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

Lastly, please read this article for important information regarding filenames, image editing and EXIF data.

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 last name, they know it would be the letter O. Or if using numbers, they know it would be a zero.

SEARCH vs. TARGET SEARCH

The default search behavior for your Studio Search Page is by Name, ID, or Snapizzi 9-digit code. You don't need to include a "Search" header in your CSV unless you wish to change this behavior. 

If you supply "Search" values in your CSV file, all other fields are excluded from search. That means customers can only find photos using the defined search value in the "Search" column, so be certain this is what you want to do.

If you upload a CSV with a "Search" header — but no values — the photos will not be able to be found. Since you set up the Project with a targeted search, you'll need to edit your CSV to correct this problem by adding values (first and/or last name, etc) to the "Search" column. If you haven't shot the Project yet, you can simply create a new Project and import the correctly formatted CSV.

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 "Gallery" column and add the Subject names.

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.

CSV RESET

  • It is not available after camera cards are issued or any photos uploaded. 
  • This deletes all Subject data, data fields and Groups.
  • Group changes aren't available after camera cards are issued or any photos uploaded.
  • Group fields will be ignored for any re-imports.

RELATED ARTICLES

Map CSV fields
Edit CSV file

Did this answer your question?