You are here: Home / Documentation / How To's / How to edit the OTIS DB

How to edit the OTIS DB

by klotzj27 — published May 10, 2010 01:35 PM, last modified Aug 16, 2016 10:50 AM
OTIS(Oshkosh Transfer Information System) is an online service designed to assist you in determining which UW Oshkosh requirements you may have satisfied at one of the Wisconsin private college. Before the admissions site's migration to Plone, OTIS was created with mySQL, Javascript, and PHP. It nows uses a series of CPT's, AJAX, the ZODB, and Python in order to provide accurate transfer information and an interface to modify the underlying ZODB TTW.

Navigate to http://www.uwosh.edu/admissions/otis-excel-files/view 

To upload an Excel file:

-Click on add new in the upper right corner and select file. Upload the .xls file that you wish to be part of the available Excel files list.

To remove an Excel file:

-To remove you can click on the contents tab in the upper left corner and delete them as you would delete any other plone object. 

To write data from an Excel file to a college in the DB:

-Select the college you wish to write to from the "Select College" dropdown. Select the excel file you wish to write to this college's entry in the DB from the "Excel File" dropdown. Click the "Submit" button. If successful a message will alert you that the excel file has been written to the DB entry for the school you selected.

To add a new college:

-Uncheck the box next to "Select College". Type in the name of the college you wish to add to the DB in "Add New College". Select the excel file you wish to associate with this college from the "Excel File" dropdown. Click the "Submit" button. If successful a message will alert you that the excel file has been written to the DB entry for the school you selected.

Remove a college:

Enter the name of the college you wish to remove in the "Delete a College" form. Press the "REMOVE COLLEGE" button. This will remove all instances of this college from the DB.

 

 

 

Navigation