Understanding the File Parser Process

The File Parser process enables you to convert data from an external file into PeopleSoft data and place it into tables in your Campus Solutions database. The external file can be a delimited file or a flat file. It can be a simple file with one row type or a complex file with several row types. If your institution routinely receives an external file from which you need to move data into your database, consider using the File Parser process to expedite the entry of that data. Whether the file is a small one that your institution receives daily or a large one that is received annually, the one-time setup of the File Parser process for that file can save significant data entry time.

Note: Suggested best practice: When creating File Parser definitions, it is recommended that the targeted tables be of an interim or staging classification, rather than have the File Parser process import data directly into application tables. Using interim or staging tables enable you to use existing data validation processes or create your own data validation processes. These validation processes can ensure that the data is clean before you load the data into one or more application specific tables.

To set up and use the File Parser process for an external file:

  • Set up a field conversion definition that identifies a field values to convert from the external file to the target staging table.

  • Set up context definitions that identify how to convert the data and in which staging tables to place the converted data to hold it for processing. Each context must also identify the parent-to-child relationship of the staging tables.

  • Set up a file mapping definition that associates fields on the external file with the context definition to use.

  • View the layout of each staging table, modify it, and map the fields from it to the target tables.

  • Preview the hierarchical record layout and the converted data before you move the data into the staging tables.

  • Run the File Parser process to convert the data and place it into the staging tables.