Transfer Agreement Post Type

The transfer post type allows transfer agreements from the transfer articulation agreements database to be imported and displayed on the transfer site.

Importing Agreements from Transfer Database

Clean up the spreadsheet

Things you need to do to the spreadsheet before importing it:

1. Find and replace all comma from the Program Area and WTCS Program Area columns with "--". (So "Accounting, Business, Management, and Marketing" becomes "Accounting-- Business-- Management-- and Marketing").
2. Combine the Program Area columns into one column (=F2&", "&G2&", "&H2)
   1. Find and replace ", ," with nothing.
3. Add columns:
   
   1. post_type column with value = transfer_agreement
   2. post_status column with value = publish
   3. post_title column with value = UWS Major + Degree Type (for example, "Sustainable Management BS" =E2&" "&G2)
4. Your header row should be: "tax_wtcs-institution","wtcs_degree_type","tax_wtcs-program","tax_uw-institution","uws_major","tax_uws-program-area","uws_degree_type","agreement_url","all_wtcs","post_title","post_type","post_status"

Convert to CSV using LibreOffice

1. Open the Excel Spreadsheet in LibreOffice, and choose Save As.
2. Select the filetype of csv.
3. Confirm you want to save the document as a Text CSF.
4. On the options screen:
   
   1. Select UTF-8 as charset.
   2. Field delimiter as ,
   3. Text delimiter as "
   4. Check the Quote all text cells box.
      
5. Select OK.

Import Into Wordpress

1. If you already have Transfer Agreements in WordPress, you need to delete all of them first.
   1. View the list of transfer agreements under Content.
   2. Use "Screen Options" to view 200 agreements at once.
   3. Check the box and use the Bulk actions dropdown to move them to trash.
2. Tools > Import > CSV.
3. Once you the import work, clean out the trash.

Display Transfer Agreements

Use Shortcode to add the archives to your pages:

[transfer_agreements_archive ]

type

Use this attribute to spcify how the archive is sorted. Options: campus, wtcs, program (default)

Example

[transfer_agreements_archive type=campus] Displays the transfer agreements sorted by UW campus.