At no cost to you, Cut Time will import your data into your account. Please format any existing spreadsheets you have for your members (Students, Parents, Participants) to the attached People Import Template provided in this document.

  1. Delete all rows with N in column A along with their related adults*

                * If you want to be able to communicate with your Alumni skip this step.

  1. Highlight Column A
  2. Replace* “Y” with nothing

                * To find “Replace” go to tool bar and click on “Find & Replace”/”Replace”

 

  1. Keep Column A highlighted
  2. Replace* ADULT with Y

                * To find “Replace” go to tool bar and click on “Find & Replace”/”Replace”

 

 

  1. Highlight Column B
  2. Replace* “Related to ” with nothing

                * To find “Replace” go to tool bar and click on “Find & Replace”/”Replace” 

  • Make sure to put a space after the “to” before replacing the content

  1. Highlight the whole document
    • Replace* “Not Assigned” with nothing

                * To find “Replace” go to tool bar and click on “Find & Replace”/”Replace” 

 

  • Replace* “Null” with nothing

                * To find “Replace” go to tool bar and click on “Find & Replace”/”Replace”

 

  1. Insert a column after “AH”

  1. Highlight the whole document
  2. Custom sort First by “Active?” then by “ID”

  1. Highlight Column “C-AF” underneath the headers and drag down until you reach your student/member data
  2. Delete these empty rows by shifting them left

  • This will move the parent/guardian information over to the left

 


TRANSFER YOUR DATA FROM CHARMS TO THE CUT TIME PEOPLE TEMPLATE

  1. Bring up the Cut Time People Template next to the document you are working on
  2. Copy and page <-PASTE the following from your NEWLY FORMATTED document to the Cut Time Template

                                                ALL:

Charms Template

Cut Time Template

Active? (A)

Parent_Flag (A)

ID (B)

Student ID (B)

Student (C)

First Name (C)

M (D)

Middle Initial (Name) (D)

Last (E)

Last Name (E)

                                             PARENTS/GUARDIANS:

Charms Template

Cut Time Template

Columns F-H

Columns U-W

Columns I-L

Columns P, R-T

Column M

Column O

                                    STUDENTS/MEMBERS:

Charms Template

Cut Time Template

Grade (F)

Grade Level (H)

Sex (I)

Gender (I)

Address (J)

Address Line 1 (P)

City (K)

City (R)

State (L)

State (S)

Zip (M)

Postal Code (T)

Phone (N)

Home Telephone (U)

Cell (O)

Mobile Telephone (V)

E-Mail (P)

Email (O)

Field 1-4 (Q-T)

Custom Fields 1-5 (X-AB)

Birthdate (U)

Date of Birth (G)

Ensemble Name (V- Header)

Group/Ensemble (AC)

Ensemble Position (V – Content)

Position (AD)

Ensemble Name (X- Header)

Additional Ensemble (AE)

Ensemble Position (X – Content)

Additional Position (AF)

Locker (AC)

Locker (I)

Folder (AD)

Folder (K)

Pvt Teacher (AE)

Private Teacher (L)

 

  • Save your Cut Time People spreadsheets as either an Excel OR .CSV file  
  • Email your Cut Time People spreadsheets to support@cuttime.net