Can I Create Programs in Bulk?

General Information
If your organization has many programs to enter or you already maintain a list of your programming in a separate database or spreadsheet, you can now quickly and easily create your Programs through the Org Dashboard.  Our aim in creating this additional avenue to enter programming is to include a broader range of learning opportunities on CCOL that may have been too numerous to enter otherwise, or to prevent duplication of work for orgs that already maintain this information.

In order to upload your programs:

Create Programs Through Bulk Upload
On the Org Programs page:

1. Click the "Import Programs" button in the top right:

   

2. On the Import Programs screen, select a properly formatted csv file.  See the heading Formatting Your CSV File below for more on properly formatting the csv.  You can also download example templates to enter your programs into: 

   

3. If you would like to do a test run before actually creating the programs, select the "Test the File Only" box.  This will email you a test report so that you can ensure that all of your programs will be created, or fix the ones that show an error:

   

4. Adjust your delimiters if necessary, then click the "Create Programs" button: 

   

5. You will see a notification that your programs are being created.  You should receive an email shortly thereafter with the import results: 

   

Formatting Your CSV File
In order to begin the formatting of your data, you can either use your own existing spreadsheet file containing your program data, or fill in one of the sample templates available on the Import Programs screen.  

Please note that if you use your own file, you must make sure that the header names in your file match the header names in the system template exactly.  A list of the header names is provided below.  Any data in a field that does not have a matching header will not be imported.

Below is a listing of the data headers (with the required ones noted by "req."), including the data type and options if applicable:

Header Name

Data Type

Entry Notes/Options

Folder_Name (req.)

String

Name of the folder within your organization where you would like this program to go.  If name of existing folder is used, then programs will be added to an existing folder.  If a new name is used, then a new folder will be created for that program.

Program_Name (req.)

String

Name of the program that you are adding.

Program_Description (req.)

String

Description of the program that you are adding.

Logo_URL

String

Link to where the desired logo image for this program is stored on the internet.  If this field is left blank, the program will inherit the organization logo supplied in the dashboard.

URL must include "http://"

Category (req.)

Number

The category that best fits the program that you are adding.  Enter the number that corresponds to the desired category.  Only the number should be entered, no text.

Options:

ACT/SAT (A&A)	408
Activism (C&S)	416
Ceramics (A&A)	393
Character Development (SEL)	387
Choral (A&A)	397
Coding (DF)	117
Community Action (C&S)	413
Dance (A&A)	390
Design & Making (DT)	113
Digital Media (DF)	395
DJing (A&A)	399
Engineering (A&A)	411
ESL & Language(A&A)	406
Financial Literacy (DF)	405
Food Service	418
Health	420
Housing	422
Instrumental (A&A)	398
Internships (C&S)	407
Leadership (C&S)	414
Legal Services	421
Literacy & Poetry (A&A)	402
Math (A&A)	412
Numbers	122
Painting & Drawing (A&A)	392
People & Cultures (C&S)	415
Physical Education (SEL)	388
Recording/Engineering (A&A, DF)	400
Remediation (A&A)	404
Science (A&A)	409
Spoken Word (A&A)	391
Sports (SEL)	385
Storytelling	120
Technology (A&A)	410
Theatre (A&A)	389
Transportation	419
Tutoring (A&A)	403
Welding (A&A)	394
Work + Career	114
Yoga (SEL)	386
Zoology	121

Program_Capacity

Number

The total number of seats or slots available to be filled in this program.

Min_Age (req.)

Number

Minimum age of program participants

Max_Age (req.)

Number

Maximum age of program participants

Meeting_Type (req.)

String

Does this program meet in a physical location or online?  Enter the option that corresponds to your program. 

Options:

face_to_face

online

Location_Name

String

Name of the physical location where the program will take place.

Address (req.)*

String

Program street address

City (req.)*

String

Program city

State (req.)*

String

Program state

Zipcode (req.)*

String

Program zipcode

Online_Address (req.)**

String

Online URL where the program takes place.

URL must include "http://"

Program_URL

String

Online URL that contains more information about the program.

URL must include "http://"

Registration_URL

String

Online URL where users can register for this program.

URL must include "http://"

Start_Date (req.)

Date

Start date for this program.

Format:

MM/DD/YYYY

End_Date (req.)

Date

End date for this program.

Format:

MM/DD/YYYY

Start_Time

Time

Start time for this program.

Format:

00:00 AM/PM

End_Time

Time

End time for this program.

Format:

00:00 AM/PM

Registration_Deadline

Date

Date registration closes for this program.

Format:

MM/DD/YYYY

Contact_Name

String

Name of point of contact for more information on this program.

Contact_Email

String

Email of point of contact for more information on this program.

Contact_Phone

String

Phone number of point of contact for more information on this program.

Price (req.)

Number

Price range of this program.  Enter the number corresponding to the price range this program falls within.

Options:

0 - Free

1 - $1-$50

2 - $50+

Extra_Data

String

Additional data for research purposes.  This data is not used by the system.

* Address, City, State and Zipcode are only required if Meeting_Type entry for that row is face_to_face.

** Online_Address is only required if Meeting_Type entry for that row is online.