====== General ======
The web admin interface allows an administrator to manually update the MySQL data via a reported output in CSV (Comma Seperated Value) format.

====== Overview ======
  - **Get the data file** from Peoplesoft, saving it locally; [[how_to_update_data#how_to_get_the_data_file|see below]]
  - **Login** to the admin site; [[how_to_update_data#login|see below]]
  - **Upload the data file** to the grants admin site; [[how_to_update_data#how_to_upload_the_data_file|see below]]

====== How to get the data file ======
A CSV (comma seperated value) file is output from UMBCs Peoplesoft reporting system. You run the particular query named below and then save its output as a local CSV file.

<code>
UM_GM_OTD_CURRENT_AWARDS
</code>

  - Login to PeopleSoft
    - Login to **myUMBC** http://my.umbc.edu
    - Click on the **'Administration'** tab at the top of the myUMBC interface
    - Click on **Finance** link underneath the PeopleSoft category. A peoplesoft login page should appear
    - Login to the **peoplesoft finance page** with the same credentials as myUMBC (most likely; if those credentials do not work, contact helpdesk)
  - Find the Query
    - Click on ** Reporting Tools**
    - Click on **Query Viewer** underneath the Query category
    - Click **Advanced Search**
    - Change the 'Query Name' operator from 'begins with' to **'contains'**
    - Type in all or part of the query name <code>UM_GM_OTD_CURRENT_AWARDS</code>
    - This should return the query that you need!
  - Run the Query
    - Click **HTML**, under the column 'Run to HTML'
    - Enter an ACTIVE DATE (ussually todays date); If you enter 1/1/2000, you will only get results from before 2000
  - Save as CSV format
    - You should now be viewing a html preview of the data
    - Click **CSV Text File** next to the text 'Download results in :'
    - Save the .csv file to your local HDD with your browser
    - Edit out all references to "NSA" in the text file; those involved with NSA projects should not be referenced as so.

  * For technical specifications of the data file, see the [[implementation]] page.
  * For technical specifications of old uploaded data files, see the [[implementation]] page.

====== Login ======
http://umbc.edu/research/grant-database/admin/

Login via the UMBC WebAuth interface that appears. Use your UMBCID and password (ussually your email user name and password) to login. Only specified users have access to the admin interface.

====== How to upload the data file ======
  - Click on the **'update'** link
  - Click **'Browse...'** and select the locally saved .csv file above
  - Click **'Upload File'**