Program Import File Layout

Latest version: 2.0

The Program Import is used to batch import programs from external information systems. This is a helpful way to setup your programs without having to individually create them in PowerFAIDS.

You can use the sample file below and replace the data with your own, noting that all eleven fields are required for your programs to be imported successfully.

Download File Layout
Download Sample File

Caution: When generating a file, be sure to choose the CSV UTF-8 (Comma delimited) (*csv) format and not the generic CSV (Comma delimited) (*csv) format, or you may receive an error message stating that the file is not valid.

Tip: Once you've imported your programs, the system will display whether each program was Created or Not Created. If the program is Not Created, you need to revisit your file and ensure that the file layout is correct. The most common reason a program is Not Created is because there is an error in the file layout. Specifically, be sure to double check the Department of Education's CIP code for the associated program is input correctly.

Tip: When manually building a program file or opening the program file generated by a reporting tool, Excel will strip away the leading and trailing zeros in CIP codes upon save of Program Import CSV files. If the leading or trailing zeros are removed from the CIP codes, the file will not import to PowerFAIDS and the programs will not be created.

This issue can be resolved in multiple ways:

  • Manually create programs that have CIP codes starting or ending in zeros
  • Open the CSV file in Notepad to manually find and update any CIP codes missing leading or trailing zeros
  • Change the format of the CIP code column to text and save as UTF8 encoded then do NOT open in Excel again