Home

Getting Started

Installation and Setup

See the README for initial installation and setup steps.

Load Initial Data (Fixtures)

1. Images
   1. python manage.py loaddata images
   2. python manage.py loaddata imagetags
2. Programs
   1. python manage.py loaddata colleges
   2. python manage.py loaddata collegeoverrides
   3. python manage.py loaddata cip
   4. python manage.py loaddata soc
   5. python manage.py loaddata fees
   6. python manage.py loaddata tuitionoverrides

Run Imports

For more details on importers listed below, please see the Importer Documentation page.

Run program importers

1. Import programs from APIM
   1. Command: python manage.py import-programs
2. Import catalog data:
   1. Command: python manage.py import-catalog-descriptions
3. Import tuition data:
   1. Command: python manage.py import-tuition
   2. Requirements:
      • URL of the tuition JSON feed, provided by Student Accounts
4. Import Classification of Instructional Program (CIP) Codes:
   1. Download the CIP codes from the NCES website. Press search with the search box empty, and then download the CSV on the next page. Do not modify the CSV.
   2. Command: python manage.py import-cip filename.csv --cip-version=[2010,2020]. Adjust the CIP Version based on what you're importing.
5. Import occupational codes (SOCs) and map them to CIPs:
   1. Command: python manage.py import-soc
   2. Requirements:
      • CSV file of SOC codes + CIP code mappings, acquired from the NCES website ("look for SOC to CIP Crosswalk"). Choose the "CIP-SOC" sheet in the excel file, rename the headings to: CIP Code , CIP Title, SOC Code and SOC Title and save the sheet as a CSV.
6. Import program outcome data (using FETPIP data set from IKM):
   1. Command: python manage.py import-program-outcome-data
   2. Requirements:
      • FETPIP data export from IKM, via an information request. Information request must be performed manually on a yearly basis. See https://ikm.ucf.edu/information-requests/. Excel file provided by IKM must be sanitized manually to:
        1. Open in excel. Filter out UCF entries - select the "School" column filter and unselect UCF.
        2. Go to Find & Select > Go To Special, and select the "Visible cells only" option.
        3. Cmd+click to deselect the heading row so you don't delete the headings.
        4. Delete all the selected rows (which should only be non-UCF data).
        5. Reset the filter so you can see all the records again.
        6. Create a new heading in the very last cell called "CIP".
        7. Click on the first cell underneath the new heading and enter the following formula: =RIGHT(B2,6)
        8. Copy the cell, select all the cells below it until the end of file and paste (this will paste the formula, updating the row number on each one).
        9. Save this out as a CSV.
        10. Open the CSV in Visual Studio Code and preform the following find/replace (make sure you enable the regex button, looks like .*): a. Find: ,(\d{2})(\d{4})\n b. Replace: ,$1.$2\n
        11. Save the changes and you're ready to import.
7. Import Bureau of Labor Statistics (BLS) employment projection data for programs:
   1. Command: python manage.py import-projection-data
   2. Requirements:
      • CSV file of BLS employment projection data, which can be downloaded from the BLS website. All the columns right of "Occupational Openings" can be removed, and the columns renamed to title, code, begin, end, change, change_perc and openings.
8. Import Slate GUIDs
   1. Command: python manage.py import-slate-guids
9. Import deadlines
   1. Command: python manage.py import-program-application-deadlines

Run teledata importers

1. Import all teledata: python manage.py import-teledata
2. Requirements:
   • Must be run from a machine with permissions to access our teledata staging table

Run unit importers

1. Import units
   1. Command: python manage.py import-units <filename>
   2. Requirements:
      • CSV of faculty data from HRIS
2. Sanitize and map units
   1. Command: python manage.py sanitize-unit-names

Run research importers

NOTE: initial unit imports should be run prior to importing researcher data.

1. Import researchers
   1. Command: python manage.py acad-analytics-import-researchers
2. Import research metadata
   1. Command: python manage.py orcid-meta-import

Run image importers

1. Import image tags
   1. Command: python manage.py import-tandemvault-tags --file=<filename>
   2. Requirements:
      • CSV file containing existing tag and synonym information from Tandem Vault
2. Import images
   1. Command: python manage.py import-tandemvault-images