Precollege Import and Export

Export existing programs

1. Navigate to Tools > CSV/XLS Export

2. Set the settings as follows:

   Open

   

   Also include “register_link” and “dates” in export.

3. Click the “Save Settings” button.

4. Choose “Export to CSV”.

5. The spreadsheet may need to be cleaned up a little.

6. Add the image column.

Edit the Exported Spreadsheet

• You can open the CSV in Excel.

• Do not edit the “id” column. For a new program, leave ID blank.

• If you want to remove program, change the status to “trash.”

• If a program should have multiple grades, use a ',' between them.

• Programs should have only one campus.

Import the Updated Spreadsheet

1. Remove the ‘Image’ column

2. Add a post_type column with the value precollege_program for each row.

3. Update the id column to “post_id”

4. Add “tax_” in front of the program_subjects, program_grades and program_campus columns.

5. Make sure “post_status” column is in all lowercase.

6. Save the file in the correct format using Office Libre then Import into WordPress. See here: Transfer Agreement Post Type

7. Do the import as described on the Transfer Agreement page, but don’t delete the existing Programs from the database first.