Using Data Load Programs
After data preparation, design conversion programs that extract the appropriate file layout, to transfer the legacy data to Campus Solutions tables.
Input Format
Often the input format for the conversion program is the flat file created by the data extract program on the legacy system and transferred—by using File Transfer Protocol—to the database server. Consider loading the data into temporary tables within the PeopleSoft system instead of directly into the "live" tables. By performing this task, you can use the tools already available to you to both clean up and properly convert data. The temporary tables would then be the input for the conversion program.
Conversion Program and Program Language
The conversion program transfers the legacy data from the input format to Campus Solutions tables, including reformatting, validating, and prompt table translating not encompassed in the data preparation programs. The conversion program must include defaults for Campus Solutions record keys and required fields whenever legacy data has no data map.
The two most commonly used languages for conversions are COBOL and SQR. Another option is a specific database management system (DBMS) import utility, if one exists—such as the Oracle SQL Loader. Determinants for making this decision include your skill set. For example, if you already know COBOL, there is no associated learning curve downtime, or increased resources if you use COBOL. Regardless of your skill set, consider if it would be advantageous to learn a language that is likely be used in the future for Campus Solutions modifications, conversion file size, level of translations and edits, and DBMS capability.
| Field or Control | Description |
|---|---|
|
COBOL |
Has a more robust debugger, can process a larger number of records faster, and is more widely recognized in the industry. |
|
SQR |
Is more commonly used in reporting and minor modifications. In most cases, SQR code can be written in less time than COBOL code. |
|
DBMS Import Utility |
Requires the least conversion effort but is limited to no application-specific edits or translations. |
Table Loading Sequence
Conversion programming may include a single program that incorporates all pertinent tables and their sequence or multiple programs that incorporate single tables or a few related tables. Multiple programs can run simultaneously—increasing efficiency and enabling the allocation of programming responsibility.
Errors and Exception Handling
Regardless of the number of conversion programs, there must be adequate and standard error and exception handling. Reports of database action failures, validation logic failures, and pertinent details help ensure a quality and thorough conversion.
Totals Controls
In addition to errors and exceptions, totals controls also help in quality control. Totals controls include the number of records processed on both the source and destination sides, and dollar tallies whenever possible are pertinent for Financial Aid and Student Financials applications.
Required Fields
You can find out what fields are required for any table or page by searching PeopleSoft Application Designer in PeopleTools. You can also write an SQR to list all required data elements from tables that you want to use in the conversion. It is important that you also read and understand the PeopleCode. There are PeopleCode restrictions within records that can mean that in certain circumstances a field is required or a default value is required. Without understanding the PeopleCode, incorrect data could be entered.
WARNING:
If a field is not required, do not assume that you do not need to convert data into that field. It is recommended that when in doubt, you review the PeopleCode to determine whether you need data or default values for a particular field.
Note:
Refer to individual discussions regarding each application for specific data conversion and data loading tips for applications within Campus Solutions.