Order School Pics – Sample School Data

The following is an example of properly formatted school data for uploading into Order School Pics (OSP).

First Name	Last Name	Image Name	Student ID	Teacher	Grade	Password
Julia	Reardon	IMG_0260.jpg;IMG_0261.jpg	4513330	Mrs. Krull	4	X6GL4MN2
Delaney	Supple	IMG_0264.jpg	4543701	Mrs. Krull	4	T8LX94W1
Sara	Young	IMG_0269.jpg	4597319	Mrs. Krull	4	W1SD6P4

Data Instructions

Required Formatting

Column headers must be placed in Row 1.
Each subject must have their own row of data.
There cannot be any blank rows between subjects.
The file must be saved as a .CSV (Comma Delimited) file.

Multiple Images Per Subject

If a subject has more than one pose, list all image names in the Image Name field separated by a semicolon (;) with no spaces.

Example:
IMG_0260.jpg;IMG_0261.jpg

Unsupported Special Characters

Data uploads will fail if any fields contain unsupported special characters.

Do not use:
, " ^ & * = | > ? ( ) ' ~ [ ] / \

Sports & Events Order Form – Sample Sports or Dance Data with Groups

First Name	Last Name	Image Name	Image Type	Packages	Teacher	Team Name	ticketcode	Group Image	Custom1
Julia	Reardon	IMG_0260.jpg		J-1;8-1;	Mrs. Krull	Get in the Groove	CM7YIYUZ	1235.jpg	1236.jpg
Julia	Reardon	IMG_0261.jpg		J-1;8-1;	Mrs. Krull	Swing Town	CM7YIYUZ	1240.jpg
Julia	Reardon	IMG_0262.jpg		D-1;	Mrs. Krull	Rappers Delight	CM7YIYUZ	1243.jpg
Get in the Groove		1235.jpg	Group	X-1	Mrs. Krull	Get in the Groove
Swing Town		1240.jpg	Group	X-1	Mrs. Krull	Swing Town
Rappers Delight		1243.jpg	Group	X-1	Mrs. Krull	Rappers Delight

Sports & Events Data Instructions

Individual Subject Rows

Each subject must have their own row of data.
If a subject has multiple poses, each image must have its own row.

Example:
Julia Reardon appears on Lines 1–3 because she has multiple poses.

Passwords & Ticket Codes

The value entered in the ticketcode column will be used as the:

ImageQuix Password
OrderSchoolPix Password

If you want to create your own passwords, they must be entered into the ticketcode column.

If no password is provided, ACI can automatically generate ticket codes during the Underclass Finishing process.

Package Formatting

Packages must follow this format:

Package-Quantity;

Multiple Packages Example

Package-Quantity;Package-Quantity;

Example:
J-1;8-1;

Group & Individual Orders

To include both group and individual images in the same order:

Individual rows must contain:
- Team or Group Name
- Group image filename
Separate group rows must also be included below the individual rows.

Group Row Requirements

For group rows:

The group name goes in the First Name field.
The group image filename goes in the Image Name field.
The Image Type field must contain Group.

Example Breakdown

Julia Reardon’s individual image:

Individual Image: IMG_0260.jpg
Teacher/Coach: Mrs. Krull
Team/Dance Group: Get in the Groove
Group Image: 1235.jpg

The Group Image field must contain the complete filename, including .jpg, in order to upload properly into OSP.

A separate group row must also exist for:

Get in the Groove
Group Image: 1235.jpg
Image Type: Group

No-Buy Package Requirement

Every subject must have a package selected.

If a subject is not purchasing a package, use the no-buy package:

X;

Additional Formatting Rules

There cannot be any blank rows between subjects.
You are not required to use every available field.
However, column headers must remain exactly as defined in order to match the software system.

If ACI must correct:

Column headers
Formatting
Data inconsistencies

additional processing charges may apply.

Using Custom1–Custom8 Fields

The Custom1 through Custom8 columns can be used for additional group images.

This is helpful when:

A subject belongs to multiple teams/groups
Multiple memory mates are needed

Primary Group

The primary memory mate image should always be listed in the Group Image field.

Additional Groups

Additional group image filenames should be listed in the Custom fields.

Example

Julia Reardon has:

Multiple individual images
Different primary group images assigned to each pose

This allows her to order memory mates from multiple groups and poses.

Underclass: Creating CSV Data for Upload