Before You Begin

You can use the Campus Community File Parser utility to load admission applications from a text file into Campus Solutions. Before you begin setting up File Parser to load your external applications, there are a few things that might be helpful to do. You may want to consider doing this with a spreadsheet or data modeling tool:

  • Review the external application data to determine which staging records and fields will be populated. Utilize the Entity Registry feature to get a clear understanding of the staging table hierarchy.

  • Document each record to be populated, the fields within each record that will come from the external data, and which fields need to be populated with default values. Utilize the AAWS Data Mapping and Entity Catalog document to view each of the staging records and their associated fields.

  • Determine which incoming fields will need to be converted to internal values.

  • Document the non-required incoming data elements so you know which records need to have Skip if Blank selected for the mapped data element.

  • Determine which fields require developing a calculated field. Examples include: Application Center, External Organization ID, and Degree Description.