Data File Specification and Review Guide

Introduction

This article provides detail on the data needed for the import files required to use the HelioCampus Assessment and Credentialing platform. Each article includes detailed file specifications as well as best practices and instructions for reviewing files to ensure they are ready to be imported.

For all files, the following rules apply:

1. The header row is required to be at the top of the file

2. Every field must be surrounded by double quotes i.e. “Subject Code”

   1. If a field is blank it contains empty double quotes i.e. ““

3. Each field must be separated by a comma but there should not be a comma at the end of the row.

1. There should be no line breaks for what should be a single row

2. The header file cannot includes asterisks

3. The file name cannot includes apostrophes

File List and Specifications

The following is a list of the import files and file specifications.

Daily Import Files (Required)

• Course Catalog

• Course Sections

• Faculty Information

• Registration

• Student Degrees

• Student Information

(Daily) Import Files (Optional)

• Co-Curricular Activity

• Co-Curricular Registration

• Co-Curricular Section

• Course Learning Outcomes

• Program & Program Learning Outcomes (PLO)

• Staff

• Term