Import Table Maintenance
Overview
The Import Table Maintenance utility provides a quick and easy way to create and update tables in Jenzabar SONIS. The Table Maintenance utility is where most table data is accessed in SONIS, including a wide variety of tables that populate fields all across the system. The import utility is most useful when bringing in data from another student information system to SONIS, but it can be used any time a new table needs to be built or a large collection of data needs to be added to an existing table. The page itself includes everything you need to get started, including a grid of the fields in each table and a downloadable file with the proper column headings.
Note that the import process can only be used to create new table data. It cannot be used to edit existing data. Table data imported through this utility must be edited or deleted from the Table Maintenance page.
Importing Data
Selecting Table
To begin the import process, first select the table where data will be added. The page has a live search function that mirrors the one in the Table Maintenance utility and makes it easy to find a table without scrolling. Locate the desired table and click Import.
On the following page, there's a link that will direct the administrator to the actual table in Table Maintenance where existing data can be viewed and individual edits can be made.
Table Schema & Preview
Before preparing an import file, administrators should study the Intuition Table Schema and use it to build their import file.
The Column Name is how the field is designated in the SONIS database. The Column Display Name is how the field is labeled on the frontend.
The Data Type column denotes the type of characters that can and should be stored in the field. Nvarchar and nchar fields will accept characters of any type except for some special characters that may be blocked to prevent errors. Int, tinyint, and float fields will accept any integer that meets the length requirements. Bit fields are used to turn things on and off and must be either a 0 to designate off or a 1 for on.
The Primary Key is the data that is used to name the program in the database. It cannot be edited once it's been created.
Just below the Table Schema is an image of in the Table Maintenance page for the specific table. This is meant as an example for informational purposes. The fields displayed cannot be edited from this page.
Preparing the File
Click Download Excel Report for a blank copy of the file that will need to be uploaded to the SONIS system.
Fill out the form with the required data for each table based on the table schema, being sure to follow the Data Type and Max Length restrictions. Note that the NSC Country Code is the two-character code provided by the National Student Clearinghouse and the ISO Country Code is the three-character code designated by the International Organization for Standardization .
Importing Data
Click Browse and select the saved file. Then click Process to continue.
The data being imported is displayed in the File Import Details box. Any errors within the data are marked with a red X. Hover over the X to see the cause of the error.
Once the data is correct and there are no errors remaining, click Import to complete the process.
Once the page reloads, the results of the import are displayed at the bottom of the screen.